protected void btnAdd_Click(object sender, EventArgs e) { Regex mo = new Regex("^1[34578][0-9]{9}$"); string username = TextName.Text; string userphone = TextPhone.Text; string usersay = TextSay.InnerText; GuestBooks guestbook = new GuestBooks(); guestbook.SayName = username; guestbook.SayPhone = userphone; guestbook.SayCont = usersay; if (mo.IsMatch(TextPhone.Text.Trim())) { lblVerfInfo.Text = ""; } else { lblVerfInfo.Text = "手机号码验证失败"; return; } if (username == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('您的姓名不能为空');</script>"); return; } else if (userphone == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('您的电话不能为空');</script>"); return; } else if (usersay == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('内容不能为空');</script>"); return; } bool b = new GuestBooksDAO().InsertGuestBooks(guestbook); if (b) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('您的留言提交成功,请等待回复');</script>"); TextName.Text = ""; TextPhone.Text = ""; TextSay.InnerText = ""; } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('您的留言提交失败');</script>"); } }
/// <summary> /// 插入留言板内容 /// </summary> /// <param name="guest">实体类</param> /// <returns></returns> public bool InsertGuestBooks(GuestBooks guest) { bool falg = false; string sql = "insert into sayGuest(sayName,sayPhone,sayCont)values(@sayName,@sayPhone,@sayCont)"; SqlParameter[] par = { new SqlParameter("@sayName", guest.SayName), new SqlParameter("@sayPhone", guest.SayPhone), new SqlParameter("@sayCont", guest.SayCont) }; int res = sqlhelper.ExecuteNonQuery(sql, CommandType.Text, par); if (res > 0) { falg = true; } return(falg); }