using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
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 System.Data;
using MSB = SuperMap.RealEstate.MainTenance.Storage.Business;

namespace SuperMap.RealEstate.MainTenance.Storage.Modules.ProblemCollection
{
    public partial class ProblemCollection : UserControl<Business.PROBLEMCOLLECTION>
    {
        #region 页面加载事件
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            //如果传入的有ID则绑定相应的服务区信息
            if (!String.IsNullOrEmpty(Request["ID"]))
            {
                string sql = "SELECT PROVINCE_CODE,SERVERPART_NAME FROM MAINTENANCE_STORAGE.T_PROBLEMCOLLECTION WHERE PROBLEMCOLLECTION_ID = " +
                    Request["ID"].ToDecrypt();
                MSB.PROBLEMCOLLECTION _PROBLEMCOLLECTION = new MSB.PROBLEMCOLLECTION(Transaction);
                DataTable dt = _PROBLEMCOLLECTION.ExecuteDataTable(sql);
                string _SelectSql = "SELECT SERVERPART_NAME FROM HIGHWAY_STORAGE.T_SERVERPART WHERE PROVINCE_CODE = " +
                    dt.Rows[0]["PROVINCE_CODE"];
                DataTable _DataTable = _PROBLEMCOLLECTION.ExecuteDataTable(_SelectSql);
                ListItemEx _ListItemEx = new ListItemEx();
                foreach (DataRow dr in _DataTable.Rows)
                {
                    _ListItemEx = new ListItemEx();
                    _ListItemEx.Text = dr["SERVERPART_NAME"].ToString();
                    _ListItemEx.Value = dr["SERVERPART_NAME"].ToString();
                    if (dr["SERVERPART_NAME"].ToString().Contains(dt.Rows[0]["SERVERPART_NAME"].ToString()))
                    {
                        _ListItemEx.Selected = true;
                    }
                    SERVERPART_NAME.Items.Add(_ListItemEx);
                }
            }
            else
            {
                //报修时间默认值
                REPAIR_DATE.Text = DateTime.Now.Date.ToString();
                //处理时间默认值
                TREAT_DATE.Text = DateTime.Now.ToString();
                //协助人
                ASSIST_PERSON.SelectedValue = this.Page.PassportInfo.Name;
            }
        }
        #endregion

        #region 在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
        public override void InitializeWebControl()
        {
            //绑定维护类型
            DictionaryHelper.BindingDropDownList("PROBLEM_TYPE", PROBLEM_TYPE.Items,Transaction);
            //绑定对接人员
            DictionaryHelper.BindingDropDownList("ASSIST_PERSON", ASSIST_PERSON.Items, Transaction);
            //绑定问题状态
            DictionaryHelper.BindingDropDownList("PROBLEM_STATUS", PROBLEM_STATUS.Items, Transaction);
            //绑定是否解决
            DictionaryHelper.BindingDropDownList("ISSOLVED", ISSOLVED.Items, Transaction);
            //绑定故障类型
            DictionaryHelper.BindingDropDownList("FAULT_TYPE", FAULT_TYPE.Items, Transaction);
            //绑定功能模块
            DictionaryHelper.BindingDropDownList("MODULE_TYPE", MODULE_TYPE.Items, Transaction);
            //绑定处理人
            DictionaryHelper.BindingDropDownList("TREAT_PERSON", TREAT_PERSON.Items, Transaction);
            //绑定重复问题
            DictionaryHelper.BindingDropDownList("REPEAT_PROBLEM", REPEAT_PROBLEM.Items, Transaction);

            //绑定省份下拉框
            string _SelectSql = @"SELECT FIELDENUM_NAME,FIELDENUM_ID FROM PLATFORM_DICTIONARY.T_FIELDENUM A 
                WHERE EXISTS(SELECT 1 FROM PLATFORM_DICTIONARY.T_FIELDEXPLAIN B WHERE A.FIELDEXPLAIN_ID = B.FIELDEXPLAIN_ID AND 
                    FIELDEXPLAIN_FIELD = 'DIVISION_CODE') AND FIELDENUM_PID = -1 ORDER BY FIELDENUM_INDEX";
            DataTable table = new MSB.PROBLEMCOLLECTION(Transaction).ExecuteDataTable(_SelectSql);
            ListItemEx _ListItemEx = new ListItemEx();
            foreach (DataRow dr in table.Rows)
            {
                _ListItemEx = new ListItemEx();
                _ListItemEx.Text = dr["FIELDENUM_NAME"].ToString();
                _ListItemEx.Value = dr["FIELDENUM_ID"].ToString();
                PROVINCE_CODE.Items.Add(_ListItemEx);
            }
        }
        #endregion

        #region 载入数据
        public override bool LoadData()
        {
            //如果是工作流组件请自行修改载入的逻辑，以下是功能模块的默认代码
            if (!String.IsNullOrEmpty(Request["ID"]))
            {
                CurrObject.PROBLEMCOLLECTION_ID_Encrypt = Request["ID"];
                return this.Select();
            }
            //默认返回值，工作流组件返回True,功能模块返回False。
            return (WorkFlowPage != null);
        }
        #endregion

        //OnDataAction_XXXXX 有一个系列可用,在此加入界面的逻辑处理
        //e.CancelDataAction 来处理是否取消该动作;
        //失败的原因可以用Page.Alert()传递到页面
        public override void OnDataAction_BeforeSave(DataActionEventArgs<Business.PROBLEMCOLLECTION> e)
        {
            e.CurrObject.PROBLEM_CODE = PROBLEM_CODE.Text;
            base.OnDataAction_BeforeSave(e);
        }

        #region 省份下拉框改变
        protected void PROVINCE_CODE_CallBackSetControl(object sender, ClientSetEventArgs e)
        {
            //当省份改变时服务重新绑定
            string PROVINCE_ID = PROVINCE_CODE.SelectedItem.Value;
            SERVERPART_NAME.Items.Clear();
            SERVERPART_NAME.Items.Add(new ListItemEx("", ""));
            string _SelectSql = "SELECT SERVERPART_NAME FROM HIGHWAY_STORAGE.T_SERVERPART WHERE PROVINCE_CODE = " +
                int.Parse(PROVINCE_CODE.SelectedValue);
            DataTable _DataTable = new MSB.PROBLEMCOLLECTION(Transaction).ExecuteDataTable(_SelectSql);
            ListItemEx _ListItemEx = new ListItemEx();
            foreach (DataRow dr in _DataTable.Rows)
            {
                _ListItemEx = new ListItemEx();
                _ListItemEx.Text = dr["SERVERPART_NAME"].ToString();
                _ListItemEx.Value = dr["SERVERPART_NAME"].ToString();
                SERVERPART_NAME.Items.Add(_ListItemEx);
            }

            e.SetDropDownListEx(SERVERPART_NAME);
        }
        #endregion
    }
}