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_MODEL.Page;
using GThinking.N_CONTROL;
using GThinking.N_MISPRO.Data;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC;
using GThinking.N_MODEL.UserControls;
using System.Text;
using GThinking.N_WORKFLOW;
using GThinking.N_PUBLIC2;

namespace GThinking.N_XLJC
{
    public partial class XLXLXHList : SingleGridBase
    {
        XLXHB entity = new XLXHB();
        XLXHB_M queryentity = new XLXHB_M();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421000;
            this.UMName = "线缆型号";
            this.CurMaster = Master;
            this.ModuleGV = grdContentGrid;
            this.CurEntity = entity;
            this.CurQueryEntity = queryentity;
            this.sURLTarget = "XLXLXHInfo.aspx";
            this.sQueryURLTarget = "XLXLXHQuery.aspx";
            this.PageHeight = 700;
            this.PageWidth = 500;
            this.CanDeleteCheckedRows = true;
            base.DataKeyNames = new string[] { "XLXHB_CPYT", "XLXHB_XLTXID", "XLXHB_XLXHID" };

            base.InitPage();
            if (!IsPostBack)
            {
                Master_OnStandardQuery(null, null);
            }
        }

        #region 模板继承事件

        protected override void Master_OnStandardQuery(object sender, EventArgs e)
        {
            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetQuerySQL();
            base.Master_OnStandardQuery(sender, e);
            entity.GridDataBind(grdContentGrid, tSession);
        }

        protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetQuerySQL();
            grdContentGrid.SelectedIndex = -1;
            base.moduleGV_PageIndexChanging(sender, e);
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            if (grdContentGrid.CheckBox && !String.IsNullOrEmpty(grdContentGrid.CheckedRowIndexs))
            {
                string[] RowsArry = grdContentGrid.CheckedRowIndexs.Split(new char[] { ',' });
                //勾选的型号
                string sXLXHIDList = "";
                for (int i = 0; i < RowsArry.Length; i++)
                {
                    sXLXHIDList = sXLXHIDList + grdContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[i].ToString())]["XLXHB_XLXHID"].ToString().Trim() + ",";
                }
                sXLXHIDList = sXLXHIDList.Trim().TrimEnd(',');
              
                dberp.ExecSQL(string.Format("delete from XLXHB where 1 =1 and " + GetWhereEqual("XLXHB_XLXHID", sXLXHIDList)));
                dberp.ExecSQL(string.Format("delete from XLXHDYDJ where 1 =1 and " + GetWhereEqual("XLXHDYDJ_XLXHID", sXLXHIDList)));
                return base.Master_BeforeDeleteAction(sender, e);
            }
            else
            {
                string sXLXHID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim();

                entity.Param.Add("XLXHB_XLXHID", sXLXHID);
                int k = dberp.ExecSQL(string.Format("delete from XLXHDYDJ where 1 =1 and XLXHDYDJ_XLXHID= '{0}'", sXLXHID));
                return base.Master_BeforeDeleteAction(sender, e);
            }
        }

        protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
        {
            if (!base.Master_AfterDeleteAction(sender, e)) { return false; }
            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetQuerySQL();
            entity.GridDataBind(grdContentGrid, tSession);
            grdContentGrid.SelectedIndex = -1;
            return true;
        }

        protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                int indexCPYT = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXHB_CPYT")) + 1;

                string sCPYT = e.Row.Cells[indexCPYT].Text.ToString().Trim();

                if (!sCPYT.Equals(""))
                {
                    e.Row.Cells[indexCPYT].Text = GetCPYTMC(sCPYT);
                }
                LinkPageParam.AddString("XLXHB_XLXHID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXHB_XLXHID"].ToString().Trim());
            }
            base.moduleGV_RowDataBound(sender, e);
        }

       

        #endregion

        #region 自定义事件

        private string GetQuerySQL()
        {
            StringBuilder sSQL = new StringBuilder();
            sSQL.AppendLine("select XLXHB_XLJBXHID,XLXHB_XLXHID,XLXHB_XLXHBH,XLXHB_XLXHMC, XLXHB_XLTXID,XLXHB_CPYT,XLXHB_XLGGJDGZ,XLXHB_QYRQ, ");
            sSQL.AppendLine("XLXHB_TYBZ,XLXHB_TYRQ,XLXHB_WHR,XLXHB_WHSJ");
            sSQL.AppendLine("  from XLXHB      ");
            sSQL.AppendLine("  where 1=1   ");

            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("CPYT").Value.Trim()))
            {
                sSQL.AppendLine(" and XLXHB_CPYT = :pCPYT ");
                entity.Param.Add("pCPYT", CurQueryEntity.FieldByName("CPYT").Value.Trim());
            }

            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("JBXH").Value.Trim()))
            {
                sSQL.AppendLine(" and XLXHB_XLJBXHID = :pJBXH ");
                entity.Param.Add("pJBXH", CurQueryEntity.FieldByName("JBXH").Value.Trim());
            }

            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHBM").Value.Trim()))
            {
                sSQL.AppendLine(" and XLXHB_XLXHID = :pXHBM ");
                entity.Param.Add("pXHBM", CurQueryEntity.FieldByName("XHBM").Value.Trim());
            }

            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHMC").Value.Trim()))
            {
                sSQL.AppendLine(" and XLXHB_XLXHMC like :pXHMC ");
                entity.Param.Add("pXHMC", "%" + CurQueryEntity.FieldByName("XHMC").Value.Trim() + "%");
            }

            sSQL.AppendLine("order by XLXHB_XLJBXHID,XLXHB_XLXHID");
            return sSQL.ToString();
        }

        public string GetWhereEqual(string p_FieldName, string p_Values)
        {
            p_Values = p_Values.Replace(",", "' or " + p_FieldName + "='");
            p_Values = p_FieldName + "='" + p_Values + "'";
            p_Values = "(" + p_Values + ")";
            return p_Values;

        }


        #endregion

        #region 控件事件

        protected void btnDRQS_Click(object sender, EventArgs e)
        {
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaEdit;
            pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DRList.aspx";
            pageParams.AddString("CZFS", "DR");
            OpenModuleDialog(101421000, pageParams, btnRefresh1.ClientID.ToString());
        }

        protected void btnRefresh1_Click(object sender, EventArgs e)
        {
            Master_OnStandardQuery(null, null);
            FormAreaUpdate();
        }


        protected void btnDRQS_MenuItemClick(object sender, string ItemIndex)
        {
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaEdit;
            pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DRList.aspx";
            pageParams.AddString("CZFS", "SC");
            OpenModuleDialog(101421000, pageParams, btnRefresh1.ClientID.ToString());
        }

        protected void btnDYDJ_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }

            if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXHB where XLXHB_XLXHID='{0}'", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim())))
            {
                ShowMessage("当前记录已不存在，请刷新后重试！");
                return;
            }
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaEdit;
            pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DYDJ.aspx";
            pageParams.AddString("DYDJID", "");
            pageParams.AddString("XLXHID", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim());
            OpenModuleDialog(101421000, pageParams);
        }

        protected void btnDYDJ_MenuItemClick(object sender, string Value)
        {
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaEdit;
            pageParams.UrlPath = "../components/N_XLJC/XLXLXH_DYDJ.aspx";
            pageParams.AddString("DYDJID", Value);
            pageParams.AddString("XLXHID", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim());
            OpenModuleDialog(101421000, pageParams);
        }

        protected void btnDYDJ_DropDown(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }

            if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXHB where XLXHB_XLXHID='{0}'", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim())))
            {
                ShowMessage("当前记录已不存在，请刷新后重试！");
                return;
            }

            btnDYDJ.Nodes.Clear();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSql = new TSQL(dberp);
            sSql.Add("select XLXHDYDJ_ACDC,XLXHDYDJ_DYDJID  ");
            sSql.Add("from XLXHDYDJ ");
            sSql.Add("left join XLDYDJB on XLDYDJB_DYDJID=XLXHDYDJ_DYDJID ");
            sSql.Add("where XLXHDYDJ_XLXHID=:pXLXHID ");
            sSql.Add("order by XLDYDJB_DYJLDW desc,XLDYDJB_XXLXDY,XLDYDJB_XXXXDY ");
            sSql.ParamByName("pXLXHID").Value = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXHB_XLXHID"].ToString().Trim();
            DataSet ds = dberp.OpenDataSet(sSql);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                btnDYDJ.Nodes.Add(new gtTreeNode(ds.Tables[0].Rows[i]["XLXHDYDJ_DYDJID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXHDYDJ_ACDC"].ToString().Trim() + "|" + ds.Tables[0].Rows[i]["XLXHDYDJ_DYDJID"].ToString().Trim()));
            }
            MenuAreaUpdate();
        }

        protected void btnCLQDDR_Click(object sender, EventArgs e)
        {
            XLJBXHService.INSERTXLJBXHB("ZXLXSBJCLQDDR");
            ShowMessage("导入完成！");
        }

        private string GetCPYTMC(string sCPYT)
        {
            string sRet = "";
            if (sCPYT.Equals("NNNN"))
            {
                sRet = "NNNN|非线缆产品";
            }
            else
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Clear();
                SQL.Add("select XLCPYT_CPYT,XLCPYT_CPYTMC from XLCPYT where XLCPYT_CPYT = :pCPYT ");
                SQL.ParamByName("pCPYT").Value = sCPYT;
                DataSet ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    sRet = ds.Tables[0].Rows[0][0].ToString().Trim() + "|" + ds.Tables[0].Rows[0][1].ToString().Trim();
                }
            }
            return sRet;

        }
        #endregion
    }
}