Aspx页面书写规范

------------------------------------------------------------页面代码开始------------------------------------------------------

 

<%@ Page Language="C#" Theme="Default" AutoEventWireup="true" CodeFile="MTrainList.aspx.cs"

    Inherits="Modules_Resource_Training_TrainingManage_TrainList" %>

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>活动列表</title>

    <script type="text/javascript" src="/EPMSWeb/Scripts/FormValidator.js"></script>

    <script type="text/javascript" src="/EPMSWeb/Scripts/My97DatePicker/WdatePicker.js"></script>

    <script type="text/javascript" src="/EPMSWeb/Scripts/Common.js"></script>

    <script type="text/javascript" language="javascript">

        //编辑记录

        function openEdit(actType, PlanID) {

            var sFeatures = "dialogHeight: 900px; dialogWidth: 690px; dialogTop: px; dialogLeft: px; edge:Raised; center:Yes; scroll:no;resizable: no; status: no;";

            var url = "TrainEdit.aspx?actionType=" + actType + "&TID=" + PlanID;

            window.open(url);

        }

        //管理学员报名

        function Apply(TID) {

            var sFeatures = "dialogHeight: 900px; dialogWidth: 690px; dialogTop: px; dialogLeft: px; edge:Raised; center:Yes; scroll:no;resizable: no; status: no;";

            var url = "MTraineesList.aspx?TID=" + TID;

            window.open(url);

        }

 

        //初审学员报名

        function FCApply(TID) {

            var sFeatures = "dialogHeight: 900px; dialogWidth: 690px; dialogTop: px; dialogLeft: px; edge:Raised; center:Yes; scroll:no;resizable: no; status: no;";

            var url = "FCTraineesList.aspx?TID=" + TID;

            window.open(url);

        }

       

         function PublicTrain(PlanID) {

            var sFeatures = "dialogHeight: 900px; dialogWidth: 690px; dialogTop: px; dialogLeft: px; edge:Raised; center:Yes; scroll:no;resizable: no; status: no;";

            var url = "TrainEdit.aspx?IsPlan=1&actionType=mod&TID=" + PlanID;

            window.open(url);

        }

       

         //查看感兴趣的学员列表

        function InJoin(TID) {

            var url = "TrainingPlanUserList.aspx?TID=" + TID;

            var sFeatures = "dialogHeight: 360px; dialogWidth: 630px; dialogTop: px; dialogLeft: px; edge:Raised; center:Yes; scroll:auto;resizable: no; status: no;";

            var result = showModalDialog(encodeURI(url), window, sFeatures);

            return false;

        }

       

        function PContens(TID) {

 

            var url = "/EPMSWeb/Modules/Resource/Training/PublicContents.aspx?TID=" + TID;

            window.open(url);

        }

       

        //短信和邮件通知

        function OpenSendMsgWindow(TID)

        {

            var url = "/EPMSWeb/Modules/Resource/Training/TrainingManage/SendmsgAndEmail.aspx?TID=" + TID;

            window.open(url);

        }

    </script>

 

</head>

<body>

 

    <script type="text/javascript" language="javascript">

        //注:js中包含后台代码需放在body内

        function delAll() {

            var count = getGridViewSelectedItems('<%=gvTrainList.ClientID%>', false);

            if (count == "") {

                alert('请选择要删除的活动!');

                return false;

            } else {

                return confirm('确定要删除这些活动吗,删除该活动将删除所有该活动相关的信息?');

            }

        }

    </script>

 

    <form id="form1" runat="server">

    <!----------------------------标题面板(开始)----------------------------------->

    <table cellspacing="0" cellpadding="0" width="100%">

        <tr>

            <td class="DG_title_Pd">

                <table id="Table2" cellspacing="2" cellpadding="0">

                    <tr class="DG_title_A">

                        <td class="DG_title_I">

                            <img src="../../../../Images/dg_title_icon.gif" alt="标题" />

                        </td>

                        <td class="DG_title_F">

                            活动列表

                        </td>

                    </tr>

                </table>

            </td>

        </tr>

    </table>

    <!----------------------------标题面板(结束)----------------------------------->

    <!---查询条件区------------------------------------------------------------------>

    <table cellspacing="0" cellpadding="0" width="100%">

        <tr>

            <td class="DG_tlb_L">

            </td>

            <td class="DG_tlb_M" valign="bottom">

        活动名称:<asp:TextBox ID="txtTrainName" MaxLength="60" runat="server"  reg="filter2" check/>

        是否已发布:<asp:DropDownList runat="server" ID="dp_Forbid">

                    <asp:ListItem Value="" Selected="True" Text="--全部--"></asp:ListItem>

                    <asp:ListItem Value="1" Text="是"></asp:ListItem>

                    <asp:ListItem Value="0" Text="否"></asp:ListItem>

                </asp:DropDownList>

                活动类别:

                <asp:DropDownList ID="dpTrainType" runat="server" Width="100px">

                    <asp:ListItem Value="">--全部--</asp:ListItem>

                    <asp:ListItem Value="培训">培训</asp:ListItem>

                    <asp:ListItem Value="生产实践">生产实践</asp:ListItem>

                    <asp:ListItem Value="技术交流">技术交流</asp:ListItem>

                </asp:DropDownList>

                活动内容:<asp:TextBox ID="txtTrainContent" MaxLength="60" runat="server" reg="filter2" check />

            </td>

            <td class="DG_tlb_R">

            </td>

        </tr>

        <tr>

            <td class="DG_tlb_L">

            </td>

            <td class="DG_tlb_M">

                活动开始时间:<asp:TextBox ID="txtStartTime" onfocus="new WdatePicker(this)" SkinID="Calendar"

                    runat="server" MaxLength="10" />&nbsp; 活动结束时间:<asp:TextBox ID="txtEndTime" onfocus="new WdatePicker(this)"

                        SkinID="Calendar" runat="server" MaxLength="10" />&nbsp;

                <asp:Button ID="btnSearch" runat="server" Text="查询" OnClick="btnSearch_Click" />

                <asp:Button ID="btnReset" runat="server" Text="重置" OnClick="btnReset_Click" />

               

            </td>

            <td class="DG_tlb_R">

            </td>

        </tr>

        <tr>

            <td class="DG_tlb_L">

            </td>

            <td class="DG_tlb_M">

              <asp:FileUpload ID="fuFileUpload" runat="server" Height="20px" />

                &nbsp;<asp:Button ID="btn_import" runat="server" Text="导入" OnClientClick="return importingNodeExcel('fuFileUpload')"

                    OnClick="btn_import_Click" />

                <asp:Button ID="btn_export" runat="server" Text="导出" OnClick="btn_export_Click" />

                <asp:Button ID="btnInsert" runat="server" Text="新增" OnClientClick="return openEdit('add',0)" />

                <asp:Button ID="btn_batDel" runat="server" Text="批量删除" OnClientClick="return delAll();"

                    OnClick="btn_batDel_Click" />

            </td>

            <td class="DG_tlb_R">

            </td>

        </tr>

    </table>

    <!---查询条件区-------------------------------------------------------------------->

    <!----------------------------列表区(开始)------------------------------------------>

    <ext:EPMSGridView

       ID="gvTrainList"

       runat="server" DataSourceID="sdsTrainList" Width="100%"

        AutoGenerateColumns="False" DataKeyNames="TID" AllowPaging="True" AllowSorting="True"

        CheckBoxDataField="TID" OnRowCommand="gvTrainList_RowCommand">

        <Columns>

            <asp:TemplateField HeaderText="活动名称" SortExpression="TrainName">

                <ItemStyle Wrap="False" />

                <HeaderStyle HorizontalAlign="Center" Wrap="False" />

                <ItemTemplate>

                    <div align="left" style="width: 190px; text-overflow: ellipsis; white-space: nowrap;

                        overflow: hidden;" title="<%# Eval("TrainName")%>">

                        <span>

                        <label runat="server" id="lb_singUp" Visible='<%# Eval("Ispublic").ToString() == "是" && Eval("IsStopSing").ToString() == "否" && Eval("IsCanSing").ToString() == "1" %>'>

                         <font color="red">[正在报名]</font>

                        </label>

                        <label runat="server" id="Label1" Visible='<%# Eval("Ispublic").ToString() == "是" && Eval("IsStopSing").ToString() == "是" && Eval("IsCanSing").ToString() == "1" %>'>

                         <font color="red">[停止报名]</font>

                        </label>

                           <%#  Eval("TrainName")%>

                        </span>

                    </div>

                </ItemTemplate>

            </asp:TemplateField>

           

            <asp:BoundField DataField="IsPublic" HeaderText="是否已发布" SortExpression="IsPublic">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

           

            <asp:BoundField DataField="TrainType" HeaderText="活动类别" SortExpression="TrainType">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

            <asp:TemplateField HeaderText="活动时间" SortExpression="StartTime">

                <ItemStyle Wrap="False" />

                <HeaderStyle HorizontalAlign="Center" Wrap="False" />

                <ItemTemplate>

                    <div align="left" style="width: 190px; text-overflow: ellipsis; white-space: nowrap;

                        overflow: hidden;">

                        <span>

                            <%# Eval("StartTime", "{0:yyyy-MM-dd}") %>

                            <asp:Label ID="lab_times" Visible='<%# Eval("StartTime").ToString() != "" && Eval("EndTime").ToString() != ""  %>' runat="server">到</asp:Label>

                            <%# Eval("EndTime", "{0:yyyy-MM-dd}")%>

                        </span>

                    </div>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:BoundField DataField="Place" HeaderText="活动地点" SortExpression="Place">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" HorizontalAlign="Left" />

            </asp:BoundField>

            <asp:TemplateField HeaderText="活动内容">

                <ItemStyle Wrap="False" />

                <HeaderStyle HorizontalAlign="Center" Wrap="False" />

                <ItemTemplate>

                    <div align="left" style="width: 200px; height: 25px;text-overflow: ellipsis; white-space: nowrap;

                        overflow: hidden;"  title="<%# Eval("TrainContents")==null?"":ConvertToText(Eval("ShowContent").ToString())%>">

                        <span>

                            <%# Eval("TrainContents")==null?"":ConvertToText(Eval("ShowContent").ToString())%>

                        </span>

                    </div>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:BoundField DataField="Orger" HeaderText="活动组织者" SortExpression="Orger">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

            <asp:BoundField DataField="OrgPhone" HeaderText="组织者电话" SortExpression="OrgPhone">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

            <asp:BoundField DataField="LastModifyUserName" HeaderText="发布人" SortExpression="LastModifyUserName">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

            <asp:BoundField DataField="LastModifyTime" HeaderText="发布时间" SortExpression="LastModifyTime"

                HtmlEncode="false" DataFormatString="{0:yyyy-MM-dd}">

                <HeaderStyle Wrap="False" />

                <ItemStyle Wrap="False" />

            </asp:BoundField>

            <asp:TemplateField HeaderText="操作" ShowHeader="False">

                <ItemStyle HorizontalAlign="left" Wrap="False" />

                <HeaderStyle Wrap="False" HorizontalAlign="Center" />

                <ItemTemplate>

                    <table style="width: 120px;">

                        <tr>

                            <td style="border: 0px solid #fff;">

                                <asp:ImageButton ID="ibtnEdit" runat="server" OnClientClick='<%# string.Format("return openEdit(\"{0}\",\"{1}\")","mod", Eval("TID")) %>'

                                    ToolTip="编辑活动信息" ImageUrl="~/Images/dg_edit.gif" CausesValidation="False" CommandName="ReBind">

                                </asp:ImageButton>

                                <asp:ImageButton ID="IbtnPublic" runat="server"

                                OnClientClick='<%# string.Format("return PublicTrain(\"{0}\")",Eval("TID")) %>'

                                Visible='<%# Eval("IsPublic").ToString() == "否" %>'

                                ToolTip="发布成为活动"

                                ImageUrl="~/Images/flowing.GIf"

                                CausesValidation="False"

                                CommandName="ReBind">

                                </asp:ImageButton>

                                <asp:ImageButton ID="ImageButton1" runat="server"

                                Visible='<%# Eval("IsPublic").ToString() == "否" %>'

                                OnClientClick='<%# string.Format("return InJoin(\"{0}\")",Eval("TID")) %>'

                                ToolTip="查看感兴趣的学员" ImageUrl="~/Images/icon_helloword.gif"

                                CausesValidation="False" CommandName="ReBind">

                                </asp:ImageButton>

                                <asp:ImageButton ID="ibtnInjoin"

                                runat="server"

                                Visible='<%# Eval("IsPublic").ToString() == "是" %>'

                                OnClientClick='<%# string.Format("return Apply(\"{0}\")",Eval("TID")) %>'

                                ToolTip="管理学员报名" ImageUrl="~/Images/dg_add.gif"

                                CausesValidation="False" CommandName="ReBind">

                                </asp:ImageButton>

                                <asp:ImageButton ID="ibtFirstCheck"

                                runat="server"

                                Visible='<%# Eval("IsPublic").ToString() == "是" %>'

                                OnClientClick='<%# string.Format("return FCApply(\"{0}\")",Eval("TID")) %>'

                                ToolTip="初审学员报名" ImageUrl="~/Images/goto.gif"

                                CausesValidation="False" CommandName="ReBind">

                                </asp:ImageButton>

                                <asp:ImageButton ID="imPublicContents" runat="server" Visible='<%# SheetHelper.HasPermission("EditTrain")%>'

                                    ToolTip="发布评论" ImageUrl="~/Images/icon_tool_114.gif" CausesValidation="False"

                                    OnClientClick='<%# string.Format(" PContens(\"{0}\")",Eval("TID")) %>'></asp:ImageButton>

                                <asp:ImageButton ID="imPhoneOrEmail" runat="server" Visible='<%# SheetHelper.HasPermission("EditTrain") && Eval("IsPublic").ToString() == "是" %>'

                                    ToolTip="短信邮件通知" ImageUrl="~/Images/unreadMail.gif" CausesValidation="False"

                                    OnClientClick='<%# string.Format("  OpenSendMsgWindow(\"{0}\")",Eval("TID")) %>'></asp:ImageButton>

                                

                                  <asp:ImageButton runat="server" ID="btn_start"  ToolTip="开始报名" Width="16px" Height="16px"

                                   Visible='<%# Eval("Ispublic").ToString() == "是" && Eval("IsStopSing").ToString() == "是" && Eval("IsCanSing").ToString() == "1"  %>'

                                   CommandArgument='<%# Eval("TID") %>' CommandName="StartSing"

                                  ImageUrl="~/Images/Start.jpg" OnClientClick="return confirm('你确认要开始活动的报名吗?')" />

                                

                                <asp:ImageButton runat="server" ID="btn_Stop"  ToolTip="停止报名" Width="16px" Height="16px"

                                 Visible='<%# Eval("Ispublic").ToString() == "是" && Eval("IsStopSing").ToString() == "否" && Eval("IsCanSing").ToString() == "1" %>'

                                 CommandArgument='<%# Eval("TID") %>' CommandName="StopSing"

                                  ImageUrl="~/Images/Stop1.jpg" OnClientClick="return confirm('你确认要停止活动的报名吗?')" />

                               

                                <asp:ImageButton ID="ibtnDelete" runat="server" Visible='<%# SheetHelper.HasPermission("EditTrain")%>'

                                    OnClientClick="return confirm('您确认要删除该活动吗?')" ToolTip="删除" ImageUrl="~/Images/fw_IF_TB_del.gif"

                                    CausesValidation="False" CommandArgument='<%# Eval("TID") %>' CommandName="DeleteList">

                                </asp:ImageButton>

                               

                            </td>

                        </tr>

                    </table>

                </ItemTemplate>

            </asp:TemplateField>

        </Columns>

    </ext:EPMSGridView>

    <!----------------------------列表区(结束)----------------------------------------->

    <!----------------------------数据源(开始)---------------------------------------->

    <ext:EPMSSqlDataSource ID="sdsTrainList" runat="server" CancelSelectOnNullParameter="False"

        ConnectionString="<%$ ConnectionStrings:EPMSDB %>" EnablePaging="True" MaximumRowsParameterName="maximumRows"

        SelectCommand="select TID,TrainName,TrainType,TrainContents,

                      TrainContents as ShowContent,

                      case when IsPublic  = 1 then '是'

                      else '否'

                      end as IsPublic,

                      case when IsStopSing = 1 then '是'

                      else '否'

                      end as IsStopSing,

                      case when isnull(startTime,getdate()) &lt; getdate() then 0

                      else 1

                      end as IsCanSing,

                      StartTime,EndTime,Place,Teacher,LastModifyUserName,LastModifyTime,Orger,OrgPhone

                      from Train where @TrainInfo@  and IsDeleted = 0"

        SelectCountQuery="select count(*) from Train where  @TrainInfo@  and Isdeleted = 0"

        SortParameterISNullColumnName="TID desc" StartRowIndexParameterName="startRowIndex">

        <Patterns>

            <ext:SearchGroup DefaultCondition="1=1" Name="TrainInfo">

                <ext:SearchPattern Name="TrainName" Pattern="TrainName like '%{0}%'" />

                <ext:SearchPattern Name="TrainContents" Pattern=" TrainContents like '%{0}%'" />

                <ext:SearchPattern Name="StartTime" Pattern=" StartTime>='{0}'" />

                <ext:SearchPattern Name="EndTime" Pattern=" EndTime<='{0}'" />

                <ext:SearchPattern Name="TrainType" Pattern=" TrainType = '{0}'" />

                <ext:SearchPattern Name="IsPublic" Pattern=" IsPublic = '{0}'" />

            </ext:SearchGroup>

        </Patterns>

        <SelectParameters>

            <asp:ControlParameter ControlID="txtTrainName" Name="TrainName" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtTrainContent" Name="TrainContents" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtStartTime" Name="StartTime" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtEndTime" Name="EndTime" PropertyName="Text" />

            <asp:ControlParameter ControlID="dpTrainType" Name="TrainType" PropertyName="SelectedValue" />

            <asp:ControlParameter ControlID="dp_Forbid" Name="IsPublic" PropertyName="SelectedValue" />

        </SelectParameters>

    </ext:EPMSSqlDataSource>

   

    <ext:SqlDataSource runat="server" ID="sdsForExcel" ConnectionString="<%$ ConnectionStrings:EPMSDB %>"

        SelectCommand="select TID,TrainName,TrainType,Teacher,

                       convert(varchar(10),StartTime,120) as StartTime,

                       Convert(varchar(10),EndTime,120) as EndTime,

                       Place,TrainContents,Orger,''''+OrgPhone,

                       convert(varchar(10),ApplyEndTime,120),

                       case when FDTypeX = 1 then '是'

                       else '否'

                       end as FDTypeX,

                       case when FDTypeC = 1 then '是'

                       else '否'

                       end as FDTypeC,

                       case when FDTypeD = 1 then '是'

                       else '否'

                       end as FDTypeD

                       from Train where @TrainInfo@ and Isdeleted = 0"

        SelectCountQuery="select count(*) from Train where  @TrainInfo@  and Isdeleted = 0">

        <Patterns>

            <ext:SearchGroup DefaultCondition="1=1" Name="TrainInfo">

                <ext:SearchPattern Name="TrainName" Pattern="TrainName like '%{0}%'" />

                <ext:SearchPattern Name="TrainContents" Pattern=" TrainContents like '%{0}%'" />

                <ext:SearchPattern Name="StartTime" Pattern=" StartTime>='{0}'" />

                <ext:SearchPattern Name="EndTime" Pattern=" EndTime>='{0}'" />

                <ext:SearchPattern Name="TrainType" Pattern=" TrainType = '{0}'" />

            </ext:SearchGroup>

        </Patterns>

        <SelectParameters>

            <asp:ControlParameter ControlID="txtTrainName" Name="TrainName" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtTrainContent" Name="TrainContents" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtStartTime" Name="StartTime" PropertyName="Text" />

            <asp:ControlParameter ControlID="txtEndTime" Name="EndTime" PropertyName="Text" />

            <asp:ControlParameter ControlID="dpTrainType" Name="TrainType" PropertyName="SelectedValue" />

        </SelectParameters>

    </ext:SqlDataSource>

    <!----------------------数据源(结束)--------------------------->

    </form>

</body>

</html>

-------------------------------------------------页面代码结束--------------------------------------------------------

 

----------------------------------------------页面后端代码开始------------------------------------------------------

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using Bingosoft.CommonLibrary;

using Microsoft.Practices.EnterpriseLibrary.Data;

using Bingosoft.Practices.Plat.Security.Environment;

using System.Text.RegularExpressions;

 

public partial class Modules_Resource_Training_TrainingManage_TrainList : System.Web.UI.Page

{

    #region 系统方法

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

 

    protected void btnSearch_Click(object sender, EventArgs e)

    {

        ListDataBind(false);

    }

    protected void btnReset_Click(object sender, EventArgs e)

    {

        ListDataBind(true);

    }

 

    protected void btn_batDel_Click(object sender, EventArgs e)

    {

        if (SheetHelper.HasPermission("DelTrain"))

        {

            DelPlan(this.gvTrainList.GetCheckedValues());

            ListDataBind(false);

        }

        else

        {

            ClientHelper.ShowMessage(this.Page, "你没有删除的权限!");

        }

    }

 

    protected void btn_import_Click(object sender, EventArgs e)

    {

        if (this.fuFileUpload.HasFile)

        {

            int susscount = 0;

            Hashtable hashtable = new Hashtable();

            try

            {

                hashtable.Add("OperID", PlatSecurityContext.Current.Environment.UserID);

                if (ExcelHelper.ImportExcel(this.fuFileUpload.PostedFile, "TrainPlan", out susscount, hashtable))

                {

                    ClientHelper.ShowMessage(this.Page, "success", string.Format("成功导入{0}条记录", susscount));

                    ListDataBind(false);

                }

                else

                {

                    ClientHelper.ShowMessage(this.Page, "hasNoFile", "所选择的文件不存在!请重新选择!");

                }

            }

            catch (Exception ex)

            {

                ClientHelper.ShowMessage(this.Page, "hasNoFile", "导入时候发生错误(请确认excel模板正确)!,错误信息:"+ex.Message);

            }

 

        }

    }

 

    protected void btn_export_Click(object sender, EventArgs e)

    {

        DataSourceSelectArguments arg = new DataSourceSelectArguments();

        DataView dv = null;

        #region 表头部分

        string TableHeader = @"<tr style='white-space: nowrap; background-color: blue; border: solid 1px white;color: white; font-weight: bold; text-align: center;' align='center'>

                    <td colspan=11>活动信息</td>

                            <td colspan=3>反馈形式</td>

                               </tr>

                                <tr style='white-space: nowrap; background-color: blue; border: solid 1px white;

                                color: white; font-weight: bold; text-align: center;' align='center'>

                                <td  scope=""col"">活动ID</td>                               

                                <td scope=""col"">活动名称</td>                            

                                <td scope=""col"">活动类别</td>

                                <td scope=""col"">讲师</td>

                                <td scope=""col"">活动开始时间</td>

                                <td scope=""col"">活动结束时间</td>

                                <td scope=""col"">活动地点</td>

                                <td scope=""col"">活动内容</td>

                                <td scope=""col"">活动组织者</td>

                                <td scope=""col"">组织者电话</td>

                                <td scope=""col"">报名截止时间</td>

                                <td scope=""col"">培训心得</td>

                                <td scope=""col"">培训成果</td>

                                <td scope=""col"">给讲师打分</td>";

        #endregion

        dv = (DataView)this.sdsForExcel.Select(arg);

        //格式化html为纯文本

        foreach (DataRowView drv in dv)

        {

            if (drv["TrainContents"] != DBNull.Value)

            {

                drv.BeginEdit();

                drv["TrainContents"] = ConvertToText(drv["TrainContents"].ToString());

                drv.EndEdit();

            }

        }

        EPMSExcelHelper.ExportExcel(dv.Table, TableHeader, "TrainPlan", "活动信息");

    }

 

    protected void gvTrainList_RowCommand(object sender, GridViewCommandEventArgs e)

    {

        if (e.CommandName == "DeleteList")

        {

            //有权限删除

            if (SheetHelper.HasPermission("DelTrain"))

            {

                string[] TID = new string[] { e.CommandArgument.ToString() };

                DelPlan(TID);

                ListDataBind(false);

            }

            else

            {

                ClientHelper.ShowMessage(this.Page, "你没有删除活动的权限!");

            }

        }

       

        if (e.CommandName == "StartSing")

        {

            StopOrStartTrain(false,e.CommandArgument.ToString());

            ListDataBind(false);

        }

 

        if (e.CommandName == "StopSing")

        {

            StopOrStartTrain(true, e.CommandArgument.ToString());

            ListDataBind(false);

        }

    }

    #endregion

 

    #region 将HTML内容转换成纯文本形式,即去除HTML格式(谢晓平添加)

    /// <summary>

    /// 将HTML内容转换成纯文本形式,即去除HTML格式

    /// </summary>

    /// <param name="source"></param>

    /// <returns></returns>

    public static string ConvertToText(string source)

    {

        string result;            //remove line breaks,tabs

        result = source.Replace("\r", " ");

        result = result.Replace("\n", " ");

        result = result.Replace("\t", " ");

 

        //remove the header

        result = Regex.Replace(result, "(<head>).*(</head>)", string.Empty, RegexOptions.IgnoreCase);

 

        result = Regex.Replace(result, @"<( )*script([^>])*>", "<script>", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @"(<script>).*(</script>)", string.Empty, RegexOptions.IgnoreCase);

 

        //remove all styles

        result = Regex.Replace(result, @"<( )*style([^>])*>", "<style>", RegexOptions.IgnoreCase); //clearing attributes

        result = Regex.Replace(result, "(<style>).*(</style>)", string.Empty, RegexOptions.IgnoreCase);

 

        //insert tabs in spaces of <td> tags

        result = Regex.Replace(result, @"<( )*td([^>])*>", " ", RegexOptions.IgnoreCase);

 

        //insert line breaks in places of <br> and <li> tags

        result = Regex.Replace(result, @"<( )*br( )*>", "\r", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @"<( )*li( )*>", "\r", RegexOptions.IgnoreCase);

 

        //insert line paragraphs in places of <tr> and <p> tags

        result = Regex.Replace(result, @"<( )*tr([^>])*>", "\r\r", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @"<( )*p([^>])*>", "\r\r", RegexOptions.IgnoreCase);

 

        //remove anything thats enclosed inside < >

        result = Regex.Replace(result, @"<[^>]*>", string.Empty, RegexOptions.IgnoreCase);

 

        //replace special characters:

        result = Regex.Replace(result, @"&", "&", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @" ", " ", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @"<", "<", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @">", ">", RegexOptions.IgnoreCase);

        result = Regex.Replace(result, @"&(.{2,6});", string.Empty, RegexOptions.IgnoreCase);

 

        //remove extra line breaks and tabs

        result = Regex.Replace(result, @" ( )+", " ");

        result = Regex.Replace(result, "(\r)( )+(\r)", "\r\r");

        result = Regex.Replace(result, @"(\r\r)+", "\r\n");

 

        //remove blank

        result = Regex.Replace(result, @"\s", "");

 

        return result;

    }

    #endregion

 

    #region 自定义方法

    //绑定数据

    protected void ListDataBind(bool reset)

    {

        if (reset)

        {

            this.txtTrainName.Text = string.Empty;

            this.dpTrainType.SelectedIndex = 0;

            this.dp_Forbid.SelectedIndex = 0;

            this.txtTrainContent.Text = string.Empty;

            this.txtStartTime.Text = string.Empty;

            this.txtEndTime.Text = string.Empty;

        }

 

        this.gvTrainList.PageIndex = 0;

        this.gvTrainList.DataBind();

    }

 

    //删除计划

    protected void DelPlan(string[] TIDs)

    {

        string sql = "";

        for (int i = 0; i < TIDs.Length; i++)

        {

           /* sql += string.Format(@"delete TrainBack where TID = {0};

                                   delete TrainObject where TID = {0};

                                   delete TrainApply where TID = {0};

                                   delete Train where TID = {0};

                                   delete FileInfo where FileID =

                                   (select top 1 FileID from Attachment where ChID = {0} and ChType= '培训');

                                   delete DocInfo where DocID = (

                                    select top 1 DocID from FileInfo where FileID =

                                   (select top 1 FileID from Attachment where ChID={0} and ChType= '培训'));

                                   delete Attachment where MarID = {0} and ChType='培训';", TIDs[i]);*/

            sql += string.Format(@"update Train set Isdeleted = 1 where TID = {0}",TIDs[i]);

        }

        DatabaseFactory.CreateDatabase().ExecuteNonQuery(CommandType.Text, sql);

    }

 

    //停止和启动活动报名

    protected void StopOrStartTrain(bool States,String TID)

    {

        string State = States ? "1" : "0";

        string sql = string.Format(@"update Train Set IsStopSing = {0} where TID = {1}",State,TID);

        DatabaseFactory.CreateDatabase().ExecuteNonQuery(CommandType.Text, sql);

    }

 

    #endregion

}

posted @ 2013-11-26 22:49  weifb  阅读(722)  评论(0)    收藏  举报