public BaseDataPackage <string> CancelPurOrder(string PurOrderNO, string UserID, string NegativeInventory) { var result = new BaseDataPackage <string>(); try { int ret = purOrder.CancelPurOrderStockIn(PurOrderNO, UserID, NegativeInventory, out string errPdtID, out string errWHID); if (ret == 1) { result.Status = ApiStatusCode.OK; result.Message = "取消成功"; return(result); } else { result.Status = ApiStatusCode.FAIL; result.Message = "取消失败"; if (ret == -9) { Dictionary <string, string> ob = new Dictionary <string, string>(); ob.Add("ret", "-9"); result.Keys = ob; result.Message = string.Format("{0} 仓库下的 {1} 产品库存不足", errWHID, errPdtID); } return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; 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 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 <string> DelPurOrderAtt(string PurOrderNO, string AttFileName) { var result = new BaseDataPackage <string>(); try { int ret = purOrder.DelPurOrderAtt(PurOrderNO, AttFileName); if (ret == 1) { //删除文件 File.Delete(HttpContext.Current.Server.MapPath(AttFileName)); result.Status = ApiStatusCode.OK; result.Message = "删除成功"; return(result); } else { result.Status = ApiStatusCode.FAIL; result.Message = "删除失败"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
public BaseDataPackage <v_purorderdtl> GetPurOrderDtl_PurOrderNO(string purOrderNO) { var result = new BaseDataPackage <v_purorderdtl>(); try { List <v_purorderdtl> list; list = purOrder.GetPurOrderDtlAndAtt(purOrderNO, out List <tpurorderatt> tpurorderatts); if (list.Count > 0) { result.DataList = list; result.ObjList = tpurorderatts.Cast <object>().ToList(); 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); } }
/// <summary> /// 注册 /// </summary> /// <param name="context"></param> public void Register(HttpContext context) { string username = context.Request["username"]; string mobile = context.Request["mobile"]; string departid = context.Request["departid"]; UserInfo user = new UserInfo(); user.username = username; user.mobile = mobile; user.departid = departid; int num = DbHelperSQL.ExecuteSql("insert into sys_UserInfo(username,mobile,departid) values('" + username + "','" + mobile + "','" + departid + "')"); var result = new BaseDataPackage <UserInfo>(); if (num != 0) { result.code = ApiStatusCode.OK; result.data = user; result.msg = "注册成功"; } else { result.code = ApiStatusCode.FAIL; result.data = user; result.msg = "注册失败"; } string jsonData = JsonConvert.SerializeObject(result); context.Response.Write(jsonData); }
public BaseDataPackage <string> DelPurOrder() { var result = new BaseDataPackage <string>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 JavaScriptSerializer js = new JavaScriptSerializer(); List <DelList> list = js.Deserialize <List <DelList> >(request.Params["delList"]); int ret = purOrder.DelPurOrder(list); if (ret == 1) { result.Status = ApiStatusCode.OK; result.Message = "删除成功"; return(result); } else { result.Status = ApiStatusCode.FAIL; result.Message = "删除失败"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }
/// <summary> /// send data to all connected clients /// </summary> /// <param name="data">Data will be added to a queue</param> public void SendToAll(BaseDataPackage data) { lock (_groupDataQueue) { _groupDataQueue.Enqueue(data); } }
/// <summary> /// send a specific client data /// </summary> /// <param name="data">Data that will be sent to one client</param> /// <param name="clientId">ID of client</param> public void SendClient(BaseDataPackage data, Guid clientId) { KeyValuePair <ClientReference, BaseDataPackage> kvp = new KeyValuePair <ClientReference, BaseDataPackage>(GetClientById(clientId), data); lock (_clientDataQueue) { _clientDataQueue.Enqueue(kvp); } }
//发布消息 public void SendMessage(HttpContext context) { var result = new BaseDataPackage <UserMessage>(); string AcceptUserID = ""; string AcceptUserName = context.Request["AcceptUserName"]; string SendUserID = context.Request["SendUserID"]; string SendUserName = context.Request["SendUserName"]; string MsgTitle = context.Request["MsgTitle"]; string MsgText = context.Request["MsgText"]; string SendToList = ""; string MessageType = ""; string[] sArray = AcceptUserName.Split(','); string AcceptUserName2 = ""; foreach (string i in sArray) { AcceptUserName2 += "'" + i + "'" + ","; } SqlDataReader dr = DbHelperSQL.ExecuteReader("select id from sys_UserInfo where username in (" + AcceptUserName2.TrimEnd(',') + ")"); while (dr.Read()) { AcceptUserID += dr["id"].ToString() + ","; } UserMessage UserMessage = new UserMessage(); UserMessage.AcceptUserID = AcceptUserID; UserMessage.AcceptUserName = AcceptUserName; UserMessage.SendUserID = SendUserID; UserMessage.SendUserName = SendUserName; UserMessage.MsgTitle = MsgTitle; UserMessage.MsgText = MsgText; UserMessage.SendToList = SendToList; UserMessage.MessageType = MessageType; UserMessage.bRead = false; UserMessage.SendDateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); int num = DbHelperSQL.ExecuteSql("insert into sys_UserMessage (AcceptUserID, AcceptUserName, SendUserID, SendUserName, MsgTitle, MsgText, SendToList, MessageType, bRead, SendDateTime) values('" + AcceptUserID + "', '" + AcceptUserName + "', '" + SendUserID + "', '" + SendUserName + "', '" + MsgTitle + "' , '" + MsgText + "', '" + SendToList + "', '" + MessageType + "', '" + false + "', '" + UserMessage.SendDateTime + "' )"); if (num != 0) { result.code = ApiStatusCode.OK; result.msg = "发送成功!"; result.data = UserMessage; } else { result.code = ApiStatusCode.OK; result.msg = "发送失败!"; result.data = UserMessage; } string jsonData = JsonConvert.SerializeObject(result); context.Response.Write(jsonData); }
public BaseDataPackage <v_purorder> GetPurOrder() { var result = new BaseDataPackage <v_purorder>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string pagesize = request.Params["pagesize"]; string currentPage = request.Params["currentPage"]; string SupID = request.Params["SupID"]; string UpdateID = request.Params["UpdateID"]; string PurOrderNo = request.Params["PurOrderNo"]; string SDate = request.Params["SDate"]; string EDate = request.Params["EDate"]; string status = request.Params["Status"]; //SaleForcast sale = new SaleForcast(); List <v_purorder> list; int pageSize = int.Parse(pagesize); int CurrentPage = int.Parse(currentPage); Dictionary <string, string> ob = new Dictionary <string, string>(); list = purOrder.GetPurOrder(PurOrderNo, SupID, UpdateID, SDate, EDate, status, pageSize, CurrentPage, out int total); 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 void CallMethod(SynchronizationContext context, BaseDataPackage data) { //Functions[data.GetType()].Invoke(data, default(Guid)); try { //dispatch call into the proper thread context.Post(s => { Functions[data.GetType()].Invoke(data, default(Guid)); }, null); //ConnectionClosed?.Invoke(); } catch (Exception ex) { //dont trust user code Console.WriteLine("Calling client CallMethod data handler threw an exception"); } }
public BaseDataPackage <vwhinventorywarning> GetWhInventoryWarning() { var result = new BaseDataPackage <vwhinventorywarning>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string pagesize = request.Params["pagesize"]; string currentPage = request.Params["currentPage"]; string pdtID = request.Params["pdtID"]; string orderby = request.Params["orderby"]; string order = request.Params["order"]; List <vwhinventorywarning> list; int pageSize = int.Parse(pagesize); int CurrentPage = int.Parse(currentPage); Dictionary <string, string> ob = new Dictionary <string, string>(); list = whInv.GetWhInventoryWarning(pageSize, CurrentPage, pdtID, orderby, order, out int total); 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 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 void SendData(BaseDataPackage data) { MemoryStream msend = new MemoryStream(); try { _bf.Serialize(msend, data); } catch (Exception ex) { Console.WriteLine("SendData: Serialize"); msend.Dispose(); return; } try { _socket.Send(msend.GetBuffer(), 0, (int)msend.Length, SocketFlags.None); } catch (Exception ex) { Console.WriteLine("SendData: Send"); } }
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 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 void CommitSuggest(HttpContext context) { string fileNewName = string.Empty; string filePath = string.Empty; var result = new BaseDataPackage <UserSuggest>(); HttpPostedFile file = context.Request.Files["file1"]; HttpPostedFile file2 = context.Request.Files["file2"]; HttpPostedFile file3 = context.Request.Files["file3"]; string Title = context.Request["Title"]; string Suggest = context.Request["Suggest"]; string UserID = context.Request["UserID"]; string paths = context.Request["paths"]; string pathsNew = ""; if (paths != "") { string[] sArray = paths.Split(','); foreach (string pathSplit in sArray) { if (pathSplit != "") { fileNewName = DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(pathSplit); string virtualPath = String.Format("/File/{0}", fileNewName); //上传到指定文件夹 string path = virtualPath; //相对获取文件路径 pathsNew += path + ","; } } } if (file != null) { file.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file.FileName))); } if (file2 != null) { file2.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file2.FileName))); } if (file3 != null) { file3.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file3.FileName))); } result.code = ApiStatusCode.OK; result.msg = ""; result.data = null; UserSuggest userSuggest = new UserSuggest(); userSuggest.commitUserID = int.Parse(UserID); userSuggest.title = Title; userSuggest.suggest = Suggest; userSuggest.commitDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); userSuggest.files = pathsNew; int num = DbHelperSQL.ExecuteSql("insert into sys_UserSuggest(commitUserID,title,suggest,commitDate,files) values('" + userSuggest.commitUserID + "','" + userSuggest.title + "','" + userSuggest.suggest + "','" + userSuggest.commitDate + "','" + userSuggest.files + "')"); if (num != 0) { result.code = ApiStatusCode.OK; result.msg = "提交成功!"; result.data = userSuggest; } else { result.code = ApiStatusCode.OK; result.msg = "提交失败!"; result.data = userSuggest; } string jsonData = JsonConvert.SerializeObject(result); context.Response.Write(jsonData); }
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); } }
private void serverDataHandler(BaseDataPackage data, Guid id) { ButtonClickData d = data.Unbox(); tbServerData.Text = d.ButtonClicked; }
private void clientDataHandler(BaseDataPackage data) { ButtonClickData d = data.Unbox(); tbClientData.Text = d.ButtonClicked; }
public BaseDataPackage <mcustomer> McustomerImport() { var result = new BaseDataPackage <mcustomer>(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string UserID = request.Form["UserID"]; HttpFileCollection filelist = HttpContext.Current.Request.Files; if (filelist != null && filelist.Count > 0) { HttpPostedFile file = filelist[0]; string Tpath = "/Import/" + DateTime.Now.ToString("yyyy-MM-dd") + "/"; string filename = file.FileName; string FileName = DateTime.Now.ToString("yyyyMMddHHmmssfff"); string FilePath = HttpContext.Current.Server.MapPath("~/" + Tpath); string type = System.IO.Path.GetExtension(filename); DirectoryInfo di = new DirectoryInfo(FilePath); if (!di.Exists) { di.Create(); } List <mcustomer> list = null; //Dictionary<string, string> ob = new Dictionary<string, string>(); try { string tmpFileName = FilePath + FileName + type; file.SaveAs(tmpFileName); MCustomer sche = new MCustomer(); list = this.ExcelToMCustomerList(tmpFileName, UserID); if (list.Count > 0) { int ret = sche.ImportList(list, out int addNum, out int updNum, out int cfNum); //result.Keys = ob; result.Status = ApiStatusCode.OK; if (cfNum > 0) { result.Message = string.Format("数据导入成功,新增数据: {0}条, 修改数据: {1}条, Excel中有 {2} 条重复数据未导入", addNum, updNum, cfNum); } else { result.Message = string.Format("数据导入成功,新增数据: {0}条, 修改数据: {1}条", addNum, updNum); } } else { result.Status = ApiStatusCode.FAIL; result.Message = "导入数据失败,请确认所选文件是否正确"; } return(result); } catch (Exception ex) { result.DataList = null; result.Status = ApiStatusCode.FAIL; result.Message = "导入数据失败:" + ex.Message; return(result); } } else { result.Status = ApiStatusCode.EXCEPTION; result.Message = "上传导入文件出现异常!"; return(result); } }
public IHttpActionResult GetWhProduct() { var result = new BaseDataPackage <mproduct>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string pagesize = request.Params["pagesize"]; string currentpage = request.Params["currentPage"]; string whID = request.Params["whID"]; string pdtID = request.Params["pdtID"]; string pdtName = request.Params["pdtName"]; string spec = request.Params["spec"]; string unit = request.Params["unit"]; string pdtType = request.Params["pdtType"]; string startDate = request.Params["startDate"]; string endDate = request.Params["endDate"]; int pageSize = int.Parse(pagesize); int currentPage = int.Parse(currentpage); List <mproduct> list = new List <mproduct>(); var tem = from p in db.mproduct join t in db.mproducttype on p.PdtType equals t.PdtTypeID join w in db.twhinventory on p.PdtID equals w.PdtID where w.WHID.Equals(whID) && w.InvNum > 0 select new { p.CreateDate, p.CreateID, p.MakeIn, p.MgrInfo, p.PdtID, p.PdtName, p.PdtType, p.PurPrice, p.Remark, p.SalPrice, p.Spec, p.Unit, p.UpdateDate, p.UpdateID, w.WHID, w.InvNum }; if (!string.IsNullOrEmpty(pdtID)) { tem = tem.Where(w => w.PdtID.Contains(pdtID)); } if (!string.IsNullOrEmpty(pdtName)) { tem = tem.Where(p => p.PdtName.Contains(pdtName)); } if (!string.IsNullOrEmpty(spec)) { tem = tem.Where(p => p.Spec.Contains(spec)); } if (!string.IsNullOrEmpty(unit)) { tem = tem.Where(p => p.Unit.Contains(unit)); } if (!string.IsNullOrEmpty(pdtType)) { tem = tem.Where(p => p.PdtType == pdtType); } if (!string.IsNullOrEmpty(startDate)) { DateTime date = Convert.ToDateTime(startDate); tem = tem.Where(p => p.CreateDate >= date); } if (!string.IsNullOrEmpty(endDate)) { DateTime date = Convert.ToDateTime(endDate); date = date.AddDays(1); tem = tem.Where(p => p.CreateDate < date); } if (tem == null) { return(NotFound()); } tem = tem.OrderBy(p => p.PdtID); var oData = new { total = tem.Count(), rows = tem.Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList() }; return(Ok(oData)); } catch (Exception ex) { return(NotFound()); } }
public BaseDataPackage <string> EditPurOrderDtl() { var result = new BaseDataPackage <string>(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string PurOrderNO = request.Form["PurOrderNO"]; string SupID = request.Form["SupID"]; string UserID = request.Form["UserID"]; string CreDate = request.Form["CreDate"]; tpurorder tpurorder = new tpurorder(); tpurorder.PurOrderNO = PurOrderNO; tpurorder.SupID = request.Form["SupID"]; tpurorder.CreDate = Convert.ToDateTime(CreDate); tpurorder.TotalNum = float.Parse(request.Form["TotalNum"]); tpurorder.TotalAmount = float.Parse(request.Form["TotalAmount"]); tpurorder.AppointDate = Convert.ToDateTime(request.Form["AppointDate"]); tpurorder.UpdateID = UserID; tpurorder.UpdateDate = DateTime.Now; JavaScriptSerializer js = new JavaScriptSerializer(); List <v_purorderdtl> list = js.Deserialize <List <v_purorderdtl> >(request.Params["list"]); list.RemoveAll(r => string.IsNullOrEmpty(r.PdtID)); List <tpurorderdtl> tpurorderdtls = new List <tpurorderdtl>(); for (int i = 0; i < list.Count; i++) { tpurorderdtl tpurorderdtl = new tpurorderdtl(); tpurorderdtl.PurOrderNO = PurOrderNO; tpurorderdtl.SeqNo = i + 1; tpurorderdtl.SupID = SupID; tpurorderdtl.PdtID = list[i].PdtID; tpurorderdtl.DelDate = list[i].DelDate; tpurorderdtl.OrderNum = Convert.ToSingle(list[i].OrderNum); tpurorderdtl.LftNum = Convert.ToSingle(list[i].LftNum); tpurorderdtl.UnitPrice = list[i].UnitPrice; tpurorderdtl.TotalAmount = list[i].TotalAmount; tpurorderdtl.State = list[i].State == null ? "N" : list[i].State; tpurorderdtl.Remark = list[i].Remark; tpurorderdtl.UpdateID = UserID; tpurorderdtl.UpdateDate = DateTime.Now; tpurorderdtls.Add(tpurorderdtl); } List <tpurorderatt> tpurorderatts = new List <tpurorderatt>(); HttpFileCollection files = HttpContext.Current.Request.Files; string url = "/upload/" + PurOrderNO + "/"; string basePath = HttpContext.Current.Server.MapPath(url); List <string> tmpPath = new List <string>(); if (files.Count > 0) { //如果目录不存在,则创建目录 if (!Directory.Exists(basePath)) { Directory.CreateDirectory(basePath); } for (int i = 0; i < files.Count; i++) { tpurorderatt tpurorderatt = new tpurorderatt(); string path = basePath + files[i].FileName; tpurorderatt.PurOrderNO = PurOrderNO; tpurorderatt.AttFileName = url + files[i].FileName; tpurorderatt.UpdateID = UserID; tpurorderatt.UpdateDate = DateTime.Now; tpurorderatts.Add(tpurorderatt); tmpPath.Add(path); } } int ret = purOrder.EditPurOrderDtl(PurOrderNO, tpurorder, tpurorderdtls, tpurorderatts); if (ret == 1) { for (int i = 0; i < files.Count; i++) { files[i].SaveAs(tmpPath[i]); } result.Status = ApiStatusCode.OK; result.Message = "修改成功"; return(result); } else { result.Status = ApiStatusCode.FAIL; result.Message = "修改失败"; return(result); } } catch (Exception ex) { result.Status = ApiStatusCode.EXCEPTION; result.Message = "发生异常=>" + ex.Message; return(result); } }