using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Drawing;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using SuperMap.RealEstate.CoreFrameWork;
using SuperMap.RealEstate.ServiceModel;
using SuperMap.RealEstate.Utility;
using SuperMap.RealEstate.Web.UI;
using SuperMap.RealEstate.Web.UI.WebControls;
using SuperMap.RealEstate.Web.Utility;
using SuperMap.RealEstate.CoreFrameWork.Dictionary.Business;
using Business = SuperMap.RealEstate.HighWay.Storage.Business;
using MSPB = SuperMap.RealEstate.MobileServicePlatform.Business;
using HZQR.Common;

namespace SuperMap.RealEstate.HighWay.CloudModule.Commodity
{
    public partial class MessageSend : BasePage
    {
        protected string SERVERPARTID = ConfigurationManager.AppSettings["UmiformCommodity"].ToString().Split('|')[0];

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

            //if (string.IsNullOrEmpty(access_token.Text.Trim()))
            //{
            //    MSPB.WECHATPUBLICSIGN _WECHATPUBLICSIGN = new MSPB.WECHATPUBLICSIGN(Transaction);
            //    _WECHATPUBLICSIGN.WECHATPUBLICSIGN_ID = 3;
            //    if (_WECHATPUBLICSIGN.Select())
            //    {
            //        AppID.Text = _WECHATPUBLICSIGN.WECHAT_APPID;
            //        AppSecret.Text = _WECHATPUBLICSIGN.WECHAT_APPSECRET;

            //        MSPB.PUSHMODULE _PUSHMODULE = new MSPB.PUSHMODULE(Transaction);
            //        _PUSHMODULE.AddSearchParameter("WECHATPUBLICSIGN_ID", _WECHATPUBLICSIGN.WECHATPUBLICSIGN_ID);
            //        _PUSHMODULE.AddSearchParameter("PUSHMODULE_NUM", "SalePriceChange");
            //        if (_PUSHMODULE.Search())
            //        {
            //            PUSH_MODULE.Text = _PUSHMODULE.PUSHMODULE_CODE;
            //        }
            //    }
                
            //    access_token.Text = MSPB.CommonHelper.GetAccess(RefreshTime, AppID.Text, AppSecret.Text);
            //}
            STARTDATE.Text = DateTime.Now.ToShortDateString();
            //重置状态
            BindDropDownList_SERVERPART();
            //初始化并加载列表
            GridViewEx1.SelectingWithInit<Business.COMMODITY>(ObjectDataSource1, GridPageEx1,
                DictionaryHelper.GetDictionary(Transaction, "BUSINESSTYPE"),
                DictionaryHelper.GetDictionary(Transaction, "COMMODITYGRADE").AsNewKeys("COMMODITY_GRADE"),
                DictionaryHelper.GetDictionary(Transaction, "COMMODITYSTATE").AsNewKeys("COMMODITY_STATE"));
            //设置回车焦点按钮
            SetControlClientAction(ButtonSearch);
            //注册遮罩式窗口关闭脚本
            SetControlClosePopDialog(ButtonClose);
        }
        #endregion

        #region 方法 -> 列表事件
        //查询
        protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e)
        {
            if (!string.IsNullOrEmpty(TextBox_Search.Text))
            {
                Session["TextBox_Search_VALUE"] = TextBox_Search.Text;
            }
            GridViewEx1.Selecting<Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
            //设置UI变化
            e.SetValue(GridViewEx1);
            e.SetValue(GridPageEx1);
        }

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

        //查询SQL设置
        protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e)
        {
            if (!string.IsNullOrEmpty(TextBox_Search.Text))
            {
                e.AddOrParams(GridViewSearch1, TextBox_Search.Text);
            }
            e.AddAndParams("1", 1);

            if (SERVERPART_ID.SelectedValue != "" && SERVERPART_ID.SelectedValue != "1=1")
            {
                e.AddAndParams("SERVERPART_ID", SERVERPART_ID.SelectedValue);
            }
            else
            {
                e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") + "SERVERPART_ID IN (" +
                    new Business.SERVERPART(Transaction).GetPassportServerPartID(this.PassportInfo.CityAuthority) + ")";
            }
            if (!string.IsNullOrEmpty(STARTDATE.Text.Trim()))
            {
                e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") +
                    "OPERATE_DATE >= TO_DATE('" + STARTDATE.Text.Trim() + "','YYYY/MM/DD HH24:MI:SS')";
            }
            if (!string.IsNullOrEmpty(ENDDATE.Text.Trim()))
            {
                e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") +
                    "OPERATE_DATE < TO_DATE('" + ENDDATE.Text.Trim() + "','YYYY/MM/DD HH24:MI:SS')";
            }
            e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") +
                "COMMODITY_ID NOT IN (SELECT Field_Value FROM HIGHWAY_STORAGE.T_MODIFYFROMSTORAGE WHERE HIGHWAYPROINST_ID = " +
                    Request["ID"].ToDecrypt() + " AND Table_Name = 'T_COMMODITY' AND Field_Name = 'COMMODITY_ID')";
            //排序
            e.AddOrderByParams(GridViewOrderBy1);
        }
        #endregion

        #region 方法 -> 加载服务区下拉框【根据用户信息】
        public void BindDropDownList_SERVERPART()
        {
            SERVERPART_ID.Items.Clear();
            ListItemEx _ListItemFirst = new ListItemEx();
            _ListItemFirst.Text = "全部";
            _ListItemFirst.Value = "1=1";
            SERVERPART_ID.Items.Insert(0, _ListItemFirst);
            foreach (Business.SERVERPART _SERVERPART in new Business.SERVERPART(Transaction).GetPassportServerPart(PassportInfo.CityAuthority))
            {
                ListItemEx _ListItemEx = new ListItemEx();
                _ListItemEx.Value = _SERVERPART.SERVERPART_ID.ToString();
                _ListItemEx.Text = _SERVERPART.SERVERPART_NAME;
                SERVERPART_ID.Items.Add(_ListItemEx);
            }
            SERVERPART_ID.SelectedValue = SERVERPARTID;
        }
        #endregion

        protected void SERVERPART_ID_CallBackSetControl(object sender, ClientSetEventArgs e)
        {
            Session["SERVERPART_ID_SELECT_VALUE"] = e.Argument;
            ButtonSearch_CallBackClick(null, e);
        }

        #region 方法 -> 消息推送
        protected void BtnSend_Click(object sender, EventArgs e)
        {
            string _COMMODITY_ID = "";
            foreach (GridViewRow _GridViewRow in GridViewEx1.Rows)
            {
                if (_GridViewRow.RowType == DataControlRowType.DataRow)
                {
                    CheckBoxEx _CheckBox = _GridViewRow.Cells[1].FindControl("CheckBox_Select") as CheckBoxEx;

                    if (_CheckBox.Checked)
                    {
                        _COMMODITY_ID += (string.IsNullOrEmpty(_COMMODITY_ID) ? "" : ",") +
                            GridViewEx1.DataKeys[_GridViewRow.RowIndex]["COMMODITY_ID"].ToString();
                    }
                }
            }

            if (string.IsNullOrEmpty(_COMMODITY_ID))
            {
                Alert("请勾选商品后推送调价信息！");
                return;
            }
            else
            {
                Business.HIGHWAYPROINST _HIGHWAYPROINST = new Business.HIGHWAYPROINST(Transaction);
                _HIGHWAYPROINST.Dept_ID = int.Parse(SERVERPARTID);
                _HIGHWAYPROINST.Dept_Name = "统一定价商品调整";
                _HIGHWAYPROINST.HIGHWAYPROINST_CREATEDATE = DateTime.Now;
                _HIGHWAYPROINST.HIGHWAYPROINST_ENDDATE = DateTime.Now;
                _HIGHWAYPROINST.Staff_Id = PassportInfo.ID;
                _HIGHWAYPROINST.Staff_Name = PassportInfo.Name;
                _HIGHWAYPROINST.HIGHWAYPROINST_DESC = "统一定价商品调价推送";
                _HIGHWAYPROINST.Insert();

                foreach (string str in _COMMODITY_ID.Split(','))
                {
                    Business.MODIFYFROMSTORAGE _MODIFYFROMSTORAGE = new Business.MODIFYFROMSTORAGE(Transaction);
                    _MODIFYFROMSTORAGE.HIGHWAYPROINST_ID = _HIGHWAYPROINST.HIGHWAYPROINST_ID;
                    _MODIFYFROMSTORAGE.Table_Name = "T_COMMODITY";
                    _MODIFYFROMSTORAGE.Field_Name = "COMMODITY_ID";
                    _MODIFYFROMSTORAGE.Field_Value = str;
                    _MODIFYFROMSTORAGE.Insert();
                }
                string ErrorString = "";
                MSPB.GROUPPUSHDETAIL _GROUPPUSHDETAIL = new MSPB.GROUPPUSHDETAIL(Transaction);
                _GROUPPUSHDETAIL.PUSH_TITLE = "您的店铺有" + _COMMODITY_ID.Split(',').Length + "件商品发生价格变动,请点击详情查看信息！";
                _GROUPPUSHDETAIL.PUSH_FIRSTCONTENT = DateTime.Now.ToString("yyyyMMddHHmmss");
                _GROUPPUSHDETAIL.PUSH_SECONDCONTENT = _HIGHWAYPROINST.HIGHWAYPROINST_ENDDATE.ToString();
                foreach (MSPB.RTWECHATPUSH _RTWECHATPUSH in new MSPB.RTWECHATPUSH(Transaction).FillCollection(
                    "WHERE RTWECHATPUSH_ID IN (SELECT RTWECHATPUSH_ID FROM T_RTWECAHTPUSHDTAIL WHERE PUSH_MODULE LIKE '%" +
                        PUSH_MODULE.Text + "%')"))
                {
                    if (!MSPB.CommonHelper.StartToSend(PUSH_MODULE.Text, access_token, _RTWECHATPUSH,
                        _GROUPPUSHDETAIL, 2, RefreshTime, AppID.Text, AppSecret.Text,
                        "http://eshangtech.com:8000/GoodsApproval/Business/index.html?HIGHWAYPROINST_ID=" +
                        _HIGHWAYPROINST.HIGHWAYPROINST_ID_Encrypt))
                    {
                        ErrorString += (string.IsNullOrEmpty(ErrorString) ? "" : ",") + _RTWECHATPUSH.USER_NAME;
                    }
                }

                Alert("发送完成!" + (string.IsNullOrEmpty(ErrorString) ? "" : "其中" + ErrorString + "发送失败!"));
            }
        }
        #endregion

        #region 方法 -> 选择推送商品
        protected void ButtonNew_Click(object sender, EventArgs e)
        {
            int AddCount = 0;
            foreach (GridViewRow _GVR in GridViewEx1.Rows)
            {
                if (_GVR.RowType == DataControlRowType.DataRow)
                {
                    CheckBoxEx _CheckBox = _GVR.Cells[1].FindControl("CheckBox_Select") as CheckBoxEx;
                    if (_CheckBox.Checked)
                    {
                        string _COMMODITY_ID = GridViewEx1.DataKeys[_GVR.RowIndex]["COMMODITY_ID"].ToString();

                        Business.MODIFYFROMSTORAGE _MODIFYFROMSTORAGE = new Business.MODIFYFROMSTORAGE(Transaction);
                        if (_MODIFYFROMSTORAGE.GetCount("WHERE Field_Value = " + _COMMODITY_ID + " AND HIGHWAYPROINST_ID = " +
                            Request["ID"].ToDecrypt() + " AND Table_Name = 'T_COMMODITY' AND Field_Name = 'COMMODITY_ID'") == 0)
                        {
                            _MODIFYFROMSTORAGE.ResetProperty();
                            _MODIFYFROMSTORAGE.HIGHWAYPROINST_ID = Request["ID"].ToDecryptInt32();
                            _MODIFYFROMSTORAGE.Table_Name = "T_COMMODITY";
                            _MODIFYFROMSTORAGE.Field_Name = "COMMODITY_ID";
                            _MODIFYFROMSTORAGE.Field_Value = _COMMODITY_ID;
                            _MODIFYFROMSTORAGE.Insert();
                            AddCount++;
                        }
                    }
                }
            }
            if (AddCount == 0)
            {
                Alert("请勾选商品进行添加!");
            }
            else
            {
                Alert("选择成功 !", 3);
            }
            //初始化并加载列表
            GridViewEx1.SelectingWithInit<Business.RTSUPPLIER>(ObjectDataSource1, GridPageEx1,
                DictionaryHelper.GetDictionary(Transaction, "BUSINESSTYPE"),
                DictionaryHelper.GetDictionary(Transaction, "COMMODITYGRADE").AsNewKeys("COMMODITY_GRADE"),
                DictionaryHelper.GetDictionary(Transaction, "COMMODITYSTATE").AsNewKeys("COMMODITY_STATE"));
            //选取完成关闭
            //RefreshOpenerGridPage(RefreshGridPageType.Insert, AddCount);
            ExecClientScript("$('#pop-dialog-frame-HighWayProinstPage',parent.parent.document).attr('src', " +
                "'/HighWay/Modules/Commodity/HighWayProinstPage.aspx?ID=" + Request["ID"] +
                "&PopDialogPageName=F_R_GridPageEx1&PopDialogName=HighWayProinstPage&r=0.7170074964121915')");
        }
        #endregion
    }
}