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