using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WMS.IData;
using WMS.IData.ISC;
using WMS.Model.SC;

namespace WMS.SqlServerData.SCData
{
    public class CUX_WMS_ISSUE_HEADER_ITF : ICUX_WMS_ISSUE_HEADER_ITF
    {
        public DataTable Get_CUX_WMS_ISSUE_HEADER_ITF(Mod_CUX_WMS_ISSUE_HEADER_ITF model, string startTime, string endTime)
        {
            //StringBuilder strSql = new StringBuilder();
            //strSql.Append("select * from CUX_WMS_ISSUE_HEADER_ITF_ZH t  ");
            ////strSql.Append(" where t.po_header_id=" + model.PO_HEADER_ID + " ");
            //strSql.Append(" where t.status=1  and  creation_date between to_date('"+ startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('"+ endTime + "', 'yyyy-MM-dd HH24:mi:ss') ");

            ////if (!int.IsNullOrEmpty(model.STORAGE_ID))
            ////{
            ////    strSql.Append(" and  a.STORAGE_ID = '" + model.STORAGE_ID + "'");
            ////}
            ////if (!string.IsNullOrEmpty(model.TASK_ID))
            ////{
            ////    strSql.Append(" and  a.TASK_ID = '" + model.TASK_ID + "'");
            ////}

            string strSql = @"select 
                            CASE T.MAT_ISSUE_TYPE WHEN 1 THEN '推式领料' WHEN 2 THEN '拉式领料' WHEN 3 THEN '非BOM领料'  END MAT_ISSUE_TYPE,
                            T.MAT_REQ_HEADER_ID,T.MAT_REQ_NUM,T.MAT_REQ_DATE,
                            T.MAT_NUMBER,T.ITEM_TYPE_NAME,
                            CASE T.IO_TYPE WHEN '35' THEN 'WIP发料' WHEN '43' THEN 'WIP退料' WHEN '34' THEN '工单补料' 
                            WHEN '1' THEN '拉式发料' WHEN '2' THEN '拉式退料' WHEN '11' THEN '非BOM出库' WHEN '21' THEN '非BOM入库' 
                            WHEN '12' THEN '报废出' WHEN '22' THEN '报废入' WHEN '13' THEN '盘亏调整' WHEN '23' THEN '盘盈调整' 
                            WHEN '31' THEN 'VMI转仓' WHEN '32' THEN '子库转移' WHEN '33' THEN '跨组织直接转移' END IO_TYPE,
                            T.DEPARTMENT_NAME,T.ORGANIZATION_CODE_APPLY,
                            T.ORGANIZATION_CODE_ISSUE,T.VENDOR_ID,T.ORGANIZATION_ID_APPLY,T.ORGANIZATION_ID_ISSUE,T.MAT_ISSUE_DATE,
                            CASE T.MAT_REQ_STATUS WHEN '3' THEN '已审批' WHEN '5' THEN '已发放' WHEN '6' THEN '已取消' END  MAT_REQ_STATUS ,
                            T.LAST_UPDATE_DATE,T.LAST_UPDATED_BY,T.CREATION_DATE,T.CREATED_BY,
                            CASE T.STATUS WHEN 1 THEN '未处理' WHEN 2 THEN '错误' WHEN 3 THEN '成功' END STATUS
                            from CUX_WMS_ISSUE_HEADER_ITF_ZH T WHERE T.MAT_ISSUE_TYPE=2 AND creation_date between to_date('"+ startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('"+ endTime + "', 'yyyy-MM-dd HH24:mi:ss') ";





            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

        public DataTable Get_CUX_WMS_ISSUE_LINE_ITF (Mod_CUX_WMS_ISSUE_LINE_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from CUX_WMS_ISSUE_LINE_ITF_ZH t  ");
            strSql.Append(" where t.MAT_REQ_HEADER_ID=" + model.MAT_REQ_HEADER_ID + " ");
            //strSql.Append(" where t.status=1   ");

            //if (!int.IsNullOrEmpty(model.STORAGE_ID))
            //{
            //    strSql.Append(" and  a.STORAGE_ID = '" + model.STORAGE_ID + "'");
            //}
            //if (!string.IsNullOrEmpty(model.TASK_ID))
            //{
            //    strSql.Append(" and  a.TASK_ID = '" + model.TASK_ID + "'");
            //}
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }






        public DataTable Get_CUX_WMS_COMPLETE_HEADERS_ITF (Mod_CUX_WMS_COMPLETE_HEADERS_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from CUX_WMS_COMPLETE_HEADERS_ITF_ZH t  ");
            //strSql.Append(" where t.MAT_REQ_HEADER_ID=" + model.MAT_REQ_HEADER_ID + " ");
            strSql.Append(" where t.status=1   ");

            //if (!int.IsNullOrEmpty(model.STORAGE_ID))
            //{
            //    strSql.Append(" and  a.STORAGE_ID = '" + model.STORAGE_ID + "'");
            //}
            //if (!string.IsNullOrEmpty(model.TASK_ID))
            //{
            //    strSql.Append(" and  a.TASK_ID = '" + model.TASK_ID + "'");
            //}
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }


        public DataTable Get_CUX_WMS_COMPLETE_LINES_ITF(Mod_CUX_WMS_COMPLETE_LINES_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from CUX_WMS_COMPLETE_LINES_ITF_ZH t  ");
            strSql.Append(" where t.MAT_REQ_HEADER_ID=" + model.MAT_REQ_HEADER_ID + " ");
            //strSql.Append(" where t.status=1   ");

            //if (!int.IsNullOrEmpty(model.STORAGE_ID))
            //{
            //    strSql.Append(" and  a.STORAGE_ID = '" + model.STORAGE_ID + "'");
            //}
            //if (!string.IsNullOrEmpty(model.TASK_ID))
            //{
            //    strSql.Append(" and  a.TASK_ID = '" + model.TASK_ID + "'");
            //}
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

        public DataTable Get_CUX_WMS_COMPLETE_LOT_ITF(Mod_CUX_WMS_COMPLETE_LOT_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from CUX_WMS_COMPLETE_LOT_ITF_ZH t  ");
            strSql.Append(" where t.MAT_REQ_HEADER_ID=" + model.MAT_REQ_HEADER_ID + " ");
            //strSql.Append(" where t.status=1   ");

            //if (!int.IsNullOrEmpty(model.STORAGE_ID))
            //{
            //    strSql.Append(" and  a.STORAGE_ID = '" + model.STORAGE_ID + "'");
            //}
            //if (!string.IsNullOrEmpty(model.TASK_ID))
            //{
            //    strSql.Append(" and  a.TASK_ID = '" + model.TASK_ID + "'");
            //}
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

    }
}