/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DtCms.Model.Feedback model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Feedback(");
strSql.Append("UserName,UserTel,UserQQ,Title,Content,IsLock,AddTime,ReContent,ReTime)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserTel,@UserQQ,@Title,@Content,@IsLock,@AddTime,@ReContent,@ReTime)");
OleDbParameter[] parameters =
{
new OleDbParameter("@UserName", OleDbType.VarWChar, 20),
new OleDbParameter("@UserTel", OleDbType.VarWChar, 30),
new OleDbParameter("@UserQQ", OleDbType.VarWChar, 20),
new OleDbParameter("@Title", OleDbType.VarWChar, 100),
new OleDbParameter("@Content", OleDbType.VarWChar),
new OleDbParameter("@IsLock", OleDbType.Integer, 4),
new OleDbParameter("@AddTime", OleDbType.Date),
new OleDbParameter("@ReContent", OleDbType.VarWChar),
new OleDbParameter("@ReTime", OleDbType.Date)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserTel;
parameters[2].Value = model.UserQQ;
parameters[3].Value = model.Title;
parameters[4].Value = model.Content;
parameters[5].Value = model.IsLock;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.ReContent;
parameters[8].Value = model.ReTime;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
//保存
protected void btnSave_Click(object sender, EventArgs e)
{
DtCms.BLL.Feedback bll = new DtCms.BLL.Feedback();
DtCms.Model.Feedback model = bll.GetModel(this.Id);
model.ReContent = DtCms.Common.StringPlus.ToHtml(txtReContent.Text);
model.ReTime = DateTime.Now;
bll.Update(model);
JscriptPrint("留言回复成功啦！", "List.aspx", "Success");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Feedback model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Feedback set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserTel=@UserTel,");
strSql.Append("UserQQ=@UserQQ,");
strSql.Append("Title=@Title,");
strSql.Append("Content=@Content,");
strSql.Append("IsLock=@IsLock,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("ReContent=@ReContent,");
strSql.Append("ReTime=@ReTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserTel", SqlDbType.NVarChar, 30),
new SqlParameter("@UserQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ReContent", SqlDbType.NText),
new SqlParameter("@ReTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserTel;
parameters[3].Value = model.UserQQ;
parameters[4].Value = model.Title;
parameters[5].Value = model.Content;
parameters[6].Value = model.IsLock;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.ReContent;
parameters[9].Value = model.ReTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DtCms.Model.Feedback GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,UserName,UserTel,UserQQ,Title,Content,IsLock,AddTime,ReContent,ReTime from dt_Feedback ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
DtCms.Model.Feedback model = new DtCms.Model.Feedback();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.UserTel = ds.Tables[0].Rows[0]["UserTel"].ToString();
model.UserQQ = ds.Tables[0].Rows[0]["UserQQ"].ToString();
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
model.ReContent = ds.Tables[0].Rows[0]["ReContent"].ToString();
if (ds.Tables[0].Rows[0]["ReTime"].ToString() != "")
{
model.ReTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Feedback model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Feedback(");
strSql.Append("UserName,UserTel,UserQQ,Title,Content,IsLock,AddTime,ReContent,ReTime)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserTel,@UserQQ,@Title,@Content,@IsLock,@AddTime,@ReContent,@ReTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserTel", SqlDbType.NVarChar, 30),
new SqlParameter("@UserQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ReContent", SqlDbType.NText),
new SqlParameter("@ReTime", SqlDbType.DateTime)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserTel;
parameters[2].Value = model.UserQQ;
parameters[3].Value = model.Title;
parameters[4].Value = model.Content;
parameters[5].Value = model.IsLock;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.ReContent;
parameters[8].Value = model.ReTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DtCms.Model.Feedback model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Feedback set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserTel=@UserTel,");
strSql.Append("UserQQ=@UserQQ,");
strSql.Append("Title=@Title,");
strSql.Append("Content=@Content,");
strSql.Append("IsLock=@IsLock,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("ReContent=@ReContent,");
strSql.Append("ReTime=@ReTime");
strSql.Append(" where Id=@Id ");
OleDbParameter[] parameters =
{
new OleDbParameter("@UserName", OleDbType.VarWChar, 20),
new OleDbParameter("@UserTel", OleDbType.VarWChar, 30),
new OleDbParameter("@UserQQ", OleDbType.VarWChar, 20),
new OleDbParameter("@Title", OleDbType.VarWChar, 100),
new OleDbParameter("@Content", OleDbType.VarWChar),
new OleDbParameter("@IsLock", OleDbType.Integer, 4),
new OleDbParameter("@AddTime", OleDbType.Date),
new OleDbParameter("@ReContent", OleDbType.VarWChar),
new OleDbParameter("@ReTime", OleDbType.Date),
new OleDbParameter("@Id", OleDbType.Integer, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserTel;
parameters[2].Value = model.UserQQ;
parameters[3].Value = model.Title;
parameters[4].Value = model.Content;
parameters[5].Value = model.IsLock;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.ReContent;
parameters[8].Value = model.ReTime;
parameters[9].Value = model.Id;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Feedback model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Feedback model)
{
return(dal.Add(model));
}
public void ProcessRequest(HttpContext context)
{
//取得处事类型
string action = context.Request.Params["action"];
//取得站点配置信息
DtCms.Model.WebSet webset = new DtCms.BLL.WebSet().loadConfig(Utils.GetXmlMapPath("Configpath"));
//===============================添加友情链接===============================
if (action == "link")
{
string _code = context.Request.Form["txtCode"];
string _title = context.Request.Form["txtTitle"];
string _username = context.Request.Form["txtUserName"];
string _usertel = context.Request.Form["txtUserTel"];
string _usermail = context.Request.Form["txtUserMail"];
string _weburl = context.Request.Form["txtWebUrl"];
string _imgurl = context.Request.Form["txtImgUrl"];
int _isimage;
//校检验证码
if (string.IsNullOrEmpty(_code))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入验证码！\"}");
return;
}
if (context.Session["DtCode"] == null)
{
context.Response.Write("{msg:0, msgbox:\"对不起，系统找不到生成的验证码！\"}");
return;
}
if (_code.ToLower() != (context.Session["DtCode"].ToString()).ToLower())
{
context.Response.Write("{msg:0, msgbox:\"您输入的验证码与系统的不一致！\"}");
return;
}
//检查网站标题
if (string.IsNullOrEmpty(_title))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您要链接的网站标题！\"}");
return;
}
//检查姓名
if (string.IsNullOrEmpty(_username))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您的姓名昵称！\"}");
return;
}
//检查联系电话
if (string.IsNullOrEmpty(_usertel))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您的联系电话！\"}");
return;
}
//检查网址
if (string.IsNullOrEmpty(_weburl))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您网站的网址！\"}");
return;
}
//检查链接类别
if (!int.TryParse(context.Request.Form["rblIsImage"] as string, out _isimage))
{
context.Response.Write("对不起，请选择要链接的类别！");
return;
}
//检查其它项
if (string.IsNullOrEmpty(_usermail))
{
_usermail = "";
}
if (string.IsNullOrEmpty(_imgurl))
{
_imgurl = "";
}
//写入数据
DtCms.Model.Links model = new DtCms.Model.Links();
DtCms.BLL.Links bll = new DtCms.BLL.Links();
model.Title = _title.Trim();
model.UserName = _username.Trim();
model.UserTel = _usertel.Trim();
model.UserMail = _usermail.Trim();
model.WebUrl = _weburl.Trim();
model.ImgUrl = _imgurl.Trim();
model.IsImage = _isimage;
model.IsLock = 1;
bll.Add(model);
context.Response.Write("{msg:1, msgbox:\"您的链接请求已提交成功，请等待审核通过！\"}");
return;
}
//===============================添加在线留言===============================
if (action == "feedback")
{
string _code = context.Request.Form["txtCode"];
string _username = context.Request.Form["txtUserName"];
string _usertel = context.Request.Form["txtUserTel"];
string _userqq = context.Request.Form["txtUserQQ"];
string _title = context.Request.Form["txtTitle"];
string _content = context.Request.Form["txtContent"];
//校检验证码
if (string.IsNullOrEmpty(_code))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入验证码！\"}");
return;
}
if (context.Session["DtCode"] == null)
{
context.Response.Write("{msg:0, msgbox:\"对不起，系统找不到生成的验证码！\"}");
return;
}
if (_code.ToLower() != (context.Session["DtCode"].ToString()).ToLower())
{
context.Response.Write("{msg:0, msgbox:\"您输入的验证码与系统的不一致！\"}");
return;
}
//检查姓名
if (string.IsNullOrEmpty(_username))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您的昵称！\"}");
return;
}
//检查输入的标题
if (string.IsNullOrEmpty(_title))
{
context.Response.Write("{msg:0, msgbox:\"请输入您要留言的标题！\"}");
return;
}
//检查输入的内容
if (string.IsNullOrEmpty(_content))
{
context.Response.Write("{msg:0, msgbox:\"请输入您要留言的信息内容！\"}");
return;
}
//检查其它项
if (string.IsNullOrEmpty(_usertel))
{
_usertel = "";
}
if (string.IsNullOrEmpty(_userqq))
{
_userqq = "";
}
//写入数据
DtCms.Model.Feedback model = new DtCms.Model.Feedback();
DtCms.BLL.Feedback bll = new DtCms.BLL.Feedback();
model.UserName = _username.Trim();
model.UserTel = _usertel.Trim();
model.UserQQ = _userqq.Trim();
model.Title = _title.Trim();
model.Content = Utils.ToHtml(_content);
model.IsLock = webset.IsCheckFeedback; //留言是否需要审核
model.AddTime = DateTime.Now;
bll.Add(model);
context.Response.Write("{msg:1, msgbox:\"您的留言已提交成功，感谢您的支持！\"}");
return;
}
}
//赋值操作
private void ShowInfo(int _id)
{
DtCms.BLL.Feedback bll = new DtCms.BLL.Feedback();
model = bll.GetModel(_id);
txtReContent.Text = DtCms.Common.Utils.ToTxt(model.ReContent);
}
