public DataTable Get(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TC_QuyenHoaDon_TrinhDoID", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID)); return(RunProcedureGet("sp_TC_QuyenHoaDon_TrinhDo_Get", colParam)); }
public void Delete(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TC_QuyenHoaDon_TrinhDoID", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID)); RunProcedure("sp_TC_QuyenHoaDon_TrinhDo_Delete", colParam); }
public int Add(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { int ID = 0; ID = oDTC_QuyenHoaDon_TrinhDo.Add(pTC_QuyenHoaDon_TrinhDoInfo); mErrorMessage = oDTC_QuyenHoaDon_TrinhDo.ErrorMessages; mErrorNumber = oDTC_QuyenHoaDon_TrinhDo.ErrorNumber; return(ID); }
public int Add(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDTC_QuyenHoaDon", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon)); colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_TC_QuyenHoaDon_TrinhDo_Add", colParam)); }
public List <TC_QuyenHoaDon_TrinhDoInfo> GetList(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { List <TC_QuyenHoaDon_TrinhDoInfo> oTC_QuyenHoaDon_TrinhDoInfoList = new List <TC_QuyenHoaDon_TrinhDoInfo>(); DataTable dtb = Get(pTC_QuyenHoaDon_TrinhDoInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oTC_QuyenHoaDon_TrinhDoInfo = new TC_QuyenHoaDon_TrinhDoInfo(); oTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID].ToString()); oTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon].ToString()); oTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo].ToString()); oTC_QuyenHoaDon_TrinhDoInfoList.Add(oTC_QuyenHoaDon_TrinhDoInfo); } } return(oTC_QuyenHoaDon_TrinhDoInfoList); }
private void btnCapNhat_Click(object sender, EventArgs e) { cBTC_QuyenHoaDon_TrinhDo oBQuyenHoaDon_Trinhdo = new cBTC_QuyenHoaDon_TrinhDo(); TC_QuyenHoaDon_TrinhDoInfo pQuyenHoaDon_TrinhDo = new TC_QuyenHoaDon_TrinhDoInfo(); if (!Check_Valid()) { return; } try { GetInfo(); string[] arrAdd = strAdd.Split(','); string[] arrDelete = strDelete.Split(','); if (status == 0) { int mQuyenHoaDonID = oBTC_QuyenHoaDon.Add(pTC_QuyenHoaDonInfo); drQuyenHoaDon = dtQuyenHoaDon.NewRow(); oBTC_QuyenHoaDon.ToDataRow(pTC_QuyenHoaDonInfo, ref drQuyenHoaDon); drQuyenHoaDon["TC_QuyenHoaDonID"] = mQuyenHoaDonID; dtQuyenHoaDon.Rows.Add(drQuyenHoaDon); ThemThanhCong(); // Update Trinh Do if (arrAdd.Length > 0) { for (int i = 0; i < arrAdd.Length - 1; i++) { if (arrAdd[i].ToString() != "") { pQuyenHoaDon_TrinhDo.IDDM_TrinhDo = int.Parse(arrAdd[i]); pQuyenHoaDon_TrinhDo.IDTC_QuyenHoaDon = mQuyenHoaDonID; oBQuyenHoaDon_Trinhdo.Add(pQuyenHoaDon_TrinhDo); } } } if (arrDelete.Length > 0) { for (int i = 0; i < arrDelete.Length - 1; i++) { if (arrDelete[i].ToString() != "") { pQuyenHoaDon_TrinhDo.TC_QuyenHoaDon_TrinhDoID = int.Parse(arrDelete[i]); oBQuyenHoaDon_Trinhdo.Delete(pQuyenHoaDon_TrinhDo); } } } GetTrinhDo(); } else { oBTC_QuyenHoaDon.Update(pTC_QuyenHoaDonInfo); drQuyenHoaDon[pTC_QuyenHoaDonInfo.strTuSo] = pTC_QuyenHoaDonInfo.TuSo; drQuyenHoaDon[pTC_QuyenHoaDonInfo.strSoHienTai] = pTC_QuyenHoaDonInfo.SoHienTai; drQuyenHoaDon[pTC_QuyenHoaDonInfo.strTenQuyenHoaDon] = pTC_QuyenHoaDonInfo.TenQuyenHoaDon; // Update Trinh Do for (int i = 0; i < arrAdd.Length - 1; i++) { if (arrAdd[i].ToString() != "") { pQuyenHoaDon_TrinhDo.IDDM_TrinhDo = int.Parse(arrAdd[i]); pQuyenHoaDon_TrinhDo.IDTC_QuyenHoaDon = pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID; oBQuyenHoaDon_Trinhdo.Add(pQuyenHoaDon_TrinhDo); } } for (int i = 0; i < arrDelete.Length - 1; i++) { if (arrDelete[i].ToString() != "") { pQuyenHoaDon_TrinhDo.TC_QuyenHoaDon_TrinhDoID = int.Parse(arrDelete[i]); oBQuyenHoaDon_Trinhdo.Delete(pQuyenHoaDon_TrinhDo); } } SuaThanhCong(); panelTop.Visible = false; } ClearText(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
public void ToInfo(ref TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo, DataRow dr) { pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID].ToString()); pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon].ToString()); pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo].ToString()); }
public void ToDataRow(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo, ref DataRow dr) { dr[pTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID] = pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID; dr[pTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon] = pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon; dr[pTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo] = pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo; }
public void Delete(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { oDTC_QuyenHoaDon_TrinhDo.Delete(pTC_QuyenHoaDon_TrinhDoInfo); mErrorMessage = oDTC_QuyenHoaDon_TrinhDo.ErrorMessages; mErrorNumber = oDTC_QuyenHoaDon_TrinhDo.ErrorNumber; }
public DataTable Get(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo) { return(oDTC_QuyenHoaDon_TrinhDo.Get(pTC_QuyenHoaDon_TrinhDoInfo)); }