using System;
using System.Collections.Generic;
using System.Text;
using Model;
using Common;
using System.Data;

namespace BLL
{
    public class DALErp : IDALErp
    {
        public IList<Erp> GetList()
        {
            try
            {
                IList<Erp> ls = new List<Erp>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select RoleName from Roles where IsDel !=1");
                
                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql);
                ls = ModelConvertHelper<Erp>.DataReaderToModel(dt);

                return ls;
            }
            catch
            { 
            throw new NotImplementedException();
            }
        }

        public IList<Erp> GetList(AjaxErpList Json,ref PageInfo page)
        {
            try
            {
                IList<Erp> list = new List<Erp>();
                StringBuilder strSql = new StringBuilder();
                List<SqlParam> para = new List<SqlParam>();
                strSql.Append("Select * from View_Log_Erp ");

                if (!string.IsNullOrEmpty(Json.OrdNo))
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("OrdNo like '%' + @OrdNo + '%' ");
                    para.Add(new SqlParam("@OrdNo", Json.OrdNo));
                }

                if (!string.IsNullOrEmpty(Json.OrdType))
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("OrdType like '%' + @OrdType + '%'  ");
                    para.Add(new SqlParam("@OrdType", Json.OrdType));
                }

                if (!string.IsNullOrEmpty(Json.Statu))
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("Statu like '%' + @Statu + '%'  ");
                    para.Add(new SqlParam("@Statu", Json.Statu));
                }

                if (Json.BeCreateTime != DateTime.MinValue && Json.BeCreateTime != null && Json.BeCreateTime != DateTime.MaxValue)
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("CreateTime >= @CreateTime1 ");
                    para.Add(new SqlParam("@CreateTime1", Convert.ToDateTime(Json.BeCreateTime)));
                }

                if (Json.EnCreateTime != DateTime.MinValue && Json.EnCreateTime != null && Json.EnCreateTime != DateTime.MaxValue)
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("CreateTime <= @CreateTime2 ");
                    para.Add(new SqlParam("@CreateTime2", Convert.ToDateTime(Json.EnCreateTime)));
                }

                if (Json.BeCOMDTime != DateTime.MinValue && Json.BeCOMDTime != null && Json.BeCOMDTime != DateTime.MaxValue)
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("CreateTime >= @CreateTime1 ");
                    para.Add(new SqlParam("@CreateTime1", Convert.ToDateTime(Json.BeCOMDTime)));
                }

                if (Json.EnCOMDTime != DateTime.MinValue && Json.EnCOMDTime != null && Json.EnCOMDTime != DateTime.MaxValue)
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("CreateTime <= @CreateTime2 ");
                    para.Add(new SqlParam("@CreateTime2", Convert.ToDateTime(Json.EnCOMDTime)));
                }

                SqlParam[] param = null;
                if (para != null)
                    param = para.ToArray();

                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "CreateTime", "desc", ref page);
                list = ModelConvertHelper<Erp>.DataTableToModel(dt);

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }

        }

        public Erp GetModel(string OrdNo)
        {
            try
            {

                ErpIn us = null;
                StringBuilder strSql = new StringBuilder();
                strSql.Append(" Select * from View_Log_Erp where ");
                strSql.Append("OrdNo = @OrdNo ");
                //strSql.Append("and IsDel != 1");
                SqlParam[] para = new SqlParam[]
                {
                    new SqlParam("@OrdNo", OrdNo),
                };

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);

                us = ModelConvertHelper<ErpIn>.ReaderToModel(dt);

                return us;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public Erp GetModel(string OrdNo,ref IList<ErpMat> erpMats)
        {
            try
            {


                ErpIn us = null;
                StringBuilder strSql = new StringBuilder();
                strSql.Append(" Select * from View_Erp_Log_Erp where ");
                strSql.Append("OrdNo = @OrdNo ");
                //strSql.Append("and IsDel != 1");
                SqlParam[] para = new SqlParam[]
                {
                    new SqlParam("@OrdNo", OrdNo),
                };

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);

                us = ModelConvertHelper<ErpIn>.ReaderToModel(dt);

                IDALErpDetail erpInDetail = new DALErpDetail();
                erpMats = erpInDetail.GetList(OrdNo);


                return us;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

    }
}