N_XLXSBJ----MX/XLXSBJCL_HQFDList.aspx.cs

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_PUBLIC;
using GThinking.N_MISPRO.Utility;
using System.Collections.Generic;
using GThinking.N_MODEL.Page;
namespace GThinking.N_XLXSBJ
{
    public partial class XLXSBJCL_HQFDList : SingleGridBase
    {
        XLXSBJCL_HQFD entity = new XLXSBJCL_HQFD();

        #region Page类事件继承
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860012;
            this.UMName = "线缆销售报价材料";
            this.CurMaster = Master;
            this.ModuleGV = grdContentGrid;
            this.CurEntity = entity;
            this.sURLTarget = "XLXSBJCL_HQFDInfo.aspx";
            this.PageHeight = 500;
            this.PageWidth = 700;
            this.CurMaster.EnableQueryBtn = false;
            Master.EnableNewBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            base.DataKeyNames = new string[] { "XLXSCLHQFD_CLHQDH", "XLXSCLHQFD_BJCLID" };

            string sBJCLID = PageParam.GetRTrimString("BJCLID");

            if (PageParam.GetBool("USED"))
            {
                btnFD.Visible = false;
                btnKR.Visible = true;
            }
            else
            {
                btnFD.Visible = true;
                btnKR.Visible = false;
            }

            grdContentGrid.FindColumnExByFieldName("XLXSCLHQFD_HSJGS").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQFD_HSJGZ").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQFD_CLJGS").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;
            grdContentGrid.FindColumnExByFieldName("XLXSCLHQFD_CLJGZ").NumberDecimalPlace = XLBJDUtils.BJCLPriceDecimal;

            base.InitPage();
            

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

        #region 模板事件继承

        protected override void Master_OnStandardQuery(object sender, EventArgs e)
        {
            entity.EntityTable.QuerySelSql = GetQuerySelSQL();

            base.Master_OnStandardQuery(sender, e);
            entity.GridDataBind(grdContentGrid, tSession);
        }

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

        protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone)
        {
            entity.Param.Add("XLXSCLHQFD_CLHQDH", this.grdContentGrid.SelectedDataKey["XLXSCLHQFD_CLHQDH"].ToString());
            entity.Param.Add("XLXSCLHQFD_BJCLID", this.grdContentGrid.SelectedDataKey["XLXSCLHQFD_BJCLID"].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("CLHQDH", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSCLHQFD_CLHQDH"].ToString().Trim());
                LinkPageParam.AddString("BJCLID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSCLHQFD_BJCLID"].ToString().Trim());
            }

            base.moduleGV_RowDataBound(sender, e);
        }

        #endregion

        #region 自定义事件

        /// <summary>
        /// 取查询语句
        /// </summary>
        /// <returns></returns>
        private string GetQuerySelSQL()
        {
            string sBJCLID = PageParam.GetRTrimString("BJCLID");
            
            string sSQL = "select XLXSCLHQFD_BJCLID,XLXSCLHQFD_CLHQDH,XLXSCLHQFD_HSJGS,XLXSCLHQFD_HSJGZ,XLXSCLHQFD_CLJGS,XLXSCLHQFD_CLJGZ,XLXSCLHQFD_WHR,XLXSCLHQFD_WHRID,XLXSCLHQFD_WHSJ "
             + "from XLXSCLHQFD "
               + "where  XLXSCLHQFD_BJCLID='" + sBJCLID + "'"
            + "order by XLXSCLHQFD_HSJGS ";
           
            return sSQL;
        }
        #endregion

        #region 按钮事件
        //分段按钮
        protected void btnFD_Click(object sender, EventArgs e)
        {
            string sBJCLID = PageParam.GetRTrimString("BJCLID");
            string sHQFD = "";
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("   select top 1 XLXSJGBPZCLHQFD_BJCLID from XLXSJGBPZCLHQFD ");
            SQL.Add("           where XLXSJGBPZCLHQFD_BJCLID=:pBJCLID");
            SQL.Add(" and exists(select 1 from XLXSJGBPZJGB where XLXSJGBPZJGB_JGBPZDH=XLXSJGBPZCLHQFD_JGBPZDH and XLXSJGBPZJGB_CLHQZH=XLXSJGBPZCLHQFD_CLHQZH and isnull(XLXSJGBPZJGB_JGBID,' ')<>' ')");
            SQL.ParamByName("pBJCLID").Value = sBJCLID;
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                sHQFD = "材料行情分段已被使用，不允许再次分段！" + "\r\n";
                ShowMessage(sHQFD);
                return;
            }
            else
            {
                TPageParams pageParams = new TPageParams();
                pageParams.CallAction = TPageCallAction.pcaInsert;
                pageParams.UrlPath = "XLXSBJCL_HQFDSZInfo.aspx";
                pageParams.AddString("BJCLID", sBJCLID);
                pageParams.AddString("btnRefresh1CID", btnRefresh.ClientID);
                OpenDialog(pageParams);
            }
        }

        //扩容按钮
        protected void btnKR_Click(object sender, EventArgs e)
        {
            string sBJCLID = PageParam.GetRTrimString("BJCLID");
            TPageParams pageParams = new TPageParams();
            pageParams.CallAction = TPageCallAction.pcaInsert;
            pageParams.UrlPath = "XLXSBJCL_HQFDKRInfo.aspx";
            pageParams.AddString("BJCLID", sBJCLID);
            pageParams.AddString("btnRefresh1CID", btnRefresh.ClientID);
            OpenDialog(pageParams);
        }

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