/// <summary>
/// 查询托盘状态
/// </summary>
/// <param name="billNO"></param>
/// <param name="containerCode"></param>
/// <param name="containerState"></param>
/// <returns></returns>
public List <TrayStatusTableEntity> ListContainerState(string billNO, string containerCode, string containerState, string warehouse)
{
string sql = String.Format("SELECT C.CT_CODE, S.CT_STATE, ST.ITEM_DESC STATE_DESC, S.UNIQUE_CODE, S.BILL_HEAD_ID, "
+ " wah.BILL_NO AS 'IN_BILL', wsh.BILL_NO AS 'OUT_BILL', "
+ " CIN.C_NAME AS 'IN_CNAME', COUT.C_NAME AS 'OUT_CNAME' "
+ " FROM WM_CONTAINER C "
+ " LEFT JOIN WM_CONTAINER_STATE S ON S.CT_CODE = C.CT_CODE "
+ " LEFT JOIN WM_BASE_CODE ST ON ST.ITEM_VALUE = S.CT_STATE "
+ " LEFT JOIN wm_asn_header wah ON S.BILL_HEAD_ID = wah.BILL_ID "
+ " LEFT JOIN wm_so_header wsh ON wsh.BILL_ID = S.BILL_HEAD_ID "
+ " LEFT JOIN CUSTOMERS CIN ON CIN.C_CODE = wah.S_CODE "
+ " LEFT JOIN CUSTOMERS COUT ON COUT.C_CODE = wsh.C_CODE "
+ " WHERE C.CT_TYPE = '50' AND C.WH_CODE='{0}' ORDER BY IN_BILL DESC, OUT_BILL DESC", warehouse);
TrayStatusTableEntity tste = new TrayStatusTableEntity();
IMapper map = DatabaseInstance.Instance();
List <TrayStatusTableEntity> list = map.Query <TrayStatusTableEntity>(sql);
return(list);
//return map.LoadTable(sql);
//if (!string.IsNullOrEmpty(containerState))
// sql = string.Format(sql + " AND ({0})", DBUtil.FormatParameter("S.CARD_STATE", containerState));
//return map.LoadTable(sql, new { BillID = containerCode, BillNO = billNO, CardNO = containerState });
}
/// <summary>
/// 托盘状态列表，初始化加载托盘数据列表
/// </summary>
/// <param name="billNO"></param>
/// <param name="containerCode"></param>
/// <param name="containerState"></param>
/// <param name="warehouse"></param>
/// <returns></returns>
public List <TrayStatusTableEntity> ListContainerState(string billNO, string containerCode, string containerState, string warehouse)
{
List <TrayStatusTableEntity> list = new List <TrayStatusTableEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("whCode=").Append(warehouse);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_ListContainerState);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonContainerState bill = JsonConvert.DeserializeObject <JsonContainerState>(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 (JsonContainerStateResult jbr in bill.result)
{
TrayStatusTableEntity tste = new TrayStatusTableEntity();
tste.IN_BILL = jbr.inBill;
tste.IN_CNAME = jbr.inCname;
tste.IN_UCODE = jbr.UNIQUE_CODE;
tste.OUT_BILL = jbr.outBill;
tste.OUT_CNAME = jbr.outCname;
tste.OUT_UCODE = jbr.UNIQUE_CODE;
tste.STATE_DESC = jbr.stateDesc;
tste.CT_CODE = jbr.ctCode;
list.Add(tste);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
