void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICusFY bll = new BLL.CusFY(); if (t == "get_list") { DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1")); DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2")); string cus_no = r.Read("cus_no"); var tb = bll.GetList(date1, date2, cus_no); 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.rp_t_supcust_fy_master ord = new Model.rp_t_supcust_fy_master(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = r.Read("supcust_flag"); ord.pay_type = r.Read("pay_type"); ord.pay_date = System.DateTime.Now; ord.old_no = r.Read("old_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.is_payed = r.Read("is_payed"); ord.sale_man = r.Read("sale_man"); ord.branch_no = r.Read("branch_no"); ord.cm_branch = r.Read("cm_branch"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.visa_id = r.Read("visa_id"); ord.is_over = r.Read("is_over"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.pay_way = r.Read("pay_way"); ord.pay_name = r.Read("pay_name"); List <Model.rp_t_supcust_fy_detail> lines = new List <Model.rp_t_supcust_fy_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_supcust_fy_detail line = new Model.rp_t_supcust_fy_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.kk_no = r2.Read("kk_no"); line.kk_cash = Helper.Conv.ToDecimal(r2.Read("kk_cash")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); } 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.rp_t_supcust_fy_master ord = new Model.rp_t_supcust_fy_master(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = r.Read("supcust_flag"); ord.pay_type = r.Read("pay_type"); ord.pay_date = System.DateTime.Now; ord.old_no = r.Read("old_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.is_payed = r.Read("is_payed"); ord.sale_man = r.Read("sale_man"); ord.branch_no = r.Read("branch_no"); ord.cm_branch = r.Read("cm_branch"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.visa_id = r.Read("visa_id"); ord.is_over = r.Read("is_over"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.pay_way = r.Read("pay_way"); ord.pay_name = r.Read("pay_name"); List <Model.rp_t_supcust_fy_detail> lines = new List <Model.rp_t_supcust_fy_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_supcust_fy_detail line = new Model.rp_t_supcust_fy_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.kk_no = r2.Read("kk_no"); line.kk_cash = Helper.Conv.ToDecimal(r2.Read("kk_cash")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); } 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(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IBranch bll = new BLL.Branch(); if (t == "get_list") { int code_len = Helper.Conv.ToInt32(r.Read("code_len")); var tb = bll.GetList(code_len); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_list_by_par_code") { string par_code = r.Read("par_code"); var tb = bll.GetListByParCode(par_code); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_item") { string branch_no = r.Read("branch_no"); var tb = bll.GetItem(branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "max_code") { string par_code = r.Read("par_code"); string code = bll.MaxCode(par_code); 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.bi_t_branch_info item = new Model.bi_t_branch_info(); item.branch_no = r.Read("branch_no"); item.branch_name = r.Read("branch_name"); item.branch_man = r.Read("branch_man"); item.address = r.Read("address"); item.display_flag = r.Read("display_flag"); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_branch_info item = new Model.bi_t_branch_info(); item.branch_no = r.Read("branch_no"); item.branch_name = r.Read("branch_name"); item.branch_man = r.Read("branch_man"); item.address = r.Read("address"); item.display_flag = r.Read("display_flag"); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string branch_no = r.Read("branch_no"); bll.Delete(branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { WebHelper w = new WebHelper(pars); w.ReflectionMethod(bll, t); res = w.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { WebHelper web = new WebHelper(pars); ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICheckBLL bll = new BLL.CheckBLL(); if (t == "get_checksheet_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); var tb = bll.GetCheckSheetList(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_check_init_list") { var tb = bll.GetCheckInitList(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_branch_stock_list") { string branch_no = r.Read("branch_no"); var tb = bll.GetBranchStockList(branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_checksheet") { string sheet_no = r.Read("sheet_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetCheckSheet(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 == "add_checksheet") { var ord = new Model.ic_t_check_master(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.meno = r.Read("meno"); ord.approve_flag = "0"; ord.cm_branch = r.Read("cm_branch"); ord.deal_man = r.Read("deal_man"); ord.max_change = 0; ord.check_no = r.Read("check_no"); List <Model.ic_t_check_detail> lines = new List <Model.ic_t_check_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.ic_t_check_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.in_price = Helper.Conv.ToDecimal(r2.Read("in_price")); item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price")); item.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty")); item.real_qty = Helper.Conv.ToDecimal(r2.Read("real_qty")); item.balance_qty = Helper.Conv.ToDecimal(r2.Read("balance_qty")); item.memo = r2.Read("memo"); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); lines.Add(item); } string sheet_no = ""; bll.AddCheckSheet(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_checksheet") { var ord = new Model.ic_t_check_master(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.meno = r.Read("meno"); ord.approve_flag = "0"; ord.cm_branch = r.Read("cm_branch"); ord.deal_man = r.Read("deal_man"); ord.max_change = 0; ord.update_time = Helper.Conv.ToDateTime(r.Read("update_time")); ord.check_no = r.Read("check_no"); List <Model.ic_t_check_detail> lines = new List <Model.ic_t_check_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.ic_t_check_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.in_price = Helper.Conv.ToDecimal(r2.Read("in_price")); item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price")); item.stock_qty = Helper.Conv.ToDecimal(r2.Read("stock_qty")); item.real_qty = Helper.Conv.ToDecimal(r2.Read("real_qty")); item.balance_qty = Helper.Conv.ToDecimal(r2.Read("balance_qty")); item.memo = r2.Read("memo"); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); lines.Add(item); } bll.ChangeCheckSheet(ord, lines); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete_checksheet") { string sheet_no = r.Read("sheet_no"); var update_time = Helper.Conv.ToDateTime(r.Read("update_time")); bll.DeleteCheckSheet(sheet_no, update_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { web.ReflectionMethod(bll, t); res = web.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); if (ex.InnerException != null) { w.Append("errMsg", ex.InnerException.Message); LogHelper.writeLog("check()", ex.InnerException.ToString(), t, pars); } else { w.Append("errMsg", ex.Message); LogHelper.writeLog("check()", ex.ToString(), t, pars); } res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext rm = new ReadWriteContext.ReadContextByJson(pars); var kv = rm.ToDictionary(); IBLL.ISettle bll = new BLL.Settle(); if (t == "upload_fhd") { if (CommonHelper.ExistsKeys(kv, "branch_no", "sale_master", "sale_detail", "pay_data") == false) { throw new Exception("参数错误"); } var branch_no = rm.Read("branch_no"); var json = rm.Read("sale_master"); ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json); var lst1 = new List <Model.sm_t_salesheet>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var ord = new Model.sm_t_salesheet(); ord.sheet_no = r.Read("sheet_no"); ord.voucher_no = ""; ord.branch_no = r.Read("branch_no"); ord.cust_no = r.Read("cust_no"); ord.pay_way = r.Read("pay_way"); ord.discount = Conv.ToDecimal(r.Read("discount")); ord.coin_no = r.Read("coin_no"); ord.real_amount = Conv.ToDecimal(r.Read("total_amount")); ord.total_amount = Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Conv.ToDecimal(r.Read("paid_amount")); ord.approve_flag = "0"; ord.source_flag = ""; ord.oper_id = r.Read("oper_id"); ord.sale_man = r.Read("sale_man"); ord.oper_date = Conv.ToDateTime(r.Read("oper_date")); ord.pay_date = Conv.ToDateTime(r.Read("pay_date")); ord.other1 = ""; ord.other2 = ""; ord.other3 = ""; ord.cm_branch = ""; ord.approve_man = ""; ord.approve_date = DateTime.MinValue; ord.num1 = 0m; ord.num2 = 0m; ord.num3 = 0m; ord.payfee_memo = ""; ord.old_no = ""; ord.psheet_no = ""; ord.pay_nowmark = ""; ord.if_back = ""; ord.cust_cls = ""; ord.other4 = ""; lst1.Add(ord); } } json = rm.Read("sale_detail"); read = new ReadWriteContext.ReadContextByJson(json); var lst2 = new List <Model.sm_t_salesheet_detail>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var item = new Model.sm_t_salesheet_detail(); item.sheet_no = r.Read("sheet_no"); item.item_no = r.Read("item_no"); item.item_name = r.Read("item_name"); item.unit_no = r.Read("unit_no"); item.unit_factor = 1m; item.sale_qnty = Conv.ToDecimal(r.Read("sale_qnty")); item.sale_price = Conv.ToDecimal(r.Read("sale_price")); item.real_price = Conv.ToDecimal(r.Read("real_price")); item.cost_price = Conv.ToDecimal(r.Read("cost_price")); item.sale_money = Conv.ToDecimal(r.Read("sale_money")); item.sale_tax = 0m; item.is_tax = "0"; item.other1 = ""; item.other2 = ""; item.other3 = ""; item.other4 = ""; item.num1 = 0m; item.num2 = 0m; item.num3 = 0m; item.num4 = 0m; item.num5 = 0m; item.num6 = 0m; item.barcode = r.Read("barcode"); item.sheet_sort = Conv.ToInt(r.Read("sheet_sort")); item.ret_qnty = 0m; item.discount = 0m; item.voucher_no = ""; item.cost_notax = 0m; item.packqty = 0; item.sgqty = 0m; item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0m; item.num7 = 0m; item.other5 = ""; item.num8 = 0m; item.produce_day = DateTime.MinValue; lst2.Add(item); } } json = rm.Read("pay_data"); read = new ReadWriteContext.ReadContextByJson(json); var lst3 = new List <Model.ot_pay_flow>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var item = new Model.ot_pay_flow(); item.sheet_no = r.Read("sheet_no"); item.flow_id = Conv.ToInt(r.Read("flow_id")); item.cus_no = r.Read("cus_no"); item.oper_id = r.Read("oper_id"); item.oper_date = Conv.ToDateTime(r.Read("oper_date")); item.pay_way = r.Read("pay_way"); item.sale_amount = Conv.ToDecimal(r.Read("sale_amount")); item.pay_amount = Conv.ToDecimal(r.Read("pay_amount")); item.old_amount = Conv.ToDecimal(r.Read("old_amount")); item.ml = Conv.ToDecimal(r.Read("ml")); item.jh = r.Read("jh"); item.remark = r.Read("remark"); lst3.Add(item); } } if (lst1.Count > 0 || lst2.Count > 0) { bll.WriteFHD(lst1, lst2, lst3); } ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "upload_cgrk") { if (CommonHelper.ExistsKeys(kv, "branch_no", "inout_master", "inout_detail", "pay_data") == false) { throw new Exception("参数错误"); } var branch_no = rm.Read("branch_no"); var json = rm.Read("inout_master"); ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json); var lst1 = new List <Model.ic_t_inout_store_master>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var ord = new Model.ic_t_inout_store_master(); ord.sheet_no = r.Read("sheet_no"); ord.trans_no = r.Read("trans_no");//A采购入库; D销售退货入库 ord.db_no = "+"; ord.branch_no = r.Read("branch_no"); ord.d_branch_no = ""; ord.voucher_no = ""; ord.supcust_no = r.Read("supcust_no"); ord.total_amount = Conv.ToDecimal(r.Read("total_amount")); ord.inout_amount = Conv.ToDecimal(r.Read("total_amount")); ord.coin_no = "RMB"; ord.pay_way = r.Read("pay_way"); ord.tax_amount = 0m; ord.discount = 0m; ord.pay_date = DateTime.MinValue; ord.approve_flag = "0"; ord.oper_date = Conv.ToDateTime(r.Read("oper_date")); ord.oper_id = r.Read("oper_id"); ord.display_flag = "1"; ord.other1 = ""; ord.other2 = ""; ord.other3 = ""; ord.cm_branch = ""; //不确定 ord.deal_man = ""; ord.old_no = ""; ord.approve_man = ""; ord.approve_date = DateTime.MinValue; ord.num1 = 0m; ord.num2 = 0m; ord.num3 = 0m; ord.max_change = 0m; //不确定 ord.sale_no = "A"; ord.lock_man = ""; ord.lock_date = DateTime.MinValue; lst1.Add(ord); } } json = rm.Read("inout_detail"); read = new ReadWriteContext.ReadContextByJson(json); var lst2 = new List <Model.ic_t_inout_store_detail>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var item = new Model.ic_t_inout_store_detail(); item.sheet_no = r.Read("sheet_no"); item.item_no = r.Read("item_no"); item.item_name = r.Read("item_name"); item.unit_no = r.Read("unit_no"); item.unit_factor = 1m; item.in_qty = Conv.ToDecimal(r.Read("in_qty")); item.orgi_price = Conv.ToDecimal(r.Read("orgi_price")); item.valid_price = Conv.ToDecimal(r.Read("valid_price")); item.cost_price = Conv.ToDecimal(r.Read("cost_price")); item.sub_amount = 0m; item.tax = 0m; item.is_tax = "0"; item.valid_date = Conv.ToDateTime(r.Read("valid_date")); item.other1 = ""; item.other2 = ""; item.other3 = ""; item.num1 = 0m; item.num2 = 0m; item.num3 = 0m; item.num4 = 0m; item.num5 = 0m; item.num6 = 0m; item.barcode = r.Read("barcode"); item.sheet_sort = Conv.ToInt(r.Read("sheet_sort")); item.ret_qnty = 0m; item.discount = 1m; item.voucher_no = ""; item.cost_notax = 0m; //不确定 item.packqty = 0; item.sgqty = 0m; item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0m; lst2.Add(item); } } json = rm.Read("pay_data"); read = new ReadWriteContext.ReadContextByJson(json); var lst3 = new List <Model.ot_pay_flow>(); if (read.Read("datas") != null) { foreach (ReadWriteContext.IReadContext r in read.ReadList("datas")) { var item = new Model.ot_pay_flow(); item.sheet_no = r.Read("sheet_no"); item.flow_id = Conv.ToInt(r.Read("flow_id")); item.cus_no = r.Read("cus_no"); item.oper_id = r.Read("oper_id"); item.oper_date = Conv.ToDateTime(r.Read("oper_date")); item.pay_way = r.Read("pay_way"); item.sale_amount = Conv.ToDecimal(r.Read("sale_amount")); item.pay_amount = Conv.ToDecimal(r.Read("pay_amount")); item.old_amount = Conv.ToDecimal(r.Read("old_amount")); item.ml = Conv.ToDecimal(r.Read("ml")); item.jh = r.Read("jh"); item.remark = r.Read("remark"); lst3.Add(item); } } if (lst1.Count > 0 || lst2.Count > 0) { bll.WriteCGRK(lst1, lst2, lst3); } ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { throw new Exception("未找到方法:" + t); } } catch (Exception ex) { LogHelper.writeLog("settle()", ex.ToString(), t, pars); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ISupSettle bll = new BLL.SupSettle(); if (t == "get_list") { DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1")); DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2")); string sup_no = r.Read("sup_no"); var tb = bll.GetList(date1, date2, sup_no); 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.rp_t_recpay_record_info ord = new Model.rp_t_recpay_record_info(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = "S"; ord.flag_post = "1"; ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.free_money = Helper.Conv.ToDecimal(r.Read("free_money")); ord.coin_no = "RMB"; ord.coin_rate = 1; ord.pay_way = r.Read("pay_way"); ord.approve_flag = "0"; ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.deal_man = r.Read("deal_man"); ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.visa_id = r.Read("visa_id"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.cm_branch = "00"; ord.branch_no = r.Read("branch_no"); ord.from_date = System.DateTime.MinValue; ord.to_date = System.DateTime.MinValue; ord.rc_sheet_no = r.Read("rc_sheet_no"); List <Model.rp_t_recpay_record_detail> lines = new List <Model.rp_t_recpay_record_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_recpay_record_detail line = new Model.rp_t_recpay_record_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.voucher_no = r2.Read("voucher_no"); line.sheet_amount = Helper.Conv.ToDecimal(r2.Read("sheet_amount")); line.paid_amount = Helper.Conv.ToDecimal(r2.Read("paid_amount")); line.paid_free = Helper.Conv.ToDecimal(r2.Read("paid_free")); line.pay_amount = Helper.Conv.ToDecimal(r2.Read("pay_amount")); line.pay_free = Helper.Conv.ToDecimal(r2.Read("pay_free")); line.memo = r2.Read("memo"); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); 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.pay_date = Helper.Conv.ToDateTime(r2.Read("pay_date")); line.item_no = r2.Read("item_no"); line.path = r2.Read("path"); line.select_flag = r2.Read("select_flag"); line.voucher_type = r2.Read("voucher_type"); line.oper_date = Helper.Conv.ToDateTime(r2.Read("oper_date")); line.voucher_other1 = r2.Read("voucher_other1"); line.voucher_other2 = r2.Read("voucher_other2"); line.order_no = r2.Read("order_no"); } 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.rp_t_recpay_record_info ord = new Model.rp_t_recpay_record_info(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = "S"; ord.flag_post = "1"; ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.free_money = Helper.Conv.ToDecimal(r.Read("free_money")); ord.coin_no = "RMB"; ord.coin_rate = 1; ord.pay_way = r.Read("pay_way"); ord.approve_flag = "0"; ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.deal_man = r.Read("deal_man"); ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.visa_id = r.Read("visa_id"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.cm_branch = "00"; ord.branch_no = r.Read("branch_no"); ord.from_date = System.DateTime.MinValue; ord.to_date = System.DateTime.MinValue; ord.rc_sheet_no = r.Read("rc_sheet_no"); List <Model.rp_t_recpay_record_detail> lines = new List <Model.rp_t_recpay_record_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_recpay_record_detail line = new Model.rp_t_recpay_record_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.voucher_no = r2.Read("voucher_no"); line.sheet_amount = Helper.Conv.ToDecimal(r2.Read("sheet_amount")); line.paid_amount = Helper.Conv.ToDecimal(r2.Read("paid_amount")); line.paid_free = Helper.Conv.ToDecimal(r2.Read("paid_free")); line.pay_amount = Helper.Conv.ToDecimal(r2.Read("pay_amount")); line.pay_free = Helper.Conv.ToDecimal(r2.Read("pay_free")); line.memo = r2.Read("memo"); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); 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.pay_date = Helper.Conv.ToDateTime(r2.Read("pay_date")); line.item_no = r2.Read("item_no"); line.path = r2.Read("path"); line.select_flag = r2.Read("select_flag"); line.voucher_type = r2.Read("voucher_type"); line.oper_date = Helper.Conv.ToDateTime(r2.Read("oper_date")); line.voucher_other1 = r2.Read("voucher_other1"); line.voucher_other2 = r2.Read("voucher_other2"); line.order_no = r2.Read("order_no"); } 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(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IFinanceBLL bll = new BLL.FinanceBLL(); if (t == "get_sz_list") { string is_show_stop = r.Read("is_show_stop"); var tb = bll.GetSZTypeList(is_show_stop); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_sz_item") { string pay_way = r.Read("pay_way"); var tb = bll.GetSZTypeItem(pay_way); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "add_sz") { Model.bi_t_sz_type item = new Model.bi_t_sz_type(); item.pay_way = r.Read("pay_way"); item.pay_name = r.Read("pay_name"); item.pay_flag = r.Read("pay_flag"); item.km_code = r.Read("km_code"); item.pay_kind = r.Read("pay_kind"); item.other1 = r.Read("other1"); item.other2 = r.Read("other2"); item.num1 = Helper.Conv.ToDecimal(r.Read("num1")); item.num2 = Helper.Conv.ToInt(r.Read("num2")); item.pay_memo = r.Read("pay_memo"); item.if_acc = r.Read("if_acc"); item.path = r.Read("path"); item.is_account = r.Read("is_account"); item.account_flag = r.Read("account_flag"); item.is_pay = r.Read("is_pay"); item.is_profit = r.Read("is_profit"); item.profit_type = r.Read("profit_type"); item.auto_cashsheet = r.Read("auto_cashsheet"); item.if_CtFix = r.Read("if_CtFix"); bll.InsertSZType(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change_sz") { Model.bi_t_sz_type item = new Model.bi_t_sz_type(); item.pay_way = r.Read("pay_way"); item.pay_name = r.Read("pay_name"); item.pay_flag = r.Read("pay_flag"); item.km_code = r.Read("km_code"); item.pay_kind = r.Read("pay_kind"); item.other1 = r.Read("other1"); item.other2 = r.Read("other2"); item.num1 = Helper.Conv.ToDecimal(r.Read("num1")); item.num2 = Helper.Conv.ToInt(r.Read("num2")); item.pay_memo = r.Read("pay_memo"); item.if_acc = r.Read("if_acc"); item.path = r.Read("path"); item.is_account = r.Read("is_account"); item.account_flag = r.Read("account_flag"); item.is_pay = r.Read("is_pay"); item.is_profit = r.Read("is_profit"); item.profit_type = r.Read("profit_type"); item.auto_cashsheet = r.Read("auto_cashsheet"); item.if_CtFix = r.Read("if_CtFix"); bll.UpdateSZType(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete_sz") { string pay_way = r.Read("pay_way"); bll.DeleteSZType(pay_way); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { throw new Exception("接口不存在[" + t + "]"); } } catch (Exception ex) { LogHelper.writeLog("finance()", ex.ToString(), t, pars); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
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(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IItemCls bll = new BLL.ItemCls(); if (t == "get_list") { var tb = bll.GetList(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_item") { string item_clsno = r.Read("item_clsno"); var tb = bll.GetItem(item_clsno); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "max_code") { string par_code = r.Read("par_code"); string code = bll.MaxCode(par_code); 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.bi_t_item_cls item = new Model.bi_t_item_cls(); item.item_clsno = r.Read("item_clsno"); item.item_flag = r.Read("item_flag"); item.item_clsname = r.Read("item_clsname"); item.display_flag = r.Read("display_flag"); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_item_cls item = new Model.bi_t_item_cls(); item.item_clsno = r.Read("item_clsno"); item.item_flag = r.Read("item_flag"); item.item_clsname = r.Read("item_clsname"); item.display_flag = r.Read("display_flag"); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string item_clsno = r.Read("item_clsno"); bll.Delete(item_clsno); 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); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { WebHelper web = new WebHelper(pars); ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IPeople bll = new BLL.People(); if (t == "get_list") { string dep_no = r.Read("dep_no"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList(dep_no, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else if (t == "get_item") { string oper_id = r.Read("oper_id"); var tb = bll.GetItem(oper_id); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); 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.bi_t_people_info item = new Model.bi_t_people_info(); item.oper_id = r.Read("oper_id"); item.oper_name = r.Read("oper_name"); item.oper_status = r.Read("oper_status"); item.dept_no = r.Read("dept_no"); if (r.Read("birthday") != "") { item.birthday = Helper.Conv.ToDateTime(r.Read("birthday")); } item.tel = r.Read("tel"); if (r.Read("in_date") != "") { item.in_date = Helper.Conv.ToDateTime(r.Read("in_date")); } bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_people_info item = new Model.bi_t_people_info(); item.oper_id = r.Read("oper_id"); item.oper_name = r.Read("oper_name"); item.oper_status = r.Read("oper_status"); item.dept_no = r.Read("dept_no"); if (r.Read("birthday") != "") { item.birthday = Helper.Conv.ToDateTime(r.Read("birthday")); } item.tel = r.Read("tel"); if (r.Read("in_date") != "") { item.in_date = Helper.Conv.ToDateTime(r.Read("in_date")); } bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string oper_id = r.Read("oper_id"); bll.Delete(oper_id); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { web.ReflectionMethod(bll, t); res = web.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IOper bll = new BLL.Oper(); if (t == "login") { string oper_id = r.Read("oper_id"); string pwd = r.Read("pwd"); string oper_name; string oper_type; bll.Login(oper_id, pwd, out oper_name, out oper_type); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("oper_name", oper_name); w.Append("oper_type", oper_type); IBLL.IMyDestop desbll = new BLL.MyDestop(); var tbs = desbll.GetAll(); w.Append("data", tbs); //我的权限 IBLL.ISys sysbll = new BLL.Sys(); tbs = sysbll.GetAllGrant(new global::Model.sa_t_oper_grant() { oper_id = oper_type }); w.Append("data2", tbs); res = w.ToString(); } else if (t == "change_pwd") { string oper_id = r.Read("oper_id"); string old_pwd = r.Read("old_pwd"); string new_pwd = r.Read("new_pwd"); bll.ChangePWD(oper_id, old_pwd, new_pwd); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t.Equals("add")) { WebHelper web = new WebHelper(pars); Model.sa_t_operator_i oper = web.GetObject <Model.sa_t_operator_i>(); bll.Add(oper); web.WriteSuccess(); res = web.NmJson(); } else if (t.Equals("GetMaxCode")) { WebHelper web = new WebHelper(pars); string code = bll.GetMaxCode(); web.Write("code", code); web.WriteSuccess(); res = web.NmJson(); } else if (t.Equals("GetOperType")) { WebHelper web = new WebHelper(pars); var tb = bll.GetOperType(); web.Write(tb); web.WriteSuccess(); res = web.NmJson(); } else if (t.Equals("GetOpers")) { WebHelper web = new WebHelper(pars); var tb = bll.GetOpers(); web.Write(tb); web.WriteSuccess(); res = web.NmJson(); } else if (t.Equals("Upload")) { WebHelper web = new WebHelper(pars); var oper = web.GetObject <Model.sa_t_operator_i>(); bll.Upload(oper); web.WriteSuccess(); res = web.NmJson(); } else if (t.Equals("Del")) { WebHelper web = new WebHelper(pars); var oper = web.GetObject <Model.sa_t_operator_i>(); bll.Del(oper.oper_id); web.WriteSuccess(); res = web.NmJson(); } else if (t == "reset_pwd") { string oper_id = r.Read("oper_id"); string new_pwd = r.Read("new_pwd"); bll.ResetPWD(oper_id, new_pwd); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { WebHelper web = new WebHelper(pars); web.ReflectionMethod(bll, t); res = web.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IPayment bll = new BLL.Payment(); if (t == "get_list") { var tb = bll.GetList( ); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_item") { string pay_way = r.Read("pay_way"); var tb = bll.GetItem(pay_way); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "add") { Model.bi_t_payment_info item = new Model.bi_t_payment_info(); item.pay_way = r.Read("pay_way"); item.pay_name = r.Read("pay_name"); item.pay_flag = r.Read("pay_flag"); item.display = r.Read("display"); item.visa_id = r.Read("visa_id"); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_payment_info item = new Model.bi_t_payment_info(); item.pay_way = r.Read("pay_way"); item.pay_name = r.Read("pay_name"); item.pay_flag = r.Read("pay_flag"); item.display = r.Read("display"); item.visa_id = r.Read("visa_id"); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string pay_way = r.Read("pay_way"); bll.Delete(pay_way); 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); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IDep bll = new BLL.Dep(); if (t == "get_list") { var tb = bll.GetList(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_item") { string dep_no = r.Read("dept_no"); var tb = bll.GetItem(dep_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "max_code") { string par_code = r.Read("par_code"); string code = bll.MaxCode(par_code); 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.bi_t_dept_info item = new Model.bi_t_dept_info(); item.dept_no = r.Read("dept_no"); item.dept_name = r.Read("dept_name"); item.manager = r.Read("manager"); item.meno = r.Read("meno"); item.update_time = DateTime.Now; bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_dept_info item = new Model.bi_t_dept_info(); item.dept_no = r.Read("dept_no"); item.dept_name = r.Read("dept_name"); item.manager = r.Read("manager"); item.meno = r.Read("meno"); item.update_time = DateTime.Now; bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string dep_no = r.Read("dept_no"); bll.Delete(dep_no); 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); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IInOutBLL bll = new BLL.InOutBLL(); if (t == "get_salesheet_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); string cust_id = r.Read("cust_id"); string sale_man = r.Read("sale_man"); var tb = bll.GetSaleSheetList(date1, date2, cust_id, sale_man); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_simple_salesheet_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); string cust_id = r.Read("cust_id"); var tb = bll.GetSimpleSaleSheetList(date1, date2, cust_id); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_salesheet") { string sheet_no = r.Read("sheet_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetSaleSheet(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 == "add_salesheet") { var ord = new Model.sm_t_salesheet(); ord.sheet_no = r.Read("sheet_no"); ord.voucher_no = r.Read("voucher_no"); ord.branch_no = r.Read("branch_no"); ord.cust_no = r.Read("cust_no"); ord.pay_way = r.Read("pay_way"); ord.discount = Helper.Conv.ToDecimal(r.Read("discount")); ord.coin_no = r.Read("coin_no"); ord.real_amount = Helper.Conv.ToDecimal(r.Read("real_amount")); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.approve_flag = "0"; ord.source_flag = ""; ord.oper_id = r.Read("oper_id"); ord.sale_man = r.Read("sale_man"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date")); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); ord.approve_man = ""; ord.approve_date = 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")); ord.payfee_memo = r.Read("payfee_memo"); ord.old_no = ""; ord.psheet_no = r.Read("psheet_no"); ord.pay_nowmark = r.Read("pay_nowmark"); ord.if_back = r.Read("if_back"); ord.cust_cls = ""; ord.other4 = r.Read("other4"); List <Model.sm_t_salesheet_detail> lines = new List <Model.sm_t_salesheet_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.sm_t_salesheet_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.item_name = r2.Read("item_name"); item.unit_no = r2.Read("unit_no"); item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor")); item.sale_qnty = Helper.Conv.ToDecimal(r2.Read("sale_qnty")); item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price")); item.real_price = Helper.Conv.ToDecimal(r2.Read("real_price")); item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price")); item.sale_money = Helper.Conv.ToDecimal(r2.Read("sale_money")); item.sale_tax = Helper.Conv.ToDecimal(r2.Read("sale_tax")); item.is_tax = r2.Read("is_tax"); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.other3 = r2.Read("other3"); item.other4 = r2.Read("other4"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.num4 = Helper.Conv.ToDecimal(r2.Read("num4")); item.num5 = Helper.Conv.ToDecimal(r2.Read("num5")); item.num6 = Helper.Conv.ToDecimal(r2.Read("num6")); item.barcode = r2.Read("barcode"); item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort")); item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty")); item.discount = Helper.Conv.ToDecimal(r2.Read("discount")); item.voucher_no = r2.Read("voucher_no"); item.cost_notax = Helper.Conv.ToDecimal(r2.Read("cost_notax")); item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0M; item.num7 = Helper.Conv.ToDecimal(r2.Read("num7")); item.other5 = r2.Read("other5"); item.num8 = Helper.Conv.ToDecimal(r2.Read("num8")); item.produce_day = DateTime.MinValue; lines.Add(item); } string sheet_no = ""; bll.AddSaleSheet(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_salesheet") { var ord = new Model.sm_t_salesheet(); ord.sheet_no = r.Read("sheet_no"); ord.voucher_no = r.Read("voucher_no"); ord.branch_no = r.Read("branch_no"); ord.cust_no = r.Read("cust_no"); ord.pay_way = r.Read("pay_way"); ord.discount = Helper.Conv.ToDecimal(r.Read("discount")); ord.coin_no = r.Read("coin_no"); ord.real_amount = Helper.Conv.ToDecimal(r.Read("real_amount")); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.approve_flag = "0"; ord.source_flag = ""; ord.oper_id = r.Read("oper_id"); ord.sale_man = r.Read("sale_man"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.pay_date = DateTime.MinValue; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); ord.approve_man = ""; ord.approve_date = 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")); ord.payfee_memo = r.Read("payfee_memo"); ord.old_no = ""; ord.psheet_no = r.Read("psheet_no"); ord.pay_nowmark = r.Read("pay_nowmark"); ord.if_back = r.Read("if_back"); ord.cust_cls = ""; ord.other4 = r.Read("other4"); ord.update_time = Helper.Conv.ToDateTime(r.Read("update_time")); List <Model.sm_t_salesheet_detail> lines = new List <Model.sm_t_salesheet_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.sm_t_salesheet_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.item_name = r2.Read("item_name"); item.unit_no = r2.Read("unit_no"); item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor")); item.sale_qnty = Helper.Conv.ToDecimal(r2.Read("sale_qnty")); item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price")); item.real_price = Helper.Conv.ToDecimal(r2.Read("real_price")); item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price")); item.sale_money = Helper.Conv.ToDecimal(r2.Read("sale_money")); item.sale_tax = Helper.Conv.ToDecimal(r2.Read("sale_tax")); item.is_tax = r2.Read("is_tax"); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.other3 = r2.Read("other3"); item.other4 = r2.Read("other4"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.num4 = Helper.Conv.ToDecimal(r2.Read("num4")); item.num5 = Helper.Conv.ToDecimal(r2.Read("num5")); item.num6 = Helper.Conv.ToDecimal(r2.Read("num6")); item.barcode = r2.Read("barcode"); item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort")); item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty")); item.discount = Helper.Conv.ToDecimal(r2.Read("discount")); item.voucher_no = r2.Read("voucher_no"); item.cost_notax = Helper.Conv.ToDecimal(r2.Read("cost_notax")); item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0M; item.num7 = Helper.Conv.ToDecimal(r2.Read("num7")); item.other5 = r2.Read("other5"); item.num8 = Helper.Conv.ToDecimal(r2.Read("num8")); item.produce_day = DateTime.MinValue; lines.Add(item); } bll.ChangeSaleSheet(ord, lines); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete_salesheet") { string sheet_no = r.Read("sheet_no"); var update_time = Helper.Conv.ToDateTime(r.Read("update_time")); bll.DeleteSaleSheet(sheet_no, update_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "check_salesheet") { string sheet_no = r.Read("sheet_no"); string approve_man = r.Read("approve_man"); var update_time = Helper.Conv.ToDateTime(r.Read("update_time")); bll.CheckSaleSheet(sheet_no, approve_man, update_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "get_inout_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); string supcust_no = r.Read("supcust_no"); string trans_no = r.Read("trans_no"); var tb = bll.GetInOutList(date1, date2, supcust_no, trans_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_simple_inout_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); string supcust_no = r.Read("supcust_no"); string trans_no = r.Read("trans_no"); var tb = bll.GetSimpleInOutList(date1, date2, supcust_no, trans_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_other_inout_list") { string date1 = r.Read("date1"); string date2 = r.Read("date2"); string trans_no = r.Read("trans_no"); var tb = bll.GetOtherInOutList(date1, date2, trans_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_inout") { string sheet_no = r.Read("sheet_no"); string trans_no = r.Read("trans_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetInOut(sheet_no, trans_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 == "get_other_inout") { string sheet_no = r.Read("sheet_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetInOut(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 == "add_inout") { var ord = new Model.ic_t_inout_store_master(); ord.sheet_no = r.Read("sheet_no"); ord.trans_no = r.Read("trans_no"); ord.branch_no = r.Read("branch_no"); ord.d_branch_no = r.Read("d_branch_no"); ord.voucher_no = r.Read("voucher_no"); ord.supcust_no = r.Read("supcust_no"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.inout_amount = Helper.Conv.ToDecimal(r.Read("inout_amount")); ord.coin_no = r.Read("coin_no"); ord.pay_way = r.Read("pay_way"); ord.tax_amount = Helper.Conv.ToDecimal(r.Read("tax_amount")); ord.discount = Helper.Conv.ToDecimal(r.Read("discount")); ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date")); ord.approve_flag = "0"; ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.oper_id = r.Read("oper_id"); ord.display_flag = "1"; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); //不确定 ord.deal_man = r.Read("deal_man"); ord.old_no = ""; ord.approve_man = r.Read("approve_man"); ord.approve_date = 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")); ord.max_change = 0m; //不确定 ord.sale_no = r.Read("sale_no"); ord.lock_man = ""; ord.lock_date = DateTime.MinValue; List <Model.ic_t_inout_store_detail> lines = new List <Model.ic_t_inout_store_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.ic_t_inout_store_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.item_name = r2.Read("item_name"); item.unit_no = r2.Read("unit_no"); item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor")); item.in_qty = Helper.Conv.ToDecimal(r2.Read("in_qty")); item.orgi_price = Helper.Conv.ToDecimal(r2.Read("orgi_price")); item.valid_price = Helper.Conv.ToDecimal(r2.Read("valid_price")); item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price")); item.sub_amount = Helper.Conv.ToDecimal(r2.Read("sub_amount")); item.tax = Helper.Conv.ToDecimal(r2.Read("tax")); item.is_tax = r2.Read("is_tax"); item.valid_date = Helper.Conv.ToDateTime(r2.Read("valid_date")); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.other3 = r2.Read("other3"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.num4 = Helper.Conv.ToDecimal(r2.Read("num4")); item.num5 = Helper.Conv.ToDecimal(r2.Read("num5")); item.num6 = Helper.Conv.ToDecimal(r2.Read("num6")); item.barcode = r2.Read("barcode"); item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort")); item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty")); item.discount = Helper.Conv.ToDecimal(r2.Read("discount")); item.voucher_no = r2.Read("voucher_no"); item.cost_notax = 0m; //不确定 item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0m; lines.Add(item); } string sheet_no = ""; bll.AddInOut(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_inout") { var ord = new Model.ic_t_inout_store_master(); ord.sheet_no = r.Read("sheet_no"); ord.trans_no = r.Read("trans_no"); ord.branch_no = r.Read("branch_no"); ord.d_branch_no = ""; ord.db_no = r.Read("db_no"); ord.voucher_no = r.Read("voucher_no"); ord.supcust_no = r.Read("supcust_no"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.inout_amount = Helper.Conv.ToDecimal(r.Read("inout_amount")); ord.coin_no = "RMB"; ord.pay_way = r.Read("pay_way"); ord.tax_amount = Helper.Conv.ToDecimal(r.Read("tax_amount")); ord.discount = Helper.Conv.ToDecimal(r.Read("discount")); ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date")); ord.approve_flag = "0"; ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.oper_id = r.Read("oper_id"); ord.display_flag = "1"; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.cm_branch = r.Read("cm_branch"); //不确定 ord.deal_man = r.Read("deal_man"); ord.old_no = ""; ord.approve_man = r.Read("approve_man"); ord.approve_date = 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")); ord.max_change = 0m; //不确定 ord.sale_no = r.Read("sale_no"); ord.lock_man = ""; ord.lock_date = DateTime.MinValue; ord.update_time = Helper.Conv.ToDateTime(r.Read("update_time")); List <Model.ic_t_inout_store_detail> lines = new List <Model.ic_t_inout_store_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { var item = new Model.ic_t_inout_store_detail(); item.sheet_no = r2.Read("sheet_no"); item.item_no = r2.Read("item_no"); item.item_name = r2.Read("item_name"); item.unit_no = r2.Read("unit_no"); item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor")); item.in_qty = Helper.Conv.ToDecimal(r2.Read("in_qty")); item.orgi_price = Helper.Conv.ToDecimal(r2.Read("orgi_price")); item.valid_price = Helper.Conv.ToDecimal(r2.Read("valid_price")); item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price")); item.sub_amount = Helper.Conv.ToDecimal(r2.Read("sub_amount")); item.tax = Helper.Conv.ToDecimal(r2.Read("tax")); item.is_tax = r2.Read("is_tax"); item.valid_date = Helper.Conv.ToDateTime(r2.Read("valid_date")); item.other1 = r2.Read("other1"); item.other2 = r2.Read("other2"); item.other3 = r2.Read("other3"); item.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); item.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); item.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); item.num4 = Helper.Conv.ToDecimal(r2.Read("num4")); item.num5 = Helper.Conv.ToDecimal(r2.Read("num5")); item.num6 = Helper.Conv.ToDecimal(r2.Read("num6")); item.barcode = r2.Read("barcode"); item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort")); item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty")); item.discount = Helper.Conv.ToDecimal(r2.Read("discount")); item.voucher_no = r2.Read("voucher_no"); item.cost_notax = 0m; //不确定 item.packqty = Helper.Conv.ToInt(r2.Read("packqty")); item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty")); item.branch_no_d = ""; item.ly_sup_no = ""; item.ly_rate = 0m; lines.Add(item); } bll.ChangeInOut(ord, lines); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete_inout") { string sheet_no = r.Read("sheet_no"); var update_time = Helper.Conv.ToDateTime(r.Read("update_time")); bll.DeleteInOut(sheet_no, update_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "check_inout") { string sheet_no = r.Read("sheet_no"); string approve_man = r.Read("approve_man"); var update_time = Helper.Conv.ToDateTime(r.Read("update_time")); bll.CheckInOut(sheet_no, approve_man, update_time); 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("inout()", ex.ToString(), t, pars); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IItem bll = new BLL.Item(); if (t == "get_list") { string item_clsno = r.Read("item_clsno"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList(item_clsno, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else if (t == "get_item") { string item_no = r.Read("item_no"); var tb = bll.GetItem(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); 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.bi_t_item_info item = new Model.bi_t_item_info(); item.item_no = r.Read("item_no"); item.item_subno = r.Read("item_subno"); item.item_name = r.Read("item_name"); item.item_subname = r.Read("item_subname"); item.item_clsno = r.Read("item_clsno"); item.unit_no = r.Read("unit_no"); item.item_size = r.Read("item_size"); item.product_area = r.Read("product_area"); item.price = Helper.Conv.ToDecimal(r.Read("price")); item.base_price = Helper.Conv.ToDecimal(r.Read("base_price")); item.sale_price = Helper.Conv.ToDecimal(r.Read("sale_price")); item.combine_sta = r.Read("combine_sta"); item.item_flag = r.Read("item_flag"); item.display_flag = r.Read("display_flag"); item.sup_no = r.Read("sup_no"); item.barcode = r.Read("barcode"); item.base_price2 = Helper.Conv.ToDecimal(r.Read("base_price2")); item.base_price3 = Helper.Conv.ToDecimal(r.Read("base_price3")); item.valid_day = Helper.Conv.ToDecimal(r.Read("valid_day")); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_item_info item = new Model.bi_t_item_info(); item.item_no = r.Read("item_no"); item.item_subno = r.Read("item_subno"); item.item_name = r.Read("item_name"); item.item_subname = r.Read("item_subname"); item.item_clsno = r.Read("item_clsno"); item.unit_no = r.Read("unit_no"); item.item_size = r.Read("item_size"); item.product_area = r.Read("product_area"); item.price = Helper.Conv.ToDecimal(r.Read("price")); item.base_price = Helper.Conv.ToDecimal(r.Read("base_price")); item.sale_price = Helper.Conv.ToDecimal(r.Read("sale_price")); item.combine_sta = r.Read("combine_sta"); item.item_flag = r.Read("item_flag"); item.display_flag = r.Read("display_flag"); item.sup_no = r.Read("sup_no"); item.barcode = r.Read("barcode"); item.base_price2 = Helper.Conv.ToDecimal(r.Read("base_price2")); item.base_price3 = Helper.Conv.ToDecimal(r.Read("base_price3")); item.valid_day = Helper.Conv.ToDecimal(r.Read("valid_day")); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string item_no = r.Read("item_no"); bll.Delete(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "get_list_short") { var tb = bll.GetListShort(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("datas", tb); res = w.ToString(); } else if (t == "is_use") { string item_no = r.Read("item_no"); var val = bll.IsUse(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("value", val.ToString()); res = w.ToString(); } else if (t == "get_list_by_sup") { string sup_no = r.Read("sup_no"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList_BySup(sup_no, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else { WebHelper w = new WebHelper(pars); w.ReflectionMethod(bll, t); res = w.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICashOrder bll = new BLL.CashOrder(); if (t == "get_list") { DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1")); DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2")); string visa_id = r.Read("visa_id"); var tb = bll.GetList(date1, date2, visa_id); 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; bll.GetOrder(sheet_no, out tb1); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("tb1", tb1); 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.bank_t_cash_master ord = new Model.bank_t_cash_master(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.voucher_no = r.Read("voucher_no"); ord.visa_id = r.Read("visa_id"); ord.visa_in = r.Read("visa_in"); ord.pay_way = r.Read("pay_way"); ord.coin_no = "RMB"; ord.coin_rate = 1; ord.deal_man = r.Read("deal_man"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.bill_flag = r.Read("bill_flag"); ord.bill_total = Helper.Conv.ToDecimal(r.Read("bill_total")); ord.cm_branch = "00"; ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); string sheet_no; bll.Add(ord, 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.bank_t_cash_master ord = new Model.bank_t_cash_master(); ord.sheet_no = r.Read("sheet_no"); ord.branch_no = r.Read("branch_no"); ord.voucher_no = r.Read("voucher_no"); ord.visa_id = r.Read("visa_id"); ord.visa_in = r.Read("visa_in"); ord.pay_way = r.Read("pay_way"); ord.coin_no = "RMB"; ord.coin_rate = 1; ord.deal_man = r.Read("deal_man"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.bill_total = Helper.Conv.ToDecimal(r.Read("bill_total")); ord.cm_branch = "00"; ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); bll.Change(ord); 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(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { WebHelper web = new WebHelper(pars); ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ISup bll = new BLL.Sup(); if (t == "get_list") { string region_no = r.Read("region_no"); string keyword = r.Read("keyword"); int show_stop = Helper.Conv.ToInt32(r.Read("show_stop")); int page_index = Helper.Conv.ToInt32(r.Read("page_index")); int page_size = Helper.Conv.ToInt32(r.Read("page_size")); int total_count = 0; var tb = bll.GetList(region_no, keyword, show_stop, page_index, page_size, out total_count); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); w.Append("total_count", total_count.ToString()); res = w.ToString(); } else if (t == "get_item") { string supcust_no = r.Read("supcust_no"); var tb = bll.GetItem(supcust_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); 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.bi_t_supcust_info item = new Model.bi_t_supcust_info(); item.supcust_no = r.Read("supcust_no"); item.supcust_flag = r.Read("supcust_flag"); item.sup_name = r.Read("sup_name"); item.region_no = r.Read("region_no"); item.sup_type = r.Read("sup_type"); item.sup_man = r.Read("sup_man"); item.sup_addr = r.Read("sup_addr"); item.sup_email = r.Read("sup_email"); item.sup_tel = r.Read("sup_tel"); item.display_flag = r.Read("display_flag"); item.credit_amt = Helper.Conv.ToDecimal(r.Read("credit_amt")); item.sale_man = r.Read("sale_man"); item.sup_pyname = r.Read("sup_pyname"); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_supcust_info item = new Model.bi_t_supcust_info(); item.supcust_no = r.Read("supcust_no"); item.supcust_flag = r.Read("supcust_flag"); item.sup_name = r.Read("sup_name"); item.region_no = r.Read("region_no"); item.sup_type = r.Read("sup_type"); item.sup_man = r.Read("sup_man"); item.sup_addr = r.Read("sup_addr"); item.sup_email = r.Read("sup_email"); item.sup_tel = r.Read("sup_tel"); item.display_flag = r.Read("display_flag"); item.credit_amt = Helper.Conv.ToDecimal(r.Read("credit_amt")); item.sale_man = r.Read("sale_man"); item.sup_pyname = r.Read("sup_pyname"); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string supcust_no = r.Read("supcust_no"); bll.Delete(supcust_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { web.ReflectionMethod(bll, t); res = web.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IPriceBLL bll = new BLL.PriceBLL(); if (t == "get_cust_price_list") { string cust_id = r.Read("cust_id"); var tb = bll.GetCustPriceList(cust_id); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_sup_price_list") { string sup_id = r.Read("sup_id"); var tb = bll.GetSupPriceList(sup_id); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_cust_item_price") { string cust_id = r.Read("cust_id"); string item_no = r.Read("item_no"); string type = r.Read("type"); decimal price = bll.GetCusItemPrice(cust_id, item_no, type); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("price", price.ToString()); res = w.ToString(); } else if (t == "get_sup_item_price") { string sup_id = r.Read("sup_id"); string item_no = r.Read("item_no"); string type = r.Read("type"); decimal price = bll.GetSupItemPrice(sup_id, item_no, type); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("price", price.ToString()); res = w.ToString(); } else if (t == "get_last_in_price") { string item_no = r.Read("item_no"); decimal price = bll.GetLastInPrice(item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("price", price.ToString()); res = w.ToString(); } else { throw new Exception("接口不存在[" + t + "]"); } } catch (Exception ex) { LogHelper.writeLog("price()", ex.ToString(), t, pars); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICommon bll = new BLL.Common(); if (t == "connect_server") { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("is_connect", "1"); res = w.ToString(); } else if (t == "get_item_count") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int count = bll.GetItemCount(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("total_count", count.ToString()); res = w.ToString(); } else if (t == "get_item_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetItemList(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_itemcls_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetItemClsList(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_branch_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetBranchList(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_stock_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "branch_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); string branch_no = r.Read("branch_no"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetBranchStockList(sysn_time, branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_oper_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "branch_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); string branch_no = r.Read("branch_no"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetOperList(sysn_time, branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_sup_count") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int count = bll.GetSupCusCount(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("total_count", count.ToString()); res = w.ToString(); } else if (t == "get_sup_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetSupCusList(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_cus_price_count") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "cust_id", "item_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var cust_id = r.Read("cust_id"); var item_no = r.Read("item_no"); int count = bll.GetCusPriceCount(sysn_time, cust_id, item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("total_count", count.ToString()); res = w.ToString(); } else if (t == "get_cus_price_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "cust_id", "item_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var cust_id = r.Read("cust_id"); var item_no = r.Read("item_no"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetCusPriceList(sysn_time, cust_id, item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_sup_price_count") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "sup_id", "item_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); string sup_id = r.Read("sup_id"); string item_no = r.Read("item_no"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int count = bll.GetSupPriceCount(sysn_time, sup_id, item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("total_count", count.ToString()); res = w.ToString(); } else if (t == "get_sup_price_list") { if (CommonHelper.ExistsKeys(kv, "sysn_time", "sup_id", "item_no") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); string sup_id = r.Read("sup_id"); string item_no = r.Read("item_no"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetSupPriceList(sysn_time, sup_id, item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_system_pars") { if (CommonHelper.ExistsKeys(kv, "sysn_time") == false) { throw new Exception("参数错误"); } string sysn_time = r.Read("sysn_time"); var dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var dt = bll.GetSystemPars(sysn_time); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sysn_time", dtime); w.Append("datas", dt); res = w.ToString(); } else if (t == "get_payway_list") { var dt = bll.GetPayWayList(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("datas", dt); res = w.ToString(); } else if (t == "update_pwd") { if (CommonHelper.ExistsKeys(kv, "branch_no", "oper_id", "pwd", "new_pwd") == false) { throw new Exception("参数错误"); } string branch_no = r.Read("branch_no"); string oper_id = r.Read("oper_id"); string pwd = r.Read("pwd").ToLower(); //加密 string new_pwd = r.Read("new_pwd").ToLower(); //加密 bll.UpdatePwd(branch_no, oper_id, pwd, new_pwd); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "get_cus_item_price") { if (CommonHelper.ExistsKeys(kv, "cust_id", "item_no") == false) { throw new Exception("参数错误"); } string cust_id = r.Read("cust_id"); string item_no = r.Read("item_no"); var price = bll.GetCusItemPrice(cust_id, item_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("price", price.ToString()); res = w.ToString(); } else if (t == "get_cus_balance") { if (CommonHelper.ExistsKeys(kv, "cust_id") == false) { throw new Exception("参数错误"); } string cust_id = r.Read("cust_id"); decimal balance = 0; decimal credit_amt = 0; bll.GetBalance(cust_id, out balance, out credit_amt); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("balance", balance.ToString()); w.Append("credit_amt", credit_amt.ToString()); res = w.ToString(); } else { throw new Exception("未找到方法:" + t); } } catch (Exception ex) { LogHelper.writeLog("common()", ex.ToString(), t, pars); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }