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_PO_HEADES_ITF: ICUX_WMS_PO_HEADES_ITF
    {
        public DataTable GetCUX_WMS_PO_HEADES_ITF (string startTime, string endTime)
        {
            //string strSql = string.Format(@"select * from CUX_WMS_PO_HEADES_ITF_ZH t ");

            ////if (!string.IsNullOrEmpty(model.GOODS_ID))
            ////{
            ////    strSql += string.Format("and a.GOODS_ID ='{0}'", model.GOODS_ID);
            ////}

            ////if (!string.IsNullOrEmpty(model.WIP_ENTITY))
            ////{
            ////    strSql += string.Format("and a.WIP_ENTITY_ID ='{0}'", model.WIP_ENTITY);
            ////}
            //strSql += " WHERE STATUS=1 order by CREATION_DATE";
            ////creation_date between to_date('"+ startTime + "', 'yyyy-MM-dd HH24:mi:ss') and to_date('"+ endTime + "', 'yyyy-MM-dd HH24:mi:ss')


            string strSql = @"select * from CUX_WMS_PO_HEADES_ITF_ZH t where t.closed_code='OPEN' 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 GetRKctl (string purchase_id)
        {
           

            string strSql = @"select a.warehousing_id,b.line_num,b.goods_id,b.goods_name,b.amount,
                            b.arramount,b.package_id from  t_rk_ware_notice a,t_rk_ware_notice_tab b 
                            where a.warehousing_id=b.warehousing_id and a.purchase_id='"+ purchase_id + "'";



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


        public DataTable Get_cux_wms_subinventory_itf_zh ()
        {


            string strSql = @"select  distinct T.SUBINVENTORY_CODE,T.SUBINVENTORY_DESC 
                                from cux_wms_subinventory_itf_zh T order by t.SUBINVENTORY_CODE";



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



        public DataTable GetCUX_WMS_PO_LINES_ITF(Mod_CUX_WMS_PO_LINES_ITF model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from CUX_WMS_PO_LINES_ITF_ZH t  ");
            strSql.Append(" where t.po_header_id="+ model.PO_HEADER_ID + " ");


            //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 GetCUX_WMS_PO_RETURN_ITF(Mod_CUX_WMS_PO_RETURN_ITF model, string startTime, string endTime )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from cux_wms_po_return_itf_zh t  ");
            //strSql.Append(" where t.po_header_id=" + model.PO_HEADER_ID + " ");
            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') ");

            //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 GetCUX_WMS_ASN_HEADES_ITF_ZH (string startTime, string endTime)
        {
           
            string strSql = @"select * from CUX_WMS_ASN_HEADES_ITF_ZH t where    
                        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 Getcux_wms_asn_lines_itf_zh(int asn_header_id)
        {

            string strSql = @"select * from cux_wms_asn_lines_itf_zh t where  t.asn_header_id="+ asn_header_id + "";
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }



    }
}