public RequestResult RtnStockCount(int pageindex, int pagesize, string startdate = "", string enddate = "", string keyword = "") { RequestResult result = new RequestResult(); try { int StartTimestamp = startdate != "" ? CommonFunc.GetTimestamp(Convert.ToDateTime(startdate + " 00:00:00")) : 0; int EndTimestamp = enddate != "" ? CommonFunc.GetTimestamp(Convert.ToDateTime(enddate + " 23:59:59")) : 0; int totalCount = 0; List <RtnStockRecord> CountList = ScaleRtnStoke.GetRtnStockCount(MobileUser.UserName, pagesize, pageindex, StartTimestamp, EndTimestamp, keyword, out totalCount); for (int i = 0; i < CountList.Count; i++) { CountList[i].ProductImg = WeConfig.b_domain + CountList[i].ProductImg; } result.data = CountList; result.pages = pageindex; result.total = totalCount; result.message = "成功"; result.success = true; } catch (Exception ex) { result.message = "失败,error:" + ex.Message; result.success = false; } return(result); }
public RequestResult BigCode(string code, string orderno = "") { RequestResult result = new RequestResult(); try { List <Scale> scale = Scale.GetScaleForBig(code); if (scale.Count > 0) { Scale scaleDeal = scale.Where(sca => (sca.IsOut == true || sca.StateID == 9) && sca.OutWay == 3).FirstOrDefault(); if (scaleDeal != null) { if (scaleDeal.IsOut) // 是否已经出货 { ScaleRtnStoke scaleRtn = new ScaleRtnStoke(); scaleRtn.BigCode = scaleDeal.BigCode; scaleRtn.OrderNo = orderno; scaleRtn.OperaUser = PdaUser.PUserName; scaleRtn.IsPDAOpera = true; scaleRtn.RtnWay = 3; scaleDeal.BigReturnStock(scaleRtn); result.message = "成功"; result.success = true; } else { result.message = "重复退货"; result.success = false; } } else { result.message = "条码未出货"; result.success = false; } } else { result.code = 304; result.message = "条码不存在"; result.success = false; } PDALog.Write("大标退货", "大标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0},orderno:{1}", code, orderno), result.message); } catch (Exception ex) { result.code = 500; result.message = "服务出错"; result.success = false; DAL.Log.Instance.Write("大标退货出错:" + ex.Message, "PDA上传出错"); } return(result); }
public RequestResult SmallCode(string code, string orderno = "") { RequestResult result = new RequestResult(); try { Scale scale = Scale.GetScaleForSmall(code); if (scale != null) { if (scale.IsOut) // 是否已经关联 { scale.IsOut = false; scale.StateID = 9; scale.UpdateByID(); ScaleRtnStoke scaleRtn = new ScaleRtnStoke(); scaleRtn.SmallCode = scale.SmallCode; scaleRtn.OrderNo = orderno; scaleRtn.OperaUser = PdaUser.PUserName; scaleRtn.IsPDAOpera = true; scaleRtn.RtnWay = 1; scale.SmallReturnStock(scaleRtn); result.message = "成功"; result.success = true; } else if (scale.StateID == 9) { result.message = "重复退货"; result.success = false; } else { result.message = "条码未出货"; result.success = false; } } else { result.code = 304; result.message = "条码不存在"; result.success = false; } PDALog.Write("小标退货", "小标", code, PdaUser.PUserName + "-" + PdaUser.PRealName, string.Format("code:{0},orderno:{1}", code, orderno), result.message); } catch (Exception ex) { result.code = 500; result.message = "服务出错"; result.success = false; DAL.Log.Instance.Write("小标退货出错:" + ex.Message, "PDA上传出错"); } return(result); }
public RequestResult RtnStockDetail(int pageindex, int pagesize, string orderno, string productno, int timestamp, string consignee, string keyword = "") { RequestResult result = new RequestResult(); try { int totalCount = 0; List <ScaleCode_Simple> DetailList = ScaleRtnStoke.GetRtnStockDetail(MobileUser.UserName, orderno, productno, pagesize, pageindex, timestamp, consignee, keyword, out totalCount); result.data = DetailList; result.pages = pageindex; result.total = totalCount; result.message = "成功"; result.success = true; } catch (Exception ex) { result.message = "失败,error:" + ex.Message; result.success = false; } return(result); }
public RequestResult OrderNo(string orderno) { RequestResult result = new RequestResult(); try { bool IsOK = Scale.CheckOutOrderNo(orderno); if (IsOK) { Scale scaleDeal = new Scale(); ScaleRtnStoke scaleRtn = new ScaleRtnStoke(); scaleRtn.OrderNo = orderno; scaleRtn.OperaUser = PdaUser.PUserName; scaleRtn.IsPDAOpera = true; scaleDeal.OrderNoReturnStock(scaleRtn); result.message = "成功"; result.success = true; } else { result.message = "未检测到出货订单!"; result.success = false; } } catch (Exception ex) { result.code = 500; result.message = "服务出错"; result.success = false; DAL.Log.Instance.Write("查询出货订单出错:" + ex.Message, "PDA上传出错"); } return(result); }
public ActionResult TrackDetail(string SmallCode) { List <TrackCode> ListTrack = new List <TrackCode>(); Scale smallTrack = Scale.GetScaleSmallCode(SmallCode); List <ScaleOutStoke> smallOutTrackList = ScaleOutStoke.GetSmallCodeList(SmallCode); List <ScaleRtnStoke> smallRtnTrackList = ScaleRtnStoke.GetSmallCodeList(SmallCode); string ProductNo = ""; string ProductName = ""; if (!string.IsNullOrWhiteSpace(smallTrack.ProductNo)) { Product product = Product.GetProductNo(smallTrack.ProductNo); ProductNo = product.ProductNumber; ProductName = product.ProductName; } string PDAUserSet = ""; string AgentUser = ""; string BoxType = "中箱"; if (!PDAUserMsg.Param.MiddlePacking) { BoxType = "大箱"; } if (!string.IsNullOrWhiteSpace(smallTrack.IntoPDAUser)) { PDAUserSet += "'" + smallTrack.IntoPDAUser + "',"; } if (!string.IsNullOrWhiteSpace(smallTrack.LinkBigPDAUser)) { PDAUserSet += "'" + smallTrack.LinkBigPDAUser + "',"; } if (!string.IsNullOrWhiteSpace(smallTrack.LinkMidPDAUser)) { PDAUserSet += "'" + smallTrack.LinkMidPDAUser + "',"; } if (!string.IsNullOrWhiteSpace(smallTrack.OutPDAUser)) { PDAUserSet += "'" + smallTrack.OutPDAUser + "',"; } if (PDAUserSet != "") { PDAUserSet = PDAUserSet.Substring(0, PDAUserSet.Length - 1); } List <PDAUser> pdauser = new List <PDAUser>(); if (PDAUserSet != "") { pdauser = PDAUser.GetUserNameSet(PDAUserSet); } foreach (ScaleOutStoke outUser in smallOutTrackList) { AgentUser += "'" + (outUser.Shipper != "总部" ? outUser.Shipper : "") + "',"; AgentUser += "'" + outUser.Consignee + "',"; } foreach (ScaleRtnStoke rtnUser in smallRtnTrackList) { if (!string.IsNullOrWhiteSpace(rtnUser.Shipper) && rtnUser.Shipper != "总部") { AgentUser += "'" + rtnUser.Shipper + "',"; } if (!string.IsNullOrWhiteSpace(rtnUser.Consignee)) { AgentUser += "'" + rtnUser.Consignee + "',"; } } if (AgentUser != "") { AgentUser = AgentUser.Substring(0, AgentUser.Length - 1); } List <C_User> UserList = new List <C_User>(); if (AgentUser != "") { UserList = C_User.GetUserSet(AgentUser); } #region 关联记录 if (smallTrack.IsLinkMid) { TrackCode track = new TrackCode(); track.ITime = smallTrack.LinkMidTime; track.STitle = "小标装箱"; PDAUser PMUser = pdauser.Where(u => u.PUserName == smallTrack.LinkMidPDAUser).FirstOrDefault(); track.SContent = "操作员:" + smallTrack.LinkMidPDAUser + (PMUser != null ? "-" + PMUser.PRealName : "") + ",将产品码(" + smallTrack.SmallCode + ")装入" + BoxType + "(" + smallTrack.MiddleCode + ")"; if (PDAUserMsg.Param.IsLinkProduct) { track.SContent += ",关联产品为:" + ProductNo + "-" + ProductName; } ListTrack.Add(track); } if (smallTrack.IsLinkBig) { TrackCode track = new TrackCode(); track.ITime = smallTrack.LinkBigTime; track.STitle = "中标装箱"; PDAUser PBUser = pdauser.Where(u => u.PUserName == smallTrack.LinkBigPDAUser).FirstOrDefault(); track.SContent = "操作员:" + smallTrack.LinkBigPDAUser + (PBUser != null ? "-" + PBUser.PRealName : "") + ",将中箱码(" + smallTrack.MiddleCode + ")装入大箱(" + smallTrack.BigCode + ")"; if (PDAUserMsg.Param.IsLinkProduct) { track.SContent += ",关联产品为:" + ProductNo + "-" + ProductName; } ListTrack.Add(track); } #endregion #region 入库记录 if (smallTrack.IsInto) { TrackCode track = new TrackCode(); track.ITime = smallTrack.IntoTime; track.STitle = "产品入库"; PDAUser PIUser = pdauser.Where(u => u.PUserName == smallTrack.IntoPDAUser).FirstOrDefault(); string BarCode = smallTrack.IsLinkBig ? smallTrack.BigCode : smallTrack.IsLinkMid ? smallTrack.MiddleCode : smallTrack.SmallCode; string CodeType = "箱码"; if (BarCode == smallTrack.SmallCode) { CodeType = "产品码"; } track.SContent = "操作员:" + smallTrack.IntoPDAUser + (PIUser != null ? "-" + PIUser.PRealName : "") + ",将" + CodeType + "(" + BarCode + ")入库"; if (PDAUserMsg.Param.IsIntoProduct) { track.SContent += ",入库产品为:" + ProductNo + "-" + ProductName; } ListTrack.Add(track); } #endregion #region 所有出货记录(包含经销商) foreach (ScaleOutStoke outcode in smallOutTrackList) { TrackCode track = new TrackCode(); track.ITime = outcode.CreateTime; track.STitle = (outcode.Shipper == "总部" ? outcode.Shipper : "经销商") + "产品出货"; C_User OUser = UserList.Where(u => u.UserName == outcode.Consignee).FirstOrDefault(); C_User OUserShipper = UserList.Where(u => u.UserName == outcode.Shipper).FirstOrDefault(); track.SContent = outcode.Shipper + (OUserShipper != null ? "-" + OUserShipper.Name : "") + ">出货>" + outcode.Consignee + (OUser != null ? "-" + OUser.Name : "") + "<br>"; track.SContent += "出货单号:" + outcode.OutOrderNo; PDAUser POUser = pdauser.Where(u => u.PUserName == smallTrack.OutPDAUser).FirstOrDefault(); if (outcode.Shipper == "总部") { track.SContent += ",操作员:" + smallTrack.OutPDAUser + "-" + (POUser != null ? "-" + POUser.PRealName : ""); } if (PDAUserMsg.Param.IsOutProduct) { track.SContent += ",出货产品为:" + ProductNo + "-" + ProductName; } ListTrack.Add(track); } #endregion #region 退货记录 foreach (ScaleRtnStoke rtncode in smallRtnTrackList) { TrackCode track1 = new TrackCode(); track1.ITime = rtncode.OutTime; track1.STitle = (rtncode.Shipper == "总部" ? rtncode.Shipper : "经销商") + "产品出货"; C_User RUserShipper = UserList.Where(u => u.UserName == rtncode.Shipper).FirstOrDefault(); C_User RUserConsignee = UserList.Where(u => u.UserName == rtncode.Consignee).FirstOrDefault(); track1.SContent = rtncode.Shipper + (RUserShipper != null ? "-" + RUserShipper.Name : "") + ">出货>" + rtncode.Consignee + (RUserConsignee != null ? "-" + RUserConsignee.Name : "") + "<br>"; track1.SContent += "出货单号:" + rtncode.OutOrderNo; if (rtncode.Shipper == "总部") { track1.SContent += ",操作员:" + smallTrack.OutPDAUser + "-" + pdauser.Where(u => u.PUserName == smallTrack.OutPDAUser).FirstOrDefault().PRealName; } ListTrack.Add(track1); TrackCode track2 = new TrackCode(); track2.ITime = rtncode.ReturnTime; track2.STitle = "产品退货" + (rtncode.Shipper == "总部" ? rtncode.Shipper : "经销商"); track2.SContent = rtncode.Consignee + (RUserConsignee != null ? "-" + RUserConsignee.Name : "") + ">退货>" + rtncode.Shipper + (RUserShipper != null ? "-" + RUserShipper.Name : "") + "<br>"; track2.SContent += "退货单号 " + rtncode.OrderNo; ListTrack.Add(track2); } #endregion ViewData["BigCode"] = smallTrack.BigCode; ViewData["MiddleCode"] = smallTrack.MiddleCode; ViewData["SmallCode"] = smallTrack.SmallCode; ViewData["CodeTrack"] = ListTrack.OrderBy(m => m.ITime).ToList(); ViewData["ProductNo"] = ProductNo; ViewData["ProductName"] = ProductName; return(View()); }