using Commom.Utility;
using Common;
using Model;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL.DAL
{
   public class DALBrand
    {
        public IList<Brand> GetList(AjaxBrandList Json, ref PageInfo pageInfo)
        {
            try
            {
                IList<Brand> list = new List<Brand>();
                StringBuilder strSql = new StringBuilder();
                List<SqlParam> para = new List<SqlParam>();
                strSql.Append("Select * from View_Brand_UserInfo where IsDel=0");

                if (Json.BrandCode != null && Json.BrandCode != "") 
                {
                    strSql.Append(" and BrandCode like '%" + Json.BrandCode + "%'  ");
                }
                if (Json.BrandName != null && Json.BrandName != "")
                {
                    strSql.Append(" and BrandName like '%" +Json.BrandName + "%'  ");
                }

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

                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "CreatTime", "Desc", ref pageInfo);
                return ModelConvertHelper<Brand>.DataTableToModel(dt);
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
        public bool Add(Brand model, string loginUser)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["BrandCode"] = model.BrandCode.AddQuotes();
                ht["BrandName"] = "'" + model.BrandName + "'";
                ht["CreatTime"] = "Getdate()";
                ht["CreatUser"] = "'" + loginUser + "'";
                ht["Demo"] = "'" + model.Demo + "'";

                int _ret = DataFactory.SqlDataBase().InsertByHashtableNullParam("Brand", ht);

                if (_ret == 1) result = true;

                return result;

            }
            catch
            {
                return result;
            }
        }
        //修改品牌
        public bool Update(Brand model,string loginUser)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();
                ht["BrandName"] = string.IsNullOrEmpty(model.BrandName) ? "''" : "'" + model.BrandName + "'";
                ht["Demo"] = string.IsNullOrEmpty(model.Demo) ? "''" : "'" + model.Demo + "'";
                ht["UpdateTime"] = "getdate()";
                ht["UpdateUser"] = loginUser.AddQuotes();

                string ID = "'" + model.ID + "'";

                int _ret = DataFactory.SqlDataBase().UpdateByHashtable("Brand", "ID", ID, ht);
                if (_ret == 1) result = true;

                return result;
            }
            catch
            {
                return result;
            }
        }
        //逻辑删除
        public bool BatchDelete(string[] ID)
        {
            bool result = false;
            try
            {
                int dt = DataFactory.SqlDataBase().IsExist("Brand", "ID", ID);
                if (dt >= ID.Length)
                {
                    int i = 0;
                    while (i < ID.Length)
                    {
                        StringBuilder sql = new StringBuilder();
                        sql.Append("update Brand set IsDel=1 where ID='" + ID[i] + "'");
                        int _ret = DataFactory.SqlDataBase().ExecuteBySql(sql);
                        if (_ret >= ID.Length) result = true;
                        i++;
                    }

                }
                return result;

            }
            catch
            {
                return result;
            }
        }
        //编辑查询
        public Brand GetModel(string ID)
        {
            try
            {
                Brand us = null;
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select * from Brand where ");
                strSql.Append("ID = @ID ");

                SqlParam[] para = new SqlParam[]
                {
                    new SqlParam("@ID", ID),
                };

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
                us = ModelConvertHelper<Brand>.ReaderToModel(dt);

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

        public bool IsExist(string sqlWhere) 
        {
            return DataFactory.SqlDataBase().IsExist("brand", sqlWhere);
        }

        public bool IsExist(Brand model) 
        {
            bool result = false;
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select count(id) from Brand where BrandName = " + model.BrandName.AddQuotes());
                strSql.Append(" and id != " + model.ID + ";");
                DataRow row = DataFactory.SqlDataBase().GetDataRowBySQL(strSql);
                if (row[0].ToString() == "0") 
                {
                    result = true;
                }

                return result;
            }
            catch (Exception)
            {

                return result;
            }
        }

        //物料查询品牌下拉框
        public IList<Brand> GetBrandList(string bdName)
        {
            try
            {

                IList<Brand> ls = new List<Brand>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select ID,BrandCode,BrandName,guid from Brand where IsDel !=1");
                if (!string.IsNullOrEmpty(bdName)) 
                {
                    strSql.Append(" and BrandName like '%" + bdName + "%'");
                }
                strSql.Append(" order by ID;");

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql);
                ls = ModelConvertHelper<Brand>.DataReaderToModel(dt);

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