/// <summary>
/// 导入包装信息
/// </summary>
/// <param name="packageinfo"></param>
/// <param name="Proc">调用不同存储过程</param>
/// <returns></returns>
public Response <string> ImportPackageInfo(AddPackageAndDetailRequest Requset, string Proc)
{
Response <string> response = new Response <string>();
string error = string.Empty;
try
{
error = new ASNManagementAccessor().ImportPackageInfo(Requset, Proc);
if (error == "1")
{
response.IsSuccess = true;
}
else
{
response.IsSuccess = false;
response.SuccessMessage = error;
}
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.SuccessMessage = ex.Message;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public string UpdatePackageExpress(long ID, string JsonPackage)
{
var responseJsonFieldsets = jsonlist <PackageInfo>(JsonPackage);
AddPackageAndDetailRequest request = new AddPackageAndDetailRequest();
DateTime d = DateTime.Now;
IList <PackageInfo> packages = new List <PackageInfo>();
IList <PackageDetailInfo> packageDetails = new List <PackageDetailInfo>();
responseJsonFieldsets.Each((i, package) =>
{
packages.Add(new PackageInfo()
{
Creator = Session["Name"].ToString(),
CreateTime = d,
Updator = Session["Name"].ToString(),
UpdateTime = d,
PackageNumber = package.PackageNumber,
ExpressNumber = package.ExpressNumber,
OID = ID
});
});
request.packages = packages;
if (new OrderManagementService().UpdatePackage(ID, request))
{
return("");
}
else
{
return("1");
}
}
public Response <string> AddPackageAndDetail(long ID, AddPackageAndDetailRequest request, int flag)
{
Response <string> response = new Response <string>();
string message = "";
try
{
message = new OrderManagementAccessor().AddPackageAndDetail(ID, request, flag);
if (message == "")
{
response.Result = message;
response.IsSuccess = true;
}
else
{
response.Result = message;
response.IsSuccess = false;
}
return(response);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Result = message + ex.Message;
}
return(response);
}
public string Package(long ID, string JsonPackage, int flag)
{
var responseJsonFieldsets = jsonlist <PackageDetailInfo>(JsonPackage);
DateTime d = DateTime.Now;
AddPackageAndDetailRequest request = new AddPackageAndDetailRequest();
IList <PackageInfo> packages = new List <PackageInfo>();
IList <PackageDetailInfo> packageDetails = new List <PackageDetailInfo>();
responseJsonFieldsets.Each((i, package) =>
{
packages.Add(new PackageInfo()
{
Creator = Session["Name"].ToString(),
CreateTime = d,
Updator = Session["Name"].ToString(),
UpdateTime = d,
PackageNumber = package.PackageNumber,
PackageType = package.PackageType,
ExpressNumber = package.ExpressNumber,
Length = package.Length,
Width = package.Width,
Height = package.Height,
NetWeight = package.NetWeight,
GrossWeight = package.GrossWeight,
PackageTime = d,
OID = ID
});
packageDetails.Add(new PackageDetailInfo()
{
Creator = Session["Name"].ToString(),
CreateTime = d,
Updator = Session["Name"].ToString(),
UpdateTime = d,
PackageNumber = package.PackageNumber,
SKU = package.SKU,
UPC = package.UPC,
GoodsName = package.GoodsName,
GoodsType = package.GoodsType,
Qty = package.Qty
});
});
request.packages = packages;
request.packageDetails = packageDetails;
var response = new OrderManagementService().AddPackageAndDetail(ID, request, flag);
return(response.Result);
}
public bool UpdatePackage(long ID, AddPackageAndDetailRequest request)
{
bool resualt = false;
try
{
string sql = "";
List <PackageInfo> Packagelist = request.packages.ToList();
for (int i = 0; i < Packagelist.Count; i++)
{
sql += "Update WMS_Package set ExpressNumber ='" + Packagelist[i].ExpressNumber + "' where PackageNumber='" + Packagelist[i].PackageNumber + "' and OID=" + Packagelist[i].OID + ";";
}
resualt = new OrderManagementAccessor().UpdatePackage(sql);
}
catch (Exception ex)
{
LogError(ex);
resualt = false;
}
return(resualt);
}
public string AddPackageAndDetail(long ID, AddPackageAndDetailRequest request, int flag)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
string message = "";
try
{
SqlCommand cmd = new SqlCommand("Proc_WMS_AddPackageANDDetail", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
cmd.Parameters[0].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@Package", request.packages.Select(p => new WMSPackageToDb(p)));
cmd.Parameters[1].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@PackageDetail", request.packageDetails.Select(p => new WMSPackageDetailToDb(p)));
cmd.Parameters[2].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@flag", flag);
cmd.Parameters[3].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@message", message);
cmd.Parameters[4].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[4].Direction = ParameterDirection.Output;
cmd.Parameters[4].Size = 500;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
message = sda.SelectCommand.Parameters["@message"].Value.ToString();
conn.Close();
return(message);
}
catch (Exception ex)
{
return(message + "(" + ex.Message + ")");
}
}
}
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);
}
public bool UpdateOrderStatusByOrderNumber(string OrderNumber, string Picker, AddPackageAndDetailRequest request, string CustomerID)
{
try
{
OrderManagementAccessor accessor = new OrderManagementAccessor();
return(accessor.UpdateOrderStatusByOrderNumber(OrderNumber, Picker, request, CustomerID));
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateOrderStatusByOrderNumber(string OrderNumber, string Picker, AddPackageAndDetailRequest request, string CustomerID)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
SqlCommand cmd = new SqlCommand("[Proc_WMS_RF_UpdateOrderStatusByOrderNumber]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderNumber", OrderNumber);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.AddWithValue("@Picker", Picker);
cmd.Parameters[1].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.AddWithValue("@Package", request.packages.Select(p => new WMSPackageToDb(p)));
cmd.Parameters[2].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@PackageDetail", request.packageDetails.Select(p => new WMSPackageDetailToDb(p)));
cmd.Parameters[3].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@CustomerID", CustomerID);
cmd.Parameters[4].SqlDbType = SqlDbType.NVarChar;
conn.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
return(false);
}
}
