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