/// <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); }