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 System.Collections.Generic;

namespace GThinking.N_XLJC
{
    [TableMap(DB = "DBERP", DbTableName = "XLJGCZBML", Umid = 101421008, IsWorkFlow = false, UseWhr = true, IsAttach = false,

        QuerySelSql = "",

        EntitySelSql = "",

        InsertSql = "",

        UpdateSql = "",

        DeleteSql = "")]
    public class XLJGCZB_XHMLOperEntity : EntityManager
    {
    }
    public partial class XLJGCZB_XHMLOper : SingleCardBase
    {
        XLJGCZB_XHMLOperEntity entity = new XLJGCZB_XHMLOperEntity();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421008;
            this.UMName = "线缆结构尺重表";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            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();
            //类型-工艺分类编码-对应按钮界面栏目数
            //A-无-4-不可用
            //B-/-4
            //C-有-6-必填
            //G-有/无-6/4-选填
            //Z-无-4-不可用

            //默认显示栏目数为4的界面（无工艺分类）
            cLSBZ.Style["display"] = "block";
            cCAPP.Style["display"] = "none";

            if ((PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) || PageParam.GetRTrimString("CZBLX").Equals("C"))
            {
                cLSBZ.Style["display"] = "none";
                cCAPP.Style["display"] = "block";
            }

            //表内表外
            cbxXLBZID_CAPP.Enabled = cbxXLBZID_LSBZ.Enabled = PageParam.GetRTrimString("XLBZBN").Equals("N");
            cbxDYDJID_CAPP.Enabled = cbxDYDJID_LSBZ.Enabled = PageParam.GetRTrimString("DYDJBN").Equals("N");
            cbxXLJBXHID_CAPP.Enabled = cbxXLJBXHID_LSBZ.Enabled = cbxXLXHID_CAPP.Enabled = cbxXLXHID_LSBZ.Enabled = PageParam.GetRTrimString("XLXHBN").Equals("N");
            if (!IsPostBack)
            {
                InitControl();
            }
        }

        #region 模板继承事件

        #endregion

        #region 自定义函数

        private void InitControl()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);

             DataSet ds;
            ///G|临时编制&Z|自主策划
            ///
            TComboBox.SetComboBox("DBERP", cbxXLBZID_LSBZ, "select XLBZ_XLBZID as ID,XLBZ_XLBZLXMC as Name from XLBZ where 1=1 order by XLBZ_XLBZID ", true);
            


            ///C|成套计算
            ///
            TComboBox.SetComboBox("DBERP", cbxXLBZID_CAPP, "select XLBZ_XLBZID as ID,XLBZ_XLBZLXMC as Name from XLBZ where 1=1 order by XLBZ_XLBZID ", true);
            TComboBox.SetComboBox("DBERP", cbxXLBZBH_CAPP, "select XLZXBZ_XLBZBH as ID, rtrim(XLZXBZ_XLBZMC) as Name from XLZXBZ where 1=1 order by XLZXBZ_XLBZID,XLZXBZ_XLBZBH ", true);

            //----------共
            //电压等级
            SQL.Clear();
            SQL.Add("select XLDYDJB_DYDJID from XLDYDJB where isnull(XLDYDJB_TYBZ,'N')<>'Y' order by XLDYDJB_XH  ");
            ds = dberp.OpenDataSet(SQL);
            cbxDYDJID_LSBZ.ClearItems();
            cbxDYDJID_CAPP.ClearItems();
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxDYDJID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                    cbxDYDJID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                }

            }

            //线缆基本型号
            SQL.Clear();
            SQL.Add("select XLXHB_XLXHID from XLXHB where XLXHB_XLXHID=XLXHB_XLJBXHID order by XLXHB_XLXHID  ");
            ds = dberp.OpenDataSet(SQL);
            cbxXLJBXHID_LSBZ.ClearItems();
            cbxXLJBXHID_CAPP.ClearItems();
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxXLJBXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                    cbxXLJBXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                }
            }

            cbxXLJBXHID_OnSelectedIndexChanged(null, null);
        }

      
        #endregion

        #region 控件事件
        //基本型号的change
        protected void cbxXLJBXHID_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            //查询全部
            int flag = 0;
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            DataSet ds;
            string sLSBZ;
            string sCAPP;
            if (!cbxXLJBXHID_LSBZ.SelectedValue.Trim().Equals(""))
            {
                sLSBZ = cbxXLXHID_LSBZ.SelectedValue.Trim();
                cbxXLXHID_LSBZ.ClearItems();
                SQL.Clear();
                SQL.Add("select XLXHB_XLXHID from XLXHB where 1 = 1 and " + CMISproDataBase.GetWhereEqual("XLXHB_XLJBXHID",cbxXLJBXHID_LSBZ.SelectedValue.Trim()));
                ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        cbxXLXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                    }

                }
                cbxXLXHID_LSBZ.SelectedValue = sLSBZ;
                flag = 1;
            }

            if (!cbxXLJBXHID_CAPP.SelectedValue.Trim().Equals(""))
            {
                sCAPP = cbxXLXHID_CAPP.SelectedValue.Trim();
                cbxXLXHID_CAPP.ClearItems();
                SQL.Clear();
                SQL.Add("select XLXHB_XLXHID from XLXHB where 1 = 1 and " + CMISproDataBase.GetWhereEqual("XLXHB_XLJBXHID",cbxXLJBXHID_CAPP.SelectedValue.Trim()));
                ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        cbxXLXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                    }

                }
                cbxXLXHID_CAPP.SelectedValue = sCAPP;
                flag = 1;
            }

            
            if (0 == flag)
            {
                sLSBZ = cbxXLXHID_LSBZ.SelectedValue.Trim();
                sCAPP = cbxXLXHID_CAPP.SelectedValue.Trim();

                cbxXLXHID_LSBZ.ClearItems();
                cbxXLXHID_CAPP.ClearItems();

                SQL.Clear();
                SQL.Add("select XLXHB_XLXHID from XLXHB order by XLXHB_XLXHID ");
                ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        cbxXLXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                        cbxXLXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
                    }
                }
                cbxXLXHID_LSBZ.SelectedValue = sLSBZ;
                cbxXLXHID_CAPP.SelectedValue = sCAPP;
            }
        }

      
        protected void btnQR_Click(object sender, EventArgs e)
        {
            if (!(PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) && !PageParam.GetRTrimString("CZBLX").Equals("C"))
            {
                if (PageParam.GetRTrimString("XLBZBN").Equals("Y") && PageParam.GetRTrimString("DYDJBN").Equals("Y") && PageParam.GetRTrimString("XLXHBN").Equals("Y"))
                {
                    ShowMessage("线缆型号，标准和电压等级均为表内，不允许批量添加！");
                    return;
                }
            }
            string sJGCZBID = PageParam.GetRTrimString("JGCZBID");
            int iXH = XLJGCZB_XHML.getNewXH(sJGCZBID);

            string sRepeat = "";
            string sJGCZB = "";
            int falg = 0;
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            //对应CAPP按钮
            if ((PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) || PageParam.GetRTrimString("CZBLX").Equals("C"))
            {
                try
                {
                   
                    dberp.BeginTrans();
                    string sCAPP_XLXHID = cbxXLXHID_CAPP.SelectedValue.Trim();
                    SQL.Clear();
                    SQL.Add("insert into XLXHJGCZBML");
                    SQL.Add("   (XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,");
                    SQL.Add("   XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,");
                    SQL.Add("   XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ) ");
                    SQL.Add("values ");
                    SQL.Add("   (:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,");
                    SQL.Add("   :XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH,");
                    SQL.Add("   :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ)");
                    SQL.ParamByName("XLXHJGCZBML_JGCZBID").Value = sJGCZBID;
                    

                    SQL.ParamByName("XLXHJGCZBML_DYDJID").Value = cbxDYDJID_CAPP.SelectedValue.Trim();
                    SQL.ParamByName("XLXHJGCZBML_XLBZID").Value = cbxXLBZID_CAPP.SelectedValue.Trim();
                   
                    SQL.ParamByName("XLXHJGCZBML_XLBZBH").Value = cbxXLBZBH_CAPP.SelectedValue.Trim();
                    SQL.ParamByName("XLXHJGCZBML_WHRID").Value = tSession.UserId;
                    SQL.ParamByName("XLXHJGCZBML_WHR").Value = tSession.UserName;
                    SQL.ParamByName("XLXHJGCZBML_WHSJ").Value = DateTime.Now.ToString();

                    string[] sTemp = sCAPP_XLXHID.ToString().Trim().Split(',');
                    for (int i = 0; i < sTemp.Length; i++)
                    {
                        //此处判断重复
                        sJGCZB = XLJGCZB_XHML.ReJudge(sTemp[i], cbxDYDJID_CAPP.SelectedValue.Trim(),
                            cbxXLBZID_CAPP.SelectedValue.Trim(), PageParam.GetRTrimString("GYFLBM"),
                            cbxXLBZBH_CAPP.SelectedValue.Trim(), sJGCZBID);
                        if (sJGCZB.Equals(""))
                        {
                            SQL.ParamByName("XLXHJGCZBML_JGCZBXH").Value = iXH;
                            SQL.ParamByName("XLXHJGCZBML_XLXHID").Value = sTemp[i];
                            dberp.ExecSQL(SQL);
                            iXH--;
                        }
                        else
                        {
                            falg = 1;
                            sRepeat += sJGCZB + "\r\n";
                        }
                       
                    }
                    dberp.CommitTrans();
                    if (0 == falg)
                    {
                        ShowMessage("添加完成！");
                    }
                    else
                    {
                        ShowMessage("存在如下涵盖范围记录重复：\r\n" + sRepeat);
                    }
                }
                catch (Exception ex)
                {
                    ShowMessage("批量添加(CAPP)出现异常！异常信息：" + ex);
                    dberp.RollbackTrans();
                }
            }
            ////对应ADD按钮
            else
            {
                try
                {
                    dberp.BeginTrans();
                    string sLSBZ_XLXHID = cbxXLXHID_LSBZ.SelectedValue.Trim();
                    string sLSBZ_DYDJID = cbxDYDJID_LSBZ.SelectedValue.Trim();
                    SQL.Clear();
                    SQL.Add("insert into XLXHJGCZBML");
                    SQL.Add("(XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,");
                    SQL.Add(" XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,");
                    SQL.Add(" XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ) ");
                    SQL.Add("values ");
                    SQL.Add("(:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,");
                    SQL.Add(" :XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH,");
                    SQL.Add(" :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ)");
                    SQL.ParamByName("XLXHJGCZBML_JGCZBID").Value = sJGCZBID;
                   

                    
                    SQL.ParamByName("XLXHJGCZBML_XLBZID").Value = cbxXLBZID_LSBZ.SelectedValue.Trim();
                    
                    SQL.ParamByName("XLXHJGCZBML_XLBZBH").Value = "";
                    SQL.ParamByName("XLXHJGCZBML_WHRID").Value = tSession.UserId;
                    SQL.ParamByName("XLXHJGCZBML_WHR").Value = tSession.UserName;
                    SQL.ParamByName("XLXHJGCZBML_WHSJ").Value = DateTime.Now.ToString();

                    string[] sTempA = sLSBZ_XLXHID.ToString().Trim().Split(',');
                    string[] sTempB = sLSBZ_DYDJID.ToString().Trim().Split(',');
                    for (int i = 0; i < sTempA.Length; i++)
                    {
                        for (int j = 0; j < sTempB.Length; j++)
                        {
                            //此处判断重复
                            sJGCZB = XLJGCZB_XHML.ReJudge(sTempA[i], sTempB[j],
                                cbxXLBZID_LSBZ.SelectedValue.Trim(), " ",
                                "", sJGCZBID);
                            if (sJGCZB.Equals(""))
                            {
                                SQL.ParamByName("XLXHJGCZBML_JGCZBXH").Value = iXH;
                                SQL.ParamByName("XLXHJGCZBML_XLXHID").Value = sTempA[i];
                                SQL.ParamByName("XLXHJGCZBML_DYDJID").Value = sTempB[j];
                                dberp.ExecSQL(SQL);
                                iXH--;
                            }
                            else
                            {
                                falg = 1;
                                sRepeat += sJGCZB + "\r\n";
                            }
                        }
                    }
                    dberp.CommitTrans();
                    if (0 == falg)
                    {
                        ShowMessage("添加完成！");
                    }
                    else
                    {
                        ShowMessage("存在如下涵盖范围记录重复：\r\n" + sRepeat);
                    }
                }
                catch (Exception ex)
                {
                    ShowMessage("批量添加(LSBZ)出现异常！异常信息：" + ex);
                    dberp.RollbackTrans();
                }

            }
            //使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
            DialogOperationScript dos = new DialogOperationScript(this);
            dos.ClickOwnerButton(PageParam.GetRTrimString("RefreshCtrlID"));
            dos.CloseSelf();
            dos.Execute();
        }

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

        #endregion
    }
}