public LogOperationToDb(WMS_Log_Operation operation) : base(s_metadata) { SetSqlInt64(0, operation.ID); SetSqlInt32(1, operation.ProjectID); SetSqlString(2, operation.ProjectName); SetSqlInt32(3, operation.CustomerID); SetSqlString(4, operation.CustomerName); SetSqlInt32(5, operation.WarehouseID); SetSqlString(6, operation.WarehouseName); SetSqlString(7, operation.MenuName); SetSqlString(8, operation.Operation); SetSqlString(9, operation.OrderType); SetSqlString(10, operation.ExternOrderNumber); SetSqlString(11, operation.OrderNumber); SetSqlString(12, operation.Controller); SetSqlString(13, operation.Remark); SetSqlString(14, operation.Creator); SetSqlDateTime(15, operation.CreateTime); SetSqlString(16, operation.Str1); SetSqlString(17, operation.Str2); SetSqlString(18, operation.Str3); SetSqlString(19, operation.Str4); SetSqlString(20, operation.Str5); SetSqlInt32(21, operation.Int1); SetSqlInt32(22, operation.Int2); SetSqlInt32(23, operation.Int3); SetSqlString(24, operation.OrderID); }
/// <summary> /// 拣货完成同步redis中数据到数据库,同时删除redis /// </summary> /// <param name="OrderNumber"></param> /// <returns></returns> public string SaveRecDataFromRedis(string OrderNumber) { List <OrderDetailForRedisRF> redisList = new List <OrderDetailForRedisRF>(); List <WMS_Log_Operation> logs = new List <WMS_Log_Operation>(); string msg = ""; try { if (RCommon.RedisOperation.Exists(OrderNumber)) { redisList = RCommon.RedisOperation.GetList <List <OrderDetailForRedisRF> >(OrderNumber); var response = new OrderManagementService().InsertPick(redisList, Session["Name"].ToString()); if (response) { WMS_Log_Operation operation = new WMS_Log_Operation(); operation.MenuName = "出库单管理"; operation.Operation = "出库单-" + "拣货"; operation.OrderType = "Order"; operation.Controller = Request.RawUrl; operation.Creator = Session["Name"].ToString(); operation.CreateTime = DateTime.Now; operation.ProjectID = Convert.ToInt32(Session["ProjectID"]); operation.ProjectName = Session["ProjectName"].ToString(); operation.OrderNumber = OrderNumber; operation.ExternOrderNumber = RCommon.RedisOperation.GetList <List <OrderDetailForRedisRF> >(OrderNumber).Select(c => c.ExternOrderNumber).FirstOrDefault().ToString(); operation.OrderID = RCommon.RedisOperation.GetList <List <OrderDetailForRedisRF> >(OrderNumber).Select(c => c.OID).FirstOrDefault().ToString(); operation.WarehouseName = Session["WareHouseName"].ToString(); operation.WarehouseID = Convert.ToInt32(Session["WareHouseIDs"]); operation.CustomerID = Convert.ToInt32(Session["CustomerID"]); logs.Add(operation); new LogOperationService().AddLogOperation(logs); RCommon.RedisOperation.Del(OrderNumber); msg = "1"; } } } catch (Exception ex) { msg = "0"; } return(msg); }
/// <summary> /// 点击完成同步redis中数据到拣货表 /// </summary> /// <param name="OrderNumber"></param> /// <returns></returns> public string InsertIntoPickFromRedis(string OrderNumber, string ID) { List <OrderDetailForRedisRF> picklistredis = new List <OrderDetailForRedisRF>(); List <WMS_Log_Operation> logs = new List <WMS_Log_Operation>(); try { if (RCommon.RedisOperation.Exists(OrderNumber)) { picklistredis = RCommon.RedisOperation.GetList <List <OrderDetailForRedisRF> >(OrderNumber); } else { return("2"); } var response = new OrderManagementService().InsertPick(picklistredis, Session["Name"].ToString()); if (response) { WMS_Log_Operation operation = new WMS_Log_Operation(); operation.MenuName = "出库单管理"; operation.Operation = "出库单-" + "拣货"; operation.OrderType = "Order"; operation.Controller = Request.RawUrl; operation.Creator = Session["Name"].ToString(); operation.CreateTime = DateTime.Now; operation.ProjectID = Convert.ToInt32(Session["ProjectID"]); operation.ProjectName = Session["ProjectName"].ToString(); operation.OrderID = ID; logs.Add(operation); new LogOperationService().AddLogOperation(logs); RCommon.RedisOperation.Del(OrderNumber); return("1"); } } catch (Exception ex) { return("0"); } return("0"); }
/// <summary> /// 保存快递包装数据 /// </summary> /// <param name="uu"></param> /// <returns></returns> public string SaveExpressPackage(long CustomerID, string WarehouseName, long OrderID, string ExpressNumber, string PackageType) { DataSet dt = new DataSet(); OrderManagementService o = new OrderManagementService(); dt = o.SaveExpressPackage(ExpressNumber, PackageType, CustomerID, WarehouseName); #region 操作日志 List <WMS_Log_Operation> logs = new List <WMS_Log_Operation>(); WMS_Log_Operation operation = new WMS_Log_Operation(); operation.MenuName = "快递包装管理"; operation.Operation = "快递包装-保存"; operation.OrderType = "ExpressPackage"; operation.Controller = Request.RawUrl; operation.Creator = Session["Name"].ToString(); operation.CreateTime = DateTime.Now; operation.ProjectID = Convert.ToInt32(Session["ProjectID"]); operation.ProjectName = Session["ProjectName"].ToString(); operation.OrderID = OrderID.ToString(); logs.Add(operation); new LogOperationService().AddLogOperation(logs); #endregion return(DataTableToJsonWithJsonNet(dt.Tables[0])); }
public string SaveRecDataFromRedisSecond(string OrderNumber) { List <OrderDetailForRedisRF> redisList = new List <OrderDetailForRedisRF>(); List <WMS_Log_Operation> logs = new List <WMS_Log_Operation>(); IList <PackageInfo> packages = new List <PackageInfo>(); IList <PackageDetailInfo> packageDetails = new List <PackageDetailInfo>(); AddPackageAndDetailRequest request = new AddPackageAndDetailRequest(); string msg = ""; try { var BoxSizeData = ApplicationConfigHelper.GetWMS_Config("BoxSize").Where(c => c.Str5 == "NIKEB2C"); if (RCommon.RedisOperation.Exists("Check:" + OrderNumber)) { redisList = RCommon.RedisOperation.GetList <List <OrderDetailForRedisRF> >("Check:" + OrderNumber); DateTime d = DateTime.Now; packages.Add(new PackageInfo() { Creator = Session["Name"].ToString(), CreateTime = d, Updator = Session["Name"].ToString(), UpdateTime = d, OrderNumber = OrderNumber, PackageType = redisList.Select(c => c.BoxNum).FirstOrDefault(), PackageNumber = redisList.Select(c => c.ExpressNumber).FirstOrDefault(), Length = BoxSizeData.Where(c => c.Code == redisList.Select(a => a.BoxNum).FirstOrDefault()).Select(a => a.Str1).FirstOrDefault(), Width = BoxSizeData.Where(c => c.Code == redisList.Select(a => a.BoxNum).FirstOrDefault()).Select(a => a.Str2).FirstOrDefault(), Height = BoxSizeData.Where(c => c.Code == redisList.Select(a => a.BoxNum).FirstOrDefault()).Select(a => a.Str3).FirstOrDefault(), NetWeight = "0", GrossWeight = "0", PackageTime = d, OID = redisList.Select(c => c.OID).FirstOrDefault() }); foreach (var item in redisList) { packageDetails.Add(new PackageDetailInfo() { Creator = Session["Name"].ToString(), CreateTime = d, Updator = Session["Name"].ToString(), UpdateTime = d, PackageNumber = item.ExpressNumber, SKU = item.SKU, UPC = item.UPC, GoodsName = item.GoodsName, GoodsType = "A品", Qty = item.QtyPicked }); } request.packages = packages; request.packageDetails = packageDetails; bool resualt = new OrderManagementService().UpdateOrderStatusByOrderNumber(OrderNumber, Session["Name"].ToString(), request, Session["CustomerID"].ToString()); if (resualt) { WMS_Log_Operation operation = new WMS_Log_Operation(); operation.MenuName = "出库单管理"; operation.Operation = "出库单-" + "复检包装"; operation.OrderType = "Order"; operation.Controller = Request.RawUrl; operation.Creator = Session["Name"].ToString(); operation.CreateTime = DateTime.Now; operation.ProjectID = Convert.ToInt32(Session["ProjectID"]); operation.ProjectName = Session["ProjectName"].ToString(); operation.OrderID = redisList.Select(c => c.OID).FirstOrDefault().ToString(); logs.Add(operation); new LogOperationService().AddLogOperation(logs); RCommon.RedisOperation.Del("Check:" + OrderNumber); msg = "1"; } } } catch (Exception ex) { msg = "0"; } return(msg); }