/// <summary>
/// 获取一个部门的溯源的全名称(含父级名称)
/// </summary>
/// <param name="guid">部门guid</param>
/// <returns></returns>
public virtual async Task<string> Proc_fullnameAsync(Nullable<System.Guid> guid)
{
System.Data.Common.DbConnection connect = null;
try
{
InfoReportSystemDBEntities db = new InfoReportSystemDBEntities();
connect = db.Database.Connection;
await connect.OpenAsync();
System.Data.Common.DbCommand dbCommand = connect.CreateCommand();
var parame1 = dbCommand.CreateParameter();
parame1.ParameterName = "@departmentguid";
parame1.DbType = System.Data.DbType.Guid;
parame1.Value = guid;
var parameOut = dbCommand.CreateParameter();
parameOut.ParameterName = "@fullname";
parameOut.DbType = System.Data.DbType.String;
parameOut.Size = 700;
parameOut.Direction = System.Data.ParameterDirection.Output;
dbCommand.Parameters.Add(parame1);
dbCommand.Parameters.Add(parameOut);
dbCommand.CommandText = "proc_fullname";
dbCommand.CommandType = System.Data.CommandType.StoredProcedure;
//var obj = await dbCommand.ExecuteScalarAsync();
var obj = await dbCommand.ExecuteNonQueryAsync();
string department_fullName = Convert.ToString(parameOut.Value);
return department_fullName;
}
catch (Exception ex)
{
return "";
}
finally
{
connect.Close();
connect.Dispose();
}
}