public void Delete(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID)); RunProcedure("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Delete", colParam); }
public DataTable Get(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID)); return(RunProcedureGet("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Get", colParam)); }
public int Add(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { int ID = 0; ID = oDNS_QuaTrinhThamGiaLucLuongVuTrang.Add(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo); mErrorMessage = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorMessages; mErrorNumber = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorNumber; return(ID); }
public void ToDataRow(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo, ref DataRow dr) { dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNS_QuaTrinhThamGiaLucLuongVuTrangID] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDNS_GiaoVien] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDDM_QuanHam] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strDonVi] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi; dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strChucVu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu; }
public void Update(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@NgayNhapNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu)); colParam.Add(CreateParam("@NgayXuatNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu)); colParam.Add(CreateParam("@IDDM_QuanHam", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam)); colParam.Add(CreateParam("@DonVi", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi)); colParam.Add(CreateParam("@ChucVu", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu)); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID)); RunProcedure("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Update", colParam); }
public int Add(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@NgayNhapNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu)); colParam.Add(CreateParam("@NgayXuatNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu)); colParam.Add(CreateParam("@IDDM_QuanHam", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam)); colParam.Add(CreateParam("@DonVi", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi)); colParam.Add(CreateParam("@ChucVu", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Add", colParam)); }
public frmQuaTrinhThamGiaLLVT() { InitializeComponent(); oBGiaoVien = new cBNS_GiaoVien(); pGiaoVienInfo = new NS_GiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBQuaTrinhThamGiaLucLuongVuTrang = new cBNS_QuaTrinhThamGiaLucLuongVuTrang(); pNS_QuaTrinhThamGiaLucLuongVuTrangInfo = new NS_QuaTrinhThamGiaLucLuongVuTrangInfo(); dtpDenNgay.Enabled = false; SetButton(false); btnThem.Enabled = true; SetControl(true); btnLuu.Enabled = false; }
public void ToInfo(ref NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo, DataRow dr) { pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID = int.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNS_QuaTrinhThamGiaLucLuongVuTrangID].ToString()); pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDNS_GiaoVien]); if (dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu].ToString() != "") { pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu = DateTime.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu].ToString()); } if (dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu].ToString() != "") { pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu = DateTime.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu].ToString()); } pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam = int.Parse("0" + dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDDM_QuanHam]); pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi = dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strDonVi].ToString(); pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu = dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strChucVu].ToString(); }
public List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo> GetList(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo> oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList = new List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo>(); DataTable dtb = Get(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oNS_QuaTrinhThamGiaLucLuongVuTrangInfo = new NS_QuaTrinhThamGiaLucLuongVuTrangInfo(); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID = int.Parse(dtb.Rows[i]["NS_QuaTrinhThamGiaLucLuongVuTrangID"].ToString()); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString()); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu = DateTime.Parse(dtb.Rows[i]["NgayNhapNgu"].ToString()); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu = DateTime.Parse(dtb.Rows[i]["NgayXuatNgu"].ToString()); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam = int.Parse(dtb.Rows[i]["IDDM_QuanHam"].ToString()); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi = dtb.Rows[i]["DonVi"].ToString(); oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu = dtb.Rows[i]["ChucVu"].ToString(); oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList.Add(oNS_QuaTrinhThamGiaLucLuongVuTrangInfo); } } return(oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList); }
public void Delete(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { oDNS_QuaTrinhThamGiaLucLuongVuTrang.Delete(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo); mErrorMessage = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorMessages; mErrorNumber = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorNumber; }
public DataTable Get(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo) { return(oDNS_QuaTrinhThamGiaLucLuongVuTrang.Get(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)); }