using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC;
using GThinking.N_MISPRO.Caching;

namespace GThinking.N_XLXSBJ
{
    public partial class JGBML_SelXSQYInfo : SingleCardBase
    {
        JGBML_SelXSQY entity = new JGBML_SelXSQY();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860018;
            this.UMName = "适用区域";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 180;
            this.PageWidth = 420;

            Master.EnableAttachBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableInsertBtn = false;
            Master.EnablePrintBtn = false;
            Master.EnableRefreshBtn = false;
            Master.EnableSaveBtn = false;

            base.InitPage();

            if (!IsPostBack)
            {
                cbxSYQY.Width = Unit.Pixel(PageWidth - 65 - 55);
            }

            if (!IsPostBack)
            {
                InitControl();
            }
        }

        #region 模板继承事件

        #endregion

        #region 自定义函数

        private void InitControl()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select XSQY_XSQYID,XSQY_XSQYMC from XSQY where ISNULL(XSQY_TYBZ,'N')<>'Y' order by XSQY_XSQYID");
            DataSet ds = dberp.OpenDataSet(SQL);
            cbxSYQY.ClearItems();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string sXSQYID = ds.Tables[0].Rows[i]["XSQY_XSQYID"].ToString().Trim();
                string sXSQYMC = ds.Tables[0].Rows[i]["XSQY_XSQYMC"].ToString().Trim();
                cbxSYQY.Items.Add(new ListItem(sXSQYID + "|" + sXSQYMC, sXSQYID));
               
            }
            SQL.Clear();
            ds.Clear();
            SQL.Add("select XLXSJGB_XSQYIDS from XLXSJGB where XLXSJGB_JGBID= :pJGBID  and XLXSJGB_MXBH= :pMXBH");
            SQL.ParamByName("pJGBID").Value = PageParam.GetRTrimString("JGBID");
            SQL.ParamByName("pMXBH").Value = PageParam.GetRTrimString("MXBH");
            ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                cbxSYQY.SelectedValue = ds.Tables[0].Rows[0]["XLXSJGB_XSQYIDS"].ToString().Trim(); ;
            }
        }
        #endregion

        #region 控件事件
        protected void btnQR_Click(object sender, EventArgs e)
        {
            //加载XLXSJGB_MXBH='JGB'&XLXSJGB_TJYS='1'的XLXSJGB记录，多选记录后点确认，更新字段XLXSJGB_JGBIDS
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            if (cbxSYQY.SelectedValue.Trim().Length <= 250)
            { 
               try
               {
                   dberp.BeginTrans();
                   SQL.Clear();
                   SQL.Add("update XLXSJGB set XLXSJGB_XSQYIDS= :pXSQYIDS ");
                   SQL.Add("  where XLXSJGB_JGBID= :pJGBID ");
                   SQL.Add("  and XLXSJGB_MXBH= :pMXBH ");
                   SQL.ParamByName("pXSQYIDS").Value = cbxSYQY.SelectedValue.Trim();
                   SQL.ParamByName("pJGBID").Value = PageParam.GetRTrimString("JGBID");
                   SQL.ParamByName("pMXBH").Value = PageParam.GetRTrimString("MXBH");
                   dberp.ExecSQL(SQL);
                   dberp.CommitTrans();
                   CacheNotify.TableIsUpdated("DBERP", "XLXSJGB");
                   ShowMessage("调整成功！");
               }
               catch (Exception ex)
               {
                   ShowMessage("选择适用区域出错，请联系系统管理员！错误原因：" + ex);
                   dberp.RollbackTrans();
               }    
            }
            else if (cbxSYQY.SelectedValue.Trim().Length > 250)
            {
                ShowMessage("选择的适用区域过多，请调整！");
            }
            else
            {
 
            }
            //使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
            DialogOperationScript dos = new DialogOperationScript(this);
            //dos.ClickOwnerButton(PageParam.GetRTrimString("RefreshCtrlID"));
            dos.CloseSelf();
            dos.Execute();
        }

        protected void btnQX_Click(object sender, EventArgs e)
        {
            CloseWindow();
        }

        #endregion
    }
}