using FineUIPro;
using iWareCommon.Common.Entity;
using iWareCommon.Common.EnumType;
using iWareDataCore.BASE.EnumType;
using iWareDataCore.BASE.Service;
using iWareExcel.EXCEL.Service;
using iWareWms;
using iWareWms.Code.Excel.Service;
using System;
using System.Collections.Generic;

namespace iWareWms.View.MATERIAL.Material
{
    
    public partial class Material : PageBase
    {
        protected override Grid GetGrid()
        {
            return MaterialGrid;
        }

        protected override DropDownList GetPageSizeDropDownList()
        {
            return ddlPageSize;
        }

        protected override List<object> GetDataSource(int pageIndex, int pageSize, out string msg, out int totalNum, out int currentPage)
        {
            var materials = MaterialViewService.GetInstance().QueryByParam(new QueryParam
            {
                Search = new Dictionary<string, object> { { "Code", tbCode.Text.Trim() } },
                Filter = new Dictionary<string, object> { { "Status", ddlStatus.SelectedValue }, { "MaterialType", ddlTypeId.SelectedValue } },
                PageIndex = pageIndex,
                PageSize = pageSize
            }, out msg, out totalNum, out currentPage);
            var material = new List<object>();
            materials.ForEach(x => material.Add(x));
            return material;
        }

        protected override void Delete(int id, out string msg)
        {
            MaterialService.GetInstance().Delete(id, out msg);
            WriteLog("物料删除" + msg, "物料管理");
        }

        protected override void Delete(List<int> ids, out string msg)
        {
            MaterialService.GetInstance().Delete(ids, out msg);
            WriteLog("物料删除" + msg, "物料管理");
        }

        protected override void ChangeStatus(List<int> ids, int enable, out string msg)
        {
            MaterialService.GetInstance().ChangeStatus(ids, enable, out msg);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //判断启用状态复选框是否选择了至少一项纪录
                ResolveEnableStatusButtonForGrid(MenuButton1, MaterialGrid, true);

                //判断禁用状态复选框是否选择了至少一项纪录
                ResolveEnableStatusButtonForGrid(MenuButton2, MaterialGrid, false);

                //判断删除复选框是否选择了至少一项纪录
                ResolveDeleteButtonForGrid(Button3, MaterialGrid);

                //物料启用状态
                ddlStatus.Items.Add("全部", "");
                foreach (var status in Enum.GetValues(typeof(iWareCommon.Common.EnumType.EStatus)))
                {
                    ddlStatus.Items.Add(status.ToString(), ((int)status).ToString());
                }

                //物料大类
                //ddlType.Items.Add("全部", "");
                //foreach (var type in Enum.GetValues(typeof(EMaterialType)))
                //{
                //    ddlType.Items.Add(type.ToString(), ((int)type).ToString());
                //}

                

                string msg;
                var types = MaterialTypeService.GetInstance().QueryByParam(new QueryParam(),out msg);
                
                ddlTypeId.Items.Add("全部", "");
                types.ForEach(x => ddlTypeId.Items.Add(x.Name, x.Type.ToString()));

                //新增物料
                Button1.OnClientClick = types.Count > 0 ? Window1.GetShowReference("~/View/MATERIAL/Material/MaterialDetail.aspx", "新增物料") : "alert('请先添加物料类型')";
                Query(1);
            }
        }

        /// <summary>
        /// 物料启用状态，枚举前台显示
        /// </summary>
        /// <param name="tryp"></param>
        /// <returns></returns>
        protected string GetStatus(object status)
        {
            return ((iWareCommon.Common.EnumType.EStatus)Convert.ToInt32(status)).ToString();
        }

        /// <summary>
        /// 物料类型，枚举前台显示
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        protected string GetType(object type)
        {
            return ((EMaterialType)Convert.ToInt32(type)).ToString();
        }

        /// <summary>
        /// 切割类型前台枚举显示
        /// </summary>
        /// <param name="tryp"></param>
        /// <returns></returns>
        protected string GetCuttingType(object cuttingtype)
        {
            return ((ECuttingType)Convert.ToInt32(cuttingtype)).ToString();
        }

        protected override Window GetWindow()
        {
            return Window2;
        }
        

        protected override void GetPath(object userName)
        {
            string msg;
            var materials = MaterialViewService.GetInstance().QueryByParam(new QueryParam
            {
                Search = new Dictionary<string, object> { { "Code", tbCode.Text.Trim() } },
                Filter = new Dictionary<string, object> { { "Status", ddlStatus.SelectedValue }, { "MaterialType", ddlTypeId.SelectedValue } }       
            }, out msg);
            var datas = new List<object>();
            materials.ForEach(x => datas.Add(x));
            var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary<string, object> { { "Name", "物料信息" } } }, out msg);
            var path = ExcelService.GetInstance().ToExcelByEPPlus(workBooks[0], new Dictionary<string, List<object>> { { "物料信息", datas } }, out msg);
            Session["ExcelPath"] = path;
        }

        protected override FineUIPro.Timer GetTimer()
        {
            return timer1;
        }

        protected void FileUpload1_FileSelected(object sender, EventArgs e)
        {
            string msg;
            if (!FileUpload1.HasFile)
            {
                Alert.ShowInTop("请选择上传文件！");
                return;
            }
            var dt = DateTime.Now;
            string path = string.Format(@"c:\importExcel\{0}\{1}\{2}\{3}\", dt.Year, dt.Month, dt.Day, (long)(dt - Convert.ToDateTime("1970-01-01 08:00:00")).TotalMilliseconds); ;
            path += FileUpload1.FileName;
            FileUpload1.SaveAs(path);

            var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary<string, object> { { "Name", "物料信息" } } }, out msg);

            MaterialViewService.GetInstance().ImportExcel(path, workBooks[0], out msg);
            if(string.IsNullOrEmpty(msg) )
            {
            msg="导入成功";
            }
            Alert.ShowInTop(msg);
            WriteLog("物料导入" + msg, "物料管理");
            Query(1);
        }
    }
}