// 审核ERP 中的订单 public JsonResult Audit(string db, string ccode, string cmtMan) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { // 获取订单 检查是否已审核 var corder = kw_m01.v_corder.Find(db, ccode); if (corder.CMTFLAG == "0") { // 执行存储过程 审核订单 try { kw_m01.sp_audit_erp_corder(ccode, db, cmtMan); jsonResult.Data = "success"; } catch (Exception ex) { new SaveError(ex, o, o, o, o, o, db, ccode); jsonResult.Data = ex.InnerException.Message; } } } return(jsonResult); }
// 生成采购计划单 public string Create_Polist(string plJson, string plcJson) { string msg = "success"; using (kw_m01Context kw_m01 = new kw_m01Context()) { var polist = JsonConvert.DeserializeObject <M_POLIST>(plJson); var polists = JsonConvert.DeserializeObject <List <M_POLISTC> >(plcJson); var db = polist.CMTMAN; var ccode = kw_m01.p_getmaxcode3("204", "1", db, DateTime.Now.Date).First(); polist.CCODE = ccode; for (var i = 0; i < polists.Count; i++) { polists[i].CCODE = ccode; } kw_m01.M_POLIST.Add(polist); kw_m01.M_POLISTC.AddRange(polists); kw_m01.SaveChanges(); kw_m01.sp_ins_erp_polist(db, ccode); } return(msg); }
// 提交登录信息 public JsonResult Login(string db, string account, string password) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; jsonResult.Data = 0; using (kw_m01Context kw_m01 = new kw_m01Context()) { var user = kw_m01.v_userlist.Find(account, db); if (user != null) { // 账户匹配 if (password == user.cdesc) { // 密码匹配 if (user.cstop == "0" && user.cempid == "Y") { // 未停用,可登陆 Session["db"] = db; Session["cid"] = user.cid; Session["cname"] = user.cname; jsonResult.Data = "success"; } } } } return(jsonResult); }
// **************************************** // *** 初始化数据 开始 // 厂家编号 - 厂家分类 public string Init_vendclas_tree(string db) { string json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var vendclas = from s in kw_m01.v_vendclas where s.db == db orderby s.cclassid select s; node root = new node(); root.id = "root"; root.text = "厂家分类"; root.clevel = "0"; root.state = "open"; root.children = new List <node>(); foreach (v_vendclas vdc in vendclas) { node temp = new node(vdc); temp.state = "open"; root.children.Add(temp); } json = "[" + JsonConvert.SerializeObject(root) + "]"; } return(json); }
// 查询库存 public JsonResult QryInventory(string pdNo, string db, string flag) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { jsonResult.Data = "无该产品库存信息。"; if (flag == "1") { var stockcs = from s in kw_m01.vq_stockc where s.db == db && s.cmteid == pdNo select s; if (stockcs.Count() != 0) { jsonResult.Data = JsonConvert.SerializeObject(stockcs); } } else { var store = kw_m01.gb_Store.Find(pdNo); if (store != null) { var inventory = store.Inventory; jsonResult.Data = inventory; } } } return(jsonResult); }
// 提交订单到erp 减库存 public JsonResult CMT(string ccode, string db, string ccustid) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; jsonResult.Data = 4; using (kw_m01Context kw_m01 = new kw_m01Context()) { var corder = kw_m01.M_CORDER.Find(ccode, db); if (corder.CMTFLAG == "1") { jsonResult.Data = 5; return(jsonResult); } // 转到erp kw_m01.p_ins_custid_no(db, ccustid); kw_m01.sp_ins_erp_corder(db, ccode); // 让订单处于已提交状态 corder.CMTFLAG = "1"; kw_m01.M_CORDER.AddOrUpdate(corder); var cordercs = from c in kw_m01.M_CORDERC where c.cquotid == db && c.CCODE == ccode select c; var date = DateTime.Now; foreach (var corderc in cordercs) { // 每个项的库存异动 M_StoreChange storeChange = new M_StoreChange(); storeChange.db = db; storeChange.ccode = ccode; storeChange.iorder = corderc.IORDER; storeChange.cmteid = corderc.CMTEID; storeChange.changeFlag = -1; storeChange.quantity = corderc.DQTY; storeChange.changeDate = date.Date; kw_m01.M_StoreChange.Add(storeChange); // 每个项的库存更改kw var store = kw_m01.gb_Store.Find(corderc.CMTEID); store.Inventory -= corderc.DQTY; kw_m01.gb_Store.AddOrUpdate(store); } // 保存数据库更改 kw_m01.SaveChanges(); jsonResult.Data = "success"; } return(jsonResult); }
// 厂家分类 public string Init_vendclas_grid(string db) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var vendclas = from s in kw_m01.v_vendclas where s.db == db select s; grid_json = JsonConvert.SerializeObject(vendclas); } return(grid_json); }
// 采购员选择 public string Init_poman_grid(string db) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var pomans = from s in kw_m01.v_poman where s.db == db orderby s.CPOMANID select s; grid_json = JsonConvert.SerializeObject(pomans); } return(grid_json); }
// 商品分类 public string Init_prodclas_grid(string db) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var prodclas = from s in kw_m01.v_prodclas where s.db == db orderby s.classid select s; grid_json = JsonConvert.SerializeObject(prodclas); } return(grid_json); }
// 颜色编号 public string Init_color_grid(string db) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var colors = from s in kw_m01.v_colorset where s.db == db orderby s.CCOLORID select s; grid_json = JsonConvert.SerializeObject(colors); } return(grid_json); }
// 厂家编号 - 厂家资料 public string Init_vender_grid(string db, string CCLASSID) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var venders = from s in kw_m01.v_vendor where s.db == db && s.CCLASSID == CCLASSID orderby s.CVENDID select s; grid_json = JsonConvert.SerializeObject(venders); } return(grid_json); }
// 查询采购单详情 public string qry_vorderc_grid(string db, string ccode) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var vordercs = from s in kw_m01.v_vorderc where s.db == db && s.CCODE == ccode orderby s.IORDER select s; grid_json = JsonConvert.SerializeObject(vordercs); } return(grid_json); }
// 前端仓库选择 public string Init_warehouse0_grid(string db) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var warehous1 = from s in kw_m01.v_warehous1 where s.db == db && s.ccalcflag == "1" orderby s.CWHID select s; grid_json = JsonConvert.SerializeObject(warehous1); } return(grid_json); }
// 删除订单 public JsonResult DelOrder(string db, string ccode, string flag) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; jsonResult.Data = 6; using (kw_m01Context kw_m01 = new kw_m01Context()) { if (flag == "1") { var erp_corder = kw_m01.v_corder.Find(db, ccode); if (erp_corder.CMTFLAG == "0") { try { int rs = kw_m01.sp_erp_corder(1, db, ccode, "clear", o, o, o, o, o, o, o); jsonResult.Data = "success"; } catch (Exception ex) { new SaveError(ex, o, o, o, o, o, o, o); } } } else { var cordercs = from c in kw_m01.M_CORDERC where (c.cquotid == db) && (c.CCODE == ccode) select c; var tempOrder = kw_m01.M_CORDER.Find(ccode, db); var customer = kw_m01.M_CUSTOMER.Find(tempOrder.CCUSTID, db); if (tempOrder.CMTFLAG == "0") { kw_m01.M_CORDER.Remove(tempOrder); kw_m01.M_CORDERC.RemoveRange(cordercs); kw_m01.M_CUSTOMER.Remove(customer); kw_m01.SaveChanges(); jsonResult.Data = "success"; } } } return(jsonResult); }
// 获取7大区 JSON public JsonResult GetAreas() { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { var areas = from c in kw_m01.v_accountinfo select new { value = c.cdbname, text = c.cname }; string areasJson = JsonConvert.SerializeObject(areas); jsonResult.Data = areasJson; } return(jsonResult); }
// 从erp撤回订单 public JsonResult CancelOrder(string ccode, string db) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; //jsonResult.Data = 4; using (kw_m01Context kw_m01 = new kw_m01Context()) { int flag = kw_m01.sp_del_erp_corder(db, ccode); if (flag == 1) { jsonResult.Data = "success"; } } return(jsonResult); }
// 通过型号返回产品 public JsonResult GetProduct(string db, string pNo, string flag) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; if (String.IsNullOrEmpty(pNo)) {// return(jsonResult); } using (kw_m01Context kw_m01 = new kw_m01Context()) { v_product product = kw_m01.v_product.Find(db, pNo); if (product == null) { return(jsonResult); } var attrItem = kw_m01.v_attrItem.Find(db, product.cattrid); var colors = from s in kw_m01.v_prodcolor where (s.db == db) && (s.CMTEID == pNo) select new { text = s.cname, value = s.CCOLORID }; decimal inventory = -99999; var store = kw_m01.gb_Store.Find(pNo); if (store != null) { inventory = store.Inventory; } ProductQry productQry = new ProductQry(); productQry.product = product; productQry.attrItem = attrItem; productQry.colors = colors; productQry.cunit = kw_m01.v_unit.Find(db, product.CUNITID).CNAME; productQry.inventory = inventory; string json = JsonConvert.SerializeObject(productQry); jsonResult.Data = json; } return(jsonResult); }
// 销售员 登录 public JsonResult Login(string loginInfoJson) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; jsonResult.Data = "NoMatch"; LoginInfo loginInfo = JsonConvert.DeserializeObject <LoginInfo>(loginInfoJson); using (kw_m01Context kw_m01 = new kw_m01Context()) { var user = kw_m01.v_userlist.Find(loginInfo.account, loginInfo.db); if (user != null) { // 账户匹配 if (loginInfo.password == user.cdesc) { // 密码匹配 if (user.cstop == "0" && user.cempid == "Y") { // 未停用,可登陆 // 店长号拥有权限 var maos = from m in kw_m01.mao_file where m.mao05 == loginInfo.account && m.mao01 == loginInfo.db select m; // 测试期间 存放mac地址 map_file map = new map_file(); map.map01 = loginInfo.db; map.map02 = loginInfo.dbName; map.map03 = loginInfo.account; map.map04 = user.cname; map.map05 = loginInfo.macAddr; map.map06 = "Y"; map.mapacti = "Y"; kw_m01.map_file.AddOrUpdate(map); kw_m01.SaveChanges(); var temp = new { cid = user.cid, cname = user.cname, maos = maos }; jsonResult.Data = JsonConvert.SerializeObject(temp); } } } } return(jsonResult); }
// 根据条件筛选采购单 public string qry_vorder_grid(string db, DateTime?date1, DateTime?date2, string pomanid, string vendid, string remark) { string grid_json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var vorders = from s in kw_m01.v_vorder where s.db == db && s.CMTFLAG == "0" && (pomanid == "" ? true : s.CMAN == pomanid) && (vendid == "" ? true : s.CVENDID == vendid) && (date1 == null ? true : date1 <= s.BEGINDT && s.BEGINDT <= date2) orderby s.BEGINDT select s; grid_json = JsonConvert.SerializeObject(vorders); } return(grid_json); }
public JsonResult HelloH5(string customerJson) {//zcscdb2 W999-11470032, zcscdb K002-KW215-001, zcscdb 21440004 var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; JavaScriptSerializer js = new JavaScriptSerializer(); //var customersJson = js.Deserialize<object>(customerJson); var customersJson = js.Deserialize <List <M_CORDERC> >(customerJson); kw_m01Context kw_m01 = new kw_m01Context(); kw_m01.M_CORDERC.AddRange(customersJson); try { kw_m01.SaveChanges(); } catch (DbUpdateException devExc1) { } catch (DbEntityValidationException devExc2) { } return(jsonResult); }
// 通过条件查询订单列表 public String OrderList(string passed, DateTime date1, DateTime date2, string areaQry, string storeQry, string salerQry, string inIDQry) { var flag = true; if (date1.Date.ToString() != "9999/12/31 0:00:00") { flag = false; date2 = date2.AddDays(1); } String json = ""; using (kw_m01Context kw_m01 = new kw_m01Context()) { var corders = from s in kw_m01.M_CORDER where (s.CMTFLAG == passed) //&& (areaQry == "" ? true : s == areaQry) //&& (storeQry == "" ? true : s.Store == storeQry) //&& (salerQry == "" ? true : s.Saler == salerQry) && (inIDQry == "" ? true : s.CCODE == inIDQry) && (flag ? true : (date1 <= s.DDATE && s.DDATE <= date2)) orderby s.DDATE select s; //var totalPage = (storageIns.Count() / 10.0); // 这里要设置每行 json = JsonConvert.SerializeObject(corders); //if (storageIns.Count() > 0) //{ // json = "{\"total\": \"" + totalPage + "\", \"page\": \"1\", \"records\": \"" + storageIns.Count() + "\", \"rows\": ["; // foreach (var st in storageIns) // { // json += "{\"InID\":\"" + st.InID + "\", \"StoreArea\":\"" + st.StoreArea + "\", \"Store\":\"" + st.Store + "\" , \"Saler\":\"" // + st.Saler + "\" , \"CustomName\":\"" + st.CustomName + "\" , \"Phone\":\"" + st.Phone + "\"}"; // json += ","; // } // json = json.Substring(0, json.Length - 1); // json += "]}"; //} } return(json); }
public JsonResult GetGlobalParm(string db) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; jsonResult.Data = "NonData"; using (kw_m01Context kw_m01 = new kw_m01Context()) { var stations = from s in kw_m01.v_station where s.a02 == db select new { value = s.cstation, text = s.cname }; var salers = from s in kw_m01.v_saler where s.db == db orderby s.CNAME select new { value = s.CEMPID, text = s.CNAME + s.CEMPID }; var custclas = from c in kw_m01.v_custclas where c.db == db select new { value = c.CCLASSID, text = c.CNAME }; var singnstylists = from c in kw_m01.v_singnstylist where c.db == db select new { value = c.csignstylistid, text = c.cname }; var payments = from c in kw_m01.v_payment where c.db == db select new { value = c.CPYID, text = c.CNAME }; var settleModes = from c in kw_m01.v_SettleMode where c.db == db select new { value = c.FStlNo, text = c.FStlName }; var stores = from c in kw_m01.v_warehous where c.db == db select new { value = c.CWHID, text = c.CNAME }; object global = new { stations, salers, custclas, singnstylists, payments, settleModes, stores }; string globalJson = JsonConvert.SerializeObject(global); jsonResult.Data = globalJson; } return(jsonResult); }
// 查询库存 public JsonResult stock_qry(string cmteid) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { // 错误信息 jsonResult.Data = 4; // 获取匹配的结果 var stocks = (from s in kw_m01.M_STOCK where s.CMTEID == cmteid select s).ToList(); if (stocks.Count != 0) { // 有结果、序列化 jsonResult.Data = JsonConvert.SerializeObject(stocks); } } return(jsonResult); }// storck_qry - End
// 获取某个订单全部信息 public JsonResult GetOrder(string InID, string db) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { var corder = kw_m01.M_CORDER.Find(db, InID); var cordercs = from s in kw_m01.vq_m_corderc where s.CCODE == InID && s.cquotid == db select s; foreach (M_CORDERC corderc in corder.M_CORDERC) { var store = kw_m01.gb_Store.Find(corderc.CMTEID); // ctype 临时用于存放库存 if (store != null) { corderc.ctype = store.Inventory.ToString(); } else { corderc.ctype = "-999999"; } } OrderQry orderQry = new OrderQry(); orderQry.corder = corder; orderQry.cordercs = cordercs; jsonResult.Data = JsonConvert.SerializeObject(orderQry); } return(jsonResult); }
// 添加订单 public JsonResult AddOrder(string customerJson, string corderJson, string cordercsJson, string flag) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; // 反序列化 单头单身 JavaScriptSerializer js = new JavaScriptSerializer(); var customer = js.Deserialize <M_CUSTOMER>(customerJson); var corder = js.Deserialize <M_CORDER>(corderJson); var cordercs = js.Deserialize <List <M_CORDERC> >(cordercsJson); Debug.Assert(customer != null, "customer 为null!"); Debug.Assert(corder != null, "corder 为null!"); // 访问数据库 using (kw_m01Context kw_m01 = new kw_m01Context()) { // 获取客户号 填入customer&corder var custmResult = kw_m01.p_cre_custid_no(customer.cdeareaid, customer.CCLASSID, customer.cconmante).ToList(); Debug.Assert(custmResult.First() != null && custmResult.First() != "", "客户ID获取失败"); customer.CCUSTID = custmResult.First(); corder.CCUSTID = customer.CCUSTID; // 获取单号 填入customer&corder var orderResult = kw_m01.p_getmaxcode3("305", "1", corder.cpathid, DateTime.Now.Date).ToList(); Debug.Assert(orderResult.First() != null && orderResult.First() != "", "订单ID获取失败"); corder.CCODE = orderResult.First(); customer.CREMARK = corder.CCODE; for (var i = 0; i < cordercs.Count; i++) { cordercs[i].CCODE = corder.CCODE; } // 操作数据库 try { kw_m01.M_CUSTOMER.AddOrUpdate(customer); kw_m01.M_CORDER.Add(corder); if (cordercs.Count != 0) { kw_m01.M_CORDERC.AddRange(cordercs); } kw_m01.SaveChanges(); if (flag == "1") { kw_m01.p_ins_custid_no(customer.cdeareaid, customer.CCUSTID); kw_m01.sp_ins_erp_corder(corder.cpathid, corder.CCODE); corder.CMTFLAG = "1"; kw_m01.M_CORDER.AddOrUpdate(corder); kw_m01.SaveChanges(); } jsonResult.Data = "success"; } catch (Exception ex) { string o = ""; new SaveError(ex, o, o, o, o, o, "区域:" + corder.cpathid, "订单号:" + corder.CCODE); jsonResult.Data = 3; } } return(jsonResult); }
// 获取某个月的订单 public JsonResult GetOrderByMonth(int cNum, int rNum, string saler, string yM, int cmtFlag, string flag) { int y = int.Parse(yM.Substring(0, 4)); int M = int.Parse(yM.Substring(5, 2)); DateTime date1 = new DateTime(y, M, 1); DateTime date2 = date1.AddMonths(1).AddDays(-1); JsonResult jsonResult = new JsonResult(); using (kw_m01Context kw_m01 = new kw_m01Context()) { Debug.Assert(cmtFlag == 1 || cmtFlag == 0); if (flag == "1") { IOrderedQueryable <v_corder> orders = null; if (cmtFlag == 0) { orders = from n in kw_m01.v_corder where (n.BEGINMAN == saler) && (date1 <= n.DDATE && n.DDATE <= date2) && (n.CMTFLAG == "0") orderby n.DDATE descending select n; } if (cmtFlag == 1) { orders = from n in kw_m01.v_corder where (n.BEGINMAN == saler) && (date1 <= n.DDATE && n.DDATE <= date2) && (n.CMTFLAG == "1") orderby n.DDATE descending select n; } var newOrders = orders.Skip(cNum).Take(rNum);// 每次获取10条数据 string json = JsonConvert.SerializeObject(newOrders); jsonResult.Data = json; } else { IOrderedQueryable <M_CORDER> orders = null; if (cmtFlag == 0) { orders = from n in kw_m01.M_CORDER where (n.BEGINMAN == saler) && (date1 <= n.DDATE && n.DDATE <= date2) && (n.CMTFLAG == "0") orderby n.DDATE descending select n; } if (cmtFlag == 1) { orders = from n in kw_m01.M_CORDER where (n.BEGINMAN == saler) && (date1 <= n.DDATE && n.DDATE <= date2) && (n.CMTFLAG == "1") orderby n.DDATE descending select n; } var newOrders = orders.Skip(cNum).Take(rNum);// 每次获取10条数据 string json = JsonConvert.SerializeObject(newOrders); jsonResult.Data = json; } } jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(jsonResult); }
// 保存订单 public JsonResult SaveOrder(string customerJson, string corderJson, string cordercsJson, string flag) { var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; // 反序列化 单头单身 JavaScriptSerializer js = new JavaScriptSerializer(); var customer = js.Deserialize <M_CUSTOMER>(customerJson); var corder = js.Deserialize <M_CORDER>(corderJson); var cordercs = js.Deserialize <List <M_CORDERC> >(cordercsJson); Debug.Assert(customer != null, "customer 为null!"); Debug.Assert(corder != null, "corder 为null!"); // 访问数据库 //TransactionScope scope = new TransactionScope() using (kw_m01Context kw_m01 = new kw_m01Context()) { var dels = from s in kw_m01.M_CORDERC where s.CCODE == corder.CCODE && s.cquotid == corder.cpathid select s; // 操作数据库 kw_m01.M_CORDER.AddOrUpdate(corder); kw_m01.M_CUSTOMER.AddOrUpdate(customer); kw_m01.M_CORDERC.RemoveRange(dels); if (cordercs.Count != 0) { kw_m01.M_CORDERC.AddRange(cordercs); } if (flag == "1") { var erp_order = kw_m01.v_corder.Find(corder.cpathid, corder.CCODE); if (erp_order.CMTFLAG == "0") { try { kw_m01.SaveChanges(); kw_m01.sp_erp_corder(1, corder.cpathid, corder.CCODE, o, o, o, o, o, o, o, o); kw_m01.p_ins_custid_no(customer.cdeareaid, customer.CCUSTID); kw_m01.sp_ins_erp_corder(corder.cpathid, corder.CCODE); jsonResult.Data = "success"; } catch (Exception ex) { new SaveError(ex, o, o, o, o, o, "db:" + corder.cpathid, "客户订单号:" + corder.CCODE); } } } else { var tempOrder = kw_m01.M_CORDER.Find(corder.CCODE, corder.cpathid); if (tempOrder.CMTFLAG == "0") { kw_m01.SaveChanges(); jsonResult.Data = "success"; } } } return(jsonResult); }
// 获取订单 public JsonResult GetOrder(string db, string ccode, string flag) { Debug.Assert((db != null) && (db != ""), "db为空"); Debug.Assert((ccode != null) && (ccode != ""), "ccode为空"); var jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; using (kw_m01Context kw_m01 = new kw_m01Context()) { if (flag == "1") { var erp_corder = kw_m01.v_corder.Find(db, ccode); if (erp_corder == null) { jsonResult.Data = 3; return(jsonResult); } var erp_corders = from s in kw_m01.v_corderc where s.db == db && s.CCODE == ccode orderby s.IORDER select s; var erp_customer = kw_m01.v_customer.Find(db, erp_corder.CCUSTID); ErpOrderQry orderQry = new ErpOrderQry(); orderQry.customer = erp_customer; orderQry.corder = erp_corder; if (erp_corders.Count() != 0) { orderQry.cordercs = erp_corders; } jsonResult.Data = JsonConvert.SerializeObject(orderQry); } else { var corder = kw_m01.vq_m_corder.Find(ccode, db); if (corder == null) { jsonResult.Data = 3; return(jsonResult); } var cordercs = from c in kw_m01.vq_m_corderc where (c.cquotid == db) && (c.CCODE == ccode) orderby c.IORDER select c; var customer = kw_m01.vq_m_customer.Find(corder.CCUSTID, db); Debug.Assert((customer != null), "customer为空"); vqOrderQry orderQry = new vqOrderQry(); orderQry.customer = customer; orderQry.corder = corder; if (cordercs.Count() != 0) { orderQry.cordercs = cordercs; } jsonResult.Data = JsonConvert.SerializeObject(orderQry); } } return(jsonResult); }
}// storck_qry - End // 下拉刷新、上拉加载 public JsonResult pull_refresh(string db, int skipNum, int takeNum, string who, string yM, string flag) { JsonResult jsonResult = new JsonResult(); jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet; int y = int.Parse(yM.Substring(0, 4)); int M = int.Parse(yM.Substring(5, 2)); DateTime date1 = new DateTime(y, M, 1); DateTime date2 = date1.AddMonths(1).AddDays(-1); using (kw_m01Context kw_m01 = new kw_m01Context()) { Sale_GB_pull_refresh result = new Sale_GB_pull_refresh(); // 初始化 三个选项卡 if (flag == "0") { var cordersSql1 = from s in kw_m01.M_CORDER where s.CMTFLAG == "0" && s.cpathid == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE descending select s; var cordersSql2 = from s in kw_m01.v_corder where s.CMTFLAG == "0" && s.db == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE descending select s; var cordersSql3 = from s in kw_m01.v_corder where s.CMTFLAG == "1" && s.db == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE descending select s; result.skipNum1 = cordersSql1.Count() - 2 * takeNum; result.skipNum2 = cordersSql2.Count() - 2 * takeNum; result.skipNum3 = cordersSql3.Count() - 2 * takeNum; result.corders1 = cordersSql1.Take(takeNum).ToList(); result.corders2 = cordersSql2.Take(takeNum).ToList(); result.corders3 = cordersSql3.Take(takeNum).ToList(); } // 未提交 if (flag == "1") { var cordersSql1 = from s in kw_m01.M_CORDER where s.CMTFLAG == "0" && s.cpathid == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE select s; result.corders1 = cordersSql1.Skip(skipNum).Take(takeNum).OrderByDescending(d => d.DDATE).ToList(); result.skipNum1 = skipNum - takeNum; } // 已提交 * 未审核 if (flag == "2") { var cordersSql2 = from s in kw_m01.v_corder where s.CMTFLAG == "0" && s.db == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE select s; result.corders2 = cordersSql2.Skip(skipNum).Take(takeNum).OrderByDescending(d => d.DDATE).ToList(); result.skipNum2 = skipNum - takeNum; } // 已审核 if (flag == "3") { var cordersSql3 = from s in kw_m01.v_corder where s.CMTFLAG == "1" && s.db == db && s.BEGINMAN == who && date1 <= s.DDATE && s.DDATE <= date2 orderby s.DDATE select s; result.corders3 = cordersSql3.Skip(skipNum).Take(takeNum).OrderByDescending(d => d.DDATE).ToList(); result.skipNum3 = skipNum - takeNum; } if ((result.skipNum1 < 0) && (result.corders1.Count == takeNum)) { result.skipNum1 = 0; } if ((result.skipNum2 < 0) && (result.corders2.Count == takeNum)) { result.skipNum2 = 0; } if ((result.skipNum3 < 0) && (result.corders3.Count == takeNum)) { result.skipNum3 = 0; } jsonResult.Data = JsonConvert.SerializeObject(result); } return(jsonResult); } // pull_refresh - End