#region 功能说明
/* 
 * 参数说明：                
 * 注意事项：
 * 更新记录：
*/
#endregion
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_MISPRO.Data;
using GThinking.N_PUBLIC;
using System.Text;
using GThinking.N_MISPRO.Utility;
using System.Drawing;
using GThinking.N_MISPRO.TableCache;
namespace GThinking.N_XLXSBJ
{
    public partial class CLHQList : SingleGridBase
    {
        XLXSCLHQ entity = new XLXSCLHQ();
        XLXSCLHQ_M qryEntity = new XLXSCLHQ_M();

        #region Page类事件继承

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860003;
            this.UMName = "线缆销售报价材料行情";
            this.CurMaster = Master;
            this.ModuleGV = grdContentGrid;
            this.CurEntity = entity;
            this.CurQueryEntity = qryEntity;
            this.sQueryURLTarget = "CLHQQuery.aspx";
            this.PageHeight = 600;
            this.PageWidth = 750;
            this.Master.EnableNewBtn = false;
            this.Master.EnableCopyBtn = false;
            this.Master.EnableDeleteBtn = false;
            this.btnCLJGTZ.Visible = false;
            base.sRefreshClientID = btnGRWJGRefer.ClientID;
            base.DataKeyNames = new string[] { "XLXSCLHQ_BJCLID", "XLXSCLHQ_YXQS", "XLXSBJCL_BJHQ", "HQJCL", "XLXSCLHQ_HSCGJG", "XLXSCLHQ_HSJG", "XLXSBJCL_TYBZ" };

            if (!IsPostBack)
            {
                CurQueryEntity.FieldByName("CKRQ").Value = DateTime.Now.Date.ToString();
                CurQueryEntity.FieldByName("PXFS").Value = "ID";
            }

            if (!IsPostBack)
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Clear();
                string sExistRecord = "select XLXSJGB_JGBID from XLXSJGB where XLXSJGB_MXBH='JGD' and XLXSJGB_JGBID='ZZZZZZZZ' ";
                if (!CMISproDataBase.ExistsRecord("DBERP", sExistRecord))
                {
                    SQL.Clear();
                    sExistRecord = "insert into XLXSJGB(XLXSJGB_MXBH,XLXSJGB_JGBID,XLXSJGB_JGBMC) values('JGD','ZZZZZZZZ','基础材料行情') ";
                    dberp.ExecSQL(sExistRecord);
                }
            }

            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_WSJG").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_HSJG").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_WSJGF").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_HSJGF").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_WSCGJG").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQ_HSCGJG").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;

            base.InitPage();

            this.Master.StandardEditButton.OnClientClick = "";
            this.Master.StandardEditButton.Click += new EventHandler(StandardEditButton_Click);

            this.Master.StandardViewButton.OnClientClick = "";
            this.Master.StandardViewButton.Click += new EventHandler(StandardViewButton_Click);

            InitControl();
            if (!IsPostBack)
            {
                Master_OnStandardQuery(null, null);
            }
        }
        #endregion

        #region 模板事件继承
        protected override void Master_OnStandardQuery(object sender, EventArgs e)
        {
            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetSQL();
            base.Master_OnStandardQuery(sender, e);
            entity.GridDataBind(grdContentGrid, tSession);
        }

        protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone)
        {
            entity.Param.Add("OLD_XLXSCLHQ_BJCLID", this.grdContentGrid.SelectedDataKey["XLXSCLHQ_BJCLID"].ToString());
            entity.Param.Add("OLD_XLXSCLHQ_YXQS", this.grdContentGrid.SelectedDataKey["XLXSCLHQ_YXQS"].ToString());
            base.BeforeDelete(db, ref ActionIsDone);
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            bool bReturn = base.Master_BeforeDeleteAction(sender, e);

            return bReturn;
        }
        

        protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                LinkPageParam.AddString("XLXSCLHQ_BJCLID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSCLHQ_BJCLID"].ToString().Trim());
                LinkPageParam.AddString("XLXSCLHQ_YXQS", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSCLHQ_YXQS"].ToString().Trim());

                //如果采购价格为空，则行情价差率不需要标红
                bool bNeedFlag =(CMISproConvert.StrToFloat(grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSCLHQ_HSCGJG"].ToString().Trim()) == 0);

                int indexHQJCL = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("HQJCL"));
                if (CMISproConvert.StrToFloat(grdContentGrid.DataKeys[e.Row.RowIndex]["HQJCL"].ToString().Trim()) <= 0 && !bNeedFlag)
                {
                    e.Row.Cells[indexHQJCL].BackColor = System.Drawing.Color.Red;//第indexHQJCL列的颜色
                }
            }

            base.moduleGV_RowDataBound(sender, e);
        }

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

            base.moduleGV_PageIndexChanging(sender, e);
        }

        #endregion

        #region 自定义函数

        private string GetSQL()
        {
            StringBuilder sSQL = new StringBuilder();
            sSQL.AppendLine(" select XLXSBJCL_BJCLID as XLXSCLHQ_BJCLID ,XLXSBJCL_BJCLMC,XLXSBJCL_BJHQ,isnull(XLXSBJCL_ZZSL,0.0) as XLXSBJCL_ZZSL,");
            sSQL.AppendLine(" isnull(XLXSCLHQ_WSJG,0.0) as XLXSCLHQ_WSJG ,isnull(XLXSCLHQ_HSJG,0.0) as XLXSCLHQ_HSJG ,XLXSCLHQ_YXQS,XLXSCLHQ_YXQZ,XLXSBJCL_CGY,XLXSBJCL_HQBDPL,isnull(XLXSCLHQ_BZ, ' ') as XLXSCLHQ_BZ ,isnull(XLXSCLHQ_WHRID, ' ') as XLXSCLHQ_WHRID,isnull(XLXSCLHQ_WHR, ' ') as XLXSCLHQ_WHR , XLXSCLHQ_WHSJ, ");
            //sSQL.AppendLine(" isnull(C.maxHSJG,0) as ZGHSWLJG,");
            //sSQL.AppendLine(" case  when isnull(XLXSCLHQ_HSJG,0.0) = 0.0 then 0.0 else (isnull(XLXSCLHQ_HSCGJG,0.0) - isnull(XLXSCLHQ_HSJG,0.0))/isnull(XLXSCLHQ_HSJG,0.0)*100 end as HQJCL,");
            //“行情价差率%”计算公式改为：含税材料价格/含税采购价格-1，当行情价差率≤0时，标红警示。
            sSQL.AppendLine(" case  when isnull(XLXSCLHQ_HSCGJG,0.0) = 0.0 then 0.0 else RoundFix((isnull(XLXSCLHQ_HSJG,0.0) - isnull(XLXSCLHQ_HSCGJG,0.0))/isnull(XLXSCLHQ_HSCGJG,0.0),14)*100 end as HQJCL,");
            sSQL.AppendLine(" isnull(XLXSCLHQ_WSJGF,0.0) as XLXSCLHQ_WSJGF ,isnull(XLXSCLHQ_HSJGF,0.0) as XLXSCLHQ_HSJGF,");
            sSQL.AppendLine(" isnull(XLXSCLHQ_WSCGJG,0.0) as XLXSCLHQ_WSCGJG ,isnull(XLXSCLHQ_HSCGJG,0.0) as XLXSCLHQ_HSCGJG,");
            sSQL.AppendLine(" XLXSBJCL_QYRQ,isnull(XLXSBJCL_TYBZ,'N') as XLXSBJCL_TYBZ,XLXSBJCL_TYRQ ");
            sSQL.AppendLine(" from XLXSBJCL left join ");
            sSQL.AppendLine(" ( ");
            sSQL.AppendLine(" select XLXSCLHQ_BJCLID,XLXSCLHQ_WSJG,XLXSCLHQ_HSJG,XLXSCLHQ_YXQS,XLXSCLHQ_YXQZ,XLXSCLHQ_BZ,XLXSCLHQ_WHRID,XLXSCLHQ_WHR,XLXSCLHQ_WHSJ, ");
            sSQL.AppendLine("        XLXSCLHQ_WSJGF,XLXSCLHQ_HSJGF,XLXSCLHQ_WSCGJG,XLXSCLHQ_HSCGJG");
            sSQL.AppendLine(" from XLXSCLHQ, ");
            sSQL.AppendLine(" ( ");
            sSQL.AppendLine(" select XLXSCLHQ_BJCLID as BJCLID,max(XLXSCLHQ_YXQS) as maxYXQS ");
            sSQL.AppendLine(" from XLXSCLHQ ");
            sSQL.AppendLine(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
            sSQL.AppendLine(" and XLXSCLHQ_YXQS<=:pCKRQ and (XLXSCLHQ_YXQZ is null or XLXSCLHQ_YXQZ>=:pCKRQ) ");
            sSQL.AppendLine(" group by XLXSCLHQ_BJCLID ");
            sSQL.AppendLine(" ) b ");
            sSQL.AppendLine(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
            sSQL.AppendLine(" and XLXSCLHQ_BJCLID=BJCLID ");
            sSQL.AppendLine(" and XLXSCLHQ_YXQS=maxYXQS ");
            sSQL.AppendLine(" ) a on XLXSCLHQ_BJCLID=XLXSBJCL_BJCLID ");
            //关联获取最高材料价格
            //sSQL.AppendLine("  left join  ");
            //sSQL.AppendLine("  ( ");
            //sSQL.AppendLine("   select XLXSBJCLWL_BJCLID,max(XLXSWLHQ_HSJG) as maxHSJG  ");
            //sSQL.AppendLine("   from XLXSWLHQ ");
            //sSQL.AppendLine("   left join XLXSBJCLWL on XLXSBJCLWL_WLID = XLXSWLHQ_WLID ");
            //sSQL.AppendLine("   where XLXSWLHQ_JGBID=' ' ");
            //sSQL.AppendLine("   and XLXSWLHQ_YXQS<=:pCKRQ and (XLXSWLHQ_YXQZ is null or XLXSWLHQ_YXQZ>=:pCKRQ)  ");
            //sSQL.AppendLine("   group by XLXSBJCLWL_BJCLID  ");
            //sSQL.AppendLine("   ) c ON c.XLXSBJCLWL_BJCLID = XLXSBJCL_BJCLID");
            sSQL.AppendLine(" where isnull(XLXSBJCL_BJCLMC, ' ')<> ' ' ");
            entity.Param.Add("pCKRQ", CurQueryEntity.FieldByName("CKRQ").Value);

            if (!CurQueryEntity.FieldByName("BJCLMC").Value.Trim().Equals(""))
            {
                sSQL.AppendLine(" and XLXSBJCL_BJCLMC like :pBJCLMC ");
                entity.Param.Add("pBJCLMC", "%" + CurQueryEntity.FieldByName("BJCLMC").Value.Trim() + "%");
            }

            if (!CurQueryEntity.FieldByName("BJHQ").Value.Trim().Equals(""))
            {
                sSQL.AppendLine(" and XLXSBJCL_BJHQ = :pBJHQ ");
                entity.Param.Add("pBJHQ", CurQueryEntity.FieldByName("BJHQ").Value.Trim());
            }

            if (!CurQueryEntity.FieldByName("CGY").Value.Trim().Equals(""))
            {
                sSQL.AppendLine(" and XLXSBJCL_CGY like :pCGY ");
                entity.Param.Add("pCGY", "%" + CurQueryEntity.FieldByName("CGY").Value.Trim() + "%");
            }

            if (!CurQueryEntity.FieldByName("HQBDPL").Value.Trim().Equals(""))
            {
                sSQL.AppendLine(" and isnull(XLXSBJCL_HQBDPL,' ') = :pHQBDPL ");
                if (CurQueryEntity.FieldByName("HQBDPL").Value.Trim().Equals("未设置"))
                    entity.Param.Add("pHQBDPL", " ");
                else
                    entity.Param.Add("pHQBDPL", CurQueryEntity.FieldByName("HQBDPL").Value.Trim());
            }

            //勾选了
            if (CurQueryEntity.FieldByName("CXByJGCZB").Value.Trim().ToUpper().Equals("TRUE"))
            {
                sSQL.AppendLine(" and exists( select XLJGCZBLM_BJCLID from XLJGCZBLM WHERE XLJGCZBLM_JGCZBID = :pJGCZBID   ");
                sSQL.AppendLine(" and XLJGCZBLM_JGCZBBBID = :pJGCZBBBID and XLXSBJCL_BJCLID= XLJGCZBLM_BJCLID ) ");
                entity.Param.Add("pJGCZBID", CurQueryEntity.FieldByName("JGCZBID").Value.Trim().Split('|')[0]);
                entity.Param.Add("pJGCZBBBID", CurQueryEntity.FieldByName("JGCZBBBID").Value.Trim());

                //用量为0的材料不显示
                if (CurQueryEntity.FieldByName("YLWLBXS").Value.Trim().ToUpper().Equals("TRUE"))
                {
                    TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                    TSQL SQL = new TSQL(dberp);
                    SQL.Clear();
                    SQL.Add("select XLJGCZBLM_CLQDL,XLJGCZBLM_BJCLID from XLJGCZBLM");
                    SQL.Add(" WHERE XLJGCZBLM_JGCZBID = :pJGCZBID and XLJGCZBLM_JGCZBBBID = :pJGCZBBBID");
                    SQL.Add("   and isnull(XLJGCZBLM_BJCLID,' ')<>' ' and isnull(XLJGCZBLM_CLQDL,' ')<>' '");
                    SQL.Add(" order by XLJGCZBLM_CLQDL");
                    SQL.ParamByName("pJGCZBID").Value = CurQueryEntity.FieldByName("JGCZBID").Value.Trim().Split('|')[0];
                    SQL.ParamByName("pJGCZBBBID").Value = CurQueryEntity.FieldByName("JGCZBBBID").Value.Trim();
                    DataSet ds = dberp.OpenDataSet(SQL);
                    string sUseBJCLIDList = "";//记录用量不为0的报价材料，此处不能反着记用量为0的报价材料
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        SQL.Clear();
                        SQL.Add("select ");
                        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                        {
                            if (i == 0)
                                SQL.Add(string.Format(" sum(XLXSCLQD_SL{0}) as SL{0} ", ds.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim().Replace("第", "").Replace("列", "")));
                            else
                                SQL.Add(string.Format(" ,sum(XLXSCLQD_SL{0}) as SL{0} ", ds.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim().Replace("第", "").Replace("列", "")));
                        }
                        SQL.Add(" from XLXSCLQD ");
                        SQL.Add(" where XLXSCLQD_JGCZBID=:pJGCZBID and XLXSCLQD_JGCZBBBID=:pJGCZBBBID");
                        if (!CurQueryEntity.FieldByName("XLXHID").Value.Trim().Equals(""))
                        {
                            SQL.Add(" and XLXSCLQD_XLXHID=:pXLXHID ");
                            SQL.ParamByName("pXLXHID").Value = CurQueryEntity.FieldByName("XLXHID").Value.Trim();
                        }
                        if (!CurQueryEntity.FieldByName("DYDJ").Value.Trim().Equals(""))
                        {
                            SQL.Add(" and XLXSCLQD_DYDJID=:pDYDJ ");
                            SQL.ParamByName("pDYDJ").Value = CurQueryEntity.FieldByName("DYDJ").Value.Trim();
                        }
                        SQL.ParamByName("pJGCZBID").Value = CurQueryEntity.FieldByName("JGCZBID").Value.Trim().Split('|')[0];
                        SQL.ParamByName("pJGCZBBBID").Value = CurQueryEntity.FieldByName("JGCZBBBID").Value.Trim();
                        DataSet dsQD = dberp.OpenDataSet(SQL);

                        if (dsQD.Tables[0].Rows.Count > 0)
                        {
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                //用量之和大于0认为报价材料被使用
                                if (CMISproConvert.StrToFloat(dsQD.Tables[0].Rows[0]["SL" + ds.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim().Replace("第", "").Replace("列", "")].ToString()) > 0)
                                {
                                    sUseBJCLIDList += ds.Tables[0].Rows[i]["XLJGCZBLM_BJCLID"].ToString().Trim() + ",";
                                }
                            }
                        }
                    }
                    sUseBJCLIDList = sUseBJCLIDList.TrimEnd(',');
                    sSQL.AppendLine(" and " + CMISproDataBase.GetWhereEqual("XLXSBJCL_BJCLID", sUseBJCLIDList));
                }
            }

            if (CurQueryEntity.FieldByName("HQWS").Value.Trim().ToUpper().Equals("TRUE"))
            {
                sSQL.AppendLine(" and isnull(XLXSCLHQ_BJCLID,' ') = ' ' ");
            }

            if (!CurQueryEntity.FieldByName("XSTYCL").Value.Trim().ToUpper().Equals("TRUE"))
            {
                sSQL.AppendLine(" and isnull(XLXSBJCL_TYBZ,'N') <> 'Y'  ");
            }

            if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("ID"))
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSBJCL_BJCLID ");
            else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("MC"))
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSBJCL_BJCLMC,XLXSBJCL_BJCLID ");
            else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("AWHSJDP"))
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSCLHQ_WHSJ desc,XLXSBJCL_BJCLID ");
            else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("HQJCLD+ID"))
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),HQJCL DESC,XLXSBJCL_BJCLID ");
            else if (CurQueryEntity.FieldByName("PXFS").Value.Trim().Equals("HQJCLD+MC"))
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),HQJCL DESC,XLXSBJCL_BJCLMC,XLXSBJCL_BJCLID ");
            else
                sSQL.AppendLine(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSBJCL_BJCLID ");

            return sSQL.ToString();
        }

        private void InitControl()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select  top 1 XLXSBJCL_BJHQ from XLXSBJCL where XLXSBJCL_BJHQ = '2' ");
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                //grdContentGrid.Columns[2].Visible = true;
                //grdContentGrid.Columns[7].Visible = true;
                //grdContentGrid.Columns[8].Visible = true;
                btnWLHQ.Visible = true;
            }
            else
            {
                //grdContentGrid.Columns[2].Visible = false;
                //grdContentGrid.Columns[7].Visible = false;
                //grdContentGrid.Columns[8].Visible = false;
                btnWLHQ.Visible = false;
            }
        }

        //是否有100860032模块浏览权限
        private bool CheckYJLL(string sGH)
        {
            UserRight UR = OpRightUtils.GetUserRight(sGH, 100860032);
            return (DSActiveModule.IsActiveModule(100860032) && UR.Open);
        }

        private void OpenInfo(TPageCallAction tpCallAction)
        {
            base.InitEntityByCondition();
            string sBJCLID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSCLHQ_BJCLID"].ToString().Trim();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Clear();
            sSQL.Add("select XLXSCLHQ_YXQS,XLXSBJCL_BJHQ from XLXSBJCL left join ");
            sSQL.Add(" ( ");
            sSQL.Add(" select XLXSCLHQ_BJCLID,XLXSCLHQ_YXQS ");
            sSQL.Add(" from XLXSCLHQ, ");
            sSQL.Add(" ( ");
            sSQL.Add(" select XLXSCLHQ_BJCLID as BJCLID,max(XLXSCLHQ_YXQS) as maxYXQS ");
            sSQL.Add(" from XLXSCLHQ ");
            sSQL.Add(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
            sSQL.Add(" and XLXSCLHQ_YXQS<=:pCKRQ and (XLXSCLHQ_YXQZ is null or XLXSCLHQ_YXQZ>=:pCKRQ) ");
            sSQL.Add(" group by XLXSCLHQ_BJCLID ");
            sSQL.Add(" ) b ");
            sSQL.Add(" where XLXSCLHQ_JGBID='ZZZZZZZZ' ");
            sSQL.Add(" and XLXSCLHQ_BJCLID=BJCLID ");
            sSQL.Add(" and XLXSCLHQ_YXQS=maxYXQS ");
            sSQL.Add(" ) a on XLXSCLHQ_BJCLID=XLXSBJCL_BJCLID ");
            sSQL.Add(" where XLXSBJCL_BJCLID =:pBJCLID ");
            sSQL.ParamByName("pBJCLID").Value = sBJCLID;
            sSQL.ParamByName("pCKRQ").Value = CurQueryEntity.FieldByName("CKRQ").Value;
            DataSet ds = dberp.OpenDataSet(sSQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                string sYXQS = ds.Tables[0].Rows[0]["XLXSCLHQ_YXQS"].ToString().Trim();
                string sBJHQ = ds.Tables[0].Rows[0]["XLXSBJCL_BJHQ"].ToString().Trim();
                if (sBJHQ.Equals("1"))
                {
                    TPageParams tpp = new TPageParams();
                    tpp.UrlPath = "CLHQInfo.aspx";
                    tpp.AddString("XLXSCLHQ_BJCLID", sBJCLID);
                    tpp.AddString("XLXSCLHQ_YXQS", sYXQS);
                    tpp.CallAction = tpCallAction;
                    OpenDialog(tpp);
                }
                else
                {
                    if (CheckYJLL(tSession.UserId))
                    {
                        TPageParams tpp = new TPageParams();
                        tpp.UrlPath = "WLHQList.aspx";
                        tpp.AddString("XLXSCLHQ_BJCLID", sBJCLID);
                        tpp.CallAction = TPageCallAction.pcaBrowse;
                        OpenModuleDialog(100860032, tpp);
                    }
                    else
                    {
                        btnWLHQ_Click(null, null);
                    }
                }
            }
        }
        #endregion

        protected void btnCLJGTZ_Click(object sender, EventArgs e)
        {
            TPageParams pageParams = new TPageParams();
            pageParams.UrlPath = "XLJGB_CLJGTZList.aspx";
            pageParams.AddString("btnRefreshCID", btnRefresh.ClientID);
            OpenFuncModuleDialog(100860001, pageParams);
        }

        protected void btnWLHQ_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择需要处理的记录！");
                return;
            }
            base.InitEntityByCondition();
            string sBJCLID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSCLHQ_BJCLID"].ToString().Trim();
            string sBJHQ = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJCL_BJHQ"].ToString().Trim();
            if (!sBJHQ.Equals("2"))
            {
                ShowMessage("仅能查看“报价行情”为“2|物料行情”的报价材料！");
                return;
            }

            TPageParams pageParams = new TPageParams();
            pageParams.UrlPath = "XLBJD_WLHQList.aspx";
            pageParams.AddString("BJCLID", sBJCLID);
            pageParams.AddString("FROM", "CLHQ");
            pageParams.AddString("JGBID", "ZZZZZZZZ");
            pageParams.AddString("BJRQ", CurQueryEntity.FieldByName("CKRQ").Value);
            OpenFuncModuleDialog(100860000, pageParams);
        }

        protected void btnDRCLHQ_Click(object sender, EventArgs e)
        {
            TPageParams pageParams = new TPageParams();
            pageParams.UrlPath = "CLHQ_DRInfo.aspx";
            pageParams.CallAction = TPageCallAction.pcaInsert;
            OpenDialogClickBtn(pageParams, btnRefresh.ClientID);
        }

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

        protected void btnGRWJGRefer_Click(object sender, EventArgs e)
        {
            int tmpIndex = grdContentGrid.SelectedIndex;
            moduleGV_PageIndexChanging(null, null);
            grdContentGrid.SelectedIndex = tmpIndex;
        }

        protected void grdContentGrid_RowDoubleClick(object sender, GThinking.N_CONTROL.RowDoubleClickEventArgs e)
        {
            OpenInfo(TPageCallAction.pcaBrowse);
        }

        protected void StandardEditButton_Click(object sender, EventArgs e)
        {
            if (grdContentGrid.SelectedIndex < 0)
            {
                ShowMessage("请选择处理记录！");
                return;
            }
            string sTYBZ = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJCL_TYBZ"].ToString().Trim();
            if (sTYBZ.Equals("Y"))
            {
                ShowMessage("当前记录已停用，不允许编辑！");
                return;
            }
            string sSQL = @"select 1 from XLXSBJCL where XLXSBJCL_BJCLID = '" + grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSCLHQ_BJCLID"].ToString().Trim() + "' and XLXSBJCL_SFQR='N' ";
            if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
            {
                ShowMessage("报价材料未确认，不允许编辑！");
                return;
            }
            OpenInfo(TPageCallAction.pcaEdit);
        }

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