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