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