/// <summary>
/// 获取科目核算类别
/// </summary>
/// <param name="CompanyCD">公司编码</param>
/// <returns>DataTable</returns>
public static DataTable GetAssistantType(string Name, string UsedStatus)
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
DataTable dt = AssistantTypeDBHelper.GetAssistantType(CompanyCD, Name, UsedStatus);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow Rows in dt.Rows)
{
if (Rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_OFF)
{
Rows["UsedStatus"] = ConstUtil.USED_STATUS_OFF_NAME;
}
else if (Rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_ON)
{
Rows["UsedStatus"] = ConstUtil.USED_STATUS_ON_NAME;
}
}
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
