public static DanhMuc SelectByMa(string DM_Ma) { var Item = new DanhMuc(); var obj = new SqlParameter[1]; if (!string.IsNullOrEmpty(DM_Ma)) { obj[0] = new SqlParameter("DM_Ma", DM_Ma); } else { obj[0] = new SqlParameter("DM_Ma", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMuc_Select_SelectByMa_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DanhMuc getFromReader(IDataReader rd) { var Item = new DanhMuc(); if (rd.FieldExists("DM_ID")) { Item.ID = (Guid)(rd["DM_ID"]); } if (rd.FieldExists("DM_GH_ID")) { Item.GH_ID = (Guid)(rd["DM_GH_ID"]); } if (rd.FieldExists("DM_PID")) { Item.PID = (Guid)(rd["DM_PID"]); } if (rd.FieldExists("DM_LDM_ID")) { Item.LDM_ID = (Guid)(rd["DM_LDM_ID"]); } if (rd.FieldExists("DM_Lang")) { Item.Lang = (String)(rd["DM_Lang"]); } if (rd.FieldExists("DM_LangBased")) { Item.LangBased = (Boolean)(rd["DM_LangBased"]); } if (rd.FieldExists("DM_LangBased_ID")) { Item.LangBased_ID = (Guid)(rd["DM_LangBased_ID"]); } if (rd.FieldExists("DM_Alias")) { Item.Alias = (String)(rd["DM_Alias"]); } if (rd.FieldExists("DM_KyHieu")) { Item.KyHieu = (String)(rd["DM_KyHieu"]); } if (rd.FieldExists("DM_Ten")) { Item.Ten = (String)(rd["DM_Ten"]); } if (rd.FieldExists("DM_Anh")) { Item.Anh = (String)(rd["DM_Anh"]); } if (rd.FieldExists("DM_Ma")) { Item.Ma = (String)(rd["DM_Ma"]); } if (rd.FieldExists("DM_GiaTri")) { Item.GiaTri = (String)(rd["DM_GiaTri"]); } if (rd.FieldExists("DM_ThuTu")) { Item.ThuTu = (Int32)(rd["DM_ThuTu"]); } if (rd.FieldExists("DM_NgayTao")) { Item.NgayTao = (DateTime)(rd["DM_NgayTao"]); } if (rd.FieldExists("DM_NguoiTao")) { Item.NguoiTao = (String)(rd["DM_NguoiTao"]); } if (rd.FieldExists("DM_NguoiSua")) { Item.NguoiSua = (String)(rd["DM_NguoiSua"]); } if (rd.FieldExists("DM_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["DM_NgayCapNhat"]); } if (rd.FieldExists("DM_KeyWords")) { Item.KeyWords = (String)(rd["DM_KeyWords"]); } if (rd.FieldExists("DM_Description")) { Item.Description = (String)(rd["DM_Description"]); } if (rd.FieldExists("DM_RowId")) { Item.RowId = (Guid)(rd["DM_RowId"]); } if (rd.FieldExists("DM_Deleted")) { Item.Deleted = (Boolean)(rd["DM_Deleted"]); } if (rd.FieldExists("LDM_Ten")) { Item.LDM_Ten = (String)(rd["LDM_Ten"]); } if (rd.FieldExists("DM_Level")) { Item.Level = (Int32)(rd["DM_Level"]); } if (rd.FieldExists("PID_Ten")) { Item.PID_Ten = (String)(rd["PID_Ten"]); } return(Item); }