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" /> 活动结束时间:<asp:TextBox ID="txtEndTime" onfocus="new WdatePicker(this)"
SkinID="Calendar" runat="server" MaxLength="10" />
<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" />
<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()) < 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
}

浙公网安备 33010602011771号