public void Delete(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID)); RunProcedure("sp_NS_SoQuyetDinh_Delete", colParam); }
public DataTable Get(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID)); return(RunProcedureGet("sp_NS_SoQuyetDinh_Get", colParam)); }
public int Add(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { int ID = 0; ID = oDNS_SoQuyetDinh.Add(pNS_SoQuyetDinhInfo); mErrorMessage = oDNS_SoQuyetDinh.ErrorMessages; mErrorNumber = oDNS_SoQuyetDinh.ErrorNumber; return(ID); }
public void Update(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_SoQuyetDinhInfo.SoQuyetDinh)); colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_SoQuyetDinhInfo.NgayQuyetDinh)); colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID)); RunProcedure("sp_NS_SoQuyetDinh_Update", colParam); }
public int Add(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_SoQuyetDinhInfo.SoQuyetDinh)); colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_SoQuyetDinhInfo.NgayQuyetDinh)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_NS_SoQuyetDinh_Add", colParam)); }
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_SoQuyetDinhInfo> GetList(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { List <NS_SoQuyetDinhInfo> oNS_SoQuyetDinhInfoList = new List <NS_SoQuyetDinhInfo>(); DataTable dtb = Get(pNS_SoQuyetDinhInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oNS_SoQuyetDinhInfo = new NS_SoQuyetDinhInfo(); oNS_SoQuyetDinhInfo.NS_SoQuyetDinhID = int.Parse(dtb.Rows[i]["NS_SoQuyetDinhID"].ToString()); oNS_SoQuyetDinhInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString(); oNS_SoQuyetDinhInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayQuyetDinh"].ToString()); oNS_SoQuyetDinhInfoList.Add(oNS_SoQuyetDinhInfo); } } return(oNS_SoQuyetDinhInfoList); }
public void ToInfo(ref NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo, DataRow dr) { pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID = int.Parse(dr[pNS_SoQuyetDinhInfo.strNS_SoQuyetDinhID].ToString()); pNS_SoQuyetDinhInfo.SoQuyetDinh = dr[pNS_SoQuyetDinhInfo.strSoQuyetDinh].ToString(); pNS_SoQuyetDinhInfo.NgayQuyetDinh = DateTime.Parse(dr[pNS_SoQuyetDinhInfo.strNgayQuyetDinh].ToString()); }
public void ToDataRow(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo, ref DataRow dr) { dr[pNS_SoQuyetDinhInfo.strNS_SoQuyetDinhID] = pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID; dr[pNS_SoQuyetDinhInfo.strSoQuyetDinh] = pNS_SoQuyetDinhInfo.SoQuyetDinh; dr[pNS_SoQuyetDinhInfo.strNgayQuyetDinh] = pNS_SoQuyetDinhInfo.NgayQuyetDinh; }
public void Delete(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { oDNS_SoQuyetDinh.Delete(pNS_SoQuyetDinhInfo); mErrorMessage = oDNS_SoQuyetDinh.ErrorMessages; mErrorNumber = oDNS_SoQuyetDinh.ErrorNumber; }
public DataTable Get(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo) { return(oDNS_SoQuyetDinh.Get(pNS_SoQuyetDinhInfo)); }