using System;
using System.Configuration;
using System.Collections.Generic;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
using SuperMap.RealEstate.Web.UI.WebControls;
using Business = SuperMap.RealEstate.HighWay.Storage.Business;
using HZQR.Common;

namespace SuperMap.RealEstate.HighWay.Modules.SellData
{
    public partial class Default : Storage.UI.BasePage
    {
        protected string SERVERPART_IDS = "", SERVERPARTSHOP_IDS = "";
        private DataTable _DataTable = null;

        #region 方法 -> 页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;

            InitControls();
            Business.CommonHelper.BindReportHeader(Label1, PassportInfo.ProvinceUnit,
                "门店销售流水汇总表", PassportInfo.CityAuthority, Transaction);
            //设置回车焦点按钮
            SetControlClientAction(ButtonStatistics, false);
            SetControlClientAction(ButtonSearch);
        }
        #endregion

        #region 方法 -> 初始化页面控件
        private void InitControls()
        {
            SERVERPART_ID.Items.Clear();
            ListItemEx _ListItemEx = new ListItemEx();
            foreach (Business.SERVERPART _SERVERPART in new Business.SERVERPART(Transaction).GetPassportServerPart(
                PassportInfo.CityAuthority, "1000,1001"))
            {
                _ListItemEx = new ListItemEx();
                _ListItemEx.Value = _SERVERPART.KeyID;
                _ListItemEx.Text = _SERVERPART.SERVERPART_NAME;
                SERVERPART_ID.Items.Add(_ListItemEx);
            }
            SERVERPART_ID.SelectedIndex = 0;

            string StrSql = string.Empty;
            SERVERPARTSHOP_ID.Items.Clear();
            _ListItemEx = new ListItemEx();
            _ListItemEx.Text = "所有门店";
            _ListItemEx.Value = "1=1";
            SERVERPARTSHOP_ID.Items.Add(_ListItemEx);
            //绑定对应的商家统计
            if (SERVERPART_ID.SelectedValue != "1=1")
            {
                foreach (Business.SERVERPARTSHOP _SERVERPARTSHOP in new Business.SERVERPARTSHOP(Transaction).FillCollection(
                    "WHERE ISVALID = 1 AND SHOPTRADE NOT IN ('9032','9999') AND SERVERPART_ID = " + SERVERPART_ID.SelectedValue +
                        " AND NVL(STATISTIC_TYPE,1000) IN (1000,2000) ORDER BY SHOPREGION,SHOPTRADE,SHOPCODE"))
                {
                    _ListItemEx = new ListItemEx();
                    _ListItemEx.Text = _SERVERPARTSHOP.SHOPNAME;
                    _ListItemEx.Value = _SERVERPARTSHOP.KeyID;
                    _ListItemEx.Level = 1;
                    SERVERPARTSHOP_ID.Items.Add(_ListItemEx);
                }
            }

            StatisticsDay.Text = DateTime.Now.Date.AddDays(-1).ToString();
        }
        #endregion

        #region 方法 -> 绑定下拉框门店
        protected void SERVERPART_ID_CallBackSetControl(object sender, ClientSetEventArgs e)
        {
            string StrSql = string.Empty;
            SERVERPARTSHOP_ID.Items.Clear();
            ListItemEx _ListItemEx = new ListItemEx();
            _ListItemEx.Text = "所有门店";
            _ListItemEx.Value = "1=1";
            SERVERPARTSHOP_ID.Items.Add(_ListItemEx);
            //绑定对应的商家统计
            if (!string.IsNullOrEmpty(e.Argument) && e.Argument != "1=1")
            {
                foreach (Business.SERVERPARTSHOP _SERVERPARTSHOP in new Business.SERVERPARTSHOP(Transaction).FillCollection(
                    "WHERE ISVALID = 1 AND SHOPTRADE NOT IN ('9032','9999') AND SERVERPART_ID = " + SERVERPART_ID.SelectedValue +
                        " AND NVL(STATISTIC_TYPE,1000) IN (1000,2000) ORDER BY SHOPREGION,SHOPTRADE,SHOPCODE"))
                {
                    _ListItemEx = new ListItemEx();
                    _ListItemEx.Text = _SERVERPARTSHOP.SHOPNAME;
                    _ListItemEx.Value = _SERVERPARTSHOP.KeyID;
                    _ListItemEx.Level = 1;
                    SERVERPARTSHOP_ID.Items.Add(_ListItemEx);
                }
            }
            e.SetDropDownListEx(SERVERPARTSHOP_ID);
        }
        #endregion

        #region 方法 -> 查询
        protected void ButtonStatistics_Click(object sender, EventArgs e)
        {
            ButtonSearch.Visible = true;
            //获取查询的门店集合
            if (string.IsNullOrEmpty(SERVERPART_ID.SelectedValue))
            {
                Alert("请选择服务区！");
                return;
            }

            #region 表头隐藏选项
            bool cashpayShow = true;        //现金支付显示
            bool mobilepayShow = true;      //移动支付显示
            bool couponpayShow = true;      //消费(大巴)券显示
            bool internalpayShow = true;    //企业会员显示
            bool memberpayShow = true;      //会员卡支付显示
            bool bankpayShow = true;        //银联卡支付显示

            foreach (Control _Control in LayoutButton_Visable.Controls)
            {
                if (_Control is CheckBoxEx && (_Control as CheckBoxEx).Checked)
                {
                    if (_Control.ClientID == "B_L_LB_CASHPAY")
                    {
                        cashpayShow = false;
                    }
                    else if (_Control.ClientID == "B_L_LB_MOBILEPAY")
                    {
                        mobilepayShow = false;
                    }
                    else if (_Control.ClientID == "B_L_LB_COUPONPAY")
                    {
                        couponpayShow = false;
                    }
                    else if (_Control.ClientID == "B_L_LB_INTERNALPAY")
                    {
                        internalpayShow = false;
                    }
                    else if (_Control.ClientID == "B_L_LB_MEMBERPAY")
                    {
                        memberpayShow = false;
                    }
                    else if (_Control.ClientID == "B_L_LB_BANKPAY")
                    {
                        bankpayShow = false;
                    }
                }
            }

            if (cashpayShow)
            {
                GridViewEx1.Columns[7].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[7].Visible = false;
            }

            if (mobilepayShow)
            {
                GridViewEx1.Columns[8].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[8].Visible = false;
            }

            if (couponpayShow)
            {
                GridViewEx1.Columns[9].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[9].Visible = false;
            }

            if (internalpayShow)
            {
                GridViewEx1.Columns[10].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[10].Visible = false;
            }

            if (memberpayShow)
            {
                GridViewEx1.Columns[11].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[11].Visible = false;
            }

            if (bankpayShow)
            {
                GridViewEx1.Columns[12].Visible = true;
            }
            else
            {
                GridViewEx1.Columns[12].Visible = false;
            }
            #endregion

            Business.CommonHelper.BindReportHeader(Label1, PassportInfo.ProvinceUnit,
                SERVERPART_ID.SelectedItem.Text + "门店销售流水汇总表", PassportInfo.CityAuthority, Transaction);
            //查询数据
            GridViewEx1.SelectingWithInit<ExchangeData.Business.SELLDATA>(ObjectDataSource1, GridPageEx1);
            //绑定统计日期、制单人、制单时间
            ENDACCOUNT_DATE.Visible = true;
            ENDACCOUNT_DATE.Text = "统计时间：" + StatisticsDay.Text;
            div_sign.Attributes["style"] = "display:block";
            lblStaffName.Visible = true;
            lblStaffName.Text = "制单人：" + PassportInfo.Name;
            lblDate.Visible = true;
            lblDate.Text = "制单时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        }
        #endregion

        #region 方法 -> 列表事件
        //查询
        protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e)
        {
            GridViewEx1.Selecting<ExchangeData.Business.SELLDATA>(ObjectDataSource1, GridPageEx1);
            //设置UI变化
            e.SetValue(GridViewEx1);
            e.SetValue(GridPageEx1);
        }

        //翻页事件
        protected void GridPageEx1_CallBackPageChanged(object src, ClientSetEventArgs e)
        {
            GridViewEx1.Pagging<ExchangeData.Business.SELLDATA>(ObjectDataSource1, GridPageEx1);
            //设置UI变化
            e.SetValue(GridViewEx1);
        }

        //查询SQL设置
        protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e)
        {
            if (!string.IsNullOrEmpty(SERVERPART_ID.SelectedValue))
            {
                //搜索选项的搜索条件过滤
                if (!string.IsNullOrEmpty(TextBox_Search.Text))
                    e.AddOrParams(GridViewSearch1, TextBox_Search.Text);

                e.AddAndParams("1", 1);

                e.AddAndParams("SERVERPART_ID", SERVERPART_ID.SelectedValue);

                if (!string.IsNullOrEmpty(SERVERPARTSHOP_ID.SelectedValue) && SERVERPARTSHOP_ID.SelectedValue != "1=1")
                {
                    e.AddAndParams("SERVERPARTSHOP_ID", SERVERPARTSHOP_ID.SelectedValue);
                }

                if (!string.IsNullOrEmpty(StatisticsDay.Text.Trim()))
                {
                    e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") +
                        "SELLMASTER_DATE >= TO_DATE('" + StatisticsDay.Text.Trim() +
                        "','YYYY/MM/DD') AND SELLMASTER_DATE < TO_DATE('" + StatisticsDay.Text.Trim() + "','YYYY/MM/DD') + 1";
                }

                //排序
                if (LayoutButton_OrderBy.Visible)
                {
                    e.AddOrderByParams(GridViewOrderBy1);
                }
                else
                {
                    e.AddOrderByParams("SELLMASTER_DATE", false);
                }
            }
            else
            {
                e.AddAndParams("1", 2);
            }
        }
        #endregion

        #region 方法 -> 行绑定事件
        decimal _SELLMASTER_COUNT = 0, _SELLMASTER_AMOUNT = 0, _SELLMASTER_OFFPRICE = 0,
            _CASHPAY = 0, _MOBILEPAY = 0, _COUPONPAY = 0, _INTERNALPAY = 0, _MEMBERPAY = 0, _BANKPAY = 0;
        protected void GridViewEx1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                _SELLMASTER_COUNT = 0;
                _SELLMASTER_AMOUNT = 0;
                _SELLMASTER_OFFPRICE = 0;
                _CASHPAY = 0;
                _MOBILEPAY = 0;
                _COUPONPAY = 0;
                _INTERNALPAY = 0;
                _MEMBERPAY = 0;
                _BANKPAY = 0;
            }
            else if (e.Row.RowType == DataControlRowType.DataRow)
            {
                string _SELLMASTER_CODE = GridViewEx1.DataKeys[e.Row.RowIndex]["SELLMASTER_CODE"].ToString();

                e.Row.Attributes["onclick"] = GridViewEx1.GetOpenPopDialogClientScript("SaleDataDetailList.aspx?SELLMASTER_CODE=" +
                    _SELLMASTER_CODE.ToEncrypt() + "&SERVERPART_NAME=" + SERVERPART_ID.SelectedItem.Text.ToEncrypt() +
                    "&SHOPNAME=" + e.Row.Cells[e.Row.Cells.Count - 2].Text.ToEncrypt());

                for (int CellCount = 6; CellCount < e.Row.Cells.Count - 3; CellCount++)
                {
                    if (e.Row.Cells[CellCount].Text == "0" || e.Row.Cells[CellCount].Text == "0.00")
                    {
                        e.Row.Cells[CellCount].Text = "";
                    }
                }

                _SELLMASTER_COUNT += e.Row.Cells[4].Text.TryParseToDecimal();
                _SELLMASTER_AMOUNT += e.Row.Cells[5].Text.TryParseToDecimal();
                _SELLMASTER_OFFPRICE += e.Row.Cells[6].Text.TryParseToDecimal();
                _CASHPAY += e.Row.Cells[7].Text.TryParseToDecimal();
                _MOBILEPAY += e.Row.Cells[8].Text.TryParseToDecimal();
                _COUPONPAY += e.Row.Cells[9].Text.TryParseToDecimal();
                _INTERNALPAY += e.Row.Cells[10].Text.TryParseToDecimal();
                _MEMBERPAY += e.Row.Cells[11].Text.TryParseToDecimal();
                _BANKPAY += e.Row.Cells[12].Text.TryParseToDecimal();
            }
            else if (e.Row.RowType == DataControlRowType.Footer)
            {
                e.Row.Cells[0].Text = "合计";
                e.Row.Cells[0].ColumnSpan = 3;
                e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Center;
                e.Row.Cells[1].Visible = false;
                e.Row.Cells[2].Visible = false;
                e.Row.Cells[4].Text = _SELLMASTER_COUNT.ToString();
                e.Row.Cells[5].Text = _SELLMASTER_AMOUNT.ToString();
                e.Row.Cells[6].Text = _SELLMASTER_OFFPRICE.ToString();
                e.Row.Cells[7].Text = _CASHPAY.ToString();
                e.Row.Cells[8].Text = _MOBILEPAY.ToString();
                e.Row.Cells[9].Text = _COUPONPAY.ToString();
                e.Row.Cells[10].Text = _INTERNALPAY.ToString();
                e.Row.Cells[11].Text = _MEMBERPAY.ToString();
                e.Row.Cells[12].Text = _BANKPAY.ToString();
            }
        }
        #endregion

        #region 方法 -> 导出对应的Excel
        protected void ButtonExport_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(SERVERPART_ID.SelectedValue))
            {
                Alert("请选择服务区！");
                return;
            }

            string WhereSql = "";
            string StrSql = @"SELECT A.SELLMASTER_DATE AS 销售时间,A.TICKET_CODE AS 小票编号,
                    WM_CONCAT(B.COMMODITY_NAME || '[' || B.COMMODITY_BARCODE || ']' || 
                        '(' || B.SELLDETAILS_COUNT || '*' || B.SELLDETAILS_PRICE || ')') AS 流水详情,
                    A.SELLMASTER_COUNT AS 销售数量,A.SELLMASTER_AMOUNT AS 实收金额,A.SELLMASTER_OFFPRICE AS 优惠金额,
                    A.CASHPAY AS 现金支付,A.MOBILEPAY AS 移动支付,A.COUPONPAY AS 消费券,A.INTERNALPAY AS 企业会员,
                    A.MEMBERPAY AS 会员卡支付,A.BANKPAY AS 银联支付,A.SHOPNAME AS 门店名称,A.MACHINECODE AS 收银机号 
                FROM 
                    {0} A,HIGHWAY_SELLDATA.T_SELLDETAILS B 
                WHERE 
                    A.SELLMASTER_CODE = B.SELLMASTER_CODE{1} 
                GROUP BY 
                    A.SELLMASTER_DATE,A.SHOPNAME,A.SELLMASTER_COUNT,A.SELLMASTER_AMOUNT,A.SELLMASTER_OFFPRICE,
                    A.CASHPAY,A.MOBILEPAY,A.COUPONPAY,A.INTERNALPAY,A.MEMBERPAY,A.BANKPAY,A.MACHINECODE,A.TICKET_CODE";

            WhereSql += " AND SERVERPART_ID = " + SERVERPART_ID.SelectedValue;

            if (!string.IsNullOrEmpty(SERVERPARTSHOP_ID.SelectedValue) && SERVERPARTSHOP_ID.SelectedValue != "1=1")
            {
                WhereSql += " AND SERVERPARTSHOP_ID = " + SERVERPARTSHOP_ID.SelectedValue;
            }

            if (!string.IsNullOrEmpty(StatisticsDay.Text.Trim()))
            {
                WhereSql += " AND SELLMASTER_DATE >= TO_DATE('" + StatisticsDay.Text.Trim() +
                    "','YYYY/MM/DD') AND SELLMASTER_DATE < TO_DATE('" + StatisticsDay.Text.Trim() + "','YYYY/MM/DD') + 1";
            }

            _DataTable = new ExchangeData.Business.SELLDATA(Transaction).ExecuteDataTable(
                string.Format(StrSql, GridViewEx1.DataTableName, WhereSql));

            ExcelHelper _ExcelHelper = new ExcelHelper();
            _ExcelHelper.DataTableToExcel(Label1.Text, ENDACCOUNT_DATE.Text, lblStaffName.Text, lblDate.Text,
                null, Label1.Text + "导出", _DataTable, "门店销售流水汇总表", true);
        }
        #endregion
    }
}