public void add(WebHelper w, Dictionary <string, object> kv) { Model.pm_t_flow_main ord = w.GetObject <Model.pm_t_flow_main>(); ord.price_type = "1"; ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; List <Model.pm_t_price_flow_detial> lines = w.GetList <Model.pm_t_price_flow_detial>("lines"); foreach (Model.pm_t_price_flow_detial line in lines) { line.sheet_no = ord.sheet_no; line.price_type = ord.price_type; line.start_date = ord.start_date; line.start_time = ord.start_time; line.end_time = ord.end_time; } string sheet_no = ""; bll.Add(ord, lines, out sheet_no); w.Write("sheet_no", sheet_no); }
void IBLL.ICusPriceOrder.Change(Model.pm_t_flow_main ord, List <Model.pm_t_price_flow_detial> lines) { string sql = "select * from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'"; var db = new DB.DBByHandClose(Appsetting.conn); DB.IDB d = db; try { db.Open(); db.BeginTran(); // var tb = d.ExecuteToTable(sql, null); if (tb.Rows.Count == 0) { throw new Exception("单据不存在" + ord.sheet_no); } else { var row = tb.Rows[0]; if (row["approve_flag"].ToString() == "1") { throw new Exception("单据已审核" + ord.sheet_no); } } sql = "delete from pm_t_price_flow_detial where sheet_no='" + ord.sheet_no + "'"; d.ExecuteScalar(sql, null); sql = "delete from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'"; d.ExecuteScalar(sql, null); // d.Insert(ord); foreach (Model.pm_t_price_flow_detial line in lines) { d.Insert(line); } // db.CommitTran(); } catch (Exception ex) { db.RollBackTran(); throw; } finally { db.Close(); } }
void IBLL.ICusPriceOrder.Add(Model.pm_t_flow_main ord, List <Model.pm_t_price_flow_detial> lines, out string sheet_no) { IBLL.ICusPriceOrder ins = this; ord.sheet_no = ins.MaxCode(); // string sql = "select * from pm_t_flow_main where sheet_no='" + ord.sheet_no + "'"; var db = new DB.DBByHandClose(Appsetting.conn); DB.IDB d = db; try { db.Open(); db.BeginTran(); // var tb = d.ExecuteToTable(sql, null); if (tb.Rows.Count != 0) { throw new Exception("已存在单号" + ord.sheet_no); } d.Insert(ord); foreach (Model.pm_t_price_flow_detial line in lines) { line.sheet_no = ord.sheet_no; d.Insert(line); } // db.CommitTran(); } catch (Exception ex) { db.RollBackTran(); throw; } finally { db.Close(); } // sheet_no = ord.sheet_no; }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICusPriceOrder bll = new BLL.CusPriceOrder(); if (t == "get_list") { DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1")); DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2")); var tb = bll.GetList(date1, date2); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_order") { string sheet_no = r.Read("sheet_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetOrder(sheet_no, out tb1, out tb2); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("tb1", tb1); w.Append("tb2", tb2); res = w.ToString(); } else if (t == "max_code") { string code = bll.MaxCode(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("code", code); res = w.ToString(); } else if (t == "add") { Model.pm_t_flow_main ord = new Model.pm_t_flow_main(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.vip_type = r.Read("vip_type"); ord.price_type = "1"; ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.oper_id = r.Read("oper_id"); ord.approve_flag = "0"; ord.memo = r.Read("memo"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); ord.start_date = Helper.Conv.ToDateTime(r.Read("start_date")); ord.end_date = Helper.Conv.ToDateTime(r.Read("end_date")); ord.start_time = r.Read("start_time"); ord.end_time = r.Read("end_time"); ord.buy_amt = Helper.Conv.ToDecimal(r.Read("buy_amt")); ord.add_amt = Helper.Conv.ToDecimal(r.Read("add_amt")); ord.deal_man = r.Read("deal_man"); ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); List <Model.pm_t_price_flow_detial> lines = new List <Model.pm_t_price_flow_detial>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.pm_t_price_flow_detial line = new Model.pm_t_price_flow_detial(); lines.Add(line); line.sheet_no = ord.sheet_no; line.item_no = r2.Read("item_no"); line.price_type = ord.price_type; line.start_date = ord.start_date; line.old_price = Helper.Conv.ToDecimal(r2.Read("old_price")); line.new_price = Helper.Conv.ToDecimal(r2.Read("new_price")); line.discount = Helper.Conv.ToDecimal(r2.Read("discount")); line.buy_qnty = Helper.Conv.ToDecimal(r2.Read("buy_qnty")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.start_time = ord.start_time; line.end_time = ord.end_time; line.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty")); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); line.old_price2 = Helper.Conv.ToDecimal(r2.Read("old_price2")); line.old_price3 = Helper.Conv.ToDecimal(r2.Read("old_price3")); line.new_price2 = Helper.Conv.ToDecimal(r2.Read("new_price2")); line.new_price3 = Helper.Conv.ToDecimal(r2.Read("new_price3")); } string sheet_no = ""; bll.Add(ord, lines, out sheet_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sheet_no", sheet_no); res = w.ToString(); } else if (t == "change") { Model.pm_t_flow_main ord = new Model.pm_t_flow_main(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.vip_type = r.Read("vip_type"); ord.price_type = "1"; ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.oper_id = r.Read("oper_id"); ord.approve_flag = "0"; ord.memo = r.Read("memo"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); ord.start_date = Helper.Conv.ToDateTime(r.Read("start_date")); ord.end_date = Helper.Conv.ToDateTime(r.Read("end_date")); ord.start_time = r.Read("start_time"); ord.end_time = r.Read("end_time"); ord.buy_amt = Helper.Conv.ToDecimal(r.Read("buy_amt")); ord.add_amt = Helper.Conv.ToDecimal(r.Read("add_amt")); ord.deal_man = r.Read("deal_man"); ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); List <Model.pm_t_price_flow_detial> lines = new List <Model.pm_t_price_flow_detial>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.pm_t_price_flow_detial line = new Model.pm_t_price_flow_detial(); lines.Add(line); line.sheet_no = ord.sheet_no; line.item_no = r2.Read("item_no"); line.price_type = ord.price_type; line.start_date = ord.start_date; line.old_price = Helper.Conv.ToDecimal(r2.Read("old_price")); line.new_price = Helper.Conv.ToDecimal(r2.Read("new_price")); line.discount = Helper.Conv.ToDecimal(r2.Read("discount")); line.buy_qnty = Helper.Conv.ToDecimal(r2.Read("buy_qnty")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.start_time = ord.start_time; line.end_time = ord.end_time; line.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty")); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); line.old_price2 = Helper.Conv.ToDecimal(r2.Read("old_price2")); line.old_price3 = Helper.Conv.ToDecimal(r2.Read("old_price3")); line.new_price2 = Helper.Conv.ToDecimal(r2.Read("new_price2")); line.new_price3 = Helper.Conv.ToDecimal(r2.Read("new_price3")); } bll.Change(ord, lines); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string sheet_no = r.Read("sheet_no"); bll.Delete(sheet_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "check") { string sheet_no = r.Read("sheet_no"); string approve_man = r.Read("approve_man"); bll.Check(sheet_no, approve_man); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { throw new Exception("未找到方法" + t); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); LogHelper.writeLog("", ex.ToString()); res = w.ToString(); } }