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_FIX_ISSUE_ITF:ICUX_WMS_FIX_ISSUE_ITF
    {
        //EBS返修单 下发  
        public DataTable Get_CUX_WMS_FIX_ISSUE_ITF (Mod_CUX_WMS_FIX_ISSUE_ITF model, string startTime, string endTime)
        {
            //
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from cux_wms_fix_issue_itf_zh t  ");
            //strSql.Append(" where t.REQUEST_NUMBER=" + model.REQUEST_NUMBER + " ");
            //strSql.Append(" AND  t.LINE_NUMBER=" + model.LINE_NUMBER + " ");
            strSql.Append(" where    CREATION_DATE between to_date('" + startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('" + endTime + "', 'yyyy-MM-dd HH24:mi:ss') ");

            strSql.Append(" and 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_FIX_LOT_ITF(Mod_CUX_WMS_FIX_LOT_ITF model, string startTime, string endTime)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from cux_wms_fix_lot_itf_zh t  ");
            //strSql.Append(" where t.WIP_ENTITY_NAME='" + model.WIP_ENTITY_NAME + "' ");
            //strSql.Append(" AND  t.LINE_NUMBER=" + model.LINE_NUMBER + " ");
            strSql.Append(" where      CREATION_DATE between to_date('" + startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('" + endTime + "', 'yyyy-MM-dd HH24:mi:ss') ");

            strSql.Append(" and  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_FIX_FINISH_ITF(Mod_CUX_WMS_FIX_FINISH_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from cux_wms_fix_finish_itf_zh t  ");
            strSql.Append(" where t.WIP_ENTITY_NAME=" + model.WIP_ENTITY_NAME + " ");
            //strSql.Append(" AND  t.LINE_NUMBER=" + model.LINE_NUMBER + " ");
            //strSql.Append(" and     CREATION_DATE between to_date('" + startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('" + endTime + "', 'yyyy-MM-dd HH24:mi:ss') ");

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

    }
}