public String insertReserveCash(ReserveCash p, String userId)
{
String re = "";
if (p.reserve_cash_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
private void chkNull(ReserveCash 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.remark = p.remark == null ? "" : p.remark;
p.status_reserve = p.status_reserve == null ? "0" : p.status_reserve;
p.desc1 = p.desc1 == null ? "" : p.desc1;
p.expenses_pay_detail_id = int.TryParse(p.expenses_pay_detail_id, out chk) ? chk.ToString() : "0";
p.reserve_pay_id = int.TryParse(p.reserve_pay_id, out chk) ? chk.ToString() : "0";
//p.billing_cover_id = int.TryParse(p.billing_cover_id, out chk) ? chk.ToString() : "0";
p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0";
}
public ReserveCash setReserveCash(DataTable dt)
{
ReserveCash bll1 = new ReserveCash();
if (dt.Rows.Count > 0)
{
bll1.reserve_cash_id = dt.Rows[0][rsc.reserve_cash_id].ToString();
bll1.reserve_pay_id = dt.Rows[0][rsc.reserve_pay_id].ToString();
bll1.expenses_pay_detail_id = dt.Rows[0][rsc.expenses_pay_detail_id].ToString();
bll1.active = dt.Rows[0][rsc.active].ToString();
bll1.date_cancel = dt.Rows[0][rsc.date_cancel].ToString();
bll1.date_create = dt.Rows[0][rsc.date_create].ToString();
bll1.date_modi = dt.Rows[0][rsc.date_modi].ToString();
bll1.user_cancel = dt.Rows[0][rsc.user_cancel].ToString();
bll1.user_create = dt.Rows[0][rsc.user_create].ToString();
bll1.user_modi = dt.Rows[0][rsc.user_modi].ToString();
bll1.remark = dt.Rows[0][rsc.remark].ToString();
bll1.amount = dt.Rows[0][rsc.amount].ToString();
bll1.status_reserve = dt.Rows[0][rsc.status_reserve].ToString();
}
else
{
bll1.reserve_cash_id = "";
bll1.reserve_pay_id = "";
bll1.expenses_pay_detail_id = "";
bll1.amount = "";
bll1.active = "";
bll1.remark = "";
bll1.date_create = "";
bll1.date_modi = "";
bll1.date_cancel = "";
bll1.user_create = "";
bll1.user_modi = "";
bll1.user_cancel = "";
bll1.status_reserve = "";
}
return(bll1);
}
private void initConfig()
{
rsc = new ReserveCash();
rsc.reserve_cash_id = "reserve_cash_id";
rsc.reserve_pay_id = "reserve_pay_id";
rsc.expenses_pay_detail_id = "expenses_pay_detail_id";
rsc.amount = "amount";
rsc.active = "active";
rsc.remark = "remark";
rsc.date_create = "date_create";
rsc.date_modi = "date_modi";
rsc.date_cancel = "date_cancel";
rsc.user_create = "user_create";
rsc.user_modi = "user_modi";
rsc.user_cancel = "user_cancel";
rsc.status_reserve = "status_reserve";
rsc.desc1 = "desc1";
rsc.table = "t_reserve_cash";
rsc.pkField = "reserve_cash_id";
lexpn = new List <ReserveCash>();
}
public String update(ReserveCash p, String userId)
{
String re = "", sql = "";
chkNull(p);
sql = "Update " + rsc.table + " Set " +
" " + rsc.expenses_pay_detail_id + "='" + p.expenses_pay_detail_id + "' " +
"," + rsc.reserve_pay_id + "='" + p.reserve_pay_id.Replace("'", "''") + "' " +
"," + rsc.remark + "='" + p.remark.Replace("'", "''") + "' " +
"," + rsc.date_modi + "=now() " +
"," + rsc.user_modi + "='" + userId.Replace("'", "''") + "' " +
"," + rsc.amount + "='" + p.amount.Replace("'", "''") + "' " +
"Where " + rsc.pkField + "='" + p.reserve_cash_id + "' ";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
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);
}
