前台代码:
<%@ Register TagPrefix="cc1" Namespace="Morrowsoft.WebUI" Assembly="Morrowsoft.WebUI.Pager" %> <%@ Page language="c#" Codebehind="ChangeDetail.aspx.cs" AutoEventWireup="false" Inherits="ProjectBillChange.ChangeDetail" %> <%@ Register TagPrefix="igtbl" Namespace="Infragistics.WebUI.UltraWebGrid" Assembly="Infragistics.WebUI.UltraWebGrid.v3.1, Version=3.1.20042.26, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>ChangeDetail</title> <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR"> <meta content="C#" name="CODE_LANGUAGE"> <meta content="JavaScript" name="vs_defaultClientScript"> <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> <LINK href="../Commons/Css/GridStyle.css" type="text/css" rel="stylesheet"> <LINK href="../Commons/Css/MrDocStyle.css" type="text/css" rel="stylesheet"> <LINK href="../Commons/Css/style.css" type="text/css" rel="stylesheet"> <script language="javascript" src="../Commons/Js/AJAXCore.js" type="text/javascript"></script> <script language="javascript" src="../Commons/Js/LinkProjectCommons.js" type="text/javascript"></script> <script language="javascript" type="text/javascript"> function Add() { //Form1.hdprj.value="<%=Request.QueryString["prjid"]%>"; Form1.hdprj.value=GetQueryString("prjid"); Form1.hdIsChecked.value=GetQueryString("ischecked"); if(Form1.hdprj.value==null) { alert("请选择项目名称!"); return; } if(Form1.hdItemChangeID.value=="") { alert("请选择一个清单!"); return; } if(Form1.hdIsChecked.value=="已审核") { alert("已经审核,不能再添加!"); return; } window.showModalDialog("ChangeDetailAdd.aspx?ItemChangeID="+Form1.hdItemChangeID.value+"&prjid="+Form1.hdprj.value+"&info=add",window,"dialogwidth=450px;dialogheight=340px;status=no;center=yes"); } function Mod() { if(Form1.hdprj.value==null) { alert("请选择项目名称!"); return; } if(Form1.hdItemChangeID.value=="") { alert("请选择一个清单!"); return; } Form1.hdIsChecked.value=GetQueryString("ischecked"); if(Form1.hdIsChecked.value=="已审核") { alert("已经审核,不能再修改!"); return; } window.showModalDialog("FItemChangeDetailModify.aspx?ItemChangeID="+Form1.hdItemChangeID.value+"&prjid="+Form1.hdprj.value,window,"dialogwidth=450px;dialogheight=300px;status=no;center=yes"); } function DelNode() { //Form1.hdprj.value="<%=Request.QueryString["prjid"]%>"; Form1.hdprj.value=GetQueryString("prjid"); Form1.hdIsChecked.value=GetQueryString("ischecked"); if(Form1.hdprj.value==null) { alert("请选择项目名称!"); return; } if(Form1.hdItemChangeID.value=="") { alert("请选择一个清单!"); return; } if(Form1.hdIsChecked.value=="已审核") { alert("已经审核,不能再删除!"); return; } window.showModalDialog("ChangeDetailDelete.aspx?ItemChangeID="+Form1.hdItemChangeID.value+"&prjid="+Form1.hdprj.value,window,"dialogwidth=450px;dialogheight=300px;status=no;center=yes"); } function Reload() { window.location.href="ChangeDetail.aspx?ItemChangeID="+Form1.hdItemChangeID.value +"&prjid="+Form1.hdprj.value+"&index="+document.getElementById("Pager1_list").value; } function UltraWebGrid1_AfterRowActivateHandler(gridName, rowId){ var row=igtbl_getActiveRow("UltraWebGrid1"); if(row==null) return; Form1.hdChangeID.value=row.getCellFromKey("ChangeID").getValue(); } function EditNode() { //Form1.hdprj.value="<%=Request.QueryString["prjid"]%>"; Form1.hdprj.value=GetQueryString("prjid"); if(Form1.hdprj.value==null) { alert("请选择项目名称!"); return; } if(Form1.hdItemChangeID.value=="") { alert("请选择一个清单!"); return; } Form1.hdIsChecked.value=GetQueryString("ischecked"); if(Form1.hdIsChecked.value=="已审核") { alert("已经审核不能修改!"); return; } window.showModalDialog("ChangeDetailAdd.aspx?ChangeID="+Form1.hdChangeID.value+"&prjid="+Form1.hdprj.value+"&info=edit",window,"dialogwidth=450px;dialogheight=340px;status=no;center=yes"); } function Del() { //Form1.hdprj.value="<%=Request.QueryString["prjid"]%>"; Form1.hdprj.value=GetQueryString("prjid"); if(Form1.hdprj.value==null) { alert("请选择项目名称!"); return; } else if(Form1.hdItemChangeID.value=="") { alert("请选择一个清单!"); return; } else if(Form1.hdIsChecked.value=="已审核") { alert("已经审核不能删除!"); return; } if(window.confirm('您确定删除吗?')) { XmlHttpSendData("DelData.aspx?ChangeID="+Form1.hdChangeID.value,GetResult_CallBack,"","GET",true); } } function GetResult_CallBack(XMLResponse) { var ret=XMLResponse.documentElement.text; if(ret=="0") { alert("删除成功!"); window.location.href=window.location.href; } else { alert(ret); return; } } </script> </HEAD> <body bottomMargin="0" leftMargin="0" topMargin="0" scroll="no" rightMargin="0" MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> <table height="100%" cellSpacing="0" cellPadding="0" width="100%" border="0"> <TR> <TD style="FILTER:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#FFDDECFE', EndColorStr='#FF84ABE3')" align="left" height="25"><A class="MrDocButton" id="Bt_AddNode" style="WIDTH: 65px; HEIGHT: 20px" οnclick="Add()">添加清单</A> <A class="MrDocButton" id="Bt_ModNode" style="WIDTH: 65px; HEIGHT: 20px" οnclick="Mod()"> 修改清单</A> <A class="MrDocButton" id="Bt_DelNode" style="WIDTH: 65px; HEIGHT: 20px" οnclick="DelNode()"> 删除清单</A> <INPUT id="hdItemChangeID" type="hidden" size="1" name="hdChangeID" runat="server"> <INPUT id="hdChangeID" type="hidden" size="1" name="hdChangeID" runat="server"> <INPUT id="hdindex" type="hidden" size="1" value="0" name="hdindex" runat="server"> <INPUT id="hdprj" type="hidden" size="1" name="hdChangeID" runat="server"><INPUT id="hdIsChecked" type="hidden" size="1" name="hdIsChecked" runat="server"></TD> </TR> <tr> <TD vAlign="top"><igtbl:ultrawebgrid id="UltraWebGrid1" runat="server" Height="100%" Width="100%"> <DisplayLayout ColWidthDefault="" StationaryMargins="Header" AutoGenerateColumns="False" AllowSortingDefault="Yes" RowHeightDefault="21px" Version="3.00" SelectTypeRowDefault="Single" HeaderClickActionDefault="SortSingle" BorderCollapseDefault="Separate" AllowColSizingDefault="Free" RowSelectorsDefault="No" Name="UltraWebGrid1" TableLayout="Fixed" CellClickActionDefault="RowSelect" NoDataMessage="暂无数据!" AllowUpdateDefault="Yes"> <AddNewBox> <Style BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray"> <BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"> </BorderDetails> </Style> </AddNewBox> <Pager PageSize="10" StyleMode="CustomLabels" Alignment="Center" AllowPaging="True"> <Style BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray"> <BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"> </BorderDetails> </Style> </Pager> <HeaderStyleDefault Font-Size="9pt" Font-Names="宋体" Font-Bold="True" BorderStyle="Solid" ForeColor="#E1E8F5" BackColor="#11459E" Height="23px" CustomRules="background-image:url(/ig_common/WebGrid3/Office2003BlueBG.png);background-repeat:repeat-x;"> <BorderDetails ColorTop="173, 197, 235" WidthLeft="1px" WidthTop="1px" ColorLeft="173, 197, 235"></BorderDetails> </HeaderStyleDefault> <FrameStyle Width="100%" BorderWidth="1px" Font-Size="8pt" Font-Names="Verdana" BorderStyle="Solid" Height="100%"></FrameStyle> <FooterStyleDefault BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray"> <BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails> </FooterStyleDefault> <ClientSideEvents AfterRowActivateHandler="UltraWebGrid1_AfterRowActivateHandler"></ClientSideEvents> <EditCellStyleDefault BorderWidth="0px" BorderStyle="None"></EditCellStyleDefault> <SelectedRowStyleDefault Cursor="Hand" BorderColor="Transparent" ForeColor="HighlightText" BackColor="#F09D21" CustomRules="background-image:url(/ig_common/WebGrid3/Office2003SelRow.png);background-repeat:repeat-x;"> <Padding Bottom="0px" Left="0px" Top="0px" Right="0px"></Padding> <Margin Bottom="0px" Left="0px" Top="0px" Right="0px"></Margin> </SelectedRowStyleDefault> <RowAlternateStyleDefault HorizontalAlign="Center" BackColor="WhiteSmoke"></RowAlternateStyleDefault> <RowStyleDefault Cursor="Hand" BorderWidth="0px" BorderColor="ScrollBar" BorderStyle="Solid" HorizontalAlign="Center" ForeColor="Black" BackColor="White"> <Padding Left="3px"></Padding> <BorderDetails WidthLeft="0px" WidthTop="0px"></BorderDetails> </RowStyleDefault> </DisplayLayout> <Bands> <igtbl:UltraGridBand Key="itemChange"> <Columns> <igtbl:UltraGridColumn HeaderText="变更ID" Key="ChangeID" Hidden="True" BaseColumnName="ChangeID" width="10%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="项目清单ID" Key="FID" Hidden="True" BaseColumnName="FID" width="10%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="项目编号" Key="FUserCode" BaseColumnName="FUserCode" width="10%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="项目名称" Key="FItemName" BaseColumnName="FItemName"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="单位" Key="FUnitName" BaseColumnName="FUnitName" width="10%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="合同数量" Key="FContractAmount" Format="¥ ###,###,##0.00" BaseColumnName="FContractAmount" width="10%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="合同单价(元)" Key="FContractPrice" Format="¥ ###,###,##0.00" BaseColumnName="FContractPrice" width="15%"></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="合同价值(元)" Key="FContractCost" Format="¥ ###,###,##0.00" BaseColumnName="FContractCost" width="15%" FooterText=""></igtbl:UltraGridColumn> <igtbl:UltraGridColumn HeaderText="变更类型" Key="ChangeType" BaseColumnName="ChangeType" width="8%"></igtbl:UltraGridColumn> <igtbl:TemplatedColumn Key="" Width="40px" HeaderText="修改" BaseColumnName="" AllowUpdate="Yes"> <CellTemplate> <FONT face="宋体"> <asp:ImageButton id="imgedit" οnclick="editnode" runat="server" BorderWidth="0px" ImageUrl="../../../images/icon_apln_typeedit.gif" CommandName="edit"></asp:ImageButton></FONT> </CellTemplate> </igtbl:TemplatedColumn> <igtbl:TemplatedColumn Key="" Width="40px" HeaderText="删除" BaseColumnName=""> <CellTemplate> <asp:ImageButton id="imgdel" runat="server" BorderWidth="0px" ImageUrl="../../../Images/icon_apln_reject.gif" CommandName="delete" OnClick="delete"></asp:ImageButton></FONT> </CellTemplate> </igtbl:TemplatedColumn> </Columns> </igtbl:UltraGridBand> </Bands> </igtbl:ultrawebgrid></TD> </tr> <TR> <TD align="right" height="25"><cc1:pager id="Pager1" runat="server" DataListControlID="UltraWebGrid1"></cc1:pager> </TD> </TR> </table> </form> </body> </HTML>
后台代码:
private void Page_Load(object sender, System.EventArgs e) { Response.Expires=0; Response.Cache.SetNoStore(); Response.AppendHeader("Program","no-cache");
if(Request.QueryString["ItemChangeID"] !=null) this.hdItemChangeID.Value=Request.QueryString["ItemChangeID"].ToString();
if(Request.QueryString["prjid"]!=null) this.hdprj.Value = Request.QueryString["ItemChangeID"].ToString();
if(Request.QueryString["prjid"]!=null) this.hdprj.Value=Request.QueryString["prjid"].ToString();
// if(LinkProjectBase.Authorization.IsAuthorized(int.Parse(this.TheSession["UsrID"].ToString()),"LINKPROJECT","PROJECTBILLCHANGE",true)==false) // { // JS.Alert("您没有权限!","../../Frame/Error.aspx?ErrorMessage=您没有权限!"); // }
if(!IsPostBack) { LoadData(this.hdItemChangeID.Value); }
} private void LoadData(string id) { try { string sql=string.Format("select ChangeID,FID,FUserCode,FItemName,FUnitName,FContractAmount,FContractPrice,FContractCost,CASE ChangeType WHEN 0 THEN '添加' WHEN 1 THEN '修改' WHEN 2 THEN '删除'END as ChangeType from PT_ItemChangeDetail WHERE ItemChangeID='{0}' Order BY ChangeID DESC",id); this.Pager1.QuerySQL = sql; this.Pager1.DataBind();
if(this.hdindex.Value!="0"&&this.hdindex.Value!="") this.Pager1.GotoPage(int.Parse(this.hdindex.Value)-1);
if(this.UltraWebGrid1.Rows.Count != 0) { this.UltraWebGrid1.Rows[0].Activate(); this.UltraWebGrid1.Rows[0].Selected=true; this.hdChangeID.Value=this.UltraWebGrid1.Rows[0].Cells[0].Text; } } catch(Exception ex) { js=new JS(); js.Alert("数据加载失败!","../../Frame.aspx?ErrorMessage="+ex.Message); } }
/// <summary> /// 模板列中的修改方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void editnode(object sender, System.Web.UI.ImageClickEventArgs e) { Page.RegisterStartupScript("ms","<script type='text/javascript' language='javascript'>EditNode();</script>"); }
/// <summary> /// 模板列中的删除方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void delete(object sender, System.Web.UI.ImageClickEventArgs e) { Page.RegisterStartupScript("ms","<script type='text/javascript' language='javascript'>Del();</script>"); }
图: