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);
}
