using System;
using System.Data;
using System.Linq;
using System.Web.UI;
using System.Web.UI.WebControls;
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 Storage = SuperMap.RealEstate.HighWay.Storage;

namespace SuperMap.RealEstate.HighWay.Compents.Commodity
{
    /// <summary>
    /// T_COMMODITY_商品管理 的WebUserControl
    /// <summary>
    public partial class Default : UserControl<Running.Business.COMMODITY>
    {
        //流程实例
        Running.Business.HIGHWAYPROINST _HighWayProInst = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
                return;
            GridViewEx1.SelectingWithInit<Running.Business.COMMODITY>(ObjectDataSource1, GridPageEx1,
                DictionaryHelper.GetDictionary(Transaction, "COMMODITYGRADE").AsNewKeys("COMMODITY_GRADE"));
            //工具条按钮事件
            GridViewEx1.SetOpenControl(ButtonNew, "/HighWay/Compents/Commodity/COMMODITYPage.aspx", "HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID.ToEncrypt());
            //设置回车焦点按钮
            //SetControlClientAction(ButtonSearch);
        }

        protected override void OnInit(EventArgs e)
        {
            Common.PageHelper.CreateHeaderStyle(Page);
            _HighWayProInst = Running.Business.HIGHWAYPROINST.CreateInstance(Page);
            base.ButtonVisible = false;
            base.OnInit(e);
        }

        //在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
        public override void InitializeWebControl()
        {
            //加载对应的数据
        }


        //载入数据
        public override bool LoadData()
        {
            //加载对应的
            foreach(Running.Business.MODIFYFROMSTORAGE _MODIFYFROMSTORAGE in (new Running.Business.MODIFYFROMSTORAGE()).FillCollection(
                "WHERE HIGHWAYPROINST_ID =" + (_HighWayProInst.HIGHWAYPROINST_ID == null ? 0 : _HighWayProInst.HIGHWAYPROINST_ID)))
            {
                if (_MODIFYFROMSTORAGE.Table_Name == "T_COMMODITY" && _MODIFYFROMSTORAGE.Field_Name == "COMMODITY_ID")
                {
                    Running.Business.COMMODITY _COMMODITY = new Running.Business.COMMODITY(this.Transaction);
                    _COMMODITY.COMMODITY_ID = int.Parse(_MODIFYFROMSTORAGE.Field_Value);
                    if (_COMMODITY.Select())
                    {
                        if (int.Parse(_COMMODITY.ExecuteDataTable("select COUNT(COMMODITY_CODE) from HIGHWAY_STORAGE.V_ALL_COMMODITY WHERE COMMODITY_BARCODE = '" +
                            _COMMODITY.COMMODITY_BARCODE + "'" + " AND COMMODITY_ID != " + _COMMODITY.COMMODITY_ID + 
                            " AND SERVERPART_ID = " + _COMMODITY.SERVERPART_ID).Rows[0][0].ToString()) > 0)
                        {
                            throw new Exception("注意:商品条码为" + _COMMODITY.COMMODITY_BARCODE + "已存在于您的服务区!请验证后重新录入!");
                        }
                    }
                }
            }
            return true;
        }

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

        //查询
        protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e)
        {
            GridViewEx1.Selecting<Running.Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
            //设置UI变化
            e.SetValue(GridViewEx1);
            e.SetValue(GridPageEx1);
        }

        protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e)
        {
            if (!string.IsNullOrEmpty(TextBox_Search.Text))
                e.AddOrParams(GridViewSearch1, TextBox_Search.Text);
            //搜索选项的搜索条件过滤
            if (e.Parameters.Count > 0)
            {
                e.SetOtherUserCustomWhereSqlString = "AND COMMODITY_ID IN(SELECT FIELD_VALUE FROM HIGHWAY_RUNNING.T_MODIFYFROMSTORAGE WHERE HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID + ")";
            }
            else
            {
                e.SetOtherUserCustomWhereSqlString = "COMMODITY_ID IN(SELECT FIELD_VALUE FROM HIGHWAY_RUNNING.T_MODIFYFROMSTORAGE WHERE HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID + ")";
            }
            //排序
            e.AddOrderByParams(GridViewOrderBy1);
        }

        protected void GridViewEx1_CallBackClick(object sender, ClientSetEventArgs e)
        {
            string _Key_ID = e.Argument;
            e.ExcuteClientScript(GridViewEx1.GetOpenPopDialogClientScript("/HighWay/Compents/Commodity/COMMODITYPage.aspx?ID=" + _Key_ID + "&HIGHWAYPROINST_ID=" + (_HighWayProInst.HIGHWAYPROINST_ID.ToString().ToEncrypt())));
        }
    }
}