void IGoods.Add(string goods_no, string goods_name, string long_name, string cls_id, string small_img_url,
string large_img_url, string detail_img_url, string themes, string text, string is_show_mall, List <Model.goods_std> lststd)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("goods_no", goods_no);
write.Append("goods_name", goods_name);
write.Append("long_name", long_name);
write.Append("cls_id", cls_id);
write.Append("small_img_url", small_img_url);
write.Append("large_img_url", large_img_url);
write.Append("detail_img_url", detail_img_url);
write.Append("themes", themes);
write.Append("text", text);
var dt = new DataTable();
dt.Columns.Add("prices");
dt.Columns.Add("is_default");
dt.Columns.Add("qty");
foreach (Model.goods_std std in lststd)
{
dt.Rows.Add(std.prices, std.is_default, std.qty);
}
write.Append("datas", dt);
var json = req.request("/goods?t=add", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
void IServiceBase.Request(string t, string pars, out string res)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
public System.Data.DataTable GetSZList()
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("is_show_stop", "0");
Helper.IRequest req = new Helper.Request();
var json = req.request("/finance?t=get_sz_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
var tb = GetDataTable(r.ReadList("data"));
var tb2 = tb.Clone();
foreach (DataRow row in tb.Rows)
{
if (row["pay_flag"].ToString() == "3")
{
tb2.Rows.Add(row.ItemArray);
}
}
return(tb2);
}
}
System.Data.DataTable IBLL.ICusPriceOrder.GetList(DateTime date1, DateTime date2)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("date1", date1.ToString("yyyy-MM-dd"));
w.Append("date2", date2.ToString("yyyy-MM-dd"));
Helper.IRequest req = new Helper.Request();
var json = req.request("/cus_price_order?t=get_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
IBLL.ICommonBLL bll = new BLL.CommonBLL();
var tb = bll.GetDataTable(r.ReadList("data"));
return(tb);
}
}
/// <summary>
/// 微信/支付宝扫码支付
/// </summary>
/// <param name="ori_sheet_no"></param>
/// <param name="pay_type"></param>
/// <param name="pay_amt"></param>
/// <param name="barcode"></param>
/// <param name="sheet_no">支付单号</param>
/// <param name="status">支付状态</param>
void IPayBLL.MicroPay(string ori_sheet_no, string pay_type, decimal pay_amt, string barcode, out string sheet_no, out string status)
{
sheet_no = "";
status = "0";
try
{
var req = new Request();
string sign = "barcode=" + barcode + "&jh=" + Program.jh + "&mer_key=" + Appsetting.mer_key + "&ori_sheet_no=" + ori_sheet_no + "&pay_amt=" + pay_amt.ToString("0.00") + "&pay_type=" + pay_type;
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("ori_sheet_no", ori_sheet_no);
write.Append("mer_key", Appsetting.mer_key);
write.Append("jh", Program.jh);
write.Append("pay_type", pay_type);
write.Append("pay_amt", pay_amt.ToString());
write.Append("barcode", barcode);
write.Append("sign", MD5Helper.ToMD5(sign));
var json = req.request("/pay?t=micro_pay", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
sheet_no = read.Read("sheet_no");
status = read.Read("status");
}
catch (Exception ex)
{
Log.writeLog("PayBLL ->MicroPay()", ex.ToString(), ori_sheet_no);
throw ex;
}
}
System.Data.DataTable IBLL.ISupSettle.GetList(DateTime date1, DateTime date2, string sup_no)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("date1", date1.ToString("yyyy-MM-dd"));
w.Append("date2", date2.ToString("yyyy-MM-dd"));
w.Append("sup_no", sup_no);
Helper.IRequest req = new Helper.Request();
var json = req.request("/sup_settle?t=get_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
var tb = GetDataTable(r.ReadList("data"));
return(tb);
}
}
DataTable ICustomer.GetCusDt(string date1, string date2, string status, string salesman_id, string keyword, int page_size, int page_no, out int total)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("date1", date1);
write.Append("date2", date2);
write.Append("status", status);
write.Append("salesman_id", salesman_id);
write.Append("keyword", keyword);
write.Append("page_size", page_size.ToString());
write.Append("page_no", page_no.ToString());
var json = req.request("/customer?t=get_cus_list", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
total = Conv.ToInt(read.Read("total"));
if (read.Read("datas").Length < 10)
{
return(new DataTable());
}
var tb = Conv.GetDataTable(read.ReadList("datas"));
return(tb);
}
void ICustomer.AddCustomer(string login_no, string cus_pwd, string cus_name, string cus_tel, string mobile, string cus_idcard, string cus_area, string contact_addr,
string detail_addr, string cus_level, string remark, string supcust_group, string salesman_id, string cus_start_date, string cus_end_date, string is_branch)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("login_no", login_no);
write.Append("cus_pwd", cus_pwd);
write.Append("cus_name", cus_name);
write.Append("cus_tel", cus_tel);
write.Append("mobile", mobile);
write.Append("cus_idcard", cus_idcard);
write.Append("cus_area", cus_area);
write.Append("contact_addr", contact_addr);
write.Append("detail_addr", detail_addr);
write.Append("cus_level", cus_level);
write.Append("remark", remark);
write.Append("salesman_id", salesman_id);
write.Append("cus_start_date", cus_start_date);
write.Append("cus_end_date", cus_end_date);
write.Append("is_branch", is_branch);
write.Append("supcust_group", supcust_group);
var json = req.request("/customer?t=add_customer", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
public System.Data.DataTable GetSupList()
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("region_no", "");
w.Append("keyword", "");
w.Append("page_index", "1");
w.Append("page_size", "20000");
Helper.IRequest req = new Helper.Request();
var json = req.request("/sup?t=get_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
var tb = GetDataTable(r.ReadList("data"));
return(tb);
}
}
List <body.salesman> ICustomer.GetSalesmanList(string keyword)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("keyword", keyword);
var json = req.request("/customer?t=select_salesman_list", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
var lst = new List <body.salesman>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new body.salesman();
item.salesman_id = r.Read("salesman_id");
item.salesman_name = r.Read("salesman_name");
item.mobile = r.Read("mobile");
item.salesman_level = r.Read("salesman_level");
item.salesman_pwd = r.Read("salesman_pwd");
item.status = r.Read("status");
item.oper_id = r.Read("oper_id");
item.create_time = Conv.ToDateTime(r.Read("create_time"));
lst.Add(item);
}
}
return(lst);
}
DataTable IBLL.IInOutBLL.GetOtherInOutList(DateTime date1, DateTime date2, string trans_no)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("date1", date1.ToString("yyyy-MM-dd"));
w.Append("date2", date2.ToString("yyyy-MM-dd"));
w.Append("trans_no", trans_no);
Helper.IRequest req = new Helper.Request();
var json = req.request("/inout?t=get_other_inout_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
IBLL.ICommonBLL bll = new BLL.CommonBLL();
var tb = bll.GetDataTable(r.ReadList("data"));
return(tb);
}
}
/// <summary>
/// 预支付
/// </summary>
/// <param name="ori_sheet_no"></param>
/// <param name="pay_type"></param>
/// <param name="pay_amt"></param>
/// <param name="sheet_no"></param>
/// <param name="prepay_id"></param>
/// <param name="qrcode_url"></param>
void IPayBLL.CreatePrePay(string ori_sheet_no, string pay_type, decimal pay_amt, out string sheet_no, out string prepay_id, out string qrcode_url)
{
sheet_no = "";
prepay_id = "";
qrcode_url = "";
try
{
var req = new Request();
string sign = "jh=" + Program.jh + "&mer_key=" + Appsetting.mer_key + "&ori_sheet_no=" + ori_sheet_no + "&pay_amt=" + pay_amt.ToString("0.00") + "&pay_type=" + pay_type;
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("ori_sheet_no", ori_sheet_no);
write.Append("mer_key", Appsetting.mer_key);
write.Append("jh", Program.jh);
write.Append("pay_type", pay_type);
write.Append("pay_amt", pay_amt.ToString());
write.Append("sign", MD5Helper.ToMD5(sign));
var json = req.request("/pay?t=create_prepay", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
sheet_no = read.Read("sheet_no");
prepay_id = read.Read("prepay_id");
qrcode_url = read.Read("qrcode_url");
}
catch (Exception ex)
{
Log.writeLog("PayBLL ->CreatePrePay()", ex.ToString(), ori_sheet_no);
throw ex;
}
}
//查询常春藤支付服务器微信支付状态（主要用于预支付）
void IPayBLL.QueryPayStatus(string sheet_no, out string status)
{
status = "";
try
{
var req = new Request();
string sign = "mer_key=" + Appsetting.mer_key + "&sheet_no=" + sheet_no;
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("sheet_no", sheet_no);
write.Append("mer_key", Appsetting.mer_key);
write.Append("sign", MD5Helper.ToMD5(sign));
var json = req.request("/pay?t=query_pay_status", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
status = read.Read("status");
}
catch (Exception ex)
{
Log.writeLog("PayBLL ->QueryPayStatus()", ex.ToString(), sheet_no);
throw ex;
}
}
DataTable ICommonBLL.GetPeopleList()
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("page_index", "1");
w.Append("page_size", "10000");
w.Append("dep_no", "");
w.Append("show_stop", "0");
w.Append("keyword", "");
Helper.IRequest req = new Helper.Request();
var json = req.request("/people?t=get_list", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
if (r.Read("data").Length < 10)
{
return(new DataTable());
}
IBLL.ICommonBLL bll = new BLL.CommonBLL();
var tb = bll.GetDataTable(r.ReadList("data"));
return(tb);
}
}
DataTable IRep失效订单明细.GetData(string key, int pageSize, int pageIndex, out int total, string field, string fields)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("key", key);
write.Append("pageSize", pageSize.ToString());
write.Append("pageIndex", pageIndex.ToString());
write.Append("field", field);
write.Append("fields", fields);
var json = req.request("/pager?t=get_data_with_total", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
total = Conv.ToInt(read.Read("total"));
//
var dt = new DataTable();
dt.Columns.Add("单号");
dt.Columns.Add("日期");
dt.Columns.Add("下单时间");
dt.Columns.Add("送达时间");
dt.Columns.Add("手机");
dt.Columns.Add("姓名");
dt.Columns.Add("品名");
dt.Columns.Add("属性");
dt.Columns.Add("数量");
dt.Columns.Add("单价");
dt.Columns.Add("金额");
if (read.Read("data") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("data"))
{
string ps = "";
ps = r.Read("属性1") + " " + r.Read("属性2") + " " + r.Read("属性3");
ps = ps.Trim();
dt.Rows.Add(
r.Read("单号"),
r.Read("日期"),
r.Read("下单时间"),
r.Read("送达时间"),
r.Read("手机"),
r.Read("姓名"),
r.Read("品名"),
ps,
r.Read("数量"),
r.Read("单价"),
r.Read("金额")
);
}
}
return(dt);
}
List <body.customer> ICustomer.GetCusList(string date1, string date2, string status, string salesman_id, string keyword, int page_size, int page_no, out int total)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("date1", date1);
write.Append("date2", date2);
write.Append("status", status);
write.Append("salesman_id", salesman_id);
write.Append("keyword", keyword);
write.Append("page_size", page_size.ToString());
write.Append("page_no", page_no.ToString());
var json = req.request("/customer?t=get_cus_list", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
total = Conv.ToInt(read.Read("total"));
//
var lst = new List <body.customer>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var cus = new body.customer();
cus.cus_no = r.Read("cus_no");
cus.login_no = r.Read("login_no");
cus.cus_level = r.Read("cus_level");
cus.cus_start_date = Conv.ToDateTime(r.Read("cus_start_date"));
cus.cus_end_date = Conv.ToDateTime(r.Read("cus_end_date"));
cus.cus_name = r.Read("cus_name");
cus.cus_tel = r.Read("cus_tel");
cus.mobile = r.Read("mobile");
cus.cus_idcard = r.Read("cus_idcard");
cus.cus_area = r.Read("cus_area");
cus.contact_address = r.Read("contact_address");
cus.detail_address = r.Read("detail_address");
cus.remark = r.Read("remark");
cus.settle_type = r.Read("settle_type");
cus.salesman_id = r.Read("salesman_id");
cus.salesman_name = r.Read("salesman_name");
cus.img_url = r.Read("img_url");
cus.create_time = Conv.ToDateTime(r.Read("create_time"));
cus.approve_time = Conv.ToDateTime(r.Read("approve_time"));
cus.msg_hand = r.Read("msg_hand");
cus.status = r.Read("status");
cus.is_branch = r.Read("is_branch");
cus.supcust_group = r.Read("supcust_group");
lst.Add(cus);
}
}
return(lst);
}
System.Data.DataTable IRep销售明细.GetData(string key, int pageSize, int pageIndex, out int total, string field, string fields)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("key", key);
write.Append("pageSize", pageSize.ToString());
write.Append("pageIndex", pageIndex.ToString());
write.Append("field", field);
write.Append("fields", fields);
var json = req.request("/pager?t=get_data_with_total", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
total = Conv.ToInt(read.Read("total"));
//
var dt = new DataTable();
dt.Columns.Add("订单ID");
dt.Columns.Add("状态");
dt.Columns.Add("付款方式");
dt.Columns.Add("客户");
dt.Columns.Add("收货人");
dt.Columns.Add("收货地址");
dt.Columns.Add("联系手机");
dt.Columns.Add("订单创建日期");
dt.Columns.Add("商品名称");
dt.Columns.Add("商品单价");
dt.Columns.Add("总数量");
dt.Columns.Add("总金额");
if (read.Read("data") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("data"))
{
dt.Rows.Add(
r.Read("订单ID"),
r.Read("状态"),
r.Read("付款方式"),
r.Read("客户"),
r.Read("收货人"),
r.Read("收货地址"),
r.Read("联系手机"),
r.Read("订单创建日期"),
r.Read("商品名称"),
r.Read("商品单价"),
r.Read("总数量"),
r.Read("总金额")
);
}
}
return(dt);
}
void IBLL.IFYOrder.Add(Model.bank_t_cash_master ord, List <Model.bank_t_cash_detail> lines, out string sheet_no)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sheet_no", ord.sheet_no);
w.Append("branch_no", ord.branch_no);
w.Append("voucher_no", ord.voucher_no);
w.Append("visa_id", ord.visa_id);
w.Append("visa_in", ord.visa_in);
w.Append("pay_way", ord.pay_way);
w.Append("coin_no", ord.coin_no);
w.Append("coin_rate", ord.coin_rate.ToString());
w.Append("deal_man", ord.deal_man);
w.Append("oper_id", ord.oper_id);
w.Append("oper_date", ord.oper_date.ToString("yyyy-MM-dd"));
w.Append("bill_total", ord.bill_total.ToString());
w.Append("bill_flag", ord.bill_flag);
w.Append("cm_branch", ord.cm_branch);
w.Append("approve_flag", "0");
w.Append("approve_man", "");
w.Append("approve_date", "");
w.Append("other1", ord.other1);
w.Append("other2", ord.other2);
w.Append("other3", ord.other3);
w.Append("num1", ord.num1.ToString());
w.Append("num2", ord.num2.ToString());
w.Append("num3", ord.num3.ToString());
var tb = new DataTable();
tb.Columns.Add("sheet_no");
tb.Columns.Add("type_no");
tb.Columns.Add("bill_cash", typeof(decimal));
tb.Columns.Add("memo");
foreach (Model.bank_t_cash_detail line in lines)
{
tb.Rows.Add(
line.sheet_no,
line.type_no,
line.bill_cash,
line.memo
);
}
w.Append("lines", tb);
Helper.IRequest req = new Helper.Request();
var json = req.request("/fy_order?t=add", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
sheet_no = r.Read("sheet_no");
}
DataTable IRep付款方式汇总表.GetData(string key, int pageSize, int pageIndex, out int total, string field, string fields)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("key", key);
write.Append("pageSize", pageSize.ToString());
write.Append("pageIndex", pageIndex.ToString());
write.Append("field", field);
write.Append("fields", fields);
var json = req.request("/pager?t=get_data_with_total", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
total = Conv.ToInt(read.Read("total"));
//
var dt = new DataTable();
dt.Columns.Add("付款方式");
dt.Columns.Add("单数");
dt.Columns.Add("数量");
dt.Columns.Add("金额");
if (read.Read("data") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("data"))
{
string pay_type = "";
if (r.Read("付款方式") == "0")
{
pay_type = "微信支付";
}
else if (r.Read("付款方式") == "1")
{
pay_type = "信用支付";
}
else if (r.Read("付款方式") == "2")
{
pay_type = "支付宝支付";
}
else
{
pay_type = r.Read("付款方式");
}
dt.Rows.Add(pay_type, r.Read("单数"), r.Read("数量"), r.Read("金额"));
}
}
return(dt);
}
void IBLL.ISupSettle.Delete(string sheet_no)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sheet_no", sheet_no);
Helper.IRequest req = new Helper.Request();
var json = req.request("/sup_settle?t=delete", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
}
void ICustomer.DeleteCustomer(string cus_no)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("cus_no", cus_no);
var json = req.request("/customer?t=delete_customer", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
void IBLL.IInOutBLL.DeleteInOut(string sheet_no, DateTime update_time)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sheet_no", sheet_no);
w.Append("update_time", update_time.ToString("yyyy-MM-dd HH:mm:ss"));
Helper.IRequest req = new Helper.Request();
var json = req.request("/inout?t=delete_inout", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
}
void IBLL.ICashOrder.Check(string sheet_no, string approve_man)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sheet_no", sheet_no);
w.Append("approve_man", approve_man);
Helper.IRequest req = new Helper.Request();
var json = req.request("/cash_order?t=check", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
}
void IAd.Delete(string ad_id)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("ad_id", ad_id);
var json = req.request("/ad?t=delete", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
void IAdvice.Reply(string av_id, string reply)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("av_id", av_id);
write.Append("reply", reply);
var json = req.request("/advice?t=reply", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
void IAd.AddMemberAd(string ad_href, string ad_img_url)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("ad_href", ad_href);
write.Append("ad_img_url", ad_img_url);
var json = req.request("/ad?t=add_member_ad", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
}
void ICustomer.GetBalance(string cus_no, out decimal balance, out decimal credit_amt)
{
var req = new Request();
ReadWriteContext.IWriteContext write = new ReadWriteContext.WriteContextByJson();
write.Append("cus_no", cus_no);
var json = req.request("/customer?t=get_balance", write.ToString());
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
balance = Conv.ToDecimal(read.Read("balance"));
credit_amt = Conv.ToDecimal(read.Read("credit_amt"));
}
string IBLL.ISupSettle.MaxCode()
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("none", "");
Helper.IRequest req = new Helper.Request();
var json = req.request("/sup_settle?t=max_code", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
return(r.Read("code"));
}
}
public string Read(string sys_var_id)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sys_var_id", sys_var_id);
Helper.IRequest req = new Helper.Request();
var json = req.request("/sys?t=read", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
else
{
return(r.Read("value"));
}
}
void IBLL.ICheckBLL.AddCheckSheet(Model.ic_t_check_master ord, List <Model.ic_t_check_detail> lines, out string sheet_no)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("sheet_no", ord.sheet_no);
w.Append("branch_no", ord.branch_no);
w.Append("check_no", ord.check_no);
w.Append("meno", ord.meno);
w.Append("oper_id", ord.oper_id);
w.Append("deal_man", ord.deal_man);
w.Append("cm_branch", ord.cm_branch);
w.Append("oper_date", ord.oper_date.ToString("yyyy-MM-dd HH:mm:ss"));
var tb = new DataTable();
tb.Columns.Add("sheet_no");
tb.Columns.Add("item_no");
tb.Columns.Add("in_price", typeof(decimal));
tb.Columns.Add("sale_price", typeof(decimal));
tb.Columns.Add("stock_qty", typeof(decimal));
tb.Columns.Add("real_qty", typeof(decimal));
tb.Columns.Add("balance_qty", typeof(decimal));
tb.Columns.Add("memo");
tb.Columns.Add("other1");
tb.Columns.Add("other2");
tb.Columns.Add("num1", typeof(decimal));
tb.Columns.Add("num2", typeof(decimal));
tb.Columns.Add("num3", typeof(decimal));
tb.Columns.Add("packqty", typeof(int));
tb.Columns.Add("sgqty", typeof(decimal));
foreach (Model.ic_t_check_detail line in lines)
{
tb.Rows.Add(line.sheet_no, line.item_no, line.in_price, line.sale_price, line.stock_qty, line.real_qty, line.balance_qty,
line.memo, line.other1, line.other2, line.num1, line.num2, line.num3, line.packqty, line.sgqty);
}
w.Append("lines", tb);
Helper.IRequest req = new Helper.Request();
var json = req.request("/check?t=add_checksheet", w.ToString());
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
if (r.Read("errId") != "0")
{
throw new Exception(r.Read("errMsg"));
}
sheet_no = r.Read("sheet_no");
}
