/// <summary>
/// 根据ID获取文档信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetodeDocType(int id)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from officedba.CodeDocType where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 根据ID获取分类信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetCodeBigTypeById(int id, string TableName)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from " + TableName + " where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
if (TableName == "officedba.CodeCompanyType")// 往来单位
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType");
}
else if (TableName == "officedba.CodeProductType")
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "TypeFlag");
}
return(model);
}
else
{
return(null);
}
}
