public String updateReserve(ReservePay p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + rsp.table + " Set " +
" " + rsp.amount_reserve + " = '" + p.amount_reserve.Replace("'", "''") + "'" +
"," + rsp.date_reserve + " = '" + p.date_reserve.Replace("'", "''") + "'" +
"," + rsp.date_modi + " = now()" +
"," + rsp.user_modi + " = '" + userId + "' " +
"Where " + rsp.pkField + "='" + p.reserve_pay_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String updateReserveAmt(String rspid, String userid)
{
String re = "";
ReservePay rsp = new ReservePay();
rsp = accDB.rspDB.selectByPk1(rspid);
if (!rsp.reserve_pay_id.Equals(""))
{
re = accDB.rspDB.updateReserve(rspid, userid);
ReserveCash rsc = new ReserveCash();
rsc.reserve_cash_id = "";
rsc.reserve_pay_id = rsp.reserve_pay_id;
rsc.expenses_pay_detail_id = "0";
rsc.amount = rsp.amount_appv;
rsc.active = "1";
rsc.remark = "เบิกเงินสำรองจ่าย";
rsc.date_create = "";
rsc.date_modi = "";
rsc.date_cancel = "";
rsc.user_create = "";
rsc.user_modi = "";
rsc.user_cancel = "";
rsc.status_reserve = "1";
rsc.desc1 = rsp.desc1;
re = accDB.rscDB.insertReserveCash(rsc, userId);
int chk = 0;
if (int.TryParse(re, out chk))
{
re = xtDB.copDB.updateAmountReserve(rsp.amount_appv);
}
}
//re = xtDB.expndDB.updateSendToApprove(doc, id);
return(re);
}
private void initConfig()
{
rsp = new ReservePay();
rsp.reserve_pay_id = "reserve_pay_id";
rsp.status_appv = "status_appv";
rsp.desc1 = "desc1";
rsp.active = "active";
rsp.date_create = "date_create";
rsp.date_modi = "date_modi";
rsp.date_cancel = "date_cancel";
rsp.user_create = "user_create";
rsp.user_modi = "user_modi";
rsp.user_cancel = "user_cancel";
rsp.remark = "remark";
rsp.amount_draw = "amount_draw";
rsp.amount_appv = "amount_appv";
rsp.amount_reserve = "amount_reserve";
rsp.date_draw = "date_draw";
rsp.date_appv = "date_appv";
rsp.date_reserve = "date_reserve";
rsp.staff_id = "staff_id";
rsp.amount_onhand = "amount_onhand";
rsp.table = "t_reserve_pay";
rsp.pkField = "reserve_pay_id";
lRsp = new List <ReservePay>();
}
private ReservePay setReservePay(String amt)
{
ReservePay rsp = new ReservePay();
rsp.reserve_pay_id = "";
rsp.desc1 = "คืนเงินจากที่เบิก";
rsp.amount_draw = amt;
rsp.date_draw = xC.datetoDB(System.DateTime.Now);
rsp.staff_id = cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : "";
rsp.status_appv = "1";
return(rsp);
}
public ReservePay setReservePay(DataTable dt)
{
ReservePay curr1 = new ReservePay();
if (dt.Rows.Count > 0)
{
curr1.reserve_pay_id = dt.Rows[0][rsp.reserve_pay_id].ToString();
curr1.desc1 = dt.Rows[0][rsp.desc1].ToString();
curr1.amount_draw = dt.Rows[0][rsp.amount_draw].ToString();
curr1.active = dt.Rows[0][rsp.active].ToString();
curr1.date_cancel = dt.Rows[0][rsp.date_cancel].ToString();
curr1.date_create = dt.Rows[0][rsp.date_create].ToString();
curr1.date_modi = dt.Rows[0][rsp.date_modi].ToString();
curr1.user_cancel = dt.Rows[0][rsp.user_cancel].ToString();
curr1.user_create = dt.Rows[0][rsp.user_create].ToString();
curr1.user_modi = dt.Rows[0][rsp.user_modi].ToString();
curr1.remark = dt.Rows[0][rsp.remark].ToString();
curr1.amount_appv = dt.Rows[0][rsp.amount_appv].ToString();
curr1.amount_reserve = dt.Rows[0][rsp.amount_reserve].ToString();
curr1.date_appv = dt.Rows[0][rsp.date_appv].ToString();
curr1.date_draw = dt.Rows[0][rsp.date_draw].ToString();
curr1.date_reserve = dt.Rows[0][rsp.date_reserve].ToString();
curr1.staff_id = dt.Rows[0][rsp.staff_id].ToString();
curr1.status_appv = dt.Rows[0][rsp.status_appv].ToString();
curr1.amount_onhand = dt.Rows[0][rsp.amount_onhand].ToString();
}
else
{
curr1.reserve_pay_id = "";
curr1.desc1 = "";
curr1.amount_draw = "0";
curr1.active = "";
curr1.date_create = "";
curr1.date_modi = "";
curr1.date_cancel = "";
curr1.user_create = "";
curr1.user_modi = "";
curr1.user_cancel = "";
curr1.remark = "";
curr1.amount_appv = "0";
curr1.amount_reserve = "";
curr1.date_appv = "";
curr1.date_draw = "";
curr1.date_reserve = "";
curr1.staff_id = "";
curr1.status_appv = "";
curr1.amount_onhand = "0";
}
return(curr1);
}
public ReservePay selectByPk1(String copId)
{
ReservePay cop1 = new ReservePay();
DataTable dt = new DataTable();
String sql = "select expC.* " +
"From " + rsp.table + " expC " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where expC." + rsp.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setReservePay(dt);
return(cop1);
}
public ReservePay selectByOnhandOLD()
{
ReservePay cop1 = new ReservePay();
DataTable dt = new DataTable();
String sql = "select expC.* " +
"From " + rsp.table + " expC " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where expC." + rsp.amount_onhand + " >0 " +
"Order By " + rsp.pkField + " asc Limit 1";
dt = conn.selectData(conn.conn, sql);
cop1 = setReservePay(dt);
return(cop1);
}
public String insertReservePay(ReservePay p, String userId)
{
String re = "";
if (p.reserve_pay_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
public void getlExpnT()
{
//lDept = new List<Department>();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
ReservePay curr1 = new ReservePay();
curr1.reserve_pay_id = row[rsp.reserve_pay_id].ToString();
curr1.desc1 = row[rsp.desc1].ToString();
lRsp.Add(curr1);
}
}
public String insert(ReservePay p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
p.amount_onhand = "0";
//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";
sql = "Insert Into " + rsp.table + "(" + rsp.desc1 + "," + rsp.amount_draw + "," + rsp.amount_appv + "," +
rsp.date_create + "," + rsp.date_modi + "," + rsp.date_cancel + "," +
rsp.user_create + "," + rsp.user_modi + "," + rsp.user_cancel + "," +
rsp.active + "," + rsp.remark + ", " + rsp.amount_reserve + ", " +
rsp.date_appv + "," + rsp.date_draw + ", " + rsp.date_reserve + ", " +
rsp.staff_id + "," + rsp.amount_onhand + "," + rsp.status_appv + " " +
") " +
"Values ('" + p.desc1.Replace("'", "''") + "','" + p.amount_draw.Replace("'", "''") + "','" + p.amount_appv.Replace("'", "''") + "', " +
"'" + p.date_create + "','" + p.date_modi + "','" + p.date_cancel + "'," +
"'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
"'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.amount_reserve.Replace("'", "''") + "', " +
"'" + p.date_appv + "','" + p.date_draw.Replace("'", "''") + "','" + p.date_reserve.Replace("'", "''") + "', " +
"'" + p.staff_id + "','" + p.amount_onhand + "','" + p.status_appv + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void chkNull(ReservePay 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.desc1 = p.desc1 == null ? "" : p.desc1;
p.remark = p.remark == null ? "" : p.remark;
p.date_draw = p.date_draw == null ? "" : p.date_draw;
p.date_appv = p.date_appv == null ? "" : p.date_appv;
p.date_reserve = p.date_reserve == null ? "" : p.date_reserve;
p.staff_id = p.staff_id == null ? "0" : p.staff_id;
p.amount_draw = Decimal.TryParse(p.amount_draw, out chk1) ? chk1.ToString() : "0";
p.amount_appv = Decimal.TryParse(p.amount_appv, out chk1) ? chk1.ToString() : "0";
p.amount_reserve = Decimal.TryParse(p.amount_reserve, out chk1) ? chk1.ToString() : "0";
p.amount_onhand = Decimal.TryParse(p.amount_onhand, out chk1) ? chk1.ToString() : "0";
}
private void setControlRsp(String rspid)
{
if (!rspid.Equals(""))
{
ReservePay rsp = new ReservePay();
rsp = xC.accDB.rspDB.selectByPk1(rspid);
txtID.Value = rsp.reserve_pay_id;
txtDesc.Value = rsp.desc1;
txtAmt.Value = rsp.amount_draw;
txtDateDraw.Value = rsp.date_draw;
xC.setC1Combo(cboStaff, rsp.staff_id);
Company cop = new Company();
cop = xC.xtDB.copDB.selectByCode1("001");
txtAmtReserve.Value = cop.amount_reserve;
txtRspWait.Value = xC.accDB.rspDB.selectAppvWait();
if (rsp.status_appv.Equals("2"))
{
btnAppv.Enabled = false;
Decimal chk = 0;
if (Decimal.TryParse(rsp.amount_reserve, out chk))
{
btnRsp.Enabled = false;
}
}
}
else
{
DateTime jobDate = DateTime.Now;
txtDateDraw.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
txtID.Value = "";
txtDesc.Value = "";
txtAmt.Value = "";
//txtDateDraw.Value = "";
xC.setC1Combo(cboStaff, xC.userId);
}
if (flagForm.Equals("appv"))
{
btnNew.Hide();
btnEdit.Hide();
btnSave.Hide();
btnAppv.Show();
btnRsp.Hide();
flagEdit = false;
setControlEnable(flagEdit);
}
else if (flagForm.Equals("reserve"))
{
btnNew.Hide();
btnEdit.Hide();
btnSave.Hide();
btnAppv.Hide();
btnRsp.Show();
}
else if (flagForm.Equals("draw"))
{
btnNew.Show();
btnEdit.Show();
btnSave.Show();
btnAppv.Hide();
btnRsp.Hide();
}
}
private void initConfig()
{
rsp = new ReservePay();
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");
theme1.SetTheme(panel3, "Office2010Black");
foreach (Control c in panel3.Controls)
{
theme1.SetTheme(c, "Office2010Black");
}
//theme1.SetTheme(txtDesc, "Office2010Green");
bg = txtID.BackColor;
fc = txtID.ForeColor;
ff = txtID.Font;
xC.xtDB.stfDB.setCboStaff(cboStaff, xC.userId);
DateTime jobDate = DateTime.Now;
txtDateDraw.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
//jobDate = jobDate.AddDays(7);
//txtDateDraw.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp;
btnNew.Click += BtnNew_Click;
btnEdit.Click += BtnEdit_Click;
btnSave.Click += BtnSave_Click;
btnAppv.Click += BtnAppv_Click;
btnRsp.Click += BtnRsp_Click;
//xC.xtDB.stfDB.setCboStaff(cboStaff, "");
initGrfDept();
//theme1.SetTheme(grfExpnD, "Office2010Black");
setGrfDeptH();
setControlEnable(false);
//setFocusColor();
//setControlAppv();
//setControl(drawId);
sB1.Text = "";
btnVoid.Hide();
txtPasswordVoid.Hide();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
//stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold;
if (flagForm.Equals("appv"))
{
btnNew.Hide();
btnEdit.Hide();
btnSave.Hide();
btnAppv.Show();
btnRsp.Hide();
flagEdit = false;
setControlEnable(flagEdit);
txtAmt.Enabled = true; //ที่ทำแบบนี้ เพราะ ใส่ theme แล้ว disable ทำให้ มองตัวอักษร ไม่ชัด
txtDesc.Enabled = true; //ที่ทำแบบนี้ เพราะ ใส่ theme แล้ว disable ทำให้ มองตัวอักษร ไม่ชัด
}
else if (flagForm.Equals("reserve"))
{
btnNew.Hide();
btnEdit.Hide();
btnSave.Hide();
btnAppv.Hide();
btnRsp.Show();
btnRsp.Enabled = true;
}
else if (flagForm.Equals("draw"))
{
btnNew.Show();
btnEdit.Show();
btnSave.Show();
btnAppv.Hide();
btnRsp.Hide();
}
}
public String updateOnhand(String expnpdid, String userId, String amt, String name1, String name2)
{
String re = "";
String sql = "";
int chk = 0;
Decimal amt1 = 0, onhand = 0;
Boolean chkOnhand = false;
if (!Decimal.TryParse(amt, out amt1))
{
return("");
}
//chkNull(p);
//1.ดึงข้อมุล ดูว่ามี onhand ใบเก่า เหลือเงินเท่าไร
//2.ถ้าเงินเหลือพอ ตัดยอด
//3.เงินไม่พอ ให้ตัด เท่าที่มี
//3.1 ดึงข้อมูล ใหม่ แล้วตัดยอดใหม่
for (int i = 1; i < 5; i++)
{
if (chkOnhand)
{
continue;
}
ReservePay rsp1 = new ReservePay();
rsp1 = rspDB.selectByOnhandOLD();
if (Decimal.TryParse(rsp1.amount_onhand, out onhand))
{
if (onhand >= amt1) //2.ถ้าเงินเหลือพอ ตัดยอด
{
//amt1 = 1000;
sql = "Update " + rspDB.rsp.table + " Set " +
" " + rspDB.rsp.amount_onhand + " = " + rspDB.rsp.amount_onhand + "-" + amt1 + " " +
"," + rspDB.rsp.date_reserve + " = now() " +
"," + rspDB.rsp.date_modi + " = now() " +
"," + rspDB.rsp.user_modi + " = '" + userId + "' " +
"Where " + rspDB.rsp.pkField + "='" + rsp1.reserve_pay_id + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
re = copDB.updateAmountReserve("-" + amt1.ToString());
ReserveCash rsc = new ReserveCash();
rsc.reserve_cash_id = "";
rsc.reserve_pay_id = rsp1.reserve_pay_id;
rsc.expenses_pay_detail_id = expnpdid;
rsc.amount = "-" + amt1;
rsc.active = "1";
rsc.remark = "";
rsc.date_create = "";
rsc.date_modi = "";
rsc.date_cancel = "";
rsc.user_create = "";
rsc.user_modi = "";
rsc.user_cancel = "";
rsc.status_reserve = "2";
rsc.desc1 = "จ่ายเงิน " + name1 + " " + name2;
re = rscDB.insertReserveCash(rsc, userId);
chkOnhand = true;
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
}
else
{
sql = "Update " + rspDB.rsp.table + " Set " +
" " + rspDB.rsp.amount_onhand + " = " + rspDB.rsp.amount_onhand + "-" + onhand + " " +
"," + rspDB.rsp.date_reserve + " = now() " +
"," + rspDB.rsp.date_modi + " = now() " +
"," + rspDB.rsp.user_modi + " = '" + userId + "' " +
"Where " + rspDB.rsp.pkField + "='" + rsp1.reserve_pay_id + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
amt1 = amt1 - onhand;
re = copDB.updateAmountReserve("-" + amt1.ToString());
ReserveCash rsc = new ReserveCash();
rsc.reserve_cash_id = "";
rsc.reserve_pay_id = rsp1.reserve_pay_id;
rsc.expenses_pay_detail_id = expnpdid;
rsc.amount = "-" + onhand.ToString();
rsc.active = "1";
rsc.remark = "";
rsc.date_create = "";
rsc.date_modi = "";
rsc.date_cancel = "";
rsc.user_create = "";
rsc.user_modi = "";
rsc.user_cancel = "";
rsc.status_reserve = "2";
rsc.desc1 = "จ่ายเงิน ";
rscDB.insertReserveCash(rsc, userId);
chkOnhand = false;
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
}
}
}
return(re);
}
private void BtnSave_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
if (calSave())
{
if (MessageBox.Show("ต้องการ บันทึกช้อมูล ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
String stfId = cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : "";
String ercDoc = "";
ercDoc = xC.xtDB.copDB.genErcDoc();
foreach (Row row in grfEcc.Rows)
{
if (row[colflag] == null)
{
continue;
}
if (row[colEccPdId] == null)
{
continue;
}
String flag = "", id = "", re1 = "", pdid = "", amt = "";
Decimal chk = 0;
flag = row[colflag].ToString();
id = row[colEccId].ToString();
pdid = row[colEccPdId].ToString();
amt = row[colEccAmt].ToString();
if (!Decimal.TryParse(amt, out chk))
{
continue;
}
if (flag.Equals("ecc"))
{
re1 = xC.accDB.eccDB.updateStatusApprove(id, ercDoc, pdid);
re1 = xC.accDB.expnpdDB.updateStatusApprove(pdid, ercDoc, amt);
re1 = xC.accDB.expnddDB.updateStatusApprove(id, ercDoc, pdid);
}
else if (flag.Equals("erf"))
{
re1 = xC.accDB.erfDB.updateStatusApprove(id, ercDoc, pdid);
ReservePay rsp = new ReservePay();
rsp = setReservePay(amt);
String rspid = xC.accDB.rspDB.insertReservePay(rsp, xC.user.staff_id);
re1 = xC.accDB.rspDB.updateAppv(rspid, xC.user.staff_id);
re1 = xC.updateReserveAmt(rspid, xC.user.staff_id);
}
else if (flag.Equals("dd"))
{
re1 = xC.accDB.expnddDB.updateStatusApprove(id, ercDoc, pdid);
}
}
//String re = xC.updateClearCashComplete(cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : "");
//int chk = 0;
//if (int.TryParse(re.Replace("CC", ""), out chk))
//{
// txtErcDoc.Value = re;
// btnSave.Image = Resources.accept_database24;
//}
//else
//{
// btnSave.Image = Resources.accept_database24;
//}
}
}
}
