using FineUIPro;
using iWareCommon.Common.Entity;
using iWareDataCore.BASE.Service;
using iWareDataCore.ORM;
using iWareLog.LOG.Service;
using System;
using System.Collections.Generic;
using System.Text;

namespace iWareWms.View.InOut
{
    public partial class WebOrder : PageBase
    {
        protected override Grid GetGrid()
        {
            return WebOrderGrid;
        }

        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 places = WebOrderService.GetInstance().QueryByParam(new QueryParam
            {
                Search = new Dictionary<string, object> { { "RequestOrder", tbRequestOrder.Text.Trim() },{ "ListNo", tbListNo.Text.Trim() }},
                Geq = new Dictionary<string, object> { { "CreateTime", (DateTime)SCreateTime.SelectedDate } },
                Ltd = new Dictionary<string, object> { { "CreateTime", ((DateTime)CreateTime.SelectedDate).AddDays(1) } },
                Filter = new Dictionary<string, object> { { "BusType", ddlBusType.SelectedValue } },
                PageIndex = pageIndex,
                PageSize = pageSize
            }, out msg, out totalNum, out currentPage);

            var res = new List<object>();
            places.ForEach(x => {
              res.Add(x);
            });
            return res;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                var today = DateTime.Today;
                SCreateTime.SelectedDate = today.AddDays(-6);
                CreateTime.SelectedDate = today;
                Query(1);
            }
        }

        /// <summary>
        /// 类型前台显示
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        protected string GetType(object type)
        {
            string st = "未知";
            try
            {
                int ty = int.Parse(type.ToString());
                switch (ty)
                {
                    case 0:
                        st = "入库";
                        break;
                    case 1:
                        st = "出库";
                        break;
                    default:
                        break;
                }
                return st;
            }
            catch (Exception)
            {
                return st;
            }
        }


        protected override Window GetWindow()
        {
            return Window1;
        }

        protected override void GetPath(object userName)
        {
            string msg;

            var places = InOutStorageDetailService.GetInstance().QueryByParam(new QueryParam
            {

                Search = new Dictionary<string, object> { { "RequestOrder", tbRequestOrder.Text.Trim() }, { "ListNo", tbListNo.Text.Trim() } },
                Geq = new Dictionary<string, object> { { "CreateTime", (DateTime)SCreateTime.SelectedDate } },
                Ltd = new Dictionary<string, object> { { "CreateTime", ((DateTime)CreateTime.SelectedDate).AddDays(1) } },
            }, out msg);

        }

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

        /// <summary>
        /// 删除物料单按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnDeleteRequest_Click(object sender, EventArgs e)
        {
            List<object> selectedRowIDs = new List<object>(WebOrderGrid.SelectedRowIDArray);
            int[] selections = WebOrderGrid.SelectedRowIndexArray;
            var detail = WebOrderGrid.Rows;

            int selectRowId = -1;

            for (int i = 0; i < selections.Length; i++)
            {
                string RowId = detail[selections[i]].RowID.ToString();
                int id = Convert.ToInt32(detail[selections[i]].Values[1].ToString());

                if (selectedRowIDs.Contains(RowId))
                {
                    selectRowId = id;
                    break;
                }
            }
            if (selectRowId > -1)
            {
                string msg;
                int count = WebOrderService.GetInstance().DeleteRequest(selectRowId, out msg);
                if (count >= 0)
                {
                    Alert.ShowInTop("删除成功！");
                    Query(1);
                }
                else
                    Alert.ShowInTop(msg);
            }
            else
                Alert.ShowInTop("请选择单据！");
        }

        /// <summary>
        /// 确认作业
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnDoInOutWork_Click(object sender, EventArgs e)
        {
            List<object> selectedRowIDs = new List<object>(WebOrderGrid.SelectedRowIDArray);
            int[] selections = WebOrderGrid.SelectedRowIndexArray;
            var detail = WebOrderGrid.Rows;

            int selectRowId = -1;

            for (int i = 0; i < selections.Length; i++)
            {
                string RowId = detail[selections[i]].RowID.ToString();
                int id = Convert.ToInt32(detail[selections[i]].Values[1].ToString());

                if (selectedRowIDs.Contains(RowId))
                {
                    selectRowId = id;
                    break;
                }
            }
            if (selectRowId > -1)
            {
                string msg;
                bool doResult = WebOrderService.GetInstance().DoInOutWork(selectRowId, out msg);
                if (doResult)
                {
                    Alert.ShowInTop("下发成功！");
                    Query(1);
                }
                else
                    Alert.ShowInTop(msg);
            }
            else
                Alert.ShowInTop("请选择单据！");
        }

        /// <summary>
        /// 校验
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnCheckWorkOption_Click(object sender, EventArgs e)
        {
            List<object> selectedRowIDs = new List<object>(WebOrderGrid.SelectedRowIDArray);
            int[] selections = WebOrderGrid.SelectedRowIndexArray;
            var detail = WebOrderGrid.Rows;

            int selectRowId = -1;

            for (int i = 0; i < selections.Length; i++)
            {
                string RowId = detail[selections[i]].RowID.ToString();
                int id = Convert.ToInt32(detail[selections[i]].Values[1].ToString());

                if (selectedRowIDs.Contains(RowId))
                {
                    selectRowId = id;
                    break;
                }
            }
            if (selectRowId > -1)
            {
                string msg;
                List<MaterialPlaceView> outMrl;
                WebOrderService.GetInstance().CheckWorkOption(selectRowId,out outMrl,out msg);
                Alert.ShowInTop(msg);
            }
            else
                Alert.ShowInTop("请选择单据！");
        }

        /// <summary>
        /// 导出excel
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ExportToExcel(object sender, EventArgs e)
        {
            List<object> selectedRowIDs = new List<object>(WebOrderGrid.SelectedRowIDArray);
            int[] selections = WebOrderGrid.SelectedRowIndexArray;
            var detail = WebOrderGrid.Rows;

            int selectRowId = -1;

            for (int i = 0; i < selections.Length; i++)
            {
                string RowId = detail[selections[i]].RowID.ToString();
                int id = Convert.ToInt32(detail[selections[i]].Values[1].ToString());

                if (selectedRowIDs.Contains(RowId))
                {
                    selectRowId = id;
                    break;
                }
            }
            if (selectRowId > -1)
            {
                string msg = "";
                List<WebOrderDetailView> cutOrderDetail = WebOrderDetailService.GetInstance().GetWebOrderDetail(selectRowId,out msg);
                if (cutOrderDetail == null || cutOrderDetail.Count == 0)
                {
                    ShowNotify("无单据明细");
                    return;
                }
                Response.ClearContent();
                Response.AddHeader("content-disposition", "attachment; filename=推送单" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
                Response.ContentType = "application/excel";
                Response.ContentEncoding = System.Text.Encoding.UTF8;
                Response.Write(GetGridHtml(cutOrderDetail));
                Response.End();
            }
            else
                Alert.ShowInTop("请选择单据！");
        }

        private string GetGridHtml(List<WebOrderDetailView> orderDetail)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("<meta http-equiv=\"content-type\" content=\"application/excel; charset=UTF-8\"/>");
            sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
            sb.Append("<tr>");

            List<string> titles = new List<string>() { "推送单据号", "出入库单据号", "序号", "规格号", "物料二维码", "物料名称", "数量", 
                                                       "物件编号", "等级", "分类", "类型", "长度" , "density","宽度", "厚度", "突起宽度", 
                                                       "突起厚度","规格","单位重量" };

            foreach (string column in titles)
            {
                sb.AppendFormat("<td>{0}</td>", column);
            }
            sb.Append("</tr>");
            foreach (WebOrderDetailView row in orderDetail)
            {
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td>"
                              + "<td>{9}</td><td>{10}</td><td>{11}</td><td>{12}</td><td>{13}</td><td>{14}</td><td>{15}</td><td>{16}</td><td>{17}</td><td>{18}</td></tr>",
                              row.requestorder, row.listno, row.sequenceno, row.materialno, row.nestingno, row.nestingname, row.quantity, row.articlenumber,
                              row.grade,row.classification,row.profiletype,row.length,row.density,row.webheight,row.webthickness,row.flangewidth,row.flangethickness,
                              row.sectiondim,row.unitweight);
            }
            sb.Append("</table>");
            return sb.ToString();
        }

    }
}