public void ToDataRow(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo, ref DataRow dr) { dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNS_QuaTrinhThamGiaToChucCTXHID] = pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID; dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strIDNS_GiaoVien] = pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien; dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia] = pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia; dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strTenToChuc] = pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc; dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strCongViec] = pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec; }
public void Delete(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID)); RunProcedure("sp_NS_QuaTrinhThamGiaToChucCTXH_Delete", colParam); }
public DataTable Get(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID)); return(RunProcedureGet("sp_NS_QuaTrinhThamGiaToChucCTXH_Get", colParam)); }
public int Add(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { int ID = 0; ID = oDNS_QuaTrinhThamGiaToChucCTXH.Add(pNS_QuaTrinhThamGiaToChucCTXHInfo); mErrorMessage = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorMessages; mErrorNumber = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorNumber; return(ID); }
public void ToInfo(ref NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo, DataRow dr) { pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID = int.Parse(dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNS_QuaTrinhThamGiaToChucCTXHID].ToString()); pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strIDNS_GiaoVien]); if (dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia].ToString() != "") { pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia = DateTime.Parse(dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia].ToString()); } pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc = dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strTenToChuc].ToString(); pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec = dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strCongViec].ToString(); }
public void Update(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@NgayThamGia", SqlDbType.DateTime, pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia)); colParam.Add(CreateParam("@TenToChuc", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc)); colParam.Add(CreateParam("@CongViec", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec)); colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID)); RunProcedure("sp_NS_QuaTrinhThamGiaToChucCTXH_Update", colParam); }
public int Add(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@NgayThamGia", SqlDbType.DateTime, pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia)); colParam.Add(CreateParam("@TenToChuc", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc)); colParam.Add(CreateParam("@CongViec", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_NS_QuaTrinhThamGiaToChucCTXH_Add", colParam)); }
public frmQuaTrinhThamGiaTCCTXH() { InitializeComponent(); oBGiaoVien = new cBNS_GiaoVien(); pGiaoVienInfo = new NS_GiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBQuaTrinhThamGiaToChucCTXH = new cBNS_QuaTrinhThamGiaToChucCTXH(); pNS_QuaTrinhThamGiaToChucCTXHInfo = new NS_QuaTrinhThamGiaToChucCTXHInfo(); SetButton(false); btnThem.Enabled = true; SetControl(true); btnLuu.Enabled = false; }
public List <NS_QuaTrinhThamGiaToChucCTXHInfo> GetList(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { List <NS_QuaTrinhThamGiaToChucCTXHInfo> oNS_QuaTrinhThamGiaToChucCTXHInfoList = new List <NS_QuaTrinhThamGiaToChucCTXHInfo>(); DataTable dtb = Get(pNS_QuaTrinhThamGiaToChucCTXHInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oNS_QuaTrinhThamGiaToChucCTXHInfo = new NS_QuaTrinhThamGiaToChucCTXHInfo(); oNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID = int.Parse(dtb.Rows[i]["NS_QuaTrinhThamGiaToChucCTXHID"].ToString()); oNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString()); oNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia = DateTime.Parse(dtb.Rows[i]["NgayThamGia"].ToString()); oNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc = dtb.Rows[i]["TenToChuc"].ToString(); oNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec = dtb.Rows[i]["CongViec"].ToString(); oNS_QuaTrinhThamGiaToChucCTXHInfoList.Add(oNS_QuaTrinhThamGiaToChucCTXHInfo); } } return(oNS_QuaTrinhThamGiaToChucCTXHInfoList); }
public void Delete(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { oDNS_QuaTrinhThamGiaToChucCTXH.Delete(pNS_QuaTrinhThamGiaToChucCTXHInfo); mErrorMessage = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorMessages; mErrorNumber = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorNumber; }
public DataTable Get(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo) { return(oDNS_QuaTrinhThamGiaToChucCTXH.Get(pNS_QuaTrinhThamGiaToChucCTXHInfo)); }