public String updatePay(ExpensesDrawDatail p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + expnC.table + " Set " +
//" " + expnC.status_pay_type + " = '" + p.status_pay_type + "'" +
" " + expnC.pay_amount + " = '" + p.pay_amount.Replace("'", "''") + "'" +
"," + expnC.pay_date + " = '" + p.pay_date.Replace("'", "''") + "'" +
"," + expnC.pay_cheque_no + " = '" + p.pay_cheque_no.Replace("'", "''") + "'" +
"," + expnC.date_modi + " = now()" +
"," + expnC.user_modi + " = '" + userId + "' " +
"," + expnC.comp_bank_id + " = '" + p.comp_bank_id + "' " +
"," + expnC.pay_staff_id + " = '" + p.pay_staff_id + "' " +
//"," + expnC.item_id + " = '" + p.item_id + "' " +
"," + expnC.pay_bank_date + " = '" + p.pay_bank_date + "' " +
"," + expnC.expenses_pay_detail_id + " = '" + p.expenses_pay_detail_id + "' " +
"," + expnC.status_pay + " = '2' " +
"Where " + expnC.pkField + "='" + p.expenses_draw_detail_id + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void setControlD()
{
if (drawdId.Equals(""))
{
return;
}
expnDd = xC.accDB.expnddDB.selectByPk1(drawdId);
txtID.Value = expnDd.item_id;
txtItmNameT.Value = expnDd.item_name_t;
txtQty.Value = expnDd.qty;
txtPrice.Value = expnDd.price;
txtRemark.Value = expnDd.remark;
txtCusId.Value = expnDd.pay_to_cus_id;
txtCusNameT.Value = expnDd.pay_to_cus_name_t;
txtCusAddr.Value = expnDd.pay_to_cus_addr;
txtCusTax.Value = expnDd.pay_to_cus_tax;
xC.setC1Combo(cboUtp, expnDd.unit_id);
txtWtax1.Value = expnDd.wtax1;
txtWtax3.Value = expnDd.wtax3;
txtVat.Value = expnDd.vat;
txtReceipt.Value = expnDd.receipt_no;
txtReceiptDate.Value = expnDd.receipt_date;
calAmt();
}
public String update(ExpensesDrawDatail p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + expnC.table + " Set " +
" " + expnC.desc1 + " = '" + p.desc1.Replace("'", "''") + "'" +
"," + expnC.desc2 + " = '" + p.desc2.Replace("'", "''") + "'" +
"," + expnC.amount + " = '" + p.amount + "'" +
"," + expnC.remark + " = '" + p.remark.Replace("'", "''") + "'" +
"," + expnC.date_modi + " = now()" +
"," + expnC.user_modi + " = '" + userId + "' " +
"," + expnC.sort1 + " = '" + p.sort1 + "' " +
"," + expnC.expense_draw_id + " = '" + p.expense_draw_id + "' " +
"," + expnC.expense_type_id + " = '" + p.expense_type_id + "' " +
"," + expnC.job_code + " = '" + p.job_code + "' " +
"," + expnC.job_id + " = '" + p.job_id + "' " +
"," + expnC.qty + " = '" + p.qty + "' " +
"," + expnC.price + " = '" + p.price + "' " +
"," + expnC.unit_id + " = '" + p.unit_id + "' " +
"," + expnC.wtax1 + " = '" + p.wtax1 + "' " +
"," + expnC.wtax3 + " = '" + p.wtax3 + "' " +
"," + expnC.vat + " = '" + p.vat + "' " +
"," + expnC.total + " = '" + p.total + "' " +
"," + expnC.item_name_t + " = '" + p.item_name_t + "' " +
"," + expnC.unit_name_t + " = '" + p.unit_name_t + "' " +
"," + expnC.pay_to_cus_id + " = '" + p.pay_to_cus_id + "' " +
"," + expnC.pay_to_cus_name_t + " = '" + p.pay_to_cus_name_t + "' " +
"," + expnC.pay_to_cus_addr + " = '" + p.pay_to_cus_addr + "' " +
"," + expnC.pay_to_cus_tax + " = '" + p.pay_to_cus_tax + "' " +
"," + expnC.receipt_no + " = '" + p.receipt_no + "' " +
"," + expnC.receipt_date + " = '" + p.receipt_date + "' " +
"," + expnC.wtax5 + " = '" + p.wtax5 + "' " +
"," + expnC.amt_wtax1 + " = '" + p.amt_wtax1 + "' " +
"," + expnC.amt_wtax3 + " = '" + p.amt_wtax3 + "' " +
"," + expnC.amt_wtax5 + " = '" + p.amt_wtax5 + "' " +
"Where " + expnC.pkField + "='" + p.expenses_draw_detail_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public ExpensesDrawDatail selectByPk1(String copId)
{
ExpensesDrawDatail cop1 = new ExpensesDrawDatail();
DataTable dt = new DataTable();
String sql = "select expC.* " +
"From " + expnC.table + " expC " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where expC." + expnC.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setExpenseDrawDetail(dt);
return(cop1);
}
public String insertExpenseDrawDetail(ExpensesDrawDatail p, String userId)
{
String re = "";
if (p.expenses_draw_detail_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
public void getlexpnC()
{
//lDept = new List<Department>();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
ExpensesDrawDatail curr1 = new ExpensesDrawDatail();
curr1.expenses_draw_detail_id = row[expnC.expenses_draw_detail_id].ToString();
curr1.desc1 = row[expnC.desc1].ToString();
curr1.desc2 = row[expnC.desc2].ToString();
curr1.amount = row[expnC.amount].ToString();
lexpnC.Add(curr1);
}
}
private void BtnCashOk_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
grfBill.Clear();
grfBill.Rows.Count = 1;
grfBill.Cols[colBItmNameT].Width = 220;
grfBill.Cols[colBExpn].Width = 100;
grfBill.Cols[colBimcome].Width = 100;
//grfBill.Cols[colCDrawDate].Width = 100;
//grfBill.Cols[colCAmt].Width = 100;
grfBill.Cols[colBItmNameT].Caption = "รายการ";
grfBill.Cols[colBExpn].Caption = "ค่าใช้จ่าย";
grfBill.Cols[colBimcome].Caption = "รายได้";
grfBill.Cols[colBID].Visible = false;
foreach (Row rowD in grfDraw.Rows)
{
if (rowD[colCChk] == null)
{
continue;
}
if ((Boolean)rowD[colCChk])
{
String ddid = "";
ExpensesDrawDatail expndd = new ExpensesDrawDatail();
Items itm = new Items();
ItemsType itmt = new ItemsType();
ItemsTypeSub itmts = new ItemsTypeSub();
ddid = rowD[colCID].ToString();
expndd = xC.accDB.expnddDB.selectByPk1(ddid);
itm = xC.iniDB.itmDB.selectByPk1(expndd.item_id);
if (itm.item_group_id.Equals(""))
{
itmts = xC.iniDB.itmtsDB.selectByPk1(itm.item_type_sub_id);
itmt = xC.iniDB.itmtDB.selectByPk1(itmts.item_type_id);
itm.item_group_id = itmt.item_group_id;
}
itm.item_name_t = rowD[colCItmNameT].ToString();
itm.amt = rowD[colCAmt].ToString();
itm.cust_id = expndd.expenses_draw_detail_id; //ฝาก
setRowGrfBill(itm);
}
}
calAmtGrfBill();
tC2.SelectedTab = tabBill;
}
private void setControl(String id)
{
txtId.Value = id;
Items itm = new Items();
expndd = new ExpensesDrawDatail();
ecc = new ExpensesClearCash();
ecc = xC.accDB.eccDB.selectByPk1(id);
expndd = xC.accDB.expnddDB.selectByPk1(ecc.expenses_draw_detail_id);
itm = xC.iniDB.itmDB.selectByPk1(expndd.item_id);
txtTableId.Value = expndd.expenses_draw_detail_id;
txtItmNameT1.Value = expndd.item_name_t;
txtRcpAmt.Value = expndd.receipt_amount;
txtRcpNum.Value = expndd.receipt_no;
txtRcpDate.Value = expndd.receipt_date;
txtItmCode.Value = itm.item_code;
txtItmNameT.Value = expndd.item_name_t;
setImages(txtId.Text);
}
private void initConfig()
{
fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = xC.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
expndd = new ExpensesDrawDatail();
expndd = xC.accDB.expnddDB.selectByPk1(tableId);
txtTableId.Value = expndd.expenses_draw_detail_id;
txtItmNameT.Value = expndd.item_name_t;
txtJobId.Value = expndd.job_id;
btnImages.Click += BtnImages_Click;
btnUpload.Click += BtnUpload_Click;
sB1.Text = "";
initGrfJob();
}
public String updateReceipt(ExpensesDrawDatail p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + expnC.table + " Set " +
" " + expnC.receipt_amount + " = '" + p.pay_amount.Replace("'", "''") + "'" +
"," + expnC.receipt_date + " = '" + p.pay_date.Replace("'", "''") + "'" +
"," + expnC.receipt_no + " = '" + p.pay_cheque_no.Replace("'", "''") + "'" +
"Where " + expnC.pkField + "='" + p.expenses_draw_detail_id + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void setExpensesDrawDetail(String expnid, String cusid)
{
for (int i = 1; i < grfExpnD.Rows.Count; i++)
{
if (grfExpnD.Row <= 0)
{
continue;
}
if (grfExpnD[i, colDedit] == null)
{
continue;
}
if (!grfExpnD[i, colDedit].ToString().Equals("1"))
{
continue;
}
ExpensesDrawDatail expndd = new ExpensesDrawDatail();
expndd.expense_draw_id = expnid;
expndd.expenses_draw_detail_id = grfExpnD[i, colDid] == null ? "" : grfExpnD[i, colDid].ToString();
expndd.qty = grfExpnD[i, colDQty] == null ? "" : grfExpnD[i, colDQty].ToString();
expndd.unit_id = grfExpnD[i, colDUnitNameT] == null ? "" : xC.iniDB.utpDB.getIdByName(grfExpnD[i, colDUnitNameT].ToString().Trim());
expndd.unit_name_t = grfExpnD[i, colDUnitNameT] == null ? "" : grfExpnD[i, colDUnitNameT].ToString();
expndd.amount = grfExpnD[i, colDamt] == null ? "" : grfExpnD[i, colDamt].ToString();
expndd.remark = grfExpnD[i, colDremark] == null ? "" : grfExpnD[i, colDremark].ToString();
expndd.item_id = grfExpnD[i, colDItemNamet] == null ? "" : xC.iniDB.itmDB.getIdByName(grfExpnD[i, colDItemNamet].ToString().Trim());
expndd.item_name_t = grfExpnD[i, colDItemNamet] == null ? "" : grfExpnD[i, colDItemNamet].ToString();
expndd.price = grfExpnD[i, colDPrice] == null ? "" : grfExpnD[i, colDPrice].ToString();
expndd.wtax1 = grfExpnD[i, colDwatx1] == null ? "" : grfExpnD[i, colDwatx1].ToString();
expndd.wtax3 = grfExpnD[i, colDwatx3] == null ? "" : grfExpnD[i, colDwatx3].ToString();
expndd.vat = grfExpnD[i, colDvat] == null ? "" : grfExpnD[i, colDvat].ToString();
expndd.total = grfExpnD[i, colDtotal] == null ? "" : grfExpnD[i, colDtotal].ToString();
expndd.job_code = txtJobCode.Text;
expndd.job_id = jobId;
if (flagfom2 == flagForm2.Cheque)
{
expndd.pay_to_cus_name_t = grfExpnD[i, colDpaytocusnamet] == null ? "" : grfExpnD[i, colDpaytocusnamet].ToString();
expndd.pay_to_cus_addr = grfExpnD[i, colDpaytocusaddr] == null ? "" : grfExpnD[i, colDpaytocusaddr].ToString();
expndd.pay_to_cus_tax = grfExpnD[i, colDapaytocustax] == null ? "" : grfExpnD[i, colDapaytocustax].ToString();
expndd.receipt_no = grfExpnD[i, colDreceiptno] == null ? "" : grfExpnD[i, colDreceiptno].ToString();
expndd.receipt_date = grfExpnD[i, colDreceiptdate] == null ? "" : grfExpnD[i, colDreceiptdate].ToString();
expndd.pay_to_cus_id = grfExpnD[i, colDpaytocusid] == null ? "" : grfExpnD[i, colDpaytocusid].ToString();
}
if (flagfom2 == flagForm2.Cash)
{
expndd.status_pay_type = "1";
}
else
{
expndd.status_pay_type = "2";
}
expndd.status_page = "1";
expndd.status_hide = "1";
expndd.job_id = jobId;
expndd.status_doc = "0";
if (flagaction == flagAction.autoappv)
{
expndd.status_erc = "1";
expndd.pay_amount = expndd.amount;
expndd.pay_staff_id = cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : "";
}
else
{
expndd.status_erc = "0";
}
if (!expndd.amount.Equals(""))
{
xC.accDB.expnddDB.insertExpenseDrawDetail(expndd, xC.userId);
}
}
}
private Boolean setExpensesDrawDetail(String expnid, String cusid)
{
Boolean re = false;
int chk = 0, chkD = 0, chkD1 = 0;
for (int i = 1; i < grfExpnD.Rows.Count; i++)
{
if (grfExpnD.Row <= 0)
{
continue;
}
if (!grfExpnD[i, colDedit].ToString().Equals("1"))
{
continue;
}
chkD1++;
ExpensesDrawDatail expndd = new ExpensesDrawDatail();
expndd.expense_draw_id = expnid;
expndd.expenses_draw_detail_id = grfExpnD[i, colDid] == null ? "" : grfExpnD[i, colDid].ToString();
expndd.qty = grfExpnD[i, colDQty] == null ? "" : grfExpnD[i, colDQty].ToString();
expndd.unit_id = grfExpnD[i, colDUnitNameT] == null ? "" : xC.iniDB.utpDB.getIdByName(grfExpnD[i, colDUnitNameT].ToString().Trim());
expndd.unit_name_t = grfExpnD[i, colDUnitNameT] == null ? "" : grfExpnD[i, colDUnitNameT].ToString();
expndd.amount = grfExpnD[i, colDamt] == null ? "" : grfExpnD[i, colDamt].ToString();
expndd.remark = grfExpnD[i, colDremark] == null ? "" : grfExpnD[i, colDremark].ToString();
expndd.item_id = grfExpnD[i, colDItemNamet] == null ? "" : xC.iniDB.itmDB.getIdByName(grfExpnD[i, colDItemNamet].ToString().Trim());
expndd.item_name_t = grfExpnD[i, colDItemNamet] == null ? "" : grfExpnD[i, colDItemNamet].ToString();
expndd.price = grfExpnD[i, colDPrice] == null ? "" : grfExpnD[i, colDPrice].ToString();
expndd.wtax1 = grfExpnD[i, colDwatx1] == null ? "" : grfExpnD[i, colDwatx1].ToString();
expndd.wtax3 = grfExpnD[i, colDwatx3] == null ? "" : grfExpnD[i, colDwatx3].ToString();
expndd.vat = grfExpnD[i, colDvat] == null ? "" : grfExpnD[i, colDvat].ToString();
expndd.total = grfExpnD[i, colDtotal] == null ? "" : grfExpnD[i, colDtotal].ToString();
expndd.job_code = txtJobCode.Text;
expndd.job_id = txtID.Text;
//if (flagfom2 == flagForm2.Cheque)
//{
expndd.pay_to_cus_name_t = grfExpnD[i, colDpaytocusnamet] == null ? "" : grfExpnD[i, colDpaytocusnamet].ToString();
expndd.pay_to_cus_addr = grfExpnD[i, colDpaytocusaddr] == null ? "" : grfExpnD[i, colDpaytocusaddr].ToString();
expndd.pay_to_cus_tax = grfExpnD[i, colDapaytocustax] == null ? "" : grfExpnD[i, colDapaytocustax].ToString();
expndd.receipt_no = grfExpnD[i, colDreceiptno] == null ? "" : grfExpnD[i, colDreceiptno].ToString();
expndd.receipt_date = grfExpnD[i, colDreceiptdate] == null ? "" : grfExpnD[i, colDreceiptdate].ToString();
expndd.pay_to_cus_id = grfExpnD[i, colDpaytocusid] == null ? "" : grfExpnD[i, colDpaytocusid].ToString();
//}
expndd.status_pay_type = "1"; // cash fix ไปเลย เพราะ ป้อนเก็บข้อมูล ไม่ได้ทำเบิก
expndd.status_page = "2";
expndd.status_hide = "2";
//expndd.job_id = jobId;
//expndd.cust_id = cusid;
if (!expndd.amount.Equals(""))
{
String re1 = "";
re1 = xC.accDB.expnddDB.insertExpenseDrawDetail(expndd, xC.userId);
if (int.TryParse(re1, out chk))
{
chkD++;
grfExpnD[i, colDedit] = "-";
grfExpnD.Rows[i].StyleNew.BackColor = xC.cTxtFocus;
}
}
}
if (chkD == chkD1)
{
re = true;
}
return(re);
}
public ExpensesDrawDatail setExpenseDrawDetail(DataTable dt)
{
ExpensesDrawDatail curr1 = new ExpensesDrawDatail();
if (dt.Rows.Count > 0)
{
curr1.expenses_draw_detail_id = dt.Rows[0][expnC.expenses_draw_detail_id].ToString();
curr1.desc1 = dt.Rows[0][expnC.desc1].ToString();
curr1.desc2 = dt.Rows[0][expnC.desc2].ToString();
curr1.amount = dt.Rows[0][expnC.amount].ToString();
curr1.active = dt.Rows[0][expnC.active].ToString();
curr1.date_cancel = dt.Rows[0][expnC.date_cancel].ToString();
curr1.date_create = dt.Rows[0][expnC.date_create].ToString();
curr1.date_modi = dt.Rows[0][expnC.date_modi].ToString();
curr1.user_cancel = dt.Rows[0][expnC.user_cancel].ToString();
curr1.user_create = dt.Rows[0][expnC.user_create].ToString();
curr1.user_modi = dt.Rows[0][expnC.user_modi].ToString();
//pti1.status_app = dt.Rows[0][tmn.status_app].ToString();
curr1.remark = dt.Rows[0][expnC.remark].ToString();
curr1.sort1 = dt.Rows[0][expnC.sort1].ToString();
curr1.expense_draw_id = dt.Rows[0][expnC.expense_draw_id].ToString();
curr1.expense_type_id = dt.Rows[0][expnC.expense_type_id].ToString();
curr1.status_pay = dt.Rows[0][expnC.status_pay].ToString();
curr1.status_pay_type = dt.Rows[0][expnC.status_pay_type].ToString();
curr1.pay_amount = dt.Rows[0][expnC.pay_amount].ToString();
curr1.pay_date = dt.Rows[0][expnC.pay_date].ToString();
curr1.pay_cheque_no = dt.Rows[0][expnC.pay_cheque_no].ToString();
curr1.comp_bank_id = dt.Rows[0][expnC.comp_bank_id].ToString();
curr1.pay_staff_id = dt.Rows[0][expnC.pay_staff_id].ToString();
curr1.item_id = dt.Rows[0][expnC.item_id].ToString();
curr1.pay_bank_date = dt.Rows[0][expnC.pay_bank_date].ToString();
curr1.job_id = dt.Rows[0][expnC.job_id].ToString();
curr1.job_code = dt.Rows[0][expnC.job_code].ToString();
curr1.qty = dt.Rows[0][expnC.qty].ToString();
curr1.price = dt.Rows[0][expnC.price].ToString();
curr1.unit_id = dt.Rows[0][expnC.unit_id].ToString();
curr1.wtax1 = dt.Rows[0][expnC.wtax1].ToString();
curr1.wtax3 = dt.Rows[0][expnC.wtax3].ToString();
curr1.vat = dt.Rows[0][expnC.vat].ToString();
curr1.total = dt.Rows[0][expnC.total].ToString();
curr1.item_name_t = dt.Rows[0][expnC.item_name_t].ToString();
curr1.unit_name_t = dt.Rows[0][expnC.unit_name_t].ToString();
curr1.pay_to_cus_id = dt.Rows[0][expnC.pay_to_cus_id].ToString();
curr1.pay_to_cus_name_t = dt.Rows[0][expnC.pay_to_cus_name_t].ToString();
curr1.pay_to_cus_addr = dt.Rows[0][expnC.pay_to_cus_addr].ToString();
curr1.pay_to_cus_tax = dt.Rows[0][expnC.pay_to_cus_tax].ToString();
curr1.receipt_no = dt.Rows[0][expnC.receipt_no].ToString();
curr1.receipt_date = dt.Rows[0][expnC.receipt_date].ToString();
curr1.status_page = dt.Rows[0][expnC.status_page].ToString();
curr1.status_hide = dt.Rows[0][expnC.status_hide].ToString();
curr1.status_doc = dt.Rows[0][expnC.status_doc].ToString();
curr1.receipt_amount = dt.Rows[0][expnC.receipt_amount].ToString();
curr1.erc_doc = dt.Rows[0][expnC.erc_doc].ToString();
curr1.status_erc = dt.Rows[0][expnC.status_erc].ToString();
curr1.status_appv = dt.Rows[0][expnC.status_appv].ToString();
curr1.wtax5 = dt.Rows[0][expnC.wtax5].ToString();
curr1.amt_wtax1 = dt.Rows[0][expnC.amt_wtax1].ToString();
curr1.amt_wtax3 = dt.Rows[0][expnC.amt_wtax3].ToString();
curr1.amt_wtax5 = dt.Rows[0][expnC.amt_wtax5].ToString();
}
else
{
curr1.expenses_draw_detail_id = "";
curr1.desc1 = "";
curr1.desc2 = "";
curr1.amount = "";
//tmn.status_app = "status_app";
curr1.sort1 = "";
curr1.active = "";
curr1.date_create = "";
curr1.date_modi = "";
curr1.date_cancel = "";
curr1.user_create = "";
curr1.user_modi = "";
curr1.user_cancel = "";
curr1.expense_draw_id = "";
curr1.remark = "";
curr1.expense_type_id = "";
curr1.status_pay = "";
curr1.status_pay_type = "";
curr1.pay_amount = "";
curr1.pay_date = "";
curr1.pay_cheque_no = "";
curr1.comp_bank_id = "";
curr1.pay_staff_id = "";
curr1.item_id = "";
curr1.pay_bank_date = "";
curr1.job_id = "";
curr1.job_code = "";
curr1.qty = "";
curr1.price = "";
curr1.unit_id = "";
curr1.wtax1 = "";
curr1.wtax3 = "";
curr1.vat = "";
curr1.total = "";
curr1.item_name_t = "";
curr1.unit_name_t = "";
curr1.pay_to_cus_id = "";
curr1.pay_to_cus_name_t = "";
curr1.pay_to_cus_addr = "";
curr1.pay_to_cus_tax = "";
curr1.receipt_no = "";
curr1.receipt_date = "";
curr1.status_page = "";
curr1.status_hide = "";
curr1.status_doc = "";
curr1.receipt_amount = "";
curr1.erc_doc = "";
curr1.status_erc = "";
curr1.status_appv = "";
curr1.wtax5 = "";
curr1.amt_wtax1 = "";
curr1.amt_wtax3 = "";
curr1.amt_wtax5 = "";
}
return(curr1);
}
private void initConfig()
{
expnC = new ExpensesDrawDatail();
expnC.expenses_draw_detail_id = "expenses_draw_detail_id";
expnC.desc1 = "desc1";
expnC.desc2 = "desc2";
expnC.amount = "amount";
//tmn.status_app = "status_app";
expnC.sort1 = "sort1";
expnC.active = "active";
expnC.date_create = "date_create";
expnC.date_modi = "date_modi";
expnC.date_cancel = "date_cancel";
expnC.user_create = "user_create";
expnC.user_modi = "user_modi";
expnC.user_cancel = "user_cancel";
expnC.expense_draw_id = "expenses_draw_id";
expnC.remark = "remark";
expnC.expense_type_id = "expenses_type_id";
expnC.status_pay = "status_pay";
expnC.status_pay_type = "status_pay_type";
expnC.pay_amount = "pay_amount";
expnC.pay_date = "pay_date";
expnC.pay_cheque_no = "pay_cheque_no";
expnC.comp_bank_id = "comp_bank_id";
expnC.pay_staff_id = "pay_staff_id";
expnC.item_id = "item_id";
expnC.pay_bank_date = "pay_bank_date";
expnC.job_id = "job_id";
expnC.job_code = "job_code";
expnC.qty = "qty";
expnC.price = "price";
expnC.unit_id = "unit_id";
expnC.wtax1 = "wtax1";
expnC.wtax3 = "wtax3";
expnC.vat = "vat";
expnC.total = "total";
expnC.item_name_t = "item_name_t";
expnC.unit_name_t = "unit_name_t";
expnC.pay_to_cus_id = "pay_to_cus_id";
expnC.pay_to_cus_name_t = "pay_to_cus_name_t";
expnC.pay_to_cus_addr = "pay_to_cus_addr";
expnC.pay_to_cus_tax = "pay_to_cus_tax";
expnC.receipt_no = "receipt_no";
expnC.receipt_date = "receipt_date";
expnC.expenses_pay_detail_id = "expenses_pay_detail_id";
expnC.status_page = "status_page";
expnC.status_hide = "status_hide";
expnC.status_doc = "status_doc";
expnC.receipt_amount = "receipt_amount";
expnC.erc_doc = "erc_doc";
expnC.status_erc = "status_erc";
expnC.status_appv = "status_appv";
expnC.wtax5 = "wtax5";
expnC.amt_wtax1 = "wtax1";
expnC.amt_wtax3 = "wtax3";
expnC.amt_wtax5 = "wtax5";
expnC.table = "t_expenses_draw_detail";
expnC.pkField = "expenses_draw_detail_id";
lexpnC = new List <ExpensesDrawDatail>();
}
public String insert(ExpensesDrawDatail p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
//p.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0";
//p.dept_id = int.TryParse(p.dept_id, out chk) ? chk.ToString() : "0";
p.status_pay = "1";
sql = "Insert Into " + expnC.table + "(" + expnC.desc1 + "," + expnC.desc2 + "," + expnC.amount + "," +
expnC.date_create + "," + expnC.date_modi + "," + expnC.date_cancel + "," +
expnC.user_create + "," + expnC.user_modi + "," + expnC.user_cancel + "," +
expnC.active + "," + expnC.remark + ", " + expnC.sort1 + "," +
expnC.expense_draw_id + "," + expnC.expense_type_id + "," + expnC.status_pay + "," +
expnC.status_pay_type + "," + expnC.pay_amount + "," + expnC.pay_date + ", " +
expnC.pay_cheque_no + "," + expnC.comp_bank_id + "," + expnC.pay_staff_id + ", " +
expnC.item_id + "," + expnC.pay_bank_date + "," + expnC.job_id + "," +
expnC.job_code + "," + expnC.qty + "," + expnC.price + "," +
expnC.unit_id + "," + expnC.wtax1 + "," + expnC.wtax3 + "," +
expnC.vat + "," + expnC.total + "," + expnC.item_name_t + "," +
expnC.unit_name_t + ", " + expnC.expenses_pay_detail_id + ", " +
expnC.pay_to_cus_id + "," + expnC.pay_to_cus_name_t + "," + expnC.pay_to_cus_addr + "," +
expnC.pay_to_cus_tax + "," + expnC.receipt_no + "," + expnC.receipt_date + "," +
expnC.status_page + "," + expnC.status_hide + "," + expnC.status_doc + "," +
expnC.receipt_amount + "," + expnC.erc_doc + "," + expnC.status_erc + "," +
expnC.status_appv + "," + expnC.wtax5 + ", " +
expnC.amt_wtax1 + "," + expnC.amt_wtax3 + "," + expnC.amt_wtax5 + " " +
") " +
"Values ('" + p.desc1.Replace("'", "''") + "','" + p.desc2.Replace("'", "''") + "','" + p.amount + "'," +
"'" + p.date_create + "','" + p.date_modi + "','" + p.date_cancel + "'," +
"'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
"'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.sort1 + "', " +
"'" + p.expense_draw_id + "','" + p.expense_type_id.Replace("'", "''") + "','" + p.status_pay + "'," +
"'" + p.status_pay_type + "','" + p.pay_amount.Replace("'", "''") + "','" + p.pay_date + "'," +
"'" + p.pay_cheque_no + "','" + p.comp_bank_id.Replace("'", "''") + "','" + p.pay_staff_id + "'," +
"'" + p.item_id + "','" + p.pay_bank_date.Replace("'", "''") + "','" + p.job_id + "'," +
"'" + p.job_code + "','" + p.qty + "','" + p.price + "'," +
"'" + p.unit_id + "','" + p.wtax1 + "','" + p.wtax3 + "'," +
"'" + p.vat + "','" + p.total + "','" + p.item_name_t + "'," +
"'" + p.unit_name_t + "','" + p.expenses_pay_detail_id + "'," +
"'" + p.pay_to_cus_id + "','" + p.pay_to_cus_name_t + "','" + p.pay_to_cus_addr + "'," +
"'" + p.pay_to_cus_tax + "','" + p.receipt_no + "','" + p.receipt_date + "', " +
"'" + p.status_page + "','" + p.status_hide + "','" + p.status_doc + "'," +
"'" + p.receipt_amount + "','" + p.erc_doc + "','" + p.status_erc + "'," +
"'" + p.status_appv + "','" + p.wtax5 + "'," +
"'" + p.amt_wtax1 + "','" + p.amt_wtax3 + "','" + p.amt_wtax5 + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void chkNull(ExpensesDrawDatail 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.desc1 = p.desc1 == null ? "" : p.desc1;
p.desc2 = p.desc2 == null ? "" : p.desc2;
//p.amount = p.amount == null ? "" : p.amount;
p.remark = p.remark == null ? "" : p.remark;
p.sort1 = p.sort1 == null ? "" : p.sort1;
p.status_pay = p.status_pay == null ? "" : p.status_pay;
p.status_pay_type = p.status_pay_type == null ? "" : p.status_pay_type;
p.pay_date = p.pay_date == null ? "" : p.pay_date;
p.pay_cheque_no = p.pay_cheque_no == null ? "" : p.pay_cheque_no;
p.pay_bank_date = p.pay_bank_date == null ? "" : p.pay_bank_date;
p.job_code = p.job_code == null ? "" : p.job_code;
p.item_name_t = p.item_name_t == null ? "" : p.item_name_t;
p.unit_name_t = p.unit_name_t == null ? "" : p.unit_name_t;
p.pay_to_cus_name_t = p.pay_to_cus_name_t == null ? "" : p.pay_to_cus_name_t;
p.pay_to_cus_addr = p.pay_to_cus_addr == null ? "" : p.pay_to_cus_addr;
p.pay_to_cus_tax = p.pay_to_cus_tax == null ? "" : p.pay_to_cus_tax;
p.receipt_no = p.receipt_no == null ? "" : p.receipt_no;
p.receipt_date = p.receipt_date == null ? "" : p.receipt_date;
p.status_page = p.status_page == null ? "0" : p.status_page;
p.status_hide = p.status_hide == null ? "0" : p.status_hide;
p.status_doc = p.status_doc == null ? "0" : p.status_doc;
p.erc_doc = p.erc_doc == null ? "" : p.erc_doc;
p.status_erc = p.status_erc == null ? "0" : p.status_erc;
p.status_appv = p.status_appv == null ? "0" : p.status_appv;
p.expense_draw_id = int.TryParse(p.expense_draw_id, out chk) ? chk.ToString() : "0";
p.expense_type_id = int.TryParse(p.expense_type_id, out chk) ? chk.ToString() : "0";
p.comp_bank_id = int.TryParse(p.comp_bank_id, out chk) ? chk.ToString() : "0";
p.item_id = int.TryParse(p.item_id, out chk) ? chk.ToString() : "0";
p.pay_staff_id = int.TryParse(p.pay_staff_id, out chk) ? chk.ToString() : "0";
p.job_id = int.TryParse(p.job_id, out chk) ? chk.ToString() : "0";
p.unit_id = int.TryParse(p.unit_id, out chk) ? chk.ToString() : "0";
p.pay_to_cus_id = int.TryParse(p.pay_to_cus_id, out chk) ? chk.ToString() : "0";
p.expenses_pay_detail_id = int.TryParse(p.expenses_pay_detail_id, out chk) ? chk.ToString() : "0";
p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0";
p.pay_amount = Decimal.TryParse(p.pay_amount, out chk1) ? chk1.ToString() : "0";
p.qty = Decimal.TryParse(p.qty, out chk1) ? chk1.ToString() : "0";
p.price = Decimal.TryParse(p.price, out chk1) ? chk1.ToString() : "0";
p.wtax1 = Decimal.TryParse(p.wtax1, out chk1) ? chk1.ToString() : "0";
p.wtax3 = Decimal.TryParse(p.wtax3, out chk1) ? chk1.ToString() : "0";
p.vat = Decimal.TryParse(p.vat, out chk1) ? chk1.ToString() : "0";
p.total = Decimal.TryParse(p.total, out chk1) ? chk1.ToString() : "0";
p.receipt_amount = Decimal.TryParse(p.receipt_amount, out chk1) ? chk1.ToString() : "0";
p.wtax5 = Decimal.TryParse(p.wtax5, out chk1) ? chk1.ToString() : "0";
p.amt_wtax1 = Decimal.TryParse(p.amt_wtax1, out chk1) ? chk1.ToString() : "0";
p.amt_wtax3 = Decimal.TryParse(p.amt_wtax3, out chk1) ? chk1.ToString() : "0";
p.amt_wtax5 = Decimal.TryParse(p.amt_wtax5, out chk1) ? chk1.ToString() : "0";
}
