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_MISPRO.TableCache;
using GThinking.N_MODEL.Page;
using GThinking.N_WORKFLOW;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC2;
using System.Text;

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

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

            if (!IsPostBack)
            {
                InitControls();
            }

            base.InitPage();
        }

        private void InitControls()
        {
            this.Master.EnableInsertBtn = false;
            this.Master.EnableCopyBtn = false;
            this.Master.EnableEditBtn = false;
            this.Master.EnableSaveBtn = false;
            this.Master.EnableCancelBtn = false;
            this.Master.EnableDeleteBtn = false;
            this.Master.EnableRefreshBtn = false;
            this.Master.EnableAttachBtn = false;
            this.Master.EnablePrintBtn = false;

            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            string tSQL = "select XLDYDJB_DYDJID,XLDYDJB_DYJLDW,XLDYDJB_ACDC,XLDYDJB_XXLXDY,XLDYDJB_XXXXDY from XLDYDJB where isnull(XLDYDJB_TYBZ,'N')='N'  order by XLDYDJB_DYJLDW desc,XLDYDJB_XXLXDY,XLDYDJB_XXXXDY";
            DataSet ds = dberp.OpenDataSet(tSQL);
            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxDYDJ.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLDYDJB_ACDC"].ToString().Trim() + "|" + ds.Tables[0].Rows[i]["XLDYDJB_DYDJID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLDYDJB_DYDJID"].ToString().Trim()));
                    cbxDYDJ2.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLDYDJB_ACDC"].ToString().Trim() + "|" + ds.Tables[0].Rows[i]["XLDYDJB_DYDJID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLDYDJB_DYDJID"].ToString().Trim())); 
                    cbxDYDJ.ShowValue = false;
                    cbxDYDJ2.ShowValue = false;

                }
            }

            if (PageParam.GetRTrimString("DYDJID").ToString().Equals(""))
            {
                cbxDYDJ.Visible = false;
                lblDYDJ.Visible = false;
                btnSC.Visible = false;
            }
            else
            {
                cbxDYDJ2.Visible = false;
                lblDYDJ2.Visible = false;
                cbxDYDJ.SelectedValue = PageParam.GetRTrimString("DYDJID").ToString();
            }
            //PageParam.ContainsKey("RYID")
            //entity.Param.Add("pRYID", PageParam.GetRTrimString("RYID"));
        }

        protected void btnQD_Click(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSql = new TSQL(dberp);
            TSQL sSqlIns = new TSQL(dberp);
            TSQL sSqlDY = new TSQL(dberp);
            if (PageParam.GetRTrimString("DYDJID").ToString().Equals(""))
            {
                string[] sDYDJ = cbxDYDJ2.SelectedValue.ToString().Trim().Split(',');
                if (cbxDYDJ2.SelectedValue.ToString().Equals(""))
                    return;
                string sXLXHID = PageParam.GetRTrimString("XLXHID").ToString();
                for (int i = 0; i < sDYDJ.Length; i++)
                {
                    sSql.Clear();
                    sSql.Add("select 1 from XLXHDYDJ");
                    sSql.Add(" where XLXHDYDJ_XLXHID=:pXLXHID");
                    sSql.Add("   and XLXHDYDJ_DYDJID=:pDYDJID");
                    sSql.ParamByName("pXLXHID").Value = sXLXHID;
                    sSql.ParamByName("pDYDJID").Value = sDYDJ[i].ToString();
                    DataSet ds = dberp.OpenDataSet(sSql);
                    if (ds.Tables[0].Rows.Count == 0)
                    {
                        sSqlDY.Clear();
                        sSqlDY.Add(" select XLDYDJB_DYDJID,XLDYDJB_ACDC from XLDYDJB where XLDYDJB_DYDJID = :pDYDJID");
                        sSqlDY.ParamByName("pDYDJID").Value = sDYDJ[i].ToString();
                        DataSet dsDY = dberp.OpenDataSet(sSqlDY);
                        string sACDC = dsDY.Tables[0].Rows[0]["XLDYDJB_ACDC"].ToString().Trim();
                        string sDYDJID = dsDY.Tables[0].Rows[0]["XLDYDJB_DYDJID"].ToString().Trim();

                        sSqlIns.Clear();
                        sSqlIns.Add("insert into XLXHDYDJ");
                        sSqlIns.Add("(XLXHDYDJ_XLXHID,XLXHDYDJ_DYDJID,XLXHDYDJ_WHR,XLXHDYDJ_WHRID,XLXHDYDJ_WHSJ,XLXHDYDJ_ACDC)");
                        sSqlIns.Add("values");
                        sSqlIns.Add("(:pXLXHID,:pDYDJID,:pWHR,:pWHRID,:pWHSJ,:pACDC)");
                        sSqlIns.ParamByName("pXLXHID").Value = sXLXHID;
                        sSqlIns.ParamByName("pDYDJID").Value = sDYDJID;
                        sSqlIns.ParamByName("pWHR").Value = tSession.UserName;
                        sSqlIns.ParamByName("pWHRID").Value = tSession.UserId;
                        sSqlIns.ParamByName("pWHSJ").Value = DateTime.Now.ToString();
                        sSqlIns.ParamByName("pACDC").Value = sACDC;
                        dberp.ExecSQL(sSqlIns);
                    }
                }
            }
            else
            {
                string sDYDJ = cbxDYDJ.SelectedValue.ToString().Trim();
                string sXLXHID = PageParam.GetRTrimString("XLXHID").ToString();
                sSql.Clear();
                sSql.Add("select 1 from XLXHDYDJ");
                sSql.Add(" where XLXHDYDJ_XLXHID=:pXLXHID");
                sSql.Add("   and XLXHDYDJ_DYDJID=:pDYDJID");
                sSql.ParamByName("pXLXHID").Value = sXLXHID;
                sSql.ParamByName("pDYDJID").Value = sDYDJ.ToString();
                DataSet ds = dberp.OpenDataSet(sSql);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ShowMessage("该线缆型号电压等级已存在，不允许保存!");
                    return;
                }
                else
                {
                    sSqlDY.Clear();
                    sSqlDY.Add(" select XLDYDJB_DYDJID,XLDYDJB_ACDC from XLDYDJB where XLDYDJB_DYDJID = :pDYDJID");
                    sSqlDY.ParamByName("pDYDJID").Value = sDYDJ.ToString();
                    DataSet dsDY = dberp.OpenDataSet(sSqlDY);
                    string sACDC = dsDY.Tables[0].Rows[0]["XLDYDJB_ACDC"].ToString().Trim();
                    string sDYDJID = dsDY.Tables[0].Rows[0]["XLDYDJB_DYDJID"].ToString().Trim();

                    sSqlIns.Clear();
                    sSqlIns.Add("update XLXHDYDJ");
                    sSqlIns.Add("   set XLXHDYDJ_DYDJID=:pDYDJID,");
                    sSqlIns.Add("       XLXHDYDJ_WHR=:pWHR,");
                    sSqlIns.Add("       XLXHDYDJ_WHRID=:pWHRID,");
                    sSqlIns.Add("       XLXHDYDJ_WHSJ=:pWHSJ,");
                    sSqlIns.Add("       XLXHDYDJ_ACDC=:pACDC");
                    sSqlIns.Add(" where XLXHDYDJ_XLXHID=:pXLXHID");
                    sSqlIns.Add("   and XLXHDYDJ_DYDJID=:pOldDYDJID");

                    sSqlIns.ParamByName("pXLXHID").Value = sXLXHID;
                    sSqlIns.ParamByName("pDYDJID").Value = sDYDJID;
                    sSqlIns.ParamByName("pWHR").Value = tSession.UserName;
                    sSqlIns.ParamByName("pWHRID").Value = tSession.UserId;
                    sSqlIns.ParamByName("pWHSJ").Value = DateTime.Now.ToString();
                    sSqlIns.ParamByName("pACDC").Value = sACDC;
                    sSqlIns.ParamByName("pOldDYDJID").Value = PageParam.GetRTrimString("DYDJID").ToString();
                    dberp.ExecSQL(sSqlIns);
                }
            }
            CloseWindow();
        }

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

        protected void btnSC_Click(object sender, EventArgs e)
        {
            string sDYDJ = PageParam.GetRTrimString("DYDJID").ToString();
            string sXLXHID = PageParam.GetRTrimString("XLXHID").ToString();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSql = new TSQL(dberp);
            sSql.Clear();
            sSql.Add("delete from XLXHDYDJ");
            sSql.Add("where XLXHDYDJ_XLXHID=:pXLXHID");
            sSql.Add("and XLXHDYDJ_DYDJID=:pDYDJID");
            sSql.ParamByName("pXLXHID").Value = sXLXHID;
            sSql.ParamByName("pDYDJID").Value = sDYDJ;
            dberp.ExecSQL(sSql);
            CloseWindow();
        }
 
    }
}