/// <summary>
/// 查询统计（叉车司机任务统计－查询移货记录）
/// </summary>
/// <param name="dateBegin"></param>
/// <param name="dateEnd"></param>
/// <param name="userCode"></param>
/// <returns></returns>
public DataTable QueryTransRecords(DateTime dateBegin, DateTime dateEnd, string userCode)
{
#region DataTable
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("FROM_LC_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("TO_LC_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("UM_QTY", Type.GetType("System.Decimal"));
tblDatas.Columns.Add("UM_NAME", Type.GetType("System.String"));
tblDatas.Columns.Add("CREATE_DATE", Type.GetType("System.DateTime"));
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
#region 参数
loStr.Append("userCode=").Append(userCode).Append("&");
loStr.Append("beginDate=").Append(dateBegin).Append("&");
loStr.Append("endDate=").Append(dateEnd);
#endregion
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_QueryTransRecordsChaChe);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 正常错误处理
JsonQueryTransRecords bill = JsonConvert.DeserializeObject <JsonQueryTransRecords>(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 (JsonQueryTransRecordsResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
newRow["FROM_LC_CODE"] = tm.fromLcCode;
newRow["TO_LC_CODE"] = tm.toLcCode;
newRow["UM_QTY"] = Convert.ToDecimal(tm.umQty);
newRow["UM_NAME"] = tm.umName;
newRow["CREATE_DATE"] = Convert.ToDateTime(tm.createDate);
tblDatas.Rows.Add(newRow);
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
/// <summary>
/// 移库记录表--查询移库记录
/// </summary>
/// <param name="dateFrom"></param>
/// <param name="dateTo"></param>
/// <param name="skuName"></param>
/// <param name="location"></param>
/// <returns></returns>
public DataTable QueryTransRecords(DateTime dateFrom, DateTime dateTo, string skuName, string location)
{
#region
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("FROM_LC_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("TO_LC_CODE", Type.GetType("System.String"));
tblDatas.Columns.Add("SKU_NAME", Type.GetType("System.String"));
tblDatas.Columns.Add("QTY_TRANS", Type.GetType("System.String"));
tblDatas.Columns.Add("ITEM_DESC", Type.GetType("System.String"));
tblDatas.Columns.Add("CREATE_DATE", Type.GetType("System.String"));
tblDatas.Columns.Add("USER_NAME", Type.GetType("System.String"));
tblDatas.Columns.Add("AUTH_USER_NAME", Type.GetType("System.String"));
#endregion
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("dateFrom=").Append(dateFrom).Append("&");
loStr.Append("dateTo=").Append(dateTo).Append("&");
loStr.Append("skuName=").Append(skuName).Append("&");
loStr.Append("location=").Append(location);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_QueryTransRecords);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(tblDatas);
}
#endregion
#region 正常错误处理
JsonQueryTransRecords bill = JsonConvert.DeserializeObject <JsonQueryTransRecords>(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 (JsonQueryTransRecordsResult tm in bill.result)
{
DataRow newRow;
newRow = tblDatas.NewRow();
newRow["FROM_LC_CODE"] = tm.fromLcCode;
newRow["TO_LC_CODE"] = tm.toLcCode;
newRow["SKU_NAME"] = tm.skuName;
newRow["QTY_TRANS"] = tm.qtyTrans;
newRow["ITEM_DESC"] = tm.itemDEsc;
newRow["CREATE_DATE"] = tm.createDate;
newRow["USER_NAME"] = tm.userName;
newRow["AUTH_USER_NAME"] = tm.authUserName;
tblDatas.Rows.Add(newRow);
}
return(tblDatas);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(tblDatas);
}
