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 XLXSBJCLDHList : SingleGridBase
    {
        XLXSBJCLDH entity = new XLXSBJCLDH();
        XLXSBJCLDH_M queryentity = new XLXSBJCLDH_M();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421009;
            this.UMName = "线缆销售报价材料代号";
            this.CurMaster = Master;
            this.ModuleGV = grdContentGrid;
            this.CurEntity = entity;
            this.CurQueryEntity = queryentity;
            this.sURLTarget = "XLXSBJCLDHInfo.aspx";
            this.sQueryURLTarget = "XLXSBJCLDHQuery.aspx";
            this.PageHeight = 700;
            this.PageWidth = 500;
            this.CanDeleteCheckedRows = true;
            base.DataKeyNames = new string[] { "XLCLZLID", "XLCLID","XLCLMC", "XLXSBJCLDH_BJCLID" };

            this.Master.EnableNewBtn = false;
            this.Master.EnableCopyBtn = false;
            this.Master.EnableDeleteBtn = false;
            this.Master.EnableEditBtn = false;
            this.Master.EnableViewBtn = false;


            base.InitPage();
            if (!IsPostBack)
            {
                if (base.IsDefaultExecute)
                {
                    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)
        {
            base.BeforeDelete(db, ref ActionIsDone);
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            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)
            {
            }
            base.moduleGV_RowDataBound(sender, e);
        }

        #endregion

        #region 自定义事件
         
        private string GetQuerySQL()
        {
            string sXLCLZLID = CurQueryEntity.FieldByName("XLCLZLID").Value.Trim();
            StringBuilder sSQL = new StringBuilder();
            // RTRIM(XLJGCZBML_XLTXID)||'|'||RTRIM(XLCPTX_CPTXMC) as XLJGCZBML_XLTXID,RTRIM(XLJGCZBML_CPYT)||'|'||RTRIM(XLCPYT_CPYTMC) as XLJGCZBML_CPYT,XLJGCZBML_QYRQ, ");
            if (sXLCLZLID.Equals("DTCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLDTCLB_DTCLID as XLCLID,XLDTCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLDTCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLDTCLB_DTCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID   ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLDTCLB_WLID = ' '  ");
            }
            else if (sXLCLZLID.Equals("JYCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLJYCLB_JYCLID as XLCLID,XLJYCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLJYCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLJYCLB_JYCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLJYCLB_WLID = ' ' ");
            }
            else if (sXLCLZLID.Equals("HTCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLHTCLB_HTCLID as XLCLID,XLHTCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLHTCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLHTCLB_HTCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID   ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLHTCLB_WLID = ' '  ");
            }
            else if (sXLCLZLID.Equals("KZCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLKZCLB_KZCLID as XLCLID,XLKZCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLKZCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLKZCLB_KZCLID  and XLXSBJCLDH_XLCLZLID = :pXLCLZLID  ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLKZCLB_WLID = ' '  ");
            }
            else if (sXLCLZLID.Equals("TCCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLTCCLB_TCCLID as XLCLID,XLTCCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLTCCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on  XLXSBJCLDH_XLCLID = XLTCCLB_TCCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID   ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLTCCLB_WLID = ' '  ");
            }
            else if (sXLCLZLID.Equals("WHCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLWHCLB_WHCLID as XLCLID,XLWHCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLWHCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLWHCLB_WHCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID   ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLWHCLB_WLID = ' '  ");
            }
            else if (sXLCLZLID.Equals("PBCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLPBCLB_PBCLID as XLCLID,XLPBCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLPBCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLPBCLB_PBCLID  and XLXSBJCLDH_XLCLZLID = :pXLCLZLID  ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLPBCLB_WLID = ' '   ");
            }
            else if (sXLCLZLID.Equals("RBCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLRBCLB_RBCLID as XLCLID,XLRBCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLRBCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLRBCLB_RBCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID  ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLRBCLB_WLID = ' '   ");
            }
            else if (sXLCLZLID.Equals("FZCL"))
            {
                sSQL.AppendLine("   select :pXLCLZLID as XLCLZLID,XLFZCLB_FZCLID as XLCLID,XLFZCLB_WLMC as XLCLMC, ");
                sSQL.AppendLine("          XLXSBJCLDH_BJCLID,XLXSBJCL_BJCLMC,case isnull(XLXSBJCL_TYBZ,'N') when 'Y' then rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC) || '(停用)' else  rtrim(XLXSBJCLDH_BJCLID)||'|'||rtrim(XLXSBJCL_BJCLMC)  end as BJCL,  ");
                sSQL.AppendLine("          XLXSBJCLDH_BZ,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHR,XLXSBJCLDH_WHSJ ");
                sSQL.AppendLine("   from XLFZCLB    ");
                sSQL.AppendLine("       left join XLXSBJCLDH on XLXSBJCLDH_XLCLID = XLFZCLB_FZCLID and XLXSBJCLDH_XLCLZLID = :pXLCLZLID   ");
                sSQL.AppendLine("       left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLDH_BJCLID ");
                sSQL.AppendLine("   where  1 = 1  and XLFZCLB_WLID = ' '    ");
            }
            entity.Param.Add("pXLCLZLID", sXLCLZLID);
            sSQL.AppendLine("order by XLCLID");
            return sSQL.ToString();
        }
        #endregion

        #region 控件事件
        protected void grdContentGrid_RowDoubleClick(object sender, GThinking.N_CONTROL.RowDoubleClickEventArgs e)
        {
            string sBJCLID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJCLDH_BJCLID"].ToString().Trim();
            string sXLCLZLID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLCLZLID"].ToString().Trim();
            string sXLCLID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLCLID"].ToString().Trim();
            string sXLCLMC = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLCLMC"].ToString().Trim();
            TPageParams tpp = new TPageParams();
            tpp.UrlPath = "XLXSBJCLDHInfo.aspx";
            tpp.AddString("BJCLID", sBJCLID);
            tpp.AddString("XLCLZLID", sXLCLZLID);
            tpp.AddString("XLCLID", sXLCLID);
            tpp.AddString("XLCLMC", sXLCLMC);
            tpp.AddString("RefreshCtrlID", btnRefresh.ClientID.Trim());
            OpenDialog(tpp);
        }

        protected void btnRefresh_Click(object sender, EventArgs e)
        {
            moduleGV_PageIndexChanging(null, null);
        }
        #endregion
    }
}