private Dictionary_Type FillModel_Dictionary_Type(IDataReader dr)
{
Dictionary_Type m = new Dictionary_Type();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
m.ID = (int)dr["ID"];
}
if (!string.IsNullOrEmpty(dr["Name"].ToString()))
{
m.Name = (string)dr["Name"];
}
if (!string.IsNullOrEmpty(dr["TableName"].ToString()))
{
m.TableName = (string)dr["TableName"];
}
return(m);
}
public Dictionary_Type Dictionary_Type_GetModel(int id)
{
SqlDataReader dr = null;
SqlParameter[] param =
{
SQLDatabase.MakeInParam("@ID", SqlDbType.Int, 4, id)
};
SQLDatabase.RunProc("MCS_SYS.dbo.sp_Dictionary_Type_GetModel", param, out dr);
Dictionary_Type model = null;
if (dr.HasRows)
{
dr.Read();
model = FillModel_Dictionary_Type(dr);
}
dr.Close();
return(model);
}
