public static DanhMucDonVi Insert(DanhMucDonVi Inserted) { DanhMucDonVi Item = new DanhMucDonVi(); SqlParameter[] obj = new SqlParameter[12]; obj[0] = new SqlParameter("DM_LDM_Ma", Inserted.LDM_Ma); obj[1] = new SqlParameter("DM_LDM_ID", Inserted.LDM_ID); obj[2] = new SqlParameter("DM_Ten", Inserted.Ten); obj[3] = new SqlParameter("DM_KyHieu", Inserted.KyHieu); obj[4] = new SqlParameter("DM_Ma", Inserted.Ma); obj[5] = new SqlParameter("DM_RowId", Inserted.RowId); obj[6] = new SqlParameter("DM_NgayTao", Inserted.NgayTao); obj[7] = new SqlParameter("DM_NguoiTao", Inserted.NguoiTao); obj[8] = new SqlParameter("DM_NgayCapNhat", Inserted.NgayCapNhat); obj[9] = new SqlParameter("DM_GiaTri", Inserted.GiaTri); obj[10] = new SqlParameter("DM_ThuTu", Inserted.ThuTu); obj[11] = new SqlParameter("DM_NguoiSua", Inserted.NguoiSua); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Insert_InsertNormal_hoangda", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DanhMucDonVi getFromReaderNoiGuiListDmGiaTri(IDataReader rd) { DanhMucDonVi Item = new DanhMucDonVi(); Item.Ten = (String)(rd["DM_Ten"]); Item.GiaTri = (String)(rd["DM_GiaTri"]); return(Item); }
//sp_tblDanhMucDonVi_Pager_Normal_hoangda #region Utilities public static DanhMucDonVi getFromReaderNoiGuiDm(IDataReader rd) { DanhMucDonVi Item = new DanhMucDonVi(); Item.ID = (Int32)(rd["DM_ID"]); Item.Ten = (String)(rd["DM_Ten"]); Item.KyHieu = (String)(rd["DM_KyHieu"]); Item.Ma = (String)(rd["DM_Ma"]); Item.RowId = (Guid)(rd["DM_RowId"]); Item.NguoiTao = (String)(rd["DM_NguoiTao"]); Item.GiaTri = (String)(rd["DM_GiaTri"]); Item.ThuTu = (Int32)(rd["DM_ThuTu"]); Item.NguoiSua = (String)(rd["DM_NguoiSua"]); return(Item); }
public static DanhMucDonVi SelectById(Int32 DM_ID) { DanhMucDonVi Item = new DanhMucDonVi(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("DM_ID", DM_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_SelectById_hoangda", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DanhMucDonVi QuickSave(string Ten, string KyHieu, string LDM_Ma) { DanhMucDonVi Item = new DanhMucDonVi(); SqlParameter[] obj = new SqlParameter[3]; obj[0] = new SqlParameter("Ten", Ten); obj[1] = new SqlParameter("KyHieu", KyHieu); obj[2] = new SqlParameter("LDM_Ma", LDM_Ma); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Insert_QuickSave_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DanhMucDonVi getFromReader(IDataReader rd) { DanhMucDonVi Item = new DanhMucDonVi(); if (rd.FieldExists("DM_ID")) { Item.ID = (Int32)(rd["DM_ID"]); } if (rd.FieldExists("DM_LDM_ID")) { Item.LDM_ID = (Int32)(rd["DM_LDM_ID"]); } if (rd.FieldExists("DM_LDM_Ma")) { Item.LDM_Ma = (String)(rd["DM_LDM_Ma"]); } if (rd.FieldExists("LDM_Ten")) { Item.LDM_Ten = (String)(rd["LDM_Ten"]); } if (rd.FieldExists("DM_Ten")) { Item.Ten = (String)(rd["DM_Ten"]); } if (rd.FieldExists("DM_KyHieu")) { Item.KyHieu = (String)(rd["DM_KyHieu"]); } if (rd.FieldExists("DM_Ma")) { Item.Ma = (String)(rd["DM_Ma"]); } if (rd.FieldExists("DM_RowId")) { Item.RowId = (Guid)(rd["DM_RowId"]); } 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_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["DM_NgayCapNhat"]); } 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_NguoiSua")) { Item.NguoiSua = (String)(rd["DM_NguoiSua"]); } return(Item); }