public void ToInfo(ref NS_NhomNgachInfo pNS_NhomNgachInfo, DataRow dr) { pNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dr[pNS_NhomNgachInfo.strNS_NhomNgachID].ToString()); pNS_NhomNgachInfo.KyHieu = dr[pNS_NhomNgachInfo.strKyHieu].ToString(); pNS_NhomNgachInfo.TenNhomNgach = dr[pNS_NhomNgachInfo.strTenNhomNgach].ToString(); pNS_NhomNgachInfo.LoaiCongChuc = dr[pNS_NhomNgachInfo.strLoaiCongChuc].ToString(); pNS_NhomNgachInfo.IDNS_LinhVucCongTac = int.Parse("0" + dr[pNS_NhomNgachInfo.strIDNS_LinhVucCongTac]); pNS_NhomNgachInfo.MoTa = dr[pNS_NhomNgachInfo.strMoTa].ToString(); pNS_NhomNgachInfo.SoNamNangBac = double.Parse(dr[pNS_NhomNgachInfo.strSoNamNangBac].ToString()); pNS_NhomNgachInfo.BacCaoNhat = int.Parse(dr[pNS_NhomNgachInfo.strBacCaoNhat].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_1].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_2].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_3].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_4].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_5].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_6].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_7].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_8].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_9].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_10].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_11].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_12].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_13].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_14].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_15].ToString()); pNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_16].ToString()); }
public void Update(NS_NhomNgachInfo pNS_NhomNgachInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pNS_NhomNgachInfo.KyHieu)); colParam.Add(CreateParam("@TenNhomNgach", SqlDbType.NVarChar, pNS_NhomNgachInfo.TenNhomNgach)); colParam.Add(CreateParam("@LoaiCongChuc", SqlDbType.NVarChar, pNS_NhomNgachInfo.LoaiCongChuc)); colParam.Add(CreateParam("@IDNS_LinhVucCongTac", SqlDbType.Int, pNS_NhomNgachInfo.IDNS_LinhVucCongTac)); colParam.Add(CreateParam("@MoTa", SqlDbType.NVarChar, pNS_NhomNgachInfo.MoTa)); colParam.Add(CreateParam("@SoNamNangBac", SqlDbType.Float, pNS_NhomNgachInfo.SoNamNangBac)); colParam.Add(CreateParam("@BacCaoNhat", SqlDbType.Int, pNS_NhomNgachInfo.BacCaoNhat)); colParam.Add(CreateParam("@HeSoLuongBac_1", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_1)); colParam.Add(CreateParam("@HeSoLuongBac_2", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_2)); colParam.Add(CreateParam("@HeSoLuongBac_3", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_3)); colParam.Add(CreateParam("@HeSoLuongBac_4", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_4)); colParam.Add(CreateParam("@HeSoLuongBac_5", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_5)); colParam.Add(CreateParam("@HeSoLuongBac_6", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_6)); colParam.Add(CreateParam("@HeSoLuongBac_7", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_7)); colParam.Add(CreateParam("@HeSoLuongBac_8", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_8)); colParam.Add(CreateParam("@HeSoLuongBac_9", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_9)); colParam.Add(CreateParam("@HeSoLuongBac_10", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_10)); colParam.Add(CreateParam("@HeSoLuongBac_11", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_11)); colParam.Add(CreateParam("@HeSoLuongBac_12", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_12)); colParam.Add(CreateParam("@HeSoLuongBac_13", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_13)); colParam.Add(CreateParam("@HeSoLuongBac_14", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_14)); colParam.Add(CreateParam("@HeSoLuongBac_15", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_15)); colParam.Add(CreateParam("@HeSoLuongBac_16", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_16)); colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID)); RunProcedure("sp_NS_NhomNgach_Update", colParam); }
//public int Add(NS_NhomNgachInfo pNS_NhomNgachInfo) //{ // int ID = 0; // var client = new UnimOsServiceClient(); // ID = client.cDNS_NhomNgach_Add(GlobalVar.MaXacThuc, pNS_NhomNgachInfo); // client.Close(); // mErrorMessage = oDNS_NhomNgach.ErrorMessages; // mErrorNumber = oDNS_NhomNgach.ErrorNumber; // return ID; //} //public void Update(NS_NhomNgachInfo pNS_NhomNgachInfo) //{ // var client = new UnimOsServiceClient(); // client.cDNS_NhomNgach_Update(GlobalVar.MaXacThuc, pNS_NhomNgachInfo); // client.Close(); // mErrorMessage = oDNS_NhomNgach.ErrorMessages; // mErrorNumber = oDNS_NhomNgach.ErrorNumber; //} //public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo) //{ // var client = new UnimOsServiceClient(); // client.cDNS_NhomNgach_Delete(GlobalVar.MaXacThuc, pNS_NhomNgachInfo); // client.Close(); // mErrorMessage = oDNS_NhomNgach.ErrorMessages; // mErrorNumber = oDNS_NhomNgach.ErrorNumber; //} //public List<NS_NhomNgachInfo> GetList(NS_NhomNgachInfo pNS_NhomNgachInfo) //{ // List<NS_NhomNgachInfo> oNS_NhomNgachInfoList = new List<NS_NhomNgachInfo>(); // DataTable dtb = Get(pNS_NhomNgachInfo); // if (dtb != null) // { // for (int i = 0; i < dtb.Rows.Count; i++) // { // oNS_NhomNgachInfo = new NS_NhomNgachInfo(); // oNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dtb.Rows[i]["NS_NhomNgachID"].ToString()); // oNS_NhomNgachInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString(); // oNS_NhomNgachInfo.TenNhomNgach = dtb.Rows[i]["TenNhomNgach"].ToString(); // oNS_NhomNgachInfo.LoaiCongChuc = dtb.Rows[i]["LoaiCongChuc"].ToString(); // oNS_NhomNgachInfo.MoTa = dtb.Rows[i]["MoTa"].ToString(); // oNS_NhomNgachInfo.SoNamNangBac = double.Parse(dtb.Rows[i]["SoNamNangBac"].ToString()); // oNS_NhomNgachInfo.BacCaoNhat = int.Parse(dtb.Rows[i]["BacCaoNhat"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dtb.Rows[i]["HeSoLuongBac_1"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dtb.Rows[i]["HeSoLuongBac_2"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dtb.Rows[i]["HeSoLuongBac_3"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dtb.Rows[i]["HeSoLuongBac_4"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dtb.Rows[i]["HeSoLuongBac_5"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dtb.Rows[i]["HeSoLuongBac_6"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dtb.Rows[i]["HeSoLuongBac_7"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dtb.Rows[i]["HeSoLuongBac_8"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dtb.Rows[i]["HeSoLuongBac_9"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dtb.Rows[i]["HeSoLuongBac_10"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dtb.Rows[i]["HeSoLuongBac_11"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dtb.Rows[i]["HeSoLuongBac_12"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dtb.Rows[i]["HeSoLuongBac_13"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dtb.Rows[i]["HeSoLuongBac_14"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dtb.Rows[i]["HeSoLuongBac_15"].ToString()); // oNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dtb.Rows[i]["HeSoLuongBac_16"].ToString()); // oNS_NhomNgachInfoList.Add(oNS_NhomNgachInfo); // } // } // return oNS_NhomNgachInfoList; //} public void ToDataRow(NS_NhomNgachInfo pNS_NhomNgachInfo, ref DataRow dr) { dr[pNS_NhomNgachInfo.strNS_NhomNgachID] = pNS_NhomNgachInfo.NS_NhomNgachID; dr[pNS_NhomNgachInfo.strKyHieu] = pNS_NhomNgachInfo.KyHieu; dr[pNS_NhomNgachInfo.strTenNhomNgach] = pNS_NhomNgachInfo.TenNhomNgach; dr[pNS_NhomNgachInfo.strLoaiCongChuc] = pNS_NhomNgachInfo.LoaiCongChuc; dr[pNS_NhomNgachInfo.strIDNS_LinhVucCongTac] = pNS_NhomNgachInfo.IDNS_LinhVucCongTac; dr[pNS_NhomNgachInfo.strMoTa] = pNS_NhomNgachInfo.MoTa; dr[pNS_NhomNgachInfo.strSoNamNangBac] = pNS_NhomNgachInfo.SoNamNangBac; dr[pNS_NhomNgachInfo.strBacCaoNhat] = pNS_NhomNgachInfo.BacCaoNhat; dr[pNS_NhomNgachInfo.strHeSoLuongBac_1] = pNS_NhomNgachInfo.HeSoLuongBac_1; dr[pNS_NhomNgachInfo.strHeSoLuongBac_2] = pNS_NhomNgachInfo.HeSoLuongBac_2; dr[pNS_NhomNgachInfo.strHeSoLuongBac_3] = pNS_NhomNgachInfo.HeSoLuongBac_3; dr[pNS_NhomNgachInfo.strHeSoLuongBac_4] = pNS_NhomNgachInfo.HeSoLuongBac_4; dr[pNS_NhomNgachInfo.strHeSoLuongBac_5] = pNS_NhomNgachInfo.HeSoLuongBac_5; dr[pNS_NhomNgachInfo.strHeSoLuongBac_6] = pNS_NhomNgachInfo.HeSoLuongBac_6; dr[pNS_NhomNgachInfo.strHeSoLuongBac_7] = pNS_NhomNgachInfo.HeSoLuongBac_7; dr[pNS_NhomNgachInfo.strHeSoLuongBac_8] = pNS_NhomNgachInfo.HeSoLuongBac_8; dr[pNS_NhomNgachInfo.strHeSoLuongBac_9] = pNS_NhomNgachInfo.HeSoLuongBac_9; dr[pNS_NhomNgachInfo.strHeSoLuongBac_10] = pNS_NhomNgachInfo.HeSoLuongBac_10; dr[pNS_NhomNgachInfo.strHeSoLuongBac_11] = pNS_NhomNgachInfo.HeSoLuongBac_11; dr[pNS_NhomNgachInfo.strHeSoLuongBac_12] = pNS_NhomNgachInfo.HeSoLuongBac_12; dr[pNS_NhomNgachInfo.strHeSoLuongBac_13] = pNS_NhomNgachInfo.HeSoLuongBac_13; dr[pNS_NhomNgachInfo.strHeSoLuongBac_14] = pNS_NhomNgachInfo.HeSoLuongBac_14; dr[pNS_NhomNgachInfo.strHeSoLuongBac_15] = pNS_NhomNgachInfo.HeSoLuongBac_15; dr[pNS_NhomNgachInfo.strHeSoLuongBac_16] = pNS_NhomNgachInfo.HeSoLuongBac_16; }
public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID)); RunProcedure("sp_NS_NhomNgach_Delete", colParam); }
public DataTable Get(NS_NhomNgachInfo pNS_NhomNgachInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID)); return(RunProcedureGet("sp_NS_NhomNgach_Get", colParam)); }
public int Add(NS_NhomNgachInfo pNS_NhomNgachInfo) { int ID = 0; ID = oDNS_NhomNgach.Add(pNS_NhomNgachInfo); mErrorMessage = oDNS_NhomNgach.ErrorMessages; mErrorNumber = oDNS_NhomNgach.ErrorNumber; return(ID); }
public frmDM_NhomNgach(frmDM_NgachCongChuc _frmDM_NgachCongChuc) { InitializeComponent(); oBNS_NhomNgach = new cBNS_NhomNgach(); pNS_NhomNgachInfo = new NS_NhomNgachInfo(); cmbLinhVucCongTac.Properties.DataSource = (new cBNS_LinhVucCongTac()).Get(new NS_LinhVucCongTacInfo()); SetControl(false); SetTxtRerdOnly(true); ofrmDM_NgachCongChuc = _frmDM_NgachCongChuc; }
public frmNangBacChuyenNgach() { InitializeComponent(); oBGiaoVien = new cBNS_GiaoVien(); pGiaoVienInfo = new NS_GiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBSoQuyetDinh = new cBNS_SoQuyetDinh(); pSoQuyetDinhInfo = new NS_SoQuyetDinhInfo(); oBLuong = new cBNS_Luong(); pNS_LuongInfo = new NS_LuongInfo(); oBNS_NhomNgach = new cBNS_NhomNgach(); pNS_NhomNgachInfo = new NS_NhomNgachInfo(); dtNangBacChuyenNgach = new DataTable(); cmbBacLuong_SelectedIndexChanged(null, null); CreateTable(); }
public frmLuong() { InitializeComponent(); oBGiaoVien = new cBNS_GiaoVien(); pGiaoVienInfo = new NS_GiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBSoQuyetDinh = new cBNS_SoQuyetDinh(); pSoQuyetDinhInfo = new NS_SoQuyetDinhInfo(); oBLuong = new cBNS_Luong(); pNS_LuongInfo = new NS_LuongInfo(); oBNS_NhomNgach = new cBNS_NhomNgach(); pNS_NhomNgachInfo = new NS_NhomNgachInfo(); SetButton(false); btnThem.Enabled = true; SetControl(true); dtpDenNgay.Enabled = false; btnLuu.Enabled = false; cmbBacLuong_SelectedIndexChanged(null, null); }
public List <NS_NhomNgachInfo> GetList(NS_NhomNgachInfo pNS_NhomNgachInfo) { List <NS_NhomNgachInfo> oNS_NhomNgachInfoList = new List <NS_NhomNgachInfo>(); DataTable dtb = Get(pNS_NhomNgachInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oNS_NhomNgachInfo = new NS_NhomNgachInfo(); oNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dtb.Rows[i]["NS_NhomNgachID"].ToString()); oNS_NhomNgachInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString(); oNS_NhomNgachInfo.TenNhomNgach = dtb.Rows[i]["TenNhomNgach"].ToString(); oNS_NhomNgachInfo.LoaiCongChuc = dtb.Rows[i]["LoaiCongChuc"].ToString(); oNS_NhomNgachInfo.MoTa = dtb.Rows[i]["MoTa"].ToString(); oNS_NhomNgachInfo.SoNamNangBac = double.Parse(dtb.Rows[i]["SoNamNangBac"].ToString()); oNS_NhomNgachInfo.BacCaoNhat = int.Parse(dtb.Rows[i]["BacCaoNhat"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dtb.Rows[i]["HeSoLuongBac_1"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dtb.Rows[i]["HeSoLuongBac_2"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dtb.Rows[i]["HeSoLuongBac_3"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dtb.Rows[i]["HeSoLuongBac_4"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dtb.Rows[i]["HeSoLuongBac_5"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dtb.Rows[i]["HeSoLuongBac_6"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dtb.Rows[i]["HeSoLuongBac_7"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dtb.Rows[i]["HeSoLuongBac_8"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dtb.Rows[i]["HeSoLuongBac_9"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dtb.Rows[i]["HeSoLuongBac_10"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dtb.Rows[i]["HeSoLuongBac_11"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dtb.Rows[i]["HeSoLuongBac_12"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dtb.Rows[i]["HeSoLuongBac_13"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dtb.Rows[i]["HeSoLuongBac_14"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dtb.Rows[i]["HeSoLuongBac_15"].ToString()); oNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dtb.Rows[i]["HeSoLuongBac_16"].ToString()); oNS_NhomNgachInfoList.Add(oNS_NhomNgachInfo); } } return(oNS_NhomNgachInfoList); }
public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo) { oDNS_NhomNgach.Delete(pNS_NhomNgachInfo); mErrorMessage = oDNS_NhomNgach.ErrorMessages; mErrorNumber = oDNS_NhomNgach.ErrorNumber; }
public DataTable Get(NS_NhomNgachInfo pNS_NhomNgachInfo) { return(oDNS_NhomNgach.Get(pNS_NhomNgachInfo)); }