62,075
社区成员
发帖
与我相关
我的任务
分享
<--❤界面-->
<!--编辑控件-->
<div class="FCKeditorV">
<FCKeditorV2:FCKeditor ID="FCKeditor" runat="server" Height="400px"></FCKeditorV2:FCKeditor>
</div>
<!--保存操作-->
<div class="opear">
<asp:Button ID="ButtonSava" runat="server" Text="保存" OnClick="ButtonSava_Click" />
<asp:TextBox ID="TextBoxTitle" runat="server"></asp:TextBox>
</div>
<!--显示区域-->
<div class="Literal1">
<asp:Literal ID="Literal1" runat="server"></asp:Literal>
</div>
//❤保存事件
protected void ButtonSava_Click(object sender, EventArgs e)
{
string strValue = this.FCKeditor.Value;//获取编辑器中的内容
//传递编辑文本标题、编辑内容和编辑时间到业务层
if (Opear.GetAddBool(TextBoxTitle.Text, strValue, DateTime.Now))
{//操作成功提示
WebMS.Show("成功!");
}
else
{//操作失败提示
WebMS.Show("失败");
}
}
//❤业务层保存方法
public static bool GetAddBool(string strTitle,string strValue, DateTime dtTime)
{ //业务层获取显示层参数设置参数文本
SqlParameter[] parm ={
DBServer.DBServerSQL.SetSqlParameter("@strTitle",SqlDbType.VarChar,50,strTitle),
DBServer.DBServerSQL.SetSqlParameter("@strValue",SqlDbType.Text,16,strValue),
DBServer.DBServerSQL.SetSqlParameter("@dtTime",SqlDbType.DateTime,8,dtTime)
}; //SqlDbType.Text,16??????怎么长度这么小?
string strSQL = string.Format("insert into tb_FCKeditorV2 (strTitle,strValue,dtTime) values(@strTitle,@strValue,@dtTime)");//执行语句
//通过数据层进行保存操作
//返回相关操作状态信息
return DBServer.DBServerSQL.GetExecuteNonQueryBool(strSQL, parm);
}
//❤数据层操作
/// <summary>
/// 返回ExecuteNonQuery受影响的Boolean类型(有参数文本)
/// </summary>
/// <param name="strSQL">执行语句</param>
/// <param name="prams">参数对象</param>
/// <returns></returns>
public static Boolean GetExecuteNonQueryBool(string strSQL, SqlParameter[] prams)
{
Boolean BIsOK = false;
try
{
SqlCommand cmd = CreateCommand(strSQL, prams);
if (cmd.ExecuteNonQuery() > 0)
{//说明操作成功
BIsOK = true;
}
CloseConn();
}
catch { }
return BIsOK;
}
<%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %>
<FTB:FreeTextBox ID="FreeTextBox1" runat="server" Width="500px" Height="300px">
</FTB:FreeTextBox>
//后台获取FreeTextBox内容
string Content = FreeTextBox1.Text.ToString();
model.Article_Title = Title;
model.BigClassName = BigClassName;
model.SmallClassName = SmallClassName;
model.AddUser = AddUser;
model.Content = Content;
model.AddTime = DateTime.Now;
model.ImgDisplay = ImgDisplay;
model.ImageNum = PicNamu;
model.FirstImgURL = ImgURL;
model.Hits = 0;
//DAL层插入
public void Add(CB_Article.Model.CB_Articles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SR_Article(");
strSql.Append("Article_Title,BigClassName,SmallClassName,AddTime,AddUser,Content,Hits,ImageNum,FirstImgURL,ImgDisplay)");
strSql.Append(" values (");
strSql.Append("@Article_Title,@BigClassName,@SmallClassName,@AddTime,@AddUser,@Content,@Hits,@ImageNum,@FirstImgURL,@ImgDisplay)");
SqlParameter[] parameters = {
//new SqlParameter("@Article_ID", SqlDbType.BigInt,8),
new SqlParameter("@Article_Title", SqlDbType.VarChar,50),
new SqlParameter("@BigClassName", SqlDbType.VarChar,50),
new SqlParameter("@SmallClassName", SqlDbType.VarChar,50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AddUser", SqlDbType.VarChar,50),
new SqlParameter("@Content", SqlDbType.Text),
new SqlParameter("@Hits", SqlDbType.Int,4),
new SqlParameter("@ImageNum", SqlDbType.SmallInt,2),
new SqlParameter("@FirstImgURL", SqlDbType.VarChar,100),
new SqlParameter("@ImgDisplay", SqlDbType.Bit,1)};
parameters[0].Value = model.Article_Title;
parameters[1].Value = model.BigClassName;
parameters[2].Value = model.SmallClassName;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.AddUser;
parameters[5].Value = model.Content;
parameters[6].Value = model.Hits;
parameters[7].Value = model.ImageNum;
parameters[8].Value = model.FirstImgURL;
parameters[9].Value = model.ImgDisplay;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
<div align="left" style='font-size: 10.5pt'>
<%=content %>
</div>
public string content;
content = Server.HtmlDecode(model.Content);