private void chkNull(ExpensesRefund p) { int chk = 0; Decimal chk1 = 0; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.status_appv = p.status_appv == null ? "0" : p.status_appv; p.status_doc = p.status_doc == null ? "0" : p.status_doc; p.status_page = p.status_page == null ? "0" : p.status_page; p.desc1 = p.desc1 == null ? "" : p.desc1; p.remark = p.remark == null ? "" : p.remark; p.expenses_refund_date = p.expenses_refund_date == null ? "" : p.expenses_refund_date; p.job_code = p.job_code == null ? "" : p.job_code; p.erc_doc = p.erc_doc == null ? "" : p.erc_doc; p.expense_clear_cash_id = int.TryParse(p.expense_clear_cash_id, out chk) ? chk.ToString() : "0"; p.job_id = int.TryParse(p.job_id, out chk) ? chk.ToString() : "0"; p.expenses_pay_detail_id = int.TryParse(p.expenses_pay_detail_id, out chk) ? chk.ToString() : "0"; p.ecc_doc = int.TryParse(p.ecc_doc, out chk) ? chk.ToString() : "0"; p.pay_staff_id = int.TryParse(p.pay_staff_id, out chk) ? chk.ToString() : "0"; p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0"; }
private void initConfig() { jim = new JobImport(); expnpd = new ExpensesPayDetail(); ecc = new ExpensesClearCash(); erf = new ExpensesRefund(); xC.xtDB.stfDB.setCboStaff(cboStaff, userId); xC.setCboYear(cboYear); jim = xC.manDB.jimDB.selectByPk1(jobId); ecc = xC.accDB.eccDB.selectByPk1(eccDoc); txtJobCode.Value = jim.job_import_code; DateTime erfDate = DateTime.Now; txtErfDate.Value = erfDate.Year.ToString() + "-" + erfDate.ToString("MM-dd"); btnSave.Click += BtnSave_Click; initGrfErf(); setGrfErf(); setControlEcc(eccDoc); if (!eccDoc.Equals("")) { grfErf.Enabled = false; } }
public String insert(ExpensesRefund p, String userId) { String re = "", sql = ""; p.active = "1"; p.status_appv = "0"; p.status_doc = "0"; chkNull(p); sql = "Insert Into " + erf.table + "(" + erf.expenses_pay_detail_id + "," + erf.expense_clear_cash_id + "," + erf.desc1 + "," + erf.active + "," + erf.remark + ", " + erf.job_id + ", " + erf.date_create + ", " + erf.date_modi + ", " + erf.date_cancel + ", " + erf.user_create + ", " + erf.user_modi + ", " + erf.user_cancel + "," + erf.amount + "," + erf.status_page + "," + erf.status_appv + ", " + erf.status_doc + "," + erf.expenses_refund_date + "," + erf.ecc_doc + "," + erf.job_code + "," + erf.pay_staff_id + "," + erf.erc_doc + " " + ") " + "Values ('" + p.expenses_pay_detail_id + "','" + p.expense_clear_cash_id + "','" + p.desc1 + "'," + "'" + p.active + "','" + p.remark + "','" + p.job_id + "', " + "now(),'" + p.date_modi + "','" + p.date_cancel + "', " + "'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," + "'" + p.amount + "','" + p.status_page + "','" + p.status_appv + "'," + "'" + p.status_doc + "','" + p.expenses_refund_date + "','" + p.ecc_doc + "'," + "'" + p.job_code + "','" + p.pay_staff_id + "','" + p.erc_doc + "' " + ")"; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void initConfig() { erf = new ExpensesRefund(); erf.expenses_refund_id = "expenses_refund_id"; erf.expense_clear_cash_id = "expense_clear_cash_id"; erf.expenses_pay_detail_id = "expenses_pay_detail_id"; erf.job_id = "job_id"; erf.desc1 = "desc1"; erf.amount = "amount"; erf.active = "active"; erf.remark = "remark"; erf.date_create = "date_create"; erf.date_modi = "date_modi"; erf.date_cancel = "date_cancel"; erf.user_create = "user_create"; erf.user_modi = "user_modi"; erf.user_cancel = "user_cancel"; erf.status_page = "status_page"; erf.status_appv = "status_appv"; erf.status_doc = "status_doc"; erf.expenses_refund_date = "expenses_refund_date"; erf.ecc_doc = "ecc_doc"; erf.job_code = "job_code"; erf.pay_staff_id = "pay_staff_id"; erf.erc_doc = "erc_doc"; erf.table = "t_expenses_refund"; erf.pkField = "expenses_refund_id"; lexpn = new List <ExpensesRefund>(); }
public String update(ExpensesRefund p, String userId) { String re = "", sql = ""; chkNull(p); sql = "Update " + erf.table + " Set " + " " + erf.expenses_pay_detail_id + "='" + p.expenses_pay_detail_id + "' " + "," + erf.desc1 + "='" + p.desc1.Replace("'", "''") + "' " + "," + erf.expense_clear_cash_id + "='" + p.expense_clear_cash_id.Replace("'", "''") + "' " + "," + erf.remark + "='" + p.remark.Replace("'", "''") + "' " + "," + erf.date_modi + "=now() " + "," + erf.user_modi + "='" + userId.Replace("'", "''") + "' " + "," + erf.job_id + "='" + p.job_id.Replace("'", "''") + "' " + "," + erf.amount + "='" + p.amount.Replace("'", "''") + "' " + "," + erf.status_page + "='" + p.status_page.Replace("'", "''") + "' " + "," + erf.status_appv + "='" + p.status_appv.Replace("'", "''") + "' " + "," + erf.job_code + "='" + p.job_code.Replace("'", "''") + "' " + "," + erf.ecc_doc + "='" + p.ecc_doc.Replace("'", "''") + "' " + "," + erf.pay_staff_id + "='" + p.pay_staff_id.Replace("'", "''") + "' " + "Where " + erf.pkField + "='" + p.expenses_refund_id + "'"; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public ExpensesRefund setExpensesRefund(DataTable dt) { ExpensesRefund erf1 = new ExpensesRefund(); if (dt.Rows.Count > 0) { erf1.expenses_refund_id = dt.Rows[0][erf.expenses_refund_id].ToString(); erf1.expense_clear_cash_id = dt.Rows[0][erf.expense_clear_cash_id].ToString(); erf1.expenses_pay_detail_id = dt.Rows[0][erf.expenses_pay_detail_id].ToString(); erf1.job_id = dt.Rows[0][erf.job_id].ToString(); erf1.active = dt.Rows[0][erf.active].ToString(); erf1.date_cancel = dt.Rows[0][erf.date_cancel].ToString(); erf1.date_create = dt.Rows[0][erf.date_create].ToString(); erf1.date_modi = dt.Rows[0][erf.date_modi].ToString(); erf1.user_cancel = dt.Rows[0][erf.user_cancel].ToString(); erf1.user_create = dt.Rows[0][erf.user_create].ToString(); erf1.user_modi = dt.Rows[0][erf.user_modi].ToString(); erf1.desc1 = dt.Rows[0][erf.desc1].ToString(); erf1.remark = dt.Rows[0][erf.remark].ToString(); erf1.amount = dt.Rows[0][erf.amount].ToString(); erf1.status_page = dt.Rows[0][erf.status_page].ToString(); erf1.status_appv = dt.Rows[0][erf.status_appv].ToString(); erf1.status_doc = dt.Rows[0][erf.status_doc].ToString(); erf1.expenses_refund_date = dt.Rows[0][erf.expenses_refund_date].ToString(); erf1.ecc_doc = dt.Rows[0][erf.ecc_doc].ToString(); erf1.job_code = dt.Rows[0][erf.job_code].ToString(); erf1.pay_staff_id = dt.Rows[0][erf.pay_staff_id].ToString(); erf1.erc_doc = dt.Rows[0][erf.erc_doc].ToString(); } else { erf1.expenses_refund_id = ""; erf1.expense_clear_cash_id = ""; erf1.expenses_pay_detail_id = ""; erf1.job_id = ""; erf1.desc1 = ""; erf1.amount = ""; erf1.active = ""; erf1.remark = ""; erf1.date_create = ""; erf1.date_modi = ""; erf1.date_cancel = ""; erf1.user_create = ""; erf1.user_modi = ""; erf1.user_cancel = ""; erf1.status_page = ""; erf1.status_appv = ""; erf1.status_doc = ""; erf1.expenses_refund_date = ""; erf1.ecc_doc = ""; erf1.job_code = ""; erf1.pay_staff_id = ""; erf1.erc_doc = ""; } return(erf1); }
private void setControl(String erfId) { erf = xC.accDB.erfDB.selectByPk1(erfId); txtId.Value = erf.expenses_refund_id; jobId = erf.job_id; eccDoc = erf.expense_clear_cash_id; pdid = erf.expenses_pay_detail_id; txtRefund.Value = erf.amount; txtErfDate.Value = erf.expenses_refund_date; txtDesc.Value = erf.desc1; txtRemark.Value = erf.remark; }
public ExpensesRefund selectByPk1(String copId) { ExpensesRefund cop1 = new ExpensesRefund(); DataTable dt = new DataTable(); String sql = "select bll.* " + "From " + erf.table + " bll " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where bll." + erf.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setExpensesRefund(dt); return(cop1); }
public String insertExpensesRefund(ExpensesRefund p, String userId) { String re = ""; if (p.expenses_refund_id.Equals("")) { re = insert(p, userId); } else { re = update(p, userId); } return(re); }
private void initConfig() { jim = new JobImport(); expnpd = new ExpensesPayDetail(); ecc = new ExpensesClearCash(); erf = new ExpensesRefund(); xC.xtDB.stfDB.setCboStaff(cboStaff, userId); jim = xC.manDB.jimDB.selectByPk1(jobId); ecc = xC.accDB.eccDB.selectByPk1(erfId); txtJobCode.Value = jim.job_import_code; DateTime erfDate = DateTime.Now; txtErfDate.Value = erfDate.Year.ToString() + "-" + erfDate.ToString("MM-dd"); btnSave.Click += BtnSave_Click; setControl(erfId); }