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_MISPRO.Utility; using GThinking.N_PUBLIC; using GThinking.N_CONTROL; namespace GThinking.N_XLJC { public partial class CPML_XHMLList : SingleGridBase { CPML_XHML entity = new CPML_XHML(); CPML_XHML_M queryentity = new CPML_XHML_M(); public string sCPML; private string sBJDID = ""; #region Page类事件继承 protected void Page_Load(object sender, EventArgs e) { this.UMID = 101421007; this.UMName = "适用型号电压"; this.CurMaster = Master; this.ModuleGV = grdGrid; this.CurEntity = entity; this.sURLTarget = "CPML_XHMLInfo.aspx"; this.CurQueryEntity = queryentity; this.sQueryURLTarget = "CPML_XHMLQuery.aspx"; this.PageHeight = 500; this.PageWidth = 700; this.sRefreshClientID = "default"; base.DataKeyNames = new string[] { "XLXSBJXHML_CPMLID", "XLXSBJXHML_XLXHID", "XLXSBJXHML_DYDJID" }; sBJDID = PageParam.GetRTrimString("BJDID").Trim(); if (!IsPostBack) { CurQueryEntity.FieldByName("XHJQPP").Value = "True"; if (!sBJDID.Equals("")) { CurQueryEntity.FieldByName("CPML").Value = "空"; } else { CurQueryEntity.FieldByName("CPML").Value = PageParam.GetRTrimString("CPMLID"); } if (!string.IsNullOrEmpty(PageParam.GetRTrimString("XLXHID"))) { CurQueryEntity.FieldByName("XHID").Value = PageParam.GetRTrimString("XLXHID"); } } this.CanDeleteCheckedRows = true; base.InitPage(); TGtGridView.SetGrdColItems("DBERP", grdGrid.FindColumnExByFieldName("XLXSBJXHML_CPMLID"), "select XLXSCPML_CPMLID,XLXSCPML_CPMLMC from XLXSCPML where 1 = 1 and isnull(XLXSCPML_TYBZ,'N')='N' "); if (!IsPostBack) { Master_OnStandardQuery(null, null); } } #endregion #region 模板事件继承 protected override void Master_OnStandardQuery(object sender, EventArgs e) { base.InitEntityByCondition(); base.Master_OnStandardQuery(sender, e); entity.EntityTable.QuerySelSql = GetSQL(); entity.GridDataBind(grdGrid, tSession); } protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone) { entity.Param.Add("XLXSBJXHML_CPMLID", grdGrid.DataKeys[grdGrid.SelectedIndex]["XLXSBJXHML_CPMLID"].ToString().Trim()); entity.Param.Add("XLXSBJXHML_DYDJID", grdGrid.DataKeys[grdGrid.SelectedIndex]["XLXSBJXHML_DYDJID"].ToString().Trim().Split('|')[0]); entity.Param.Add("XLXSBJXHML_XLXHID", grdGrid.DataKeys[grdGrid.SelectedIndex]["XLXSBJXHML_XLXHID"].ToString().Trim()); base.BeforeDelete(db, ref ActionIsDone); } protected override bool Master_AfterDeleteAction(object sender, EventArgs e) { base.InitEntityByCondition(); entity.EntityTable.QuerySelSql = GetSQL(); entity.GridDataBind(grdGrid, tSession); grdGrid.SelectedIndex = -1; return true; } protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkPageParam.AddString("XLXSBJXHML_CPMLID", grdGrid.DataKeys[e.Row.RowIndex]["XLXSBJXHML_CPMLID"].ToString().Trim()); LinkPageParam.AddString("XLXSBJXHML_DYDJID", grdGrid.DataKeys[e.Row.RowIndex]["XLXSBJXHML_DYDJID"].ToString().Trim()); LinkPageParam.AddString("XLXSBJXHML_XLXHID", grdGrid.DataKeys[e.Row.RowIndex]["XLXSBJXHML_XLXHID"].ToString().Trim()); LinkPageParam.AddString("CPML", CurQueryEntity.FieldByName("CPML").Value.Trim()); } base.moduleGV_RowDataBound(sender, e); } protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e) { base.InitEntityByCondition(); entity.EntityTable.QuerySelSql = GetSQL(); base.moduleGV_PageIndexChanging(sender, e); grdGrid.SelectedIndex = -1; } #endregion #region 自定义事件 private string GetSQL() { sCPML = queryentity.FieldByName("CPML").Value; TPageParams pageparams = new TPageParams(); pageparams.AddString("CPML", sCPML); if (!string.IsNullOrEmpty(PageParam.GetRTrimString("XLXHID"))) { pageparams.AddString("XLXHID", PageParam.GetRTrimString("XLXHID")); } SetNewFormParam(pageparams); string sSql = ""; sSql = @" select XLXSCPML_XSXH,XLXSBJXHML_CPMLID,XLXSBJXHML_XLXHID,XLXSBJXHML_DYDJID,XLXSBJXHML_ZSXH,XLXSBJXHML_WHR,XLXSBJXHML_WHRID,XLXSBJXHML_WHSJ from XLXSBJXHML left join XLDYDJB on XLDYDJB_DYDJID=XLXSBJXHML_DYDJID left join XLXSCPML on XLXSCPML_CPMLID=XLXSBJXHML_CPMLID where 1=1 and isnull(XLXSCPML_BJY,'N') = 'Y' "; if (CurQueryEntity.FieldByName("XHJQPP").Value.ToString().Trim().ToUpper().Equals("TRUE")) { if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHID").Value.Trim())) { sSql += " and XLXSBJXHML_XLXHID=:pXHID "; entity.Param.Add("pXHID", CurQueryEntity.FieldByName("XHID").Value.Trim()); } } else { if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XHID").Value.Trim())) { sSql += " and XLXSBJXHML_XLXHID like :pXHID "; entity.Param.Add("pXHID", "%" + CurQueryEntity.FieldByName("XHID").Value.Trim() + "%"); } } if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("CPML").Value.Trim())) { if (CurQueryEntity.FieldByName("CPML").Value.Trim().Equals("空")) { sSql += " and isnull(XLXSBJXHML_CPMLID,' ') = ' ' "; } else { sSql += " and XLXSBJXHML_CPMLID=:pCPMLID "; entity.Param.Add("pCPMLID", CurQueryEntity.FieldByName("CPML").Value.Trim()); } } if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("DYDJID").Value.Trim())) { sSql += " and XLXSBJXHML_DYDJID=:pDYDJID "; entity.Param.Add("pDYDJID", CurQueryEntity.FieldByName("DYDJID").Value.Trim()); } sSql += "order by XLXSCPML_XSXH,XLXSBJXHML_CPMLID,XLXSBJXHML_ZSXH,XLXSBJXHML_XLXHID,XLDYDJB_XH"; return sSql; } #endregion #region 控件事件 protected void btnDR_DropDown(object sender, EventArgs e) { btnDR.Nodes.Clear(); btnDR.Nodes.Add(new gtTreeNode("ZCLQDDR", "自材料清单导入")); btnDR.Nodes.Add(new gtTreeNode("EXCELDR", "EXCEL导入")); MenuAreaUpdate(); } protected void btnDR_MenuItemClick(object sender, string value) { base.InitEntityByCondition(); if (string.IsNullOrEmpty(CurQueryEntity.FieldByName("CPML").Value.Trim()) || CurQueryEntity.FieldByName("CPML").Value.Trim().Equals("空")) { ShowMessage("请先查询产品目录！"); return; } string sCPMLID = CurQueryEntity.FieldByName("CPML").Value.Trim(); TPageParams pageParams = new TPageParams(); switch (value) { case "ZCLQDDR": pageParams.UrlPath = "CPML_PLDRList.aspx"; pageParams.AddString("CPMLID", sCPMLID); pageParams.AddString("XHMLLB", "BJ"); OpenModuleDialog(101421007, pageParams); break; case "EXCELDR": pageParams.UrlPath = "CPML_DRInfo.aspx"; OpenDialog(pageParams); break; } } protected void btnXHMLXQ_OnClick(object sender, EventArgs e) { if (grdGrid.SelectedIndex == -1) { ShowMessage("请选择记录！"); return; } string sMLXLXHID = grdGrid.DataKeys[grdGrid.SelectedIndex]["XLXSBJXHML_XLXHID"].ToString().Trim(); string sMLDYDJID = grdGrid.DataKeys[grdGrid.SelectedIndex]["XLXSBJXHML_DYDJID"].ToString().Trim(); TPageParams pageParams = new TPageParams(); pageParams.UrlPath = "XHMLXQList.aspx"; pageParams.AddString("MLXLXHID", sMLXLXHID); pageParams.AddString("MLDYDJID", sMLDYDJID); OpenModuleDialog(101421007, pageParams); } #endregion } }