public CloseDay setCloseday(DataTable dt) { CloseDay dgs1 = new CloseDay(); if (dt.Rows.Count > 0) { dgs1.closeday_id = dt.Rows[0][cld.closeday_id].ToString(); dgs1.amount = dt.Rows[0][cld.amount].ToString(); dgs1.amt_cash = dt.Rows[0][cld.amt_cash].ToString(); dgs1.amt_credit_card = dt.Rows[0][cld.amt_credit_card].ToString(); dgs1.closeday_date = dt.Rows[0][cld.closeday_date].ToString(); dgs1.res_id = dt.Rows[0][cld.res_id].ToString(); dgs1.deposit = dt.Rows[0][cld.deposit].ToString(); dgs1.expense_1 = dt.Rows[0][cld.expense_1].ToString(); dgs1.expense_2 = dt.Rows[0][cld.expense_2].ToString(); dgs1.expense_3 = dt.Rows[0][cld.expense_3].ToString(); dgs1.expense_4 = dt.Rows[0][cld.expense_4].ToString(); dgs1.expense_5 = dt.Rows[0][cld.expense_5].ToString(); dgs1.total_cash = dt.Rows[0][cld.total_cash].ToString(); dgs1.amount_order = dt.Rows[0][cld.amount_order].ToString(); dgs1.bill_amount = dt.Rows[0][cld.bill_amount].ToString(); dgs1.cash_draw1 = dt.Rows[0][cld.cash_draw1].ToString(); dgs1.cash_draw1_remark = dt.Rows[0][cld.cash_draw1_remark].ToString(); dgs1.cash_draw2 = dt.Rows[0][cld.cash_draw2].ToString(); dgs1.cash_draw2_remark = dt.Rows[0][cld.cash_draw2_remark].ToString(); dgs1.cash_draw3 = dt.Rows[0][cld.cash_draw3].ToString(); dgs1.cash_draw3_remark = dt.Rows[0][cld.cash_draw3_remark].ToString(); dgs1.cash_receive1 = dt.Rows[0][cld.cash_receive1].ToString(); dgs1.cash_receive1_remark = dt.Rows[0][cld.cash_receive1_remark].ToString(); dgs1.cash_receive2 = dt.Rows[0][cld.cash_receive2].ToString(); dgs1.cash_receive2_remark = dt.Rows[0][cld.cash_receive2_remark].ToString(); dgs1.cash_receive3 = dt.Rows[0][cld.cash_receive3].ToString(); dgs1.cash_receive3_remark = dt.Rows[0][cld.cash_receive3_remark].ToString(); dgs1.closeday_user = dt.Rows[0][cld.closeday_user].ToString(); dgs1.cnt_bill = dt.Rows[0][cld.cnt_bill].ToString(); dgs1.cnt_order = dt.Rows[0][cld.cnt_order].ToString(); dgs1.discount = dt.Rows[0][cld.discount].ToString(); dgs1.nettotal = dt.Rows[0][cld.nettotal].ToString(); dgs1.service_charge = dt.Rows[0][cld.service_charge].ToString(); dgs1.status_void = dt.Rows[0][cld.status_void].ToString(); dgs1.total = dt.Rows[0][cld.total].ToString(); dgs1.vat = dt.Rows[0][cld.vat].ToString(); dgs1.void_date = dt.Rows[0][cld.void_date].ToString(); dgs1.void_user = dt.Rows[0][cld.void_user].ToString(); dgs1.weather = dt.Rows[0][cld.weather].ToString(); dgs1.cash_receive = dt.Rows[0][cld.cash_receive].ToString(); dgs1.cash_ton = dt.Rows[0][cld.cash_ton].ToString(); } else { setCloseday(dgs1); } return(dgs1); }
public CloseDay selectByPk1(String copId) { CloseDay cop1 = new CloseDay(); DataTable dt = new DataTable(); String sql = "select cld.* " + "From " + cld.table + " cld " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where cld." + cld.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setCloseday(dt); return(cop1); }
public String insertCloseDay(CloseDay p, String userId) { String re = ""; if (p.closeday_id.Equals("")) { re = insert(p, ""); } else { //re = update(p, ""); } return(re); }
private void setControl() { CloseDay cld = new CloseDay(); cld = mposC.mposDB.cldDB.selectByPk1(cldid); if (cld.closeday_id.Length > 0) { } else { DataTable dt = new DataTable(); dt = mposC.mposDB.bildDB.selectCloseDayCurr(); if (dt.Rows.Count > 0) { txtCntOrder.Value = dt.Rows[0]["cnt_order"].ToString(); txtAmt.Value = dt.Rows[0]["sum_price"].ToString(); } } }
public CloseDay setCloseday(CloseDay dgs1) { dgs1.closeday_id = ""; dgs1.amount = ""; dgs1.amt_cash = ""; dgs1.amt_credit_card = ""; dgs1.closeday_date = ""; dgs1.cnt_order = ""; dgs1.deposit = ""; dgs1.active = ""; dgs1.remark = ""; dgs1.sort1 = ""; dgs1.date_cancel = ""; dgs1.date_create = ""; dgs1.date_modi = ""; dgs1.user_cancel = ""; dgs1.user_create = ""; dgs1.user_modi = ""; dgs1.host_id = ""; dgs1.branch_id = ""; dgs1.device_id = ""; dgs1.res_id = ""; dgs1.expense_1 = ""; dgs1.expense_2 = ""; dgs1.expense_3 = ""; dgs1.expense_4 = ""; dgs1.expense_5 = ""; dgs1.total_cash = ""; dgs1.amount_order = ""; dgs1.bill_amount = ""; dgs1.cash_draw1 = ""; dgs1.cash_draw1_remark = ""; dgs1.cash_draw2 = ""; dgs1.cash_draw2_remark = ""; dgs1.cash_draw3 = ""; dgs1.cash_draw3_remark = ""; dgs1.cash_receive1 = ""; dgs1.cash_receive1_remark = ""; dgs1.cash_receive2 = ""; dgs1.cash_receive2_remark = ""; dgs1.cash_receive3 = ""; dgs1.cash_receive3_remark = ""; dgs1.closeday_user = ""; dgs1.cnt_bill = ""; dgs1.cnt_order = ""; dgs1.discount = ""; dgs1.nettotal = ""; dgs1.res_id = ""; dgs1.service_charge = ""; dgs1.status_void = ""; dgs1.total = ""; dgs1.vat = ""; dgs1.void_date = ""; dgs1.void_user = ""; dgs1.weather = ""; dgs1.service_charge = ""; dgs1.vat = ""; dgs1.total = ""; dgs1.nettotal = ""; dgs1.cash_receive = ""; dgs1.cash_ton = ""; return(dgs1); }
public String insert(CloseDay p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; //bil.table = "t_bill"; chkNull(p); sql = "Insert Into " + cld.table + " set " + " " + cld.amount + " = '" + p.amount + "'" + "," + cld.amt_cash + " = '" + p.amt_cash + "'" + "," + cld.date_create + " = now()" + "," + cld.active + " = '1'" + "," + cld.user_create + " = '" + userId + "' " + "," + cld.host_id + " = '" + p.host_id + "' " + "," + cld.branch_id + " = '" + p.branch_id + "' " + "," + cld.device_id + " = '" + p.device_id + "' " + "," + cld.date_cancel + " = '" + p.date_cancel + "' " + "," + cld.date_modi + " = '" + p.date_modi + "' " + "," + cld.user_cancel + " = '" + p.user_cancel + "' " + "," + cld.user_modi + " = '" + p.user_modi + "' " + "," + cld.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + cld.closeday_date + " = '" + p.closeday_date + "' " + "," + cld.res_id + " = '" + p.res_id + "' " + "," + cld.deposit + " = '" + p.deposit + "' " + "," + cld.expense_1 + " = '" + p.expense_1 + "' " + "," + cld.expense_2 + " = '" + p.expense_2 + "' " + "," + cld.expense_3 + " = '" + p.expense_3 + "' " + "," + cld.expense_4 + " = '" + p.expense_4 + "' " + "," + cld.expense_5 + " = '" + p.expense_5 + "' " + "," + cld.total_cash + " = '" + p.total_cash + "' " + "," + cld.amount_order + " = '" + p.amount_order + "' " + "," + cld.bill_amount + " = '" + p.bill_amount + "' " + "," + cld.cash_draw1 + " = '" + p.cash_draw1 + "' " + "," + cld.cash_draw1_remark + " = '" + p.cash_draw1_remark.Replace("'", "''") + "' " + "," + cld.cash_draw2 + " = '" + p.cash_draw2 + "' " + "," + cld.cash_draw2_remark + " = '" + p.cash_draw2_remark.Replace("'", "''") + "' " + "," + cld.cash_draw3 + " = '" + p.cash_draw3 + "' " + "," + cld.cash_draw3_remark + " = '" + p.cash_draw3_remark.Replace("'", "''") + "' " + "," + cld.cash_receive1 + " = '" + p.cash_receive1 + "' " + "," + cld.cash_receive1_remark + " = '" + p.cash_receive1_remark.Replace("'", "''") + "' " + "," + cld.cash_receive2 + " = '" + p.cash_receive2 + "' " + "," + cld.cash_receive2_remark + " = '" + p.cash_receive2_remark.Replace("'", "''") + "' " + "," + cld.cash_receive3 + " = '" + p.cash_receive3 + "' " + "," + cld.cash_receive3_remark + " = '" + p.cash_receive3_remark.Replace("'", "''") + "' " + "," + cld.closeday_user + " = '" + p.closeday_user + "' " + "," + cld.cnt_bill + " = '" + p.cnt_bill + "' " + "," + cld.cnt_order + " = '" + p.cnt_order + "' " + "," + cld.discount + " = '" + p.discount + "' " + "," + cld.nettotal + " = '" + p.nettotal + "' " + "," + cld.service_charge + " = '" + p.service_charge + "' " + "," + cld.status_void + " = '" + p.status_void + "' " + "," + cld.total + " = '" + p.total + "' " + "," + cld.vat + " = '" + p.vat + "' " + "," + cld.void_date + " = '" + p.void_date + "' " + "," + cld.void_user + " = '" + p.void_user + "' " + "," + cld.weather + " = '" + p.weather + "' " + "," + cld.cash_receive + " = '" + p.cash_receive + "' " + "," + cld.cash_ton + " = '" + p.cash_ton + "' " + " "; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; new LogFile("CloseDay -> insert" + ex.Message + " " + ex.InnerException); } return(re); }
private void initConfig() { cld = new CloseDay(); cld.closeday_id = "closeday_id"; cld.amount = "amount"; cld.amt_cash = "amt_cash"; cld.amt_credit_card = "amt_credit_card"; cld.closeday_date = "closeday_date"; cld.cnt_order = "cnt_patient"; cld.deposit = "deposit"; cld.active = "active"; cld.remark = "remark"; cld.sort1 = "sort1"; cld.date_cancel = "date_cancel"; cld.date_create = "date_create"; cld.date_modi = "date_modi"; cld.user_cancel = "user_cancel"; cld.user_create = "user_create"; cld.user_modi = "user_modi"; cld.host_id = "host_id"; cld.branch_id = "branch_id"; cld.device_id = "device_id"; cld.res_id = "res_id"; cld.expense_1 = "expense_1"; cld.expense_2 = "expense_2"; cld.expense_3 = "expense_3"; cld.expense_4 = "expense_4"; cld.expense_5 = "expense_5"; cld.total_cash = "total_cash"; cld.amount_order = "amount_order"; cld.bill_amount = "bill_amount"; cld.cash_draw1 = "cash_draw1"; cld.cash_draw1_remark = "cash_draw1_remark"; cld.cash_draw2 = "cash_draw2"; cld.cash_draw2_remark = "cash_draw2_remark"; cld.cash_draw3 = "cash_draw3"; cld.cash_draw3_remark = "cash_draw3_remark"; cld.cash_receive1 = "cash_receive1"; cld.cash_receive1_remark = "cash_receive1_remark"; cld.cash_receive2 = "cash_receive2"; cld.cash_receive2_remark = "cash_receive2_remark"; cld.cash_receive3 = "cash_receive3"; cld.cash_receive3_remark = "cash_receive3_remark"; cld.closeday_user = "******"; cld.cnt_bill = "cnt_bill"; cld.cnt_order = "cnt_order"; cld.discount = "discount"; cld.nettotal = "nettotal"; cld.res_id = "res_id"; cld.service_charge = "service_charge"; cld.status_void = "status_void"; cld.total = "total"; cld.vat = "vat"; cld.void_date = "void_date"; cld.void_user = "******"; cld.weather = "weather"; cld.service_charge = "service_charge"; cld.vat = "vat"; cld.total = "total"; cld.nettotal = "nettotal"; cld.cash_receive = "cash_receive"; cld.cash_ton = "cash_ton"; cld.pkField = "closeday_id"; cld.table = "t_closeday"; }
private void chkNull(CloseDay p) { long 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_void = p.status_void == null ? "" : p.status_void; p.void_date = p.void_date == null ? "" : p.void_date; p.closeday_date = p.closeday_date == null ? "" : p.closeday_date; p.cash_draw1_remark = p.cash_draw1_remark == null ? "" : p.cash_draw1_remark; p.cash_draw2_remark = p.cash_draw2_remark == null ? "" : p.cash_draw2_remark; p.cash_draw3_remark = p.cash_draw3_remark == null ? "" : p.cash_draw3_remark; p.cash_receive1_remark = p.cash_receive1_remark == null ? "" : p.cash_receive1_remark; p.cash_receive2_remark = p.cash_receive2_remark == null ? "" : p.cash_receive2_remark; p.cash_receive3_remark = p.cash_receive3_remark == null ? "" : p.cash_receive3_remark; p.closeday_user = p.closeday_user == null ? "" : p.closeday_user; p.status_void = p.status_void == null ? "" : p.status_void; p.void_date = p.void_date == null ? "" : p.void_date; p.void_user = p.void_user == null ? "" : p.void_user; p.weather = p.weather == null ? "" : p.weather; p.void_date = p.void_date == null ? "" : p.void_date; p.host_id = long.TryParse(p.host_id, out chk) ? chk.ToString() : "0"; p.branch_id = long.TryParse(p.branch_id, out chk) ? chk.ToString() : "0"; p.device_id = long.TryParse(p.device_id, out chk) ? chk.ToString() : "0"; //p.closeday_id = long.TryParse(p.closeday_id, out chk) ? chk.ToString() : "0"; //p.bill_id = long.TryParse(p.bill_id, out chk) ? chk.ToString() : "0"; //p.area_id = long.TryParse(p.area_id, out chk) ? chk.ToString() : "0"; p.res_id = long.TryParse(p.res_id, out chk) ? chk.ToString() : "0"; p.cash_receive = Decimal.TryParse(p.cash_receive, out chk1) ? chk1.ToString() : "0"; p.cash_ton = Decimal.TryParse(p.cash_ton, out chk1) ? chk1.ToString() : "0"; p.nettotal = Decimal.TryParse(p.nettotal, out chk1) ? chk1.ToString() : "0"; p.total = Decimal.TryParse(p.total, out chk1) ? chk1.ToString() : "0"; p.vat = Decimal.TryParse(p.vat, out chk1) ? chk1.ToString() : "0"; p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0"; p.discount = Decimal.TryParse(p.discount, out chk1) ? chk1.ToString() : "0"; p.service_charge = Decimal.TryParse(p.service_charge, out chk1) ? chk1.ToString() : "0"; p.amt_cash = Decimal.TryParse(p.amt_cash, out chk1) ? chk1.ToString() : "0"; p.amt_credit_card = Decimal.TryParse(p.amt_credit_card, out chk1) ? chk1.ToString() : "0"; p.deposit = Decimal.TryParse(p.deposit, out chk1) ? chk1.ToString() : "0"; p.expense_1 = Decimal.TryParse(p.expense_1, out chk1) ? chk1.ToString() : "0"; p.expense_2 = Decimal.TryParse(p.expense_2, out chk1) ? chk1.ToString() : "0"; p.expense_3 = Decimal.TryParse(p.expense_3, out chk1) ? chk1.ToString() : "0"; p.expense_4 = Decimal.TryParse(p.expense_4, out chk1) ? chk1.ToString() : "0"; p.expense_5 = Decimal.TryParse(p.expense_5, out chk1) ? chk1.ToString() : "0"; p.total_cash = Decimal.TryParse(p.total_cash, out chk1) ? chk1.ToString() : "0"; p.amount_order = Decimal.TryParse(p.amount_order, out chk1) ? chk1.ToString() : "0"; p.bill_amount = Decimal.TryParse(p.bill_amount, out chk1) ? chk1.ToString() : "0"; p.cash_draw1 = Decimal.TryParse(p.cash_draw1, out chk1) ? chk1.ToString() : "0"; p.cash_draw2 = Decimal.TryParse(p.cash_draw2, out chk1) ? chk1.ToString() : "0"; p.cash_draw3 = Decimal.TryParse(p.cash_draw3, out chk1) ? chk1.ToString() : "0"; p.cash_receive1 = Decimal.TryParse(p.cash_receive1, out chk1) ? chk1.ToString() : "0"; p.cash_receive2 = Decimal.TryParse(p.cash_receive2, out chk1) ? chk1.ToString() : "0"; p.cash_receive3 = Decimal.TryParse(p.cash_receive3, out chk1) ? chk1.ToString() : "0"; p.cnt_bill = Decimal.TryParse(p.cnt_bill, out chk1) ? chk1.ToString() : "0"; p.cnt_order = Decimal.TryParse(p.cnt_order, out chk1) ? chk1.ToString() : "0"; p.discount = Decimal.TryParse(p.discount, out chk1) ? chk1.ToString() : "0"; p.nettotal = Decimal.TryParse(p.nettotal, out chk1) ? chk1.ToString() : "0"; p.service_charge = Decimal.TryParse(p.service_charge, out chk1) ? chk1.ToString() : "0"; p.total = Decimal.TryParse(p.total, out chk1) ? chk1.ToString() : "0"; p.vat = Decimal.TryParse(p.vat, out chk1) ? chk1.ToString() : "0"; p.cash_receive = Decimal.TryParse(p.cash_receive, out chk1) ? chk1.ToString() : "0"; p.cash_ton = Decimal.TryParse(p.cash_ton, out chk1) ? chk1.ToString() : "0"; //p.table_id = Decimal.TryParse(p.table_id, out chk1) ? chk1.ToString() : "0"; }