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"));
}
}
List <body.theme> IGoods.GetThemeList()
{
var req = new Request();
var json = req.request("/goods?t=get_theme_list", "");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
var lst = new List <body.theme>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new body.theme();
lst.Add(item);
item.theme_id = r.Read("theme_id");
item.theme_code = r.Read("theme_code");
item.theme_name = r.Read("theme_name");
}
}
return(lst);
}
DataTable IGoodsCls.GetDtForSupCustGroup()
{
var req = new Request();
var json = req.request("/goods_cls?t=get_list_for_menu", "{\"is_first_level\":\"0\"}");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
if (read.Read("datas").Length < 10)
{
return(new DataTable());
}
var tb = Conv.GetDataTable(read.ReadList("datas"));
if (tb.Rows.Count > 0)
{
tb.Columns.Add("is_check");
foreach (DataRow dr in tb.Rows)
{
dr["is_check"] = "0";
}
}
return(tb);
}
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);
}
}
List <body.goods_cls> IGoodsCls.GetListForSupCustGroup()
{
var req = new Request();
var json = req.request("/goods_cls?t=get_list_for_menu", "{\"is_first_level\":\"1\"}");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
var lst = new List <body.goods_cls>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new body.goods_cls();
lst.Add(item);
item.is_check = false;
item.item_clsno = r.Read("cls_no");
item.item_clsname = r.Read("cls_name");
}
}
return(lst);
}
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);
}
}
List <Model.goods> IGoods.GetList(string cls_no, string keyword, string theme, string is_no_show_mall, int pageSize, int pageIndex, out int total)
{
var req = new Request();
var json = req.request("/goods?t=select_key", "{\"cls_no\":\"" + cls_no + "\",\"keyword\":\"" + keyword + "\",\"theme\":\"" + theme + "\",\"is_no_show_mall\":\"" + is_no_show_mall + "\",\"pageIndex\":\"" + pageIndex + "\",\"pageSize\":\"" + pageSize + "\"}");
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 <Model.goods>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new Model.goods();
lst.Add(item);
item.goods_id = r.Read("goods_id");
item.goods_no = r.Read("goods_no");
item.goods_name = r.Read("goods_name");
item.is_show_mall = r.Read("is_show_mall");
item.status = r.Read("status");
item.cls_id = r.Read("cls_id");
item.cls_name = r.Read("cls_name");
item.themes = r.Read("themes");
}
}
return(lst);
}
List <Model.advice> IAdvice.GetList(int pageSize, int pageIndex, out int total)
{
var req = new Request();
var json = req.request("/advice?t=get_list", "{\"pageSize\":\"" + pageSize + "\",\"pageIndex\":\"" + pageIndex + "\"}");
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 <Model.advice>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new Model.advice();
lst.Add(item);
item.av_id = r.Read("av_id");
item.use_ask = r.Read("use_ask");
item.mc_reply = r.Read("mc_reply");
item.ask_date = Conv.ToDateTime(r.Read("ask_date"));
item.reply_date = Conv.ToDateTime(r.Read("reply_date"));
item.nickname = r.Read("nickname");
}
}
return(lst);
}
List <Model.goods_cls> IGoodsCls.GetList(string parent_cls_no, string keyword, int pageSize, int pageIndex, out int total)
{
var req = new Request();
var json = req.request("/goods_cls?t=get_list", "{\"parent_cls_no\":\"" + parent_cls_no + "\",\"keyword\":\"" + keyword + "\",\"pageSize\":\"" + pageSize + "\",\"pageIndex\":\"" + pageIndex + "\"}");
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 <Model.goods_cls>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new Model.goods_cls();
lst.Add(item);
item.cls_id = r.Read("cls_id");
item.cls_no = r.Read("cls_no");
item.cls_name = r.Read("cls_name");
item.status = r.Read("status");
item.is_show_mall = r.Read("is_show_mall");
item.cus_group = r.Read("cus_group");
item.supcust_groupname = r.Read("supcust_groupname");
}
}
return(lst);
}
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);
}
}
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);
}
}
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 <string> IOrder.GetNewOrderCode()
{
var req = new Request();
var json = req.request("/order?t=get_new_msg", "");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") == "-2")
{
var json1 = req.request("/oper?t=login", "{\"oper_id\":\"" + Program.oper_id + "\",\"pwd\":\"" + Program.pwd + "\"}");
ReadWriteContext.IReadContext read1 = new ReadWriteContext.ReadContextByJson(json);
}
else if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
var lst = new List <string>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
lst.Add(r.Read("ord_id"));
}
}
return(lst);
}
public static void UploadImage(Image img, out string img_path)
{
string url = AppSetting.svr + "/upload_img?t=upload";
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
req.Timeout = 60 * 1000;
req.ReadWriteTimeout = 60 * 1000;
//
req.Headers.Add("img_type", "jpg");
//
System.IO.MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
var bs = ms.ToArray();
req.Method = "POST";
Stream requestStream = req.GetRequestStream();
requestStream.Write(bs, 0, bs.Length);
requestStream.Close();
//
HttpWebResponse res = (HttpWebResponse)req.GetResponse();
Stream stream = res.GetResponseStream();
StreamReader reader = new StreamReader(stream);
string str = reader.ReadToEnd();
stream.Close();
reader.Close();
//
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(str);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
img_path = read.Read("img_path");
}
public bool CheckConnect(string svr, out string errMsg)
{
errMsg = "";
try
{
bool is_connect = false;
IRequest req = new TestWebServiceRequest(svr);
var json = req.request("/common?t=connect_server", "");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
if (read.Read("is_connect") == "1")
{
is_connect = true;
}
return(is_connect);
}
catch (Exception ex)
{
Log.writeLog("TestNetBLL ->CheckConnect()", ex.ToString(), null);
errMsg = ex.GetMessage();
return(false);
}
}
List <Model.goods_cls> IGoodsCls.GetListForMenu()
{
var req = new Request();
var json = req.request("/goods_cls?t=get_list_for_menu", "{\"is_first_level\":\"0\"}");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
var lst = new List <Model.goods_cls>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new Model.goods_cls();
lst.Add(item);
item.cls_id = r.Read("cls_id");
item.cls_no = r.Read("cls_no");
item.cls_name = r.Read("cls_name");
item.status = r.Read("status");
item.is_show_mall = r.Read("is_show_mall");
}
}
return(lst);
}
//查询常春藤支付服务器微信支付状态（主要用于预支付）
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;
}
}
List <Model.ad> IAd.GetList(int pageSize, int pageIndex, out int total)
{
var req = new Request();
var json = req.request("/ad?t=get_list", "{\"pageSize\":\"" + pageSize + "\",\"pageIndex\":\"" + pageIndex + "\"}");
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 <Model.ad>();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
var item = new Model.ad();
lst.Add(item);
item.ad_id = r.Read("ad_id");
item.ad_type = Conv.ToInt(r.Read("ad_type"));
item.ad_name = r.Read("ad_name");
item.title_img = r.Read("title_img");
item.detail_img = r.Read("detail_img");
item.ad_text = r.Read("ad_text");
item.goods_ids = r.Read("goods_ids");
}
}
return(lst);
}
/// <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;
}
}
/// <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;
}
}
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 IRep销售汇总表.GetData(string key, int pageSize, int pageIndex, out int total)
{
var req = new Request();
var json = req.request("/pager?t=get_data", "{\"key\":\"" + key + "\",\"pageSize\":\"" + pageSize + "\",\"pageIndex\":\"" + pageIndex + "\"}");
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("金额");
if (read.Read("data") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("data"))
{
dt.Rows.Add(
r.Read("单数"),
r.Read("数量"),
r.Read("金额")
);
}
}
return(dt);
}
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"));
}
}
List <body.key_value> ICustomer.GetCusGroupList()
{
var req = new Request();
var json = req.request("/customer?t=get_group_list", "");
ReadWriteContext.IReadContext read = new ReadWriteContext.ReadContextByJson(json);
if (read.Read("errId") != "0")
{
throw new Exception(read.Read("errMsg"));
}
//
var lst = new List <body.key_value>();
var item = new body.key_value();
if (read.Read("datas") != "")
{
foreach (ReadWriteContext.IReadContext r in read.ReadList("datas"))
{
item = new body.key_value();
item.t_key = r.Read("supcust_groupno");
item.t_value = r.Read("supcust_groupname");
lst.Add(item);
}
}
return(lst);
}
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);
}
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);
}
}
public alimicropay_res(string context)
{
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(context);
code = r.Read("alipay_trade_pay_response/code");
msg = r.Read("alipay_trade_pay_response/msg");
sub_code = r.Read("alipay_trade_pay_response/sub_code");
sub_msg = r.Read("alipay_trade_pay_response/sub_msg");
}
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);
}
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);
}
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);
}
