///<summary> ///添加一条留言 ///</summary> public bool Add(GustBook.Model.Content model) { myData.AddParameter("@userName", model.UserName); myData.AddParameter("@picUrl", model.PicUrl); myData.AddParameter("@userEmail", model.UserMail); myData.AddParameter("@userUrl", model.UserUrl); myData.AddParameter("@userQQ", model.UserQQ); myData.AddParameter("@faceUrl", model.FaceUrl); myData.AddParameter("@userIp", model.UserIp); myData.AddParameter("@addTime", model.AddTime); myData.AddParameter("@content", model.Contents); myData.AddParameter("@ishid", model.IsHid); string sqlstr = "insert into Content(UserName,UserEmail,UserQQ,UserUrl,UserIp,faceUrl,PicUrl,AddTime,Content,Reply,IsHid,IsReply)"; sqlstr += " values(@userName,@userEmail,@userQQ,@userUrl,@userIp,@faceUrl,@picUrl,@addTime,@content,'',@ishid,0)"; if (myData.ExecuteNonQuery(sqlstr) > 0) { return(true); } else { return(false); } }
///<summary> ///回复留言 ///</summary> public bool uAddRe(GustBook.Model.Content model) { myData.AddParameter("@id", model.Id); myData.AddParameter("@content", model.Reply); string sqlstr = "update Content set Reply=@content where Id=@id"; if (myData.ExecuteNonQuery(sqlstr) > 0) { return(true); } else { return(false); } }
protected void Button1_Click(object sender, EventArgs e) { GustBook.DBUtility.ShowMessagae sm = new GustBook.DBUtility.ShowMessagae(); GustBook.Model.Content mo = new GustBook.Model.Content(); mo.Id = int.Parse(Request.QueryString["id"]); mo.Reply = FCKeditor1.Value; GustBook.BLL.Admin bll = new GustBook.BLL.Admin(); if (bll.uAddRe(mo)) { sm.ShowRedirect("回复成功!", "Default.aspx"); } else { sm.Show("回复不成功!"); } }
protected void Button1_Click1(object sender, EventArgs e) { GustBook.DBUtility.ShowMessagae ShowMess = new GustBook.DBUtility.ShowMessagae(); GustBook.Model.Content ad = new GustBook.Model.Content(); ad.UserName = txtName.Text.Trim(); ad.PicUrl = ddllPic.SelectedValue.ToString(); ad.UserMail = txtEmail.Text.Trim(); ad.UserUrl = txtUrl.Text.Trim(); ad.UserQQ = txtQQ.Text.Trim(); string faceurl = ""; ad.FaceUrl = faceurl; ad.UserIp = HttpContext.Current.Request.UserHostAddress; ad.Contents = FCKeditor1.Value; if (CheckBox1.Checked == true) { ad.IsHid = 1; } else { ad.IsHid = 0; } ad.AddTime = System.DateTime.Now; GustBook.BLL.Message bll = new GustBook.BLL.Message(); if (bll.Add(ad)) { ShowMess.ShowRedirect("留言发表成功!", "default.aspx"); } else { ShowMess.Show("发表失败:("); } }
protected void Button1_Click1(object sender, EventArgs e) { GustBook.DBUtility.ShowMessagae ShowMess = new GustBook.DBUtility.ShowMessagae(); GustBook.Model.Content ad = new GustBook.Model.Content(); ad.UserName = txtName.Text.Trim(); ad.PicUrl = ddllPic.SelectedValue.ToString(); ad.UserMail = txtEmail.Text.Trim(); ad.UserUrl = txtUrl.Text.Trim(); ad.UserQQ = txtQQ.Text.Trim(); string faceurl = ""; if (this.Radio1.Checked) { faceurl = "images/face/face1.gif"; } if (this.Radio2.Checked) { faceurl = "images/face/face2.gif"; } if (this.Radio3.Checked) { faceurl = "images/face/face3.gif"; } if (this.Radio4.Checked) { faceurl = "images/face/face4.gif"; } if (this.Radio5.Checked) { faceurl = "images/face/face5.gif"; } if (this.Radio6.Checked) { faceurl = "images/face/face6.gif"; } if (this.Radio7.Checked) { faceurl = "images/face/face7.gif"; } if (this.Radio8.Checked) { faceurl = "images/face/face8.gif"; } if (this.Radio9.Checked) { faceurl = "images/face/face9.gif"; } if (this.Radio10.Checked) { faceurl = "images/face/face10.gif"; } if (this.Radio11.Checked) { faceurl = "images/face/face11.gif"; } if (this.Radio12.Checked) { faceurl = "images/face/face12.gif"; } if (this.Radio13.Checked) { faceurl = "images/face/face13.gif"; } if (this.Radio14.Checked) { faceurl = "images/face/face14.gif"; } if (this.Radio15.Checked) { faceurl = "images/face/face15.gif"; } if (this.Radio16.Checked) { faceurl = "images/face/face16.gif"; } if (this.Radio17.Checked) { faceurl = "images/face/face17.gif"; } if (this.Radio18.Checked) { faceurl = "images/face/face18.gif"; } if (this.Radio19.Checked) { faceurl = "images/face/face19.gif"; } if (this.Radio20.Checked) { faceurl = "images/face/face20.gif"; } ad.FaceUrl = faceurl; ad.UserIp = HttpContext.Current.Request.UserHostAddress; ad.Contents = FCKeditor1.Value; if (CheckBox1.Checked == true) { ad.IsHid = 1; } else { ad.IsHid = 0; } ad.AddTime = System.DateTime.Now; GustBook.BLL.Message bll = new GustBook.BLL.Message(); if (bll.Add(ad)) { ShowMess.ShowRedirect("留言发表成功!", "default.aspx"); } else { ShowMess.Show("发表失败:("); } }
///<summary> ///回复留言 ///</summary> public bool uAddRe(GustBook.Model.Content model) { return(dal.uAddRe(model)); }
///<summary> ///增加一条留言 业务逻辑曾直接调用数据访问曾 ///</summary> public bool Add(GustBook.Model.Content model) { return(dal.Add(model)); }