public void upload_fhd(WebHelper w, Dictionary <string, object> kv)
{
if (ExistsKeys(kv, "branch_no", "sale_master", "sale_detail", "pay_data") == false)
{
throw new Exception("参数错误");
}
var branch_no = w.Read("branch_no");
var json = w.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 = w.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 = w.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);
}
}
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.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();
}
}
