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 XLJGCZBList : SingleGridBase
    {
        XLJGCZB entity = new XLJGCZB();
        XLJGCZB_M queryentity = new XLJGCZB_M();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421008;
            this.UMName = "线缆结构尺重表";
            this.CurMaster = Master;
            this.ModuleGV = grdContentGrid;
            this.CurEntity = entity;
            this.CurQueryEntity = queryentity;
            this.sURLTarget = "XLJGCZBInfo.aspx";
            this.sQueryURLTarget = "XLJGCZBQuery.aspx";
            this.PageHeight = 700;
            this.PageWidth = 500;
            this.CanDeleteCheckedRows = true;
            base.DataKeyNames = new string[] { "XLJGCZBML_JGCZBID", "XLJGCZBML_CZBLX", "XLJGCZBML_GYFLBM", "GYFLBM", "XLJGCZBML_XLXHBN", "XLJGCZBML_XLBZBN", "XLJGCZBML_DYDJBN" };

            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 void BeforeDelete(TDatabase db, ref bool ActionIsDone)
        {
            entity.Param.Add("XLJGCZBML_JGCZBID", grdContentGrid.SelectedDataKey["XLJGCZBML_JGCZBID"].ToString().Trim());
            base.BeforeDelete(db, ref ActionIsDone);
        }

        protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
        {
            string sJGCZBID = grdContentGrid.SelectedDataKey["XLJGCZBML_JGCZBID"].ToString().Trim();
            string sJGCBZLX = grdContentGrid.SelectedDataKey["XLJGCZBML_CZBLX"].ToString().Trim();
            string sSQL1 = string.Format("delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}'", sJGCZBID);
            string sSQL2 = string.Format("delete from XLJGCZBRZ where XLJGCZBRZ_JGCZBID='{0}'", sJGCZBID);
            string sSQL3 = string.Format("delete from XLJGCZBBB where XLJGCZBBB_JGCZBID='{0}'", sJGCZBID);
            db.ExecSQL(sSQL1);
            db.ExecSQL(sSQL2);
            db.ExecSQL(sSQL3);
            if (sJGCBZLX.Equals("A") || sJGCBZLX.Equals("B"))
            {
                string sSQL4 = string.Format("delete from XLJGCZBNR where XLJGCZBNR_JGCZBID='{0}'", sJGCZBID);
                string sSQL5 = string.Format("delete from XLJGCZBLM where XLJGCZBLM_JGCZBID='{0}'", sJGCZBID);
                string sSQL6 = string.Format("delete from XLXHJGCZBNR where XLXHJGCZBNR_JGCZBID='{0}'", sJGCZBID);
                string sSQL7 = string.Format("delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}'", sJGCZBID);
                string sSQL8 = string.Format("delete from XLXSCLQDWL where XLXSCLQDWL_JGCZBID='{0}'", sJGCZBID);
                db.ExecSQL(sSQL4);
                db.ExecSQL(sSQL5);
                db.ExecSQL(sSQL6);
                db.ExecSQL(sSQL7);
                db.ExecSQL(sSQL8);
            }
            base.AfterDelete(db, ref ActionIsDone);
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            string sJGCZBID = grdContentGrid.SelectedDataKey["XLJGCZBML_JGCZBID"].ToString().Trim();
            string sJGCBZLX = grdContentGrid.SelectedDataKey["XLJGCZBML_CZBLX"].ToString().Trim();
            string sSQL = "";

            if (sJGCBZLX.Equals("A") || sJGCBZLX.Equals("B"))
            {
                sSQL = string.Format("select top 1 XLXSCLQD_JGCZBID from XLXSCLQD where XLXSCLQD_JGCZBID='{0}'", sJGCZBID);
                if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
                {
                    ShowMessage("当前尺重表存在材料清单记录，不允许删除！");
                    return false;
                }
            }
            else
            {
                sSQL = string.Format("select TOP 1 XLXHJGCZBML_JGCZBID from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}' and XLXHJGCZBML_JGCZBXH< 0 ", sJGCZBID);
                if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
                {
                    ShowMessage("已经存在涵盖范围，不允许删除！");
                    return false;
                }

                sSQL = string.Format("select top 1 XLJGCZBNR_JGCZBID from XLJGCZBNR where XLJGCZBNR_JGCZBID='{0}'", sJGCZBID);
                if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
                {
                    ShowMessage("当前尺重表已存在导入内容，不允许删除！");
                    return false;
                }

                sSQL = string.Format("select top 1 XLXHJGCZBNR_JGCZBID from XLXHJGCZBNR where XLXHJGCZBNR_JGCZBID='{0}'", sJGCZBID);
                if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
                {
                    ShowMessage("当前尺重表已生成型号内容，不允许删除！");
                    return false;
                }

                sSQL = string.Format("select top 1 XLXHJGCZBML_JGCZBID from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}' and XLXHJGCZBML_JGCZBXH>0 ", sJGCZBID);
                if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
                {
                    ShowMessage("当前尺重表已处理过结构工艺，不允许删除！");
                    return false;
                }
            }
            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)
            {
                LinkPageParam.AddString("XLJGCZBML_JGCZBID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLJGCZBML_JGCZBID"].ToString().Trim());
            }
            base.moduleGV_RowDataBound(sender, e);
        }

        #endregion

        #region 自定义事件

        private string GetQuerySQL()
        {
            StringBuilder sSQL = new StringBuilder();
            // RTRIM(XLJGCZBML_XLTXID)||'|'||RTRIM(XLCPTX_CPTXMC) as XLJGCZBML_XLTXID,RTRIM(XLJGCZBML_CPYT)||'|'||RTRIM(XLCPYT_CPYTMC) as XLJGCZBML_CPYT,XLJGCZBML_QYRQ, ");

            sSQL.AppendLine("   SELECT XLJGCZBML_JGCZBID,XLJGCZBML_JGCZBMC,XLJGCZBML_FZR,XLJGCZBML_CZBJLDW, ");
            sSQL.AppendLine("           XLJGCZBML_XLGGDW, isnull(XLJGCZBML_CZBLX,' ') as XLJGCZBML_CZBLX,XLJGCZBML_GGHLX,      ");
            sSQL.AppendLine("           XLJGCZBML_JGCZBBBID,XLJGCZBML_EXCEL,XLJGCZBML_SHEET,    ");
            sSQL.AppendLine("           XLJGCZBML_XLBZBN,XLJGCZBML_DYDJBN,XLJGCZBML_XLXHBN,RTRIM(XLJGCZBML_GYFLBM)||'|'||RTRIM(XLSCGYBB_SCGYMC) as XLJGCZBML_GYFLBM, XLJGCZBML_GYFLBM as GYFLBM,   ");
            sSQL.AppendLine("           RTRIM(XLJGCZBML_CPMLID)||'|'||RTRIM(XLXSCPML_CPMLMC) as XLJGCZBML_CPMLID,XLJGCZBML_WHRID,XLJGCZBML_WHR,XLJGCZBML_WHSJ    ");
            sSQL.AppendLine("   FROM XLJGCZBML   ");
            sSQL.AppendLine("       left join XLXSCPML on XLXSCPML_CPMLID= XLJGCZBML_CPMLID ");
            sSQL.AppendLine("       left join XLSCGYBB on XLSCGYBB_GYFLBM= XLJGCZBML_GYFLBM and XLSCGYBB_GYBBH = 1 ");
            sSQL.AppendLine("   where 1 = 1    ");

            //此处不可以使用trim()防止将" "过滤掉
            if (!CurQueryEntity.FieldByName("CZBLXList").Value.Equals(""))
            {
                sSQL.AppendLine("           and " +  CMISproDataBase.GetWhereEqual("isnull(XLJGCZBML_CZBLX,' ')", CurQueryEntity.FieldByName("CZBLXList").Value));
            }

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

            sSQL.AppendLine("order by XLJGCZBML_JGCZBID");
            return sSQL.ToString();
        }
        #endregion

        #region 控件事件
        protected void btnHGFW_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }
            string sJGCZBID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_JGCZBID"].ToString().Trim();
            string sCZBLX   = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_CZBLX"].ToString().Trim();
            string sGYFLBM  = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["GYFLBM"].ToString().Trim();
            
            string sXLXHBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_XLXHBN"].ToString().Trim();
            string sXLBZBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_XLBZBN"].ToString().Trim();
            string sDYDJBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_DYDJBN"].ToString().Trim();
            if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLJGCZBML where XLJGCZBML_JGCZBID='{0}'", sJGCZBID)))
            {
                ShowMessage("当前记录已不存在，请刷新后重试！");
                return;
            }
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaBrowse;
            pageParams.UrlPath = "XLJGCZB_XHMLList.aspx";
            pageParams.Title = "涵盖范围";
            pageParams.AddString("LX", "HGFW");
            pageParams.AddString("JGCZBID", sJGCZBID);
            pageParams.AddString("CZBLX", sCZBLX);
            pageParams.AddString("GYFLBM", sGYFLBM);
            //表内表外
            pageParams.AddString("XLXHBN", sXLXHBN);
            pageParams.AddString("XLBZBN", sXLBZBN);
            pageParams.AddString("DYDJBN", sDYDJBN);
            OpenModuleDialog(101421008, pageParams);
        }

        protected void btnXHML_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }
            string sJGCZBID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_JGCZBID"].ToString().Trim();
            string sCZBLX   = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_CZBLX"].ToString().Trim();
            string sGYFLBM  = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["GYFLBM"].ToString().Trim();

            string sXLXHBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_XLXHBN"].ToString().Trim();
            string sXLBZBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_XLBZBN"].ToString().Trim();
            string sDYDJBN = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_DYDJBN"].ToString().Trim();
            if (!CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLJGCZBML where XLJGCZBML_JGCZBID='{0}'", sJGCZBID)))
            {
                ShowMessage("当前记录已不存在，请刷新后重试！");
                return;
            }
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaBrowse;
            pageParams.UrlPath = "XLJGCZB_XHMLList.aspx";
            pageParams.Title = "型号目录";
            pageParams.AddString("LX", "XHML");
            pageParams.AddString("JGCZBID", sJGCZBID);
            pageParams.AddString("CZBLX", sCZBLX);
            pageParams.AddString("GYFLBM", sGYFLBM);
            //表内表外
            pageParams.AddString("XLXHBN", sXLXHBN);
            pageParams.AddString("XLBZBN", sXLBZBN);
            pageParams.AddString("DYDJBN", sDYDJBN);
            OpenModuleDialog(101421008, pageParams);
        }

        protected void btnCZBLM_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }
            string sJGCZBID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_JGCZBID"].ToString().Trim();
            string sCZBLX   = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLJGCZBML_CZBLX"].ToString().Trim();
            if (!sCZBLX.Equals("A"))
            {
                ShowMessage("仅A类尺重表可以设置尺重表栏目！");
                return;
            }
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaBrowse;
            pageParams.UrlPath = "XLJGCZB_LMSZList.aspx";
            pageParams.AddString("JGCZBID", sJGCZBID);
            OpenModuleDialog(101421008, pageParams);
        }
        #endregion
    }
}