public static List <ContainerEntity> GetContainerListByBillID(int billID, EWarehouseType wType)
{
string sql = string.Empty;
if (wType == EWarehouseType.整货仓)
{
sql = string.Format(
"SELECT DISTINCT R.CT_CODE, C.CT_NAME, C.CT_TYPE, BC.ITEM_DESC CT_TYPE_DESC, C.CT_WEIGHT, " +
"R.BILL_HEAD_ID, C.IS_DELETED " +
"FROM WM_CONTAINER_RECORD R " +
"LEFT JOIN WM_CONTAINER C ON C.CT_CODE = R.CT_CODE " +
"LEFT JOIN WM_BASE_CODE BC ON BC.ITEM_VALUE = C.CT_TYPE " +
"WHERE R.BILL_HEAD_ID = {0} AND IFNULL(C.IS_DELETED, 0) <> 1", billID);
}
else
{
sql = string.Format(
"SELECT DISTINCT R.CT_CODE, C.CT_NAME, C.CT_TYPE, BC.ITEM_DESC CT_TYPE_DESC, C.CT_WEIGHT, " +
"R.BILL_ID, C.IS_DELETED " +
"FROM WM_SO_PICK_RECORD R " +
"LEFT JOIN WM_SO_PICK P ON P.ID = R.PICK_ID " +
"LEFT JOIN WM_SO_DETAIL D ON D.ID = P.DETAIL_ID AND D.IS_CASE = 2 " +
"INNER JOIN WM_CONTAINER C ON C.CT_CODE = R.CT_CODE AND C.CT_TYPE = '51' " +
"LEFT JOIN WM_BASE_CODE BC ON BC.ITEM_VALUE = C.CT_TYPE " +
"WHERE R.BILL_ID = {0} AND IFNULL(C.IS_DELETED, 0) <> 1", billID);
}
IMapper map = DatabaseInstance.Instance();
return(map.Query <ContainerEntity>(sql));
}
/// <summary>
/// 打印销售发货单－生成车次信息
/// </summary>
/// <param name="whCode"></param>
/// <param name="creator"></param>
/// <param name="vhNo"></param>
/// <param name="vehicleName"></param>
/// <param name="userPhone"></param>
/// <param name="list"></param>
/// <param name="listUsers"></param>
/// <param name="warehouseType"></param>
/// <param name="loadingNo"></param>
/// <returns></returns>
public bool CreateTrain(string whCode, string creator, string vhNo, string vehicleName,
string userPhone, List<SOHeaderEntity> list, List<UserEntity> listUsers,
EWarehouseType warehouseType, string loadingNo)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("whCode=").Append(whCode).Append("&");
loStr.Append("creator=").Append(creator).Append("&");
loStr.Append("vehicleNo=").Append(vhNo).Append("&");
loStr.Append("vehicleName=").Append(vehicleName).Append("&");
loStr.Append("vehiclePhone=").Append(userPhone).Append("&");
loStr.Append("loadingNo=").Append(loadingNo).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(warehouseType)).Append("&");
#region list 转 json
List<string> prop = new List<string>() { "BillNO", "OriginalBillNo", "BillID", "BillType" };
string soHeaderEntity = GetRes<SOHeaderEntity>(list, prop);
loStr.Append("soHeaderEntity=").Append(soHeaderEntity).Append("&");
List<string> prop1 = new List<string>() { "UserName", "UserCode", "ROLE_ID" };
string userStr = GetRes<UserEntity>(listUsers, prop1);
loStr.Append("listUsers=").Append(userStr);
#endregion
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_CreateTrain);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return false;
}
#endregion
#region 正常错误处理
Sucess bill = JsonConvert.DeserializeObject<Sucess>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return false;
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return false;
}
#endregion
return true;
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return false;
}
public Warehouse(string locality, int quantity, EWarehouseType type)
{
Locality = locality;
Quantity = quantity;
Type = type;
}
/// <summary>
/// 当前订单量－当前订单量 未排序订单，传60,,已排序订单，不传
/// </summary>
/// <param name="wType"></param>
/// <param name="billState"></param>
/// <returns></returns>
public List <BillSKUNum> GetBillPlans(EWarehouseType wType, string billState)
{
List <BillSKUNum> list = new List <BillSKUNum>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("wType=").Append(EUtilStroreType.WarehouseTypeToInt(wType)).Append("&");
loStr.Append("billState=").Append(billState);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetBillPlans, 300000);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetBillPlans bill = JsonConvert.DeserializeObject <JsonGetBillPlans>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值
BillSKUNum sku = null;
foreach (JsonGetBillPlansResult tm in bill.result)
{
sku = new BillSKUNum();
sku.SKUCode = tm.skuCode;
sku.SKUName = tm.skuName;
sku.Spec = tm.spec;
sku.UmCode = tm.umCode;
sku.UmName = tm.umName;
sku.Qty = Convert.ToDecimal(tm.qty);
sku.BillQty = Convert.ToDecimal(tm.billQty);
sku.TotalQty = StringToDecimal.GetTwoDecimal(tm.totalQty);
sku.StockTotalQty = StringToDecimal.GetTwoDecimal(tm.stockTotalQty);
sku.BackupQty = StringToDecimal.GetTwoDecimal(tm.backupQty);
sku.IsCase = Convert.ToInt32(tm.isCase);
sku.Flag = Convert.ToInt32(tm.flag);
sku.AdviceQty = tm.qtyAdviceQty;
sku.AdviceUmName = tm.adviceUmName;
list.Add(sku);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
/// <summary>
/// 拣货计划 ： 保存拣配结果
/// </summary>
/// <param name="data"></param>
/// <param name="userName"></param>
/// <param name="whType"></param>
/// <returns></returns>
public string SavePickPlan(List <PickPlanEntity> data, string userName, EWarehouseType whType)
{
#region //取出不重复的单据编号
var billids = (from d in data select d).Distinct();
List <PickPlanEntity> list = new List <PickPlanEntity>();
foreach (PickPlanEntity tm in data)
{
bool flag = false;
foreach (PickPlanEntity temp in list)
{
if (tm.BillID == temp.BillID)
{
flag = true;
break;
}
}
if (!flag)
{
list.Add(tm);
}
}
#endregion
List <PickPlanEntity> listDetails = new List <PickPlanEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("WarehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(whType)).Append("&");
loStr.Append("UserName="******"&");
#region list 转 json
List <string> prop = new List <string>()
{
"BillID", "BillNO"
};
string pickPlanEntity = GetResList <PickPlanEntity>("billids", list, prop);
//loStr.Append("billids=").Append(pickPlanEntity).Append("&");
#region //组装details数据
/*string jsons = string.Empty;
* foreach (PickPlanEntity ID in list)
* {
*
* var details = from d in data where d.BillID == ID.BillID && d.STOCK_ID != 0 select d;
*
* foreach (PickPlanEntity detail in details)
* {
* listDetails.Add(detail);
* }
* List<string> prop1 = new List<string>() { "BillID", "DetailID", "STOCK_ID", "Qty", "IsCase", "BillNO", "MaterialName" };
* jsons = GetResList<PickPlanEntity>(listDetails, prop1);
* jsons = jsons.Insert(0, "{\"Group\":[");
* jsons = jsons.Insert(jsons.Length, "]}");
* jsons += ",";
* }
* jsons = jsons.Substring(0, jsons.Length - 1);
*
* jsons = jsons.Insert(0, "{\"details\":[");
* jsons = jsons.Insert(jsons.Length, "]}");*/
#endregion
List <string> prop1 = new List <string>()
{
"BillID", "DetailID", "STOCK_ID", "Qty", "IsCase", "BillNO", "Material"
};
string pickPlanEntity1 = GetResList <PickPlanEntity>("details", data, prop1);
pickPlanEntity1 = pickPlanEntity1.Replace("Material", "MaterialName");
string jsons = "{" + pickPlanEntity + "," + pickPlanEntity1 + "}";
loStr.Append("pickJson=").Append(jsons);
#endregion
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SavePickPlan);
if (string.IsNullOrEmpty(jsonQuery))
{
//MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(WebWork.RESULT_NULL);
}
#endregion
#region 正常错误处理
JosnSavePickPlan bill = JsonConvert.DeserializeObject <JosnSavePickPlan>(jsonQuery);
if (bill == null)
{
// MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(WebWork.JSON_DATA_NULL);
}
if (bill.flag != 0)
{
//MsgBox.Warn(bill.error);
return(bill.error);
}
#endregion
if (bill.result != null && bill.result.Length > 0)
{
return(bill.result[0].result);
}
}
catch (Exception ex)
{
//MsgBox.Err(ex.Message);
return(ex.Message);
}
return(null);
}
/// <summary>
/// 车次信息-打印装车单-获取所有有关联的托盘
/// </summary>
/// <param name="billID"></param>
/// <param name="wType"></param>
/// <returns></returns>
public List <ContainerEntity> GetContainerListByBillID(int billID, EWarehouseType wType)
{
List <ContainerEntity> list = new List <ContainerEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billId=").Append(billID).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(wType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetContainerListByBillID);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetContainerListByBillID bill = JsonConvert.DeserializeObject <JsonGetContainerListByBillID>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonGetContainerListByBillIDResult jbr in bill.result)
{
ContainerEntity asnEntity = new ContainerEntity();
asnEntity.BillHeadID = Convert.ToInt32(jbr.billHeadId);
asnEntity.ContainerCode = jbr.ctCode;
asnEntity.ContainerName = jbr.ctName;
asnEntity.ContainerType = jbr.ctType;
asnEntity.ContainerTypeDesc = jbr.ctTypeDesc;
asnEntity.ContainerWeight = Convert.ToDecimal(jbr.ctWeight);
asnEntity.IsDelete = Convert.ToInt32(jbr.isDeleted);
//try
//{
// if (!string.IsNullOrEmpty(jbr.closeDate))
// asnEntity.CloseDate = Convert.ToDateTime(jbr.closeDate);
// if (!string.IsNullOrEmpty(jbr.printedTime))
// asnEntity.PrintedTime = Convert.ToDateTime(jbr.printedTime);
// if (!string.IsNullOrEmpty(jbr.createDate))
// asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
//}
//catch (Exception msg)
//{
// LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
//}
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
