public BaseDataPackage <string> DelSupplierProdPrice(List <DelThreePrimarykeys> data) { var result = new BaseDataPackage <string>(); erpsEntities db = new erpsEntities(); for (int i = 0; i < data.Count; i++) { var PdtID = data[i].Primary1.ToString(); var SupID = data[i].Primary2.ToString(); var Model = data[i].Primary3.ToString(); var list = db.msupplierprodprice.Where(c => c.PdtID == PdtID && c.SupID == SupID && c.Model == Model).FirstOrDefault(); db.msupplierprodprice.Remove(list); } try { db.SaveChanges(); result.Status = ApiStatusCode.OK; result.Message = "删除成功"; return(result); } catch (Exception ex) { result.Message = "发生异常=>" + ex.Message; result.Status = ApiStatusCode.EXCEPTION; return(result); } }
public BaseDataPackage <mcustomer> GetCustomer() { var result = new BaseDataPackage <mcustomer>(); try { erpsEntities db = new erpsEntities(); var list = db.mcustomer.ToList(); if (list.Count > 0) { result.DataList = list; result.Status = ApiStatusCode.OK; result.Message = "查询成功"; return(result); } else { result.DataList = null; result.Status = ApiStatusCode.FAIL; result.Message = "暂无客户数据"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
public IHttpActionResult GetPurOrderDtl_PurOrderNOList() { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; HttpRequestBase request = context.Request; JavaScriptSerializer js = new JavaScriptSerializer(); string purOrder = request.Params["purOrderNOList"]; String[] purOrderArray = purOrder.Split(','); List <Object> saleorderdtls = new List <object>(); try { erpsEntities db = new erpsEntities(); foreach (string id in purOrderArray) { var list = (from dtl in db.tpurorderdtl join pur in db.tpurorder on dtl.PurOrderNO equals pur.PurOrderNO join s in db.msupplier on dtl.SupID equals s.SupID join p in db.mproduct on dtl.PdtID equals p.PdtID where dtl.PurOrderNO == id let p1 = new { dtl.PurOrderNO, //订单号 dtl.SupID, //供应商编号 s.SupName, //供应商名称 pur.AppointDate, //约定日期 dtl.PdtID, //产品编号 p.PdtName, //产品名称 p.Spec, //产品规格 p.Unit, //单位 p.MakeIn, //产地 dtl.UnitPrice, //价格 dtl.OrderNum, //合同数量 dtl.LftNum, //剩余数量 dtl.DelDate, //纳期 dtl.Remark //备注 } select p1); saleorderdtls.AddRange(list); } } catch (Exception ex) { return(new PageResult(ex.ToString(), Request)); } return(new PageResult(saleorderdtls, Request)); }
public BaseDataPackage <string> WholePurOrderWriteOff(string PurOrderNO) { var result = new BaseDataPackage <string>(); try { erpsEntities db = new erpsEntities(); int ret = 0; var purorder = db.tpurorder.Where(w => w.PurOrderNO == PurOrderNO).FirstOrDefault <tpurorder>(); purorder.State = "F"; var entitys = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO); entitys.ToList().ForEach(item => { item.LftNum = 0; item.State = "F"; db.Entry(item).State = System.Data.Entity.EntityState.Modified; }); ret = db.SaveChanges(); if (ret > 0) { result.Status = ApiStatusCode.OK; result.Message = "冲销成功"; return(result); } else { result.DataList = null; result.Status = ApiStatusCode.FAIL; result.Message = "冲销失败"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
public BaseDataPackage <string> EditSupplierProdPrice(string id, msupplierprodprice msupplier) { var result = new BaseDataPackage <string>(); erpsEntities db = new erpsEntities(); msupplier.UpdateDate = DateTime.Now; db.Entry(msupplier).State = EntityState.Modified; try { db.SaveChanges(); result.Status = ApiStatusCode.OK; result.Message = "修改成功"; return(result); } catch (Exception ex) { result.Message = "发生异常=>" + ex.Message; result.Status = ApiStatusCode.EXCEPTION; return(result); } }
public BaseDataPackage <string> AddSupplierProdPrice(msupplierprodprice msupplier) { var result = new BaseDataPackage <string>(); erpsEntities db = new erpsEntities(); if (!ModelState.IsValid) { result.Status = ApiStatusCode.FAIL; result.Message = "无效数据"; return(result); } msupplier.CreateDate = DateTime.Now; db.msupplierprodprice.Add(msupplier); try { db.SaveChanges(); result.Status = ApiStatusCode.OK; result.Message = "提交成功"; return(result); } catch (Exception ex) { if (db.msupplierprodprice.Count(e => e.SupID == msupplier.SupID && e.PdtID == msupplier.PdtID && e.Model == msupplier.Model) > 0) { result.Message = "发生异常=>" + "已存在该供应商编号+产品编号+车型组合"; } else { result.Message = "发生异常=>" + ex.Message; } result.Status = ApiStatusCode.EXCEPTION; return(result); } }
public MProduct() { erpsEntities = new erpsEntities(); }
public WhInventory() { erpsEntities = new erpsEntities(); }
public PurOrder() { erpsEntities = new erpsEntities(); }
public MSupplier() { erpsEntities = new erpsEntities(); }
public BaseDataPackage <string> SelPurOrderDtlWriteOff() { var result = new BaseDataPackage <string>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 JavaScriptSerializer js = new JavaScriptSerializer(); List <SterilizationSel> list = js.Deserialize <List <SterilizationSel> >(request.Params["List"]); erpsEntities db = new erpsEntities(); db.Database.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); }; int ret = 0; //for (int i = 0; i < list.Count; i++) //{ // string PurOrderNO = list[i].saleFocaNO; // int SeqNo = list[i].seqNo; // float LftNum = list[i].lftNum; // var entitys = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO && w.SeqNo == SeqNo); // entitys.ToList().ForEach(item => // { // item.LftNum = LftNum; // item.State = "F"; // db.Entry(item).State = System.Data.Entity.EntityState.Modified; // }); //} string PurOrderNO2 = list.Count > 0? list[0].saleFocaNO:""; //var unFunishOrderDtls = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO2 && (!w.State.Equals("F") || w.State == null)).ToList<tpurorderdtl>(); int fNum = 0; //所有已经冲销的明细数量 var unFunishOrderDtls = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO2).ToList <tpurorderdtl>(); for (int i = 0; i < unFunishOrderDtls.Count; i++) { if (unFunishOrderDtls[i].State == "F") { fNum++; } else { for (int j = 0; j < list.Count; j++) { if (unFunishOrderDtls[i].PurOrderNO == list[j].saleFocaNO && unFunishOrderDtls[i].SeqNo == list[j].seqNo) { unFunishOrderDtls[i].LftNum = list[j].lftNum; unFunishOrderDtls[i].State = "F"; fNum++; } } } } //如果所有明细的状态都是"F"完成,把整体订单的状态都改成完成 if (fNum == unFunishOrderDtls.Count) { var purOrder = db.tpurorder.Where(w => w.PurOrderNO == PurOrderNO2).FirstOrDefault <tpurorder>(); purOrder.State = "F"; } ret = db.SaveChanges(); if (ret > 0) { result.Status = ApiStatusCode.OK; result.Message = "冲销成功"; return(result); } else { result.DataList = null; result.Status = ApiStatusCode.FAIL; result.Message = "冲销失败"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
public BaseDataPackage <v_supplierprodprice> GetSupplierProdPrice(string pagesize, string currentPage, string orderby, string order, string SupID, string SupName, string PdtID, string PdtName) { var result = new BaseDataPackage <v_supplierprodprice>(); erpsEntities db = new erpsEntities(); try { List <v_supplierprodprice> list = new List <v_supplierprodprice>(); int pageSize = int.Parse(pagesize); int CurrentPage = int.Parse(currentPage); Dictionary <string, string> ob = new Dictionary <string, string>(); var tem = from f in db.v_supplierprodprice.AsNoTracking() select f; if (!string.IsNullOrEmpty(SupID)) { tem = tem.Where(w => w.SupID.Contains(SupID)); } if (!string.IsNullOrEmpty(SupName)) { tem = tem.Where(w => w.SupName.Contains(SupName)); } if (!string.IsNullOrEmpty(PdtID)) { tem = tem.Where(w => w.PdtID.Contains(PdtID)); } if (!string.IsNullOrEmpty(PdtName)) { tem = tem.Where(w => w.PdtName.Contains(PdtName)); } if (string.IsNullOrEmpty(orderby) || string.IsNullOrEmpty(order)) // 没有排序信息,直接按预警排序 { tem = tem.OrderByDescending(o => o.CreateDate); } else { string orderPhase = "ASC"; if (order.ToLower() == "descending") { orderPhase = "DESC"; } tem = Tool.SetQueryableOrder(tem, orderby, orderPhase); } int total = tem.Count(); tem = tem .Skip(pageSize * (CurrentPage - 1)) .Take(pageSize); list = tem.ToList(); if (list.Count > 0) { ob.Add("total", total.ToString()); result.DataList = list; result.Keys = ob; result.Status = ApiStatusCode.OK; result.Message = "查询成功"; return(result); } else { result.DataList = null; result.Status = ApiStatusCode.FAIL; result.Message = "暂无数据"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
public SaleForcast() { erpsEntities = new erpsEntities(); }
public StockRecord() { erpsEntities = new erpsEntities(); }
public MCustomer() { erpsEntities = new erpsEntities(); }