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

namespace BLL
{
    public class DALArea : IDALArea
    {
        public IList<Area> GetList()
        {
            try
            {
                IList<Area> ls = new List<Area>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select RoleName from Roles where IsDel !=1");

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

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

        public IList<Area> GetList(AjaxAreaList Json, ref PageInfo page)
        {
            try
            {

                IList<Area> list = new List<Area>();
                StringBuilder strSql = new StringBuilder();
                List<SqlParam> para = new List<SqlParam>();
                strSql.Append("Select ID, StorageNo,StorageName,pai,lie,ceng,Demo from StorageArea ");

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

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

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

                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "ID", "Asc", ref page);
                list = ModelConvertHelper<Area>.DataTableToModel(dt);

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

        }

        public Area GetModel(string StorageNo)
        {
            try
            {
                Area us = null;
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select StorageNo,StorageName,Pai,Lie,Ceng,Demo from StorageArea where ");
                strSql.Append("StorageNo = @StorageNo ");

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

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

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

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

        public bool Add(Area model)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["StorageNo"] = "'" + model.StorageNo + "'";
                ht["StorageName"] = "'" + model.StorageName + "'";
                ht["Pai"] = "'" + model.Pai + "'";
                ht["Lie"] = "'" + model.Lie + "'";
                ht["Ceng"] = "'" + model.Ceng + "'";
                ht["Demo"] = "'" + model.Demo + "'";

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

                if (_ret == 1) result = true;
                return result;
            }
            catch
            {
                return result;
            }
        }

        /// <summary>
        ///  验证是否已生成库位
        /// </summary>
        /// <param name="StorageNo">库区编码</param>
        /// <returns>true:已创建库位 fale：未创建库位</returns>
        public bool IsCreateLocation(string StorageNo) 
        {
            bool bl = false;
            try
            {
                StringBuilder sbstr = new StringBuilder();
                sbstr.Append("select status from StorageArea where StorageNo = '" + StorageNo + "';");
                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sbstr);
                if(dt != null)
                {
                    if (dt.Rows[0][0].ToString() == "1")
                    {
                        bl = true;
                    }
                }                
            }
            catch (Exception)
            {
                bl = false;
            }

            return bl;
        }

        /// <summary>
        /// 自动生成仓位
        /// </summary>
        /// <param name="StorageNo"></param>
        /// <returns></returns>
        public bool Createlocation(string StorageNo) 
        {
            bool bl = true;

            try
            {
                // 获取库区信息
                Area StorageInfo = this.GetModel(StorageNo);
                // 根据库区 排 列 层 生成库位信息。
                int pai = int.Parse(StorageInfo.Pai);
                int lie = int.Parse(StorageInfo.Lie);
                int ceng = int.Parse(StorageInfo.Ceng);

                IDALGoodsPos provider = new DALGoodsPos();

                // 循环取得每个库位号
                for (int p = 1; p <= pai; p++)
                {
                    for (int l = 1; l <= lie; l++)
                    {
                        for (int c = 1; c <= ceng; c++)
                        {
                            GoodsPos gdModel = new GoodsPos();
                            gdModel.Area = StorageNo;
                            gdModel.pai = p.ToString().PadLeft(2, '0');
                            gdModel.lie = l.ToString().PadLeft(2, '0');
                            gdModel.ceng = c.ToString().PadLeft(2, '0');
                            gdModel.property = "N";
                            gdModel.ALock = "N";
                            gdModel.Demo = "";

                            provider.Add(gdModel, "");
                        }
                    }
                }

                // 改变创建库位标记
                Hashtable ht = new Hashtable();
                ht["status"] = "'1'";
                StorageNo = "'" + StorageNo + "'";
                if (DataFactory.SqlDataBase().UpdateByHashtable("StorageArea", "StorageNo", StorageNo, ht) != 1) 
                {
                    bl = false;
                }
            }
            catch (Exception ex)
            {
                bl = false;
            }

            return bl;
        }

        public bool Update(Area model)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["StorageName"] = string.IsNullOrEmpty(model.StorageName) ? "''" : "'" + model.StorageName + "'";
                ht["pai"] = string.IsNullOrEmpty(model.Pai) ? "''" : "'" + model.Pai + "'";
                ht["lie"] = string.IsNullOrEmpty(model.Lie) ? "''" : "'" + model.Lie + "'";
                ht["ceng"] = string.IsNullOrEmpty(model.Ceng) ? "''" : "'" + model.Ceng + "'";
                ht["Demo"] = string.IsNullOrEmpty(model.Demo) ? "''" : "'" + model.Demo + "'";

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

                int _ret = DataFactory.SqlDataBase().UpdateByHashtable("StorageArea", nameof(model.StorageNo), StorageNo, ht);

                if (_ret == 1) result = true;

                return result;

            }
            catch
            {
                return result;
            }
        }
        public bool IsExist(string name, string value)
        {
            bool result = false;
            try
            {
                string[] para = new string[] { value };
                int dt = DataFactory.SqlDataBase().IsExist("StorageArea", name, para);
                if (dt > 0) result = true;
                return result;
            }
            catch
            {
                return result;
            }

        }
        public DataTable GetDataTable(string[] strWhere)
        {
            DataTable dt = null;
            try
            {
                int index = 0;
                string str = "@RoleNum" + index;
                SqlParam[] param = new SqlParam[strWhere.Length];
                StringBuilder sql = new StringBuilder();
                sql.Append("Select RoleNum as 角色编号, RoleName as 角色名,CreatUser as 创建人,CreatTime as 创建时间,UpdateUser as 更新人,UpdateTime as 更新时间,Demo as 备注 FROM View_GetRoles where RoleNum in (");

                for (int i = 0; i < param.Length - 1; i++)
                {
                    string obj2 = strWhere[i];
                    str = "@RoleNum" + index;
                    sql.Append(str).Append(",");
                    param[index] = new SqlParam(str, obj2);
                    index++;
                }
                str = "@RoleNum" + index;
                sql.Append(str);
                param[index] = new SqlParam(str, strWhere[index]);
                sql.Append(")");

                dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql, param,"");

                return dt;

            }
            catch
            {
                throw new NotImplementedException();
            }

        }
        public bool BatchDelete(string[] RoleNum)
        {
            bool result = false;
            try
            {
                int dt = DataFactory.SqlDataBase().IsExist("StorageArea", "StorageNo", RoleNum);
                if (dt >= RoleNum.Length)
                {
                    int _ret = DataFactory.SqlDataBase().BatchDeleteData("StorageArea", "StorageNo", RoleNum);
                    if (_ret >= RoleNum.Length) result = true;
                }
                return result;
            }
            catch
            {
                return result;
            }
        }
    }
}