/// <summary>
/// 物流箱信息
/// </summary>
/// <param name="billID"></param>
/// <param name="wareHouseType"></param>
/// <returns></returns>
public DataTable GetWuLiuXiangInfo(int billID, string wareHouseType)
{
#region
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("CTL_ID", Type.GetType("System.Int32"));
tblDatas.Columns.Add("CT_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("LC_CODE", Type.GetType("System.String"));
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billId=").Append(billID).Append("&");
loStr.Append("wareHouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetWuLiuXiangInfo);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 正常错误处理
JsonGetWuLiuXiangInfo bill = JsonConvert.DeserializeObject <JsonGetWuLiuXiangInfo>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(tblDatas);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(tblDatas);
}
#endregion
#region 赋值
foreach (JsonGetWuLiuXiangInfoResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
newRow["CTL_ID"] = System.Convert.ToInt32(tm.ctlId);
newRow["CT_CODE"] = tm.ctCode;
newRow["LC_CODE"] = tm.lcCode;
tblDatas.Rows.Add(newRow);
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
public void CancelOrder()
{
SOHeaderEntity header = IParent.GetFocusedBill();
if (header == null)
{
MsgBox.Warn("请选择要“取消”的订单。");
return;
}
//先从界面上判断一下，减少网络交互和数据库负载
if (header.Status == "693")
{
MsgBox.Warn(string.Format("单据“{0}”已发车，不允许取消。", header.BillNO));
return;
}
else if (header.CancelFlag == 1)
{
MsgBox.Warn(string.Format("单据“{0}”已经被“取消”，不允许多次执行。", header.BillNO));
return;
}
if (MsgBox.AskOK(string.Format("确认要将单据“{0}”执行“取消”操作吗？", header.BillNO)) != DialogResult.OK)
{
return;
}
try
{
FrmTempAuthorize frmAuthorize = new FrmTempAuthorize("称重复核员");
if (frmAuthorize.ShowDialog() == DialogResult.OK)
{
//string errorStr = soDal.CancelBill(header.BillID, GlobeSettings.LoginedUser.UserName);
//if (string.IsNullOrEmpty(errorStr))
bool errorStr = CancelBill(header.BillID, GlobeSettings.LoginedUser.UserName,
EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
if (errorStr)
{
//成功，刷新界面即可，不再提示
Query(1, DateTime.Now, DateTime.Now);
IParent.RefreshHeaderGrid();
// 如果为整货仓，提示用户；如果该订单物流箱已接收，系统已将商品库存转移到900货位
if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.整货仓)
{
MsgBox.OK("如果当前订单存在已接收的物流箱，系统会将散货商品转移到900-01-01货位。");
}
// 存储过程中已在 WM_SO_LOG 表里记录日志
//LogDal.Insert(ELogType.订单状态变更, GlobeSettings.LoginedUser.UserName, header.BillNO, "称重复核员：" + frmAuthorize.AuthUserCode, "出库单管理");
}
//else
//{
// throw new Exception(errorStr);
//}
}
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
}
/// <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;
}
/// <summary>
/// 盘点任务分派--保存任务分派
/// </summary>
/// <param name="userName"></param>
/// <param name="billID"></param>
/// <param name="userCode"></param>
/// <param name="locations"></param>
/// <returns></returns>
public bool SaveCountTask(string userName, int billID, string userCode, List <CountDetailEntity> locations)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("userName="******"&");
loStr.Append("billId=").Append(billID).Append("&");
loStr.Append("counts=").Append(locations.Count).Append("&");
loStr.Append("userCode=").Append(userCode).Append("&");
loStr.Append("wareHouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType)).Append("&");
List <string> prop = new List <string>()
{
"ID"
};
string jsonDetail = GetResList <CountDetailEntity>("jsonDetail", locations, prop);
loStr.Append("jsonDetail=").Append(jsonDetail);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveCountTask);
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);
}
/// <summary>
/// 存储排序记录
/// </summary>
/// <param name="billIDs"></param>
/// <param name="userName"></param>
/// <param name="errBillNO"></param>
/// <returns></returns>
public bool SaveSortOrders(string billIDs, string userName, out string errBillNO)
{
errBillNO = "";
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billIds=").Append(billIDs).Append("&");
loStr.Append("userName="******"&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType)).Append("&");
loStr.Append("uuid=").Append(Guid.NewGuid().ToString().Replace("-", ""));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveSortOrders);
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 bool UpdatePrintedFlag(int billID, string creator, string BillNO,int num)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billID=").Append(billID).Append("&");
loStr.Append("userName="******"&");
loStr.Append("billNo=").Append(BillNO).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType)).Append("&");
loStr.Append("printed=").Append(num);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_UpdatePrintedFlagLongMiao);
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;
}
/// <summary>
/// 考勤登记
/// </summary>
/// <param name="userID"></param>
/// <param name="onlineType"></param>
/// <returns>1:成功；-1：员工号不存在; -2:密码错误</returns>
public bool LoginRegister(string userID, string onlineType, string userPwd)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("userCode=").Append(userID).Append("&");
loStr.Append("onlineType=").Append(onlineType).Append("&");
loStr.Append("userPwd=").Append(userPwd).Append("&");
loStr.Append("wareHouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_LoginRegister);
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);
}
///<summary>
///查询所有计量单位组
///</summary>
///<returns></returns>
public List <UnitGroupEntity> GetAllZJQ(int nums, int begin, out int total)
{
List <UnitGroupEntity> list = new List <UnitGroupEntity>();
total = 0;
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
if (begin == 0)
{
loStr.Append("beginRow=").Append("&");
}
else
{
loStr.Append("beginRow=").Append(begin).Append("&");
}
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType)).Append("&");
if (begin == 0)
{
loStr.Append("rows=");
}
else
{
loStr.Append("rows=").Append(nums);
}
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetAllZJQ);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllZJQ bill = JsonConvert.DeserializeObject <JsonGetAllZJQ>(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 (JsonGetAllZJQResult jbr in bill.result)
{
UnitGroupEntity asnEntity = new UnitGroupEntity();
#region 0-10
asnEntity.Height = StringToDecimal.GetTwoDecimal(jbr.height);
asnEntity.ID = Convert.ToInt32(jbr.id);
asnEntity.IsActive = jbr.isActive;
asnEntity.Length = StringToDecimal.GetTwoDecimal(jbr.length);
asnEntity.Qty = Convert.ToInt32(jbr.qty);
asnEntity.SkuBarcode = jbr.skuBarcode;
asnEntity.SkuCode = jbr.skuCode;
asnEntity.SkuLevel = Convert.ToInt32(jbr.skuLevel);
asnEntity.SkuName = jbr.skuName;
asnEntity.Spec = jbr.spec;
#endregion
#region 11-15
asnEntity.UnitCode = jbr.umCode;
asnEntity.UnitName = jbr.umName;
asnEntity.Weight = StringToDecimal.GetTwoDecimal(jbr.weight);
asnEntity.Width = StringToDecimal.GetTwoDecimal(jbr.width);
if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.散货仓)
{
asnEntity.SkuLevel = Convert.ToInt32(jbr.skuLevel);
asnEntity.Skuvol = StringToDecimal.GetTwoDecimal(jbr.skuVol);
}//
#endregion
list.Add(asnEntity);
}
total = bill.total;
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message + ex.StackTrace);
}
return(list);
}
/// <summary>
/// 人员状态表
/// </summary>
/// <param name="warehouseCode"></param>
/// <returns></returns>
public DataTable ListUserState(string warehouseCode)
{
#region
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("USER_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("USER_NAME", Type.GetType("System.String"));
tblDatas.Columns.Add("IS_ONLINE", Type.GetType("System.String"));
tblDatas.Columns.Add("UPDATE_DATE", Type.GetType("System.String"));
tblDatas.Columns.Add("ROLES", Type.GetType("System.String"));
if (GlobeSettings.LoginedUser.WarehouseType != EWarehouseType.散货仓)
{
tblDatas.Columns.Add("ITEM_DESC", Type.GetType("System.String"));
}
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("whCode=").Append(warehouseCode).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_ListUserState);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 正常错误处理
JsonListUserState bill = JsonConvert.DeserializeObject <JsonListUserState>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(tblDatas);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(tblDatas);
}
#endregion
#region 赋值
foreach (JsonListUserStateResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
newRow["USER_CODE"] = tm.userCode;
newRow["USER_NAME"] = tm.userName;
newRow["IS_ONLINE"] = tm.isOnline;
newRow["UPDATE_DATE"] = tm.updateDate;
newRow["ROLES"] = tm.roles;
if (GlobeSettings.LoginedUser.WarehouseType != EWarehouseType.散货仓)
{
newRow["ITEM_DESC"] = tm.itemDesc;
}
tblDatas.Rows.Add(newRow);
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
/// <summary>
/// 获取系统设置
/// </summary>
/// <returns></returns>
public DataTable GetSysSetting()
{
#region
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("ID", Type.GetType("System.String"));
tblDatas.Columns.Add("SET_ITEM", Type.GetType("System.String"));
tblDatas.Columns.Add("SET_VALUE", Type.GetType("System.String"));
tblDatas.Columns.Add("SET_GROUP", Type.GetType("System.String"));
tblDatas.Columns.Add("REMARK", Type.GetType("System.String"));
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetSysSetting);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 正常错误处理
JsonGetSysSetting bill = JsonConvert.DeserializeObject <JsonGetSysSetting>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(tblDatas);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(tblDatas);
}
#endregion
#region 赋值
foreach (JsonGetSysSettingResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
newRow["ID"] = tm.id;
newRow["SET_ITEM"] = tm.setItem;
newRow["SET_VALUE"] = tm.setValue;
newRow["SET_GROUP"] = tm.setGroup;
newRow["REMARK"] = tm.remark;
tblDatas.Rows.Add(newRow);
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
/// <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);
}
/// <summary>
/// 打印装车单信息查询
/// </summary>
/// <param name="vhTrainNo"></param>
/// <returns></returns>
public List <OrderSortDetailPrintEntity> Query(string vhTrainNo)
{
List <OrderSortDetailPrintEntity> list = new List <OrderSortDetailPrintEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("vhTrainNo=").Append(vhTrainNo).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_Query);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonQuery bill = JsonConvert.DeserializeObject <JsonQuery>(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 (JsonQueryResult jbr in bill.result)
{
OrderSortDetailPrintEntity asnEntity = new OrderSortDetailPrintEntity();
asnEntity.BillID = Convert.ToInt32(jbr.billId);
asnEntity.BillNo = jbr.billNo;
asnEntity.BillRemark = jbr.wmsRemark;
asnEntity.CustomerAddress = jbr.address;
asnEntity.CustomerName = jbr.cName;
asnEntity.FullCount = Convert.ToInt32(jbr.fullCount);
asnEntity.OrderSort = Convert.ToInt32(jbr.inVhSort);
asnEntity.Warehouse = jbr.whName;
//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);
}
/// <summary>
/// 查询统计（库房人员绩效汇总）
/// </summary>
/// <param name="dateBegin"></param>
/// <param name="dateEnd"></param>
/// <returns></returns>
public DataTable SummaryByPersonnel(DateTime dateBegin, DateTime dateEnd)
{
#region DataTable
DataTable tblDatas = new DataTable("Datas");
#region 整散区分
if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.整货仓)
{
#region 0-10
tblDatas.Columns.Add("USER_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("人员姓名", Type.GetType("System.String"));
tblDatas.Columns.Add("所属", Type.GetType("System.String"));
tblDatas.Columns.Add("拣货单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("批市拣货量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("补货量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("移货次数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("上架件数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("上架托数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("收货单量", Type.GetType("System.Decimal"));
#endregion
#region 11-20
tblDatas.Columns.Add("收货件数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("退货单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("退货总数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送整货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送散货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("装车整货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("装车散货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("二批拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("批市拣货量(整)", Type.GetType("System.Decimal"));
#endregion
#region 21-30
tblDatas.Columns.Add("调拨拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("盘点货位数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("称重件数(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("称重次数", Type.GetType("System.Decimal"));
#endregion
}
else if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.混合仓)
{
#region 0-10
tblDatas.Columns.Add("USER_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("人员姓名", Type.GetType("System.String"));
tblDatas.Columns.Add("所属", Type.GetType("System.String"));
tblDatas.Columns.Add("拣货单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("拣货量(散)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("批市拣货量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("补货量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("移货次数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("上架件数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("上架托数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("收货单量", Type.GetType("System.Decimal"));
#endregion
#region 11-20
tblDatas.Columns.Add("收货件数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("退货单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("退货总数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送单量", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送整货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("配送散货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("装车整货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("装车散货", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("二批拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("二批拣货量(散)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("批市拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("批市拣货量(散)", Type.GetType("System.Decimal"));
#endregion
#region 21-30
tblDatas.Columns.Add("调拨拣货量(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("调拨拣货量(散)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("盘点货位数", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("称重件数(整)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("称重件数(散)", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("称重次数", Type.GetType("System.Decimal"));
#endregion
}
#endregion
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("beginDate=").Append(dateBegin).Append("&");
loStr.Append("endDate=").Append(dateEnd).Append("&");
loStr.Append("warehouseType=").Append(EUtilStroreType.WarehouseTypeToInt(GlobeSettings.LoginedUser.WarehouseType));
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SummaryByPersonnel, 20000);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 赋值
if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.整货仓)
{
#region 000 整货仓
#region 正常错误处理
JsonSummaryByPersonnel bill = JsonConvert.DeserializeObject <JsonSummaryByPersonnel>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(tblDatas);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(tblDatas);
}
#endregion
foreach (JsonSummaryByPersonnelResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
#region 0-10
newRow["人员姓名"] = tm.userName;
newRow["所属"] = tm.itemDesc;
newRow["拣货单量"] = Convert.ToDecimal(tm.abCount);
newRow["拣货量(整)"] = Convert.ToDecimal(tm.bQty);
newRow["批市拣货量"] = Convert.ToDecimal(tm.cQty);
newRow["补货量"] = Convert.ToDecimal(tm.dQty);
newRow["移货次数"] = Convert.ToDecimal(tm.eCnt);
newRow["上架件数"] = Convert.ToDecimal(tm.fQty);
newRow["上架托数"] = Convert.ToDecimal(tm.gQty);
newRow["收货单量"] = Convert.ToDecimal(tm.hbCount);
#endregion
#region 11-20
newRow["收货件数"] = Convert.ToDecimal(tm.hQty);
newRow["退货单量"] = Convert.ToDecimal(tm.ibCount);
newRow["退货总数"] = Convert.ToDecimal(tm.iQty);
newRow["配送单量"] = Convert.ToDecimal(tm.dispatchOne);
newRow["配送整货"] = Convert.ToDecimal(tm.dispatchWhole);
newRow["配送散货"] = Convert.ToDecimal(tm.dispatchSanhuo);
newRow["装车整货"] = Convert.ToDecimal(tm.loadingWhole);
newRow["装车散货"] = Convert.ToDecimal(tm.loadingSanhuo);
newRow["二批拣货量(整)"] = Convert.ToDecimal(tm.lQty);
newRow["批市拣货量(整)"] = Convert.ToDecimal(tm.mQty);
#endregion
#region 21-30
newRow["调拨拣货量(整)"] = Convert.ToDecimal(tm.nQty);
newRow["USER_CODE"] = tm.userCode;
newRow["盘点货位数"] = Convert.ToDecimal(tm.oQty);
newRow["称重件数(整)"] = Convert.ToDecimal(tm.pQty);
newRow["称重次数"] = Convert.ToDecimal(tm.qctQty);
#endregion
tblDatas.Rows.Add(newRow);
}
#endregion
}
else if (GlobeSettings.LoginedUser.WarehouseType == EWarehouseType.混合仓)
{
#region 000 混合仓
#region 正常错误处理
JsonSummaryByPersonnelSanhuo bill = JsonConvert.DeserializeObject <JsonSummaryByPersonnelSanhuo>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(tblDatas);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(tblDatas);
}
#endregion
foreach (JsonSummaryByPersonnelResultSanhuo tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
#region 0-10
newRow["人员姓名"] = tm.userName;
newRow["所属"] = tm.itemDesc;
newRow["拣货单量"] = Convert.ToDecimal(tm.abCount);
newRow["拣货量(整)"] = Convert.ToDecimal(tm.bQty);
newRow["拣货量(散)"] = Convert.ToDecimal(tm.cQty);
newRow["批市拣货量"] = Convert.ToDecimal(tm.dQty);
newRow["补货量"] = Convert.ToDecimal(tm.eCnt);
newRow["移货次数"] = Convert.ToDecimal(tm.fQty);
newRow["上架件数"] = Convert.ToDecimal(tm.gQty);
newRow["上架托数"] = Convert.ToDecimal(tm.hQty);
newRow["收货单量"] = Convert.ToDecimal(tm.ibCount);
#endregion
#region 11-20
newRow["收货件数"] = Convert.ToDecimal(tm.iQty);
newRow["退货单量"] = Convert.ToDecimal(tm.jbQty);
newRow["退货总数"] = Convert.ToDecimal(tm.jQty);
newRow["配送单量"] = Convert.ToDecimal(tm.dispatchOne);
newRow["配送整货"] = Convert.ToDecimal(tm.dispatchWhole);
newRow["配送散货"] = Convert.ToDecimal(tm.dispatchSanhuo);
newRow["装车整货"] = Convert.ToDecimal(tm.loadingWhole);
newRow["装车散货"] = Convert.ToDecimal(tm.loadingSanhuo);
newRow["二批拣货量(整)"] = Convert.ToDecimal(tm.erCiWhole);
newRow["二批拣货量(散)"] = Convert.ToDecimal(tm.erCiSanHuo);
newRow["批市拣货量(整)"] = Convert.ToDecimal(tm.oQty);
newRow["批市拣货量(散)"] = Convert.ToDecimal(tm.pQty);
#endregion
#region 21-30
newRow["调拨拣货量(整)"] = Convert.ToDecimal(tm.qctQty);
newRow["调拨拣货量(散)"] = Convert.ToDecimal(tm.rQty);
newRow["USER_CODE"] = tm.userCode;
newRow["盘点货位数"] = Convert.ToDecimal(tm.sQty);
newRow["称重件数(整)"] = Convert.ToDecimal(tm.tQty);
newRow["称重件数(散)"] = Convert.ToDecimal(tm.vQty);
newRow["称重次数"] = Convert.ToDecimal(tm.wQty);
#endregion
tblDatas.Rows.Add(newRow);
}
#endregion
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
