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_WORKFLOW;
using GThinking.N_PUBLIC;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC2;

namespace GThinking.N_XLJC
{
    public partial class XLXLGGInfo : SingleCardBase
    {
        XLXLGG entity = new XLXLGG();
        #region Page类事件继承

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421010;
            this.UMName = "线缆规格";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 500;
            this.PageWidth = 700;
            this.Master.EnableInsertBtn = false;
            this.Master.EnableCopyBtn = false;
            this.Master.EnableDeleteBtn = false;
            base.InitPage();
            if (!IsPostBack)
            {
                InitControls();
            }
        }
        #endregion
        #region 模板事件继承
        protected override void LoadRecord()
        {
            if (!this.IsPostBack)
            {
                this.CurEntity.Param.Add("XLGGB_XLGGID", PageParam.GetRTrimString("XLGGB_XLGGID").Trim());
                this.CurEntity.Param.Add("XLGGB_XLGGJDGZ", PageParam.GetRTrimString("XLGGB_XLGGJDGZ").Trim());
            }
            else
            {
                entity.Param.Add("XLGGB_XLGGID", txtOLDXLGGID.Value);
                entity.Param.Add("XLGGB_XLGGJDGZ", txtOLDXLGGJDGZ.Value.Trim());
            }
            base.LoadRecord();
            this.txtOLDXLGGID.Value = txtXLGGID.Text.Trim().ToString();
            this.txtOLDXLGGJDGZ.Value = hidXLGGJDGZ.Value;
        }
        protected override bool DataLogicValid()
        {
            if (txtDTJM5.Value > 0 && txtDTJM4.Value == 0)
            {
                ShowMessage("导体截面5大于0，导体截面4不允许为0！");
                return false;
            }
            if (txtDTJM5.Value > 0 && txtDTJM3.Value == 0)
            {
                ShowMessage("导体截面5大于0，导体截面3不允许为0！");
                return false;
            }
            if (txtDTJM5.Value > 0 && txtDTJM2.Value == 0)
            {
                ShowMessage("导体截面5大于0，导体截面2不允许为0！");
                return false;
            }
            if (txtDTJM5.Value > 0 && txtDTJM1.Value == 0)
            {
                ShowMessage("导体截面5大于0，导体截面1不允许为0！");
                return false;
            }
            if (txtDTJM4.Value > 0 && txtDTJM3.Value == 0)
            {
                ShowMessage("导体截面4大于0，导体截面3不允许为0！");
                return false;
            }
            if (txtDTJM4.Value > 0 && txtDTJM2.Value == 0)
            {
                ShowMessage("导体截面4大于0，导体截面2不允许为0！");
                return false;
            }
            if (txtDTJM4.Value > 0 && txtDTJM1.Value == 0)
            {
                ShowMessage("导体截面4大于0，导体截面1不允许为0！");
                return false;
            }
            if (txtDTJM3.Value > 0 && txtDTJM2.Value == 0)
            {
                ShowMessage("导体截面3大于0，导体截面2不允许为0！");
                return false;
            }
            if (txtDTJM3.Value > 0 && txtDTJM1.Value == 0)
            {
                ShowMessage("导体截面3大于0，导体截面1不允许为0！");
                return false;
            }
            if (txtDTJM2.Value > 0 && txtDTJM1.Value == 0)
            {
                ShowMessage("导体截面2大于0，导体截面1不允许为0！");
                return false;
            }
            return base.DataLogicValid();
        }

        protected override void OnCopyRecorder()
        {
            base.OnCopyRecorder();
            txtWHR.Text = tSession.UserName.ToString().Trim();
            txtWHRID.Value = tSession.UserId.ToString().Trim();
            datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
        }

        protected override void SetControlState()
        {
            base.SetControlState();
            txtWHR.Enabled = false;
            datWHSJ.Enabled = false;
            txtXH.Enabled = false;
            txtXLGGID.Enabled = false;
            txtDTJMZHID.Enabled = false;
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            if (!base.Master_AfterSaveAction(sender, e)) return false;
            txtOLDXLGGJDGZ.Value = hidXLGGJDGZ.Value;
            txtOLDXLGGID.Value = txtXLGGID.Text.Trim().ToString();

            string sSFXDList="";
            string sSLList="";
            sSFXDList=txtSFXD1.Value+","+txtSFXD2.Value+","+txtSFXD3.Value+","+txtSFXD4.Value+","+txtSFXD5.Value;
            sSLList=txtSL1.Value+","+txtSL2.Value+","+txtSL3.Value+","+txtSL4.Value+","+txtSL5.Value;
            N_PUBLIC2.XLGGService.SaveXLXXJGB(txtXXJGID.Text.Trim(), sSFXDList, sSLList);//调用公共方法插入XLXXJGB
            N_PUBLIC2.XLGGService.SaveXLDTJMZHB(txtDTJMZHID.Text.Trim());  //调用公共方法插入XLDTJMZHB
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Add(" update  XLGGB set XLGGB_XXJGID=:pXXJGID ,XLGGB_DTJMZHID=:pDTJMZHID where  XLGGB_XLGGID=:pXLGGB_XLGGID and XLGGB_XLGGJDGZ=:pXLGGB_XLGGJDGZ ");
            sSQL.ParamByName("pXXJGID").Value = txtXXJGID.Text.Trim();
            sSQL.ParamByName("pDTJMZHID").Value = txtDTJMZHID.Text.Trim();
            sSQL.ParamByName("pXLGGB_XLGGID").Value = PageParam.GetRTrimString("XLGGB_XLGGID").Trim();
            sSQL.ParamByName("pXLGGB_XLGGJDGZ").Value = PageParam.GetRTrimString("XLGGB_XLGGJDGZ").Trim();
            dberp.ExecSQL(sSQL);
            return true;
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            if (ControlState == TControlState.ctsEdit)
            {
                entity.Param.Add("OLDXLGGB_XLGGID", txtOLDXLGGID.Value);
                entity.Param.Add("OLDXLGGB_XLGGJDGZ", txtOLDXLGGJDGZ.Value);
            }
            return base.Master_BeforeSaveAction(sender, e);
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {

            return base.Master_BeforeDeleteAction(sender, e);
        }

        protected override void SetComboxItems()
        {
            base.SetComboxItems();
        
        }
 
        #endregion

        #region 自定义事件
        private void InitControls()
        {
            cbxXLGGDW.Items.Add(new ListItem("mm2", "mm2"));
            cbxXLGGDW.Items.Add(new ListItem("mm", "mm"));
            cbxXLGGDW.ShowValue = false;   

        }
        private void JmChange()
        {
            if (txtDTJM1.Value > 0)
            {
                txtDTJMZHID.Text = txtDTJM1.Value.ToString();
            }
            if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0)
            {
                txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value;
            }
            if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0)
            {
                txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value;
            }
            if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0 && txtDTJM4.Value > 0)
            {
                txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value + "/" + txtDTJM4.Value;
            }
            if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0 && txtDTJM4.Value > 0 && txtDTJM5.Value > 0)
            {
                txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value + "/" + txtDTJM4.Value + "/" + txtDTJM5.Value;
            }
        }
        #endregion

        #region 控件事件
        protected void txtXXJGID_TextChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select  XLXXJGB_SFXD1,XLXXJGB_SFXD2,XLXXJGB_SFXD3,XLXXJGB_SFXD4,XLXXJGB_SFXD5,XLXXJGB_SL1,XLXXJGB_SL2,XLXXJGB_SL3,XLXXJGB_SL4,XLXXJGB_SL5  from XLXXJGB ");
            SQL.Add("        where XLXXJGB_XXJGID = :pXXJGID ");
            SQL.ParamByName("pXXJGID").Value = txtXXJGID.Text.Trim();
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count >0)
            {
               txtSFXD1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD1"].ToString().Trim());
               txtSFXD2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD2"].ToString().Trim());
               txtSFXD3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD3"].ToString().Trim());
               txtSFXD4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD4"].ToString().Trim());
               txtSFXD5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD5"].ToString().Trim());
               txtSL1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL1"].ToString().Trim());
               txtSL2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL2"].ToString().Trim());
               txtSL3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL3"].ToString().Trim());
               txtSL4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL4"].ToString().Trim());
               txtSL5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL5"].ToString().Trim());
            }
        }

        //protected void txtDTJMZHID_TextChanged(object sender, EventArgs e)
        //{
        //    TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
        //    TSQL SQL = new TSQL(dberp);
        //    SQL.Clear();
        //    SQL.Add("select  XLDTJMZHB_DTJM1,XLDTJMZHB_DTJM2,XLDTJMZHB_DTJM3,XLDTJMZHB_DTJM4,XLDTJMZHB_DTJM5 FROM  XLDTJMZHB   ");
        //    SQL.Add("        where XLDTJMZHB_DTJMZHID = :pDTJMZHID ");
        //    SQL.ParamByName("pDTJMZHID").Value = txtDTJMZHID.Text.Trim();
        //    DataSet ds = dberp.OpenDataSet(SQL);
        //    if (ds.Tables[0].Rows.Count >0)
        //    {
        //       txtDTJM1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM1"].ToString().Trim());
        //       txtDTJM2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM2"].ToString().Trim());
        //       txtDTJM3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM3"].ToString().Trim());
        //       txtDTJM4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM4"].ToString().Trim());
        //       txtDTJM5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM5"].ToString().Trim());
        //    }
        //}
        protected void txtDTJM1_TextChanged(object sender, EventArgs e)
        {
            JmChange();
        }
        protected void txtDTJM2_TextChanged(object sender, EventArgs e)
        {
            JmChange();
        }
        protected void txtDTJM3_TextChanged(object sender, EventArgs e)
        {
            JmChange();
        }
        protected void txtDTJM4_TextChanged(object sender, EventArgs e)
        {
            JmChange();
        }
        protected void txtDTJM5_TextChanged(object sender, EventArgs e)
        {
            JmChange();
        }
        #endregion
    }

}