//销售对账
List <Model.ot_pay_flow> IBLL.ISaleData.GetSaleSum(string date1, string date2, string order_key, out int order_count, out decimal total_amt, out decimal give_amt)
{
order_count = 0;
total_amt = 0;
give_amt = 0;
try
{
var d2 = Conv.ToDateTime(date2).AddDays(1).ToString("yyyy-MM-dd");
string condition_str = " and oper_date>='" + date1 + "' and oper_date<='" + d2 + "' and ifnull(approve_flag,'0')='1' ";
condition_str += " and sheet_no like '" + order_key + "%' ";
var sql = "select sheet_no from t_order_detail where 1=1 " + condition_str + " group by sheet_no ";
var dt = Program.db.ExecuteToTable(sql, null);
order_count = dt.Rows.Count;
//过滤赠送金额
sql = "select ifnull(sum(amt),0) total_amt from t_order_detail where ifnull(is_give,'0')='0' " + condition_str;
dt = Program.db.ExecuteToTable(sql, null);
if (dt.Rows.Count > 0)
{
total_amt = Conv.ToDecimal(dt.Rows[0]["total_amt"]);
}
//赠送金额
sql = "select ifnull(sum(source_price*qty),0) total_amt from t_order_detail where ifnull(is_give,'0')='1' " + condition_str;
dt = Program.db.ExecuteToTable(sql, null);
if (dt.Rows.Count > 0)
{
give_amt = Conv.ToDecimal(dt.Rows[0]["total_amt"]);
}
sql = "select sheet_no,flow_id,pay_way,sale_amount,pay_amount,ml from ot_pay_flow ";
sql += "where ifnull(approve_flag,'0')='1' and sheet_no in (select distinct sheet_no from t_order_detail where 1=1 " + condition_str + ") ";
sql += "order by sheet_no,flow_id asc ";
dt = Program.db.ExecuteToTable(sql, null);
var lst = new List <Model.ot_pay_flow>();
foreach (DataRow dr in dt.Rows)
{
var item = new Model.ot_pay_flow();
item.flow_id = Conv.ToInt(dr["flow_id"].ToString());
item.sheet_no = dr["sheet_no"].ToString();
item.sale_amount = Conv.ToDecimal(dr["sale_amount"].ToString());
item.pay_way = dr["pay_way"].ToString();
item.pay_amount = Conv.ToDecimal(dr["pay_amount"].ToString());
item.ml = Conv.ToDecimal(dr["ml"].ToString());
lst.Add(item);
}
return(lst);
}
catch (Exception ex)
{
Log.writeLog("SaleData->GetSaleSum()", ex.ToString());
throw ex;
}
}
//收银流水
List <Model.ot_pay_flow> IBLL.ISaleData.GetPayFlow(string date1, string date2, string order_key, int page_no, int page_size, out int total)
{
total = 0;
try
{
var sup_flag = "C";
if (order_key == "PI")
{
sup_flag = "S";
}
var d2 = Conv.ToDateTime(date2).AddDays(1).ToString("yyyy-MM-dd");
string condition_str = " and oper_date>='" + date1 + "' and oper_date<='" + d2 + "' and ifnull(approve_flag,'0')='1' ";
condition_str += " and sheet_no like '" + order_key + "%' ";
string sql = "select a.*,b.sup_name from ot_pay_flow a ";
sql += "left join (select supcust_no,sup_name from bi_t_supcust_info where supcust_flag='" + sup_flag + "') b on a.cus_no=b.supcust_no ";
sql += "where ifnull(a.approve_flag,'0')='1' and a.sheet_no in (select distinct sheet_no from t_order_detail where 1=1 " + condition_str + ") ";
sql += "order by a.sheet_no,a.flow_id asc limit " + (page_no - 1) * page_size + "," + page_size;
var dt = Program.db.ExecuteToTable(sql, null);
var lst = new List <Model.ot_pay_flow>();
foreach (DataRow dr in dt.Rows)
{
var item = new Model.ot_pay_flow();
item.flow_id = Conv.ToInt(dr["flow_id"].ToString());
item.sheet_no = dr["sheet_no"].ToString();
item.sale_amount = Conv.ToDecimal(dr["sale_amount"].ToString());
item.pay_way = dr["pay_way"].ToString();
item.pay_amount = Conv.ToDecimal(dr["pay_amount"].ToString());
item.oper_date = Conv.ToDateTime(dr["oper_date"].ToString());
item.oper_id = dr["oper_id"].ToString();
item.approve_flag = dr["approve_flag"].ToString();
item.cus_no = dr["cus_no"].ToString();
item.sup_name = dr["sup_name"].ToString();
lst.Add(item);
}
sql = "select count(*) total from ot_pay_flow where ifnull(approve_flag,'0')='1' and sheet_no in (select distinct sheet_no from t_order_detail where 1=1 " + condition_str + ") ";
dt = Program.db.ExecuteToTable(sql, null);
if (dt.Rows.Count > 0)
{
total = Conv.ToInt(dt.Rows[0]["total"]);
}
return(lst);
}
catch (Exception ex)
{
Log.writeLog("SaleData->GetPayFlow()", ex.ToString());
throw ex;
}
}
void IBLL.ISaleData.InsertPayFlow(Model.ot_pay_flow item, out int flow_id)
{
try
{
var sql = "select ifnull(max(flow_id),0)+1 as flow_id from ot_pay_flow where sheet_no='" + item.sheet_no + "' ";
var dt = Program.db.ExecuteToTable(sql, null);
flow_id = 1;
if (dt.Rows.Count > 0)
{
flow_id = Conv.ToInt(dt.Rows[0]["flow_id"]);
}
sql = "insert into ot_pay_flow values('" + item.sheet_no + "','" + flow_id + "','" + item.cus_no + "','" + item.oper_id + "','" + item.oper_date.ToString("yyyy-MM-dd HH:mm:ss") + "'";
sql += ",'" + item.pay_way + "','" + item.sale_amount + "','" + item.pay_amount + "','" + item.old_amount + "','" + item.ml + "','" + item.jh + "','1','','0') ";
Program.db.ExecuteScalar(sql, null);
}
catch (Exception ex)
{
Log.writeLog("SaleData->InsertPayFlow()", ex.ToString(), null);
throw ex;
}
}
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();
}
}
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);
}
}
public void upload_cgrk(WebHelper w, Dictionary <string, object> kv)
{
if (ExistsKeys(kv, "branch_no", "inout_master", "inout_detail", "pay_data") == false)
{
throw new Exception("参数错误");
}
var branch_no = w.Read("branch_no");
var json = w.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 = w.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 = 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.WriteCGRK(lst1, lst2, lst3);
}
}
