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 System.Text.RegularExpressions;

namespace GThinking.N_XLJC
{
    public partial class XLXLXHInfo : SingleCardBase
    {
        XLXHB entity = new XLXHB();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421000;
            this.UMName = "线缆型号";
            base.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            if (!IsPostBack)
            {
                InitControls();
            }

            base.InitPage();
        }

        #region 模板继承事件

        protected override void LoadRecord()
        {
            if (!this.IsPostBack)
            {
                entity.Param.Add("XLXHB_XLXHID", PageParam.GetRTrimString("XLXHB_XLXHID").Trim());
            }
            else
            {
                entity.Param.Add("XLXHB_XLXHID", txtXLXHID_OLD.Value.Trim());
            }

            base.LoadRecord();
        }

        protected override void OnNewRecorder()
        {
            base.OnNewRecorder();

            datQYRQ.Text = CMISproConvert.ConvertDate(System.DateTime.Now);
            chkTY.Checked = false;
            datTYRQ.Text = "";
            txtXLXHBH.Text = "";
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
            cbxGGJDGZ.SelectedValue = "0";

        }

        protected override void OnCopyRecorder()
        {
            base.OnCopyRecorder();

            datQYRQ.Text = CMISproConvert.ConvertDate(System.DateTime.Now);
            chkTY.Checked = false;
            datTYRQ.Text = "";
            txtXLXHBH.Text = "";
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
            cbxGGJDGZ.SelectedValue = "0";
        }

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

        protected override bool DataLogicValid()
        {
            if (txtXLXHID.Text.ToString().Trim().Equals(""))
            {
                ShowMessage("线缆型号编码不允许为空！");
                return false;
            }


            if (cbxCPYT.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("产品用途不允许为空！");
                return false;
            }

            if (cbxGGJDGZ.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("规格解读规则不允许为空！");
                return false;
            }
            return base.DataLogicValid();
        }

        protected override bool CanDelete()
        {

            return base.CanDelete();
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            return base.Master_BeforeDeleteAction(sender, e);
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
            if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
            {
                //txtXLXHBH.Text = GetMaxBH().ToString().Trim().PadLeft(4, '0');
                txtXLXHBH.Text = "";
            }
            return base.Master_BeforeSaveAction(sender, e);
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            if (!base.Master_AfterSaveAction(sender, e))
            {
                return false;
            }
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select XLCPYT_CPYT,XLCPYT_CPYTMC from XLCPYT where XLCPYT_CPYT = 'NNNN' ");
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count == 0)
            {
                SQL.Clear();
                SQL.Add(" insert into XLCPYT(XLCPYT_CPYT,XLCPYT_CPYTMC,XLCPYT_WHR,XLCPYT_WHRID,XLCPYT_WHSJ,XLCPYT_XSSX)");
                SQL.Add(" values(:XLCPYT_CPYT,:XLCPYT_CPYTMC,:XLCPYT_WHR,:XLCPYT_WHRID,:XLCPYT_WHSJ,:XLCPYT_XSSX)");
                SQL.ParamByName("XLCPYT_CPYT").Value = "NNNN";
                SQL.ParamByName("XLCPYT_CPYTMC").Value = "非线缆产品";
                SQL.ParamByName("XLCPYT_WHR").Value = tSession.UserName;
                SQL.ParamByName("XLCPYT_WHRID").Value = tSession.UserId;
                SQL.ParamByName("XLCPYT_WHSJ").Value = DateTime.Now;
                SQL.ParamByName("XLCPYT_XSSX").Value = 0;
                dberp.ExecSQL(SQL);
            }
            txtXLXHID_OLD.Value = txtXLXHID.Text.Trim();

            return true;
        }


        protected override void SetComboxItems()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Clear();
            string sCPYT = cbxCPYT.SelectedValue.Trim();
            cbxCPYT.ClearItems();
            if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
            {
                cbxCPYT.Items.Add(new ListItem("非线缆产品", "NNNN"));
            }
            else
            {
                if (sCPYT.Equals("NNNN"))
                {
                    cbxCPYT.Items.Add(new ListItem("非线缆产品", "NNNN"));
                }
                else
                {
                    sSQL.Add("select XLCPYT_CPYT,XLCPYT_CPYTMC from XLCPYT where 1=1 and XLCPYT_CPYT <> 'NNNN' order by XLCPYT_CPYT ");
                    DataSet ds = dberp.OpenDataSet(sSQL);
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        cbxCPYT.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLCPYT_CPYTMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLCPYT_CPYT"].ToString().Trim()));
                    }
                }
            }

            cbxGGJDGZ.ClearItems();
            cbxGGJDGZ.Items.Add(new ListItem("mm2-芯数截面", "0"));
            cbxGGJDGZ.Items.Add(new ListItem("mm2-绞型线", "1"));
            cbxGGJDGZ.Items.Add(new ListItem("mm-信号线", "2"));
            cbxGGJDGZ.Items.Add(new ListItem("mm2-矿缆", "3"));
            cbxGGJDGZ.Items.Add(new ListItem("mm-矿缆", "4"));
            cbxGGJDGZ.Items.Add(new ListItem("射频电缆", "5"));
            cbxGGJDGZ.Items.Add(new ListItem("安装线", "6"));
            cbxGGJDGZ.Items.Add(new ListItem("绕粗线", "7"));

            base.SetComboxItems();
        }

        #endregion

        #region 自定义事件

        private void InitControls()
        {
            
        }

        private int GetMaxBH()
        {
            int iBH = 0;
            string SQL = "select max(XLXHB_XLXHBH) as XLXHB_XLXHBH from XLXHB where 1=1 ";
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Add(SQL);
            DataSet ds = dberp.OpenDataSet(sSQL);
            iBH = CMISproConvert.StrToInt(ds.Tables[0].Rows[0][0].ToString().Trim());
            return iBH + 1;

        }

        #endregion

        #region 控件事件

        protected void txtXLJBXHID_OnTextChanged(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                if (!txtXLJBXHID.Text.Trim().Equals(""))
                {
                    TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                    TSQL sSQL = new TSQL(dberp);
                    sSQL.Add("select XLXHB_CPYT from XLXHB where 1=1 and XLXHB_XLJBXHID = :XLXHB_XLJBXHID order by XLXHB_XLXHID ");
                    sSQL.ParamByName("XLXHB_XLJBXHID").Value = txtXLJBXHID.Text.Trim();
                    DataSet ds = dberp.OpenDataSet(sSQL);
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        cbxCPYT.SelectedValue = ds.Tables[0].Rows[0][0].ToString().Trim();
                    }
                    else
                    {
                        cbxCPYT.SelectedValue = "";
                    }
                }
                else
                {
                    cbxCPYT.SelectedValue = "";
                }
            }
        }


        protected void chkTY_CheckedChanged(object sender, EventArgs e)
        {
            if (chkTY.Checked == true)
            {
                datTYRQ.Text = CMISproConvert.ConvertDate(System.DateTime.Now);
            }
            else
            {
                datQYRQ.Text = CMISproConvert.ConvertDate(System.DateTime.Now);
                datTYRQ.Text = "";
            }
        }

        protected void datTYRQ_TextChanged(object sender, EventArgs e)
        {
            if (!datTYRQ.Text.ToString().Equals(""))
                chkTY.Checked = true;
            else
                chkTY.Checked = false;
        }
        #endregion

    }
}