// 审核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
