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 StorageHighWay = SuperMap.RealEstate.HighWay.Storage.Business;
using SuperMap.RealEstate.HighWay.Storage.Business;

namespace SuperMap.RealEstate.ExchangeData.Modules.WebConfig
{
    public partial class Info : UserControl<Business.MOBILEPAYCONFIG>
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;

            if (!String.IsNullOrEmpty(Request["ID"]))
            {
                CurrObject.MOBILEPAYCONFIG_ID_Encrypt = Request["ID"];
                SERVERPART_ID.SelectedValue = CurrObject.SERVERPART_ID.ToString();
                SERVERPART_ID.Enabled = false;
                SHOPCODE.Visible = true;
                BUSINESS_CODE.Visible = true;
                TERM_CODE.Visible = true;
                SHOPCODE.Enabled = false;
                BUSINESS_CODE.Enabled = false;
                TERM_CODE.Enabled = false;
            }
        }

        //载入数据
        public override bool LoadData()
        {
            this.STAFF_ID.Text = Page.PassportInfo.ID.ToString();
            this.STAFF_NAME.Text = Page.PassportInfo.Name;
            this.OPERATE_DATE.Text = System.DateTime.Now.ToString();
            this.MOBILEPAYCONFIG_TYPE.Text = "1";

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

        //在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
        public override void InitializeWebControl()
        {
            SERVERPART_ID.Clear();
            foreach (DataRow _DataRow in (new StorageHighWay.SERVERPART(this.Transaction)).ExecuteDataTable(
                @"SELECT * FROM HIGHWAY_STORAGE.T_SERVERPART A WHERE EXISTS(SELECT 1 FROM HIGHWAY_STORAGE.T_SERVERPARTSHOP B 
                    WHERE A.SERVERPART_ID = B.SERVERPART_ID) AND NOT EXISTS (SELECT 1 FROM T_MOBILEPAYCONFIG@NEWEX B 
                    WHERE MOBILEPAYCONFIG_TYPE = 1 AND A.SERVERPART_ID = B.SERVERPART_ID" + (string.IsNullOrEmpty(Request["ID"]) ?
                        "" : " AND MOBILEPAYCONFIG_ID NOT IN (" + Request["ID"].ToDecrypt() + ")") +
                    ") ORDER BY SERVERPART_INDEX,SERVERPART_CODE,SERVERPART_NAME").Rows)
            {
                ListItemEx _ListItemEx = new ListItemEx();
                _ListItemEx.Text = _DataRow["SERVERPART_NAME"].ToString();
                _ListItemEx.Value = _DataRow["SERVERPART_ID"].ToString();
                SERVERPART_ID.Items.Add(_ListItemEx);
            }
        }

        protected void SERVERPART_ID_CallBackSetControl(object sender, ClientSetEventArgs e)
        {
            string StrSql = string.Empty;
            using (StorageHighWay.SERVERPART _SERVERPART = new StorageHighWay.SERVERPART(Transaction))
            {
                _SERVERPART.SERVERPART_ID = int.Parse(e.Argument);
                if (_SERVERPART.Select())
                {
                    e.SetValue(SERVERPART_CODE, _SERVERPART.SERVERPART_CODE);
                    e.SetValue(SERVERPART_NAME, _SERVERPART.SERVERPART_NAME);
                }
            }
        }

        //OnDataAction_XXXXX 有一个系列可用,在此加入界面的逻辑处理
        //e.CancelDataAction 来处理是否取消该动作;
        //失败的原因可以用Page.Alert()传递到页面
        public override void OnDataAction_BeforeSave(DataActionEventArgs<Business.MOBILEPAYCONFIG> e)
        {
            if (!string.IsNullOrEmpty(Request["ID"]) || !string.IsNullOrEmpty(MOBILEPAYCONFIG_ID.Text))
            {
                Business.MOBILEPAYCONFIG _MOBILEPAYCONFIG_HIS = new Business.MOBILEPAYCONFIG(Transaction);
                _MOBILEPAYCONFIG_HIS.ExecuteNonQuery(@"INSERT INTO HIGHWAY_EXCHANGE.T_MOBILEPAYCONFIG_HIS (
                        MOBILEPAYCONFIG_ID,SERVERPART_ID,SERVERPART_CODE,SERVERPART_NAME,MOBILEPAYCONFIG_TYPE,
                        SHOPCODE,SHOPNAME,BUSINESS_CODE,TERM_CODE,CONNECTSTRING,CONNECTSTRINGBLD,ORACLEHELPERSTRING,
                        ORACLEHELPERSTRINGSP,ORACLEHELPERSTRINGPS,STAFF_ID,STAFF_NAME,OPERATE_DATE,MOBILEPAYCONFIGDESC)
                    SELECT MOBILEPAYCONFIG_ID,SERVERPART_ID,SERVERPART_CODE,SERVERPART_NAME,MOBILEPAYCONFIG_TYPE,
                        SHOPCODE,SHOPNAME,BUSINESS_CODE,TERM_CODE,CONNECTSTRING,CONNECTSTRINGBLD,ORACLEHELPERSTRING,
                        ORACLEHELPERSTRINGSP,ORACLEHELPERSTRINGPS,STAFF_ID,STAFF_NAME,SYSDATE,'" + Page.PassportInfo.Name +
                        "修改了内容' FROM HIGHWAY_EXCHANGE.T_MOBILEPAYCONFIG WHERE MOBILEPAYCONFIG_ID = " +
                        e.CurrObject.MOBILEPAYCONFIG_ID, null);
            }
            base.OnDataAction_BeforeSave(e);
        }
    }
}