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);
}
