public void Button1_Click(object sender, EventArgs e) { string username = string.Empty; //get user information if (Session["user"] != null) { username = Session["user"].ToString(); UserRegisterBusiness userReg = new UserRegisterBusiness(); string validateResult = userReg.AddArticleValidation(txtTitle.Value, Request["content"].ToString()); if (string.IsNullOrEmpty(validateResult)) { int userId = userReg.GetUserId(username); int typeId = Convert.ToInt32(DropDownList1.SelectedValue); int i = userReg.AddArticle(txtTitle.Value, txtSummary.Value, Request["content"].ToString(), userId, typeId); if (i != 0) { Response.Redirect("Article.aspx"); } else { AddErrorMessageshtml += validateResult; } } } else { Response.Redirect("../Login.aspx"); } }
private void ShowUserInfo() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet dsUserInfo = userReg.ShowUserInfo(); if (dsUserInfo.Tables[0].Rows.Count > 0) { string NickName = dsUserInfo.Tables[0].Rows[0]["NickName"].ToString(); string Gender = dsUserInfo.Tables[0].Rows[0]["Gender"].ToString(); string Profession = dsUserInfo.Tables[0].Rows[0]["Profession"].ToString(); string Major = dsUserInfo.Tables[0].Rows[0]["Major"].ToString(); UserInfoHtml += "<div class=\"row bt-margin\">"; UserInfoHtml += "<div class=\"l-detail-name\">姓名:</div>"; UserInfoHtml += "<div class=\"l-detail-name\">" + NickName + "</div>"; UserInfoHtml += "</div>"; UserInfoHtml += "<div class=\"row bt-margin\">"; UserInfoHtml += "<div class=\"l-detail-name\">性别:</div>"; UserInfoHtml += "<div class=\"l-detail-name\">" + Gender + "</div>"; UserInfoHtml += "</div>"; UserInfoHtml += "<div class=\"row bt-margin\">"; UserInfoHtml += "<div class=\"l-detail-name\">职业:</div>"; UserInfoHtml += "<div class=\"l-detail-name\">" + Profession + "</div>"; UserInfoHtml += "</div>"; UserInfoHtml += "<div class=\"row bt-margin\">"; UserInfoHtml += "<div class=\"l-detail-name\">领域:</div>"; UserInfoHtml += "<div class=\"l-detail-name\">" + Major + "</div>"; UserInfoHtml += "</div>"; } }
/// <summary> /// show artcile detail /// </summary> private void ShowArticleDetail() { bool isSuc = true; UserRegisterBusiness userReg = new UserRegisterBusiness(); if (Request.QueryString["id"] != null && !userReg.ValidateArticleId(Request.QueryString["id"])) { isSuc = false; } else { int articleId = Convert.ToInt32(Request.QueryString["id"]); DataSet dsArtDetail = userReg.ArticleDetails(articleId); if (dsArtDetail.Tables[0].Rows.Count > 0) { TitleHtml += dsArtDetail.Tables[0].Rows[0]["Title"].ToString(); CrDateHtml += dsArtDetail.Tables[0].Rows[0]["CreateDate"].ToString(); TypeHtml += dsArtDetail.Tables[0].Rows[0]["TypeName"].ToString(); ContentHtml += dsArtDetail.Tables[0].Rows[0]["Contents"].ToString(); } else { isSuc = false; } } if (!isSuc) { Response.Redirect("Index.aspx"); } }
private void BindTypeDp() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet articleTypeDs = userReg.GetArticleType(); DropDownList1.DataSource = articleTypeDs; DropDownList1.DataTextField = "TypeName"; DropDownList1.DataValueField = "TypeId"; DropDownList1.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { UserRegisterBusiness userReg = new UserRegisterBusiness(); int articleId = Convert.ToInt32(Request.QueryString["id"]); int i = userReg.DeleteArticle(articleId); if (i != 0) { Response.Redirect("Article.aspx"); } }
private void ShowHeaderWord() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet dsUserSign = userReg.ShowUserSign(); if (dsUserSign.Tables[0].Rows.Count > 0) { string Signature = dsUserSign.Tables[0].Rows[0]["Signature"].ToString(); HeaderWrodhtml += Signature; } }
protected void Page_Load(object sender, EventArgs e) { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet ds = userReg.HotArticle(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { HotArticlehtml += "<div class=\"right-t\">"; HotArticlehtml += "<div class=\"right-num\">" + (i + 1).ToString().PadLeft(2, '0') + "</div>"; HotArticlehtml += "<div class=\"right-con\"><a href=\"ArticleDetail.aspx?id=" + Convert.ToInt32(ds.Tables[0].Rows[i]["ArticleId"]) + "\">" + ds.Tables[0].Rows[i]["Title"].ToString() + "</a></div>"; HotArticlehtml += "</div>"; } }
private void ShowArticleType() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet dsArtType = userReg.ArticleType(); for (int i = 0; i < dsArtType.Tables[0].Rows.Count; i++) { ArticleTypeHtml += "<div class=\"row bt-margin\">"; ArticleTypeHtml += "<div class=\"l-cate-name\"><a href=\"Index.aspx?id=" + dsArtType.Tables[0].Rows[i]["TypeId"].ToString() + "\">" + dsArtType.Tables[0].Rows[i]["TypeName"].ToString() + "</a></div>"; ArticleTypeHtml += "<div class=\"l-cate-name-d\">(" + dsArtType.Tables[0].Rows[i]["TypeCount"].ToString() + ")</div>"; ArticleTypeHtml += "</div>"; } }
private void ShowArticleDate() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet dsArtDate = userReg.ArticleDate(); for (int i = 0; i < dsArtDate.Tables[0].Rows.Count; i++) { ArticleDateHtml += "<div class=\"row bt-margin\">"; ArticleDateHtml += "<div class=\"l-cate-name\"><a href=\"\">" + DateTime.Parse(dsArtDate.Tables[0].Rows[i]["CrDate"].ToString()).Year.ToString() + "年" + DateTime.Parse(dsArtDate.Tables[0].Rows[i]["CrDate"].ToString()).Month.ToString() + "月" + "</a></div>"; ArticleDateHtml += "<div class=\"l-cate-name-d\">(" + dsArtDate.Tables[0].Rows[i]["DateCount"].ToString() + ")</div>"; ArticleDateHtml += "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { UserRegisterBusiness userReg = new UserRegisterBusiness(); if (!userReg.ValidateArticleId(Request.QueryString["id"])) { Response.Redirect("Article.aspx"); } else { int articleId = Convert.ToInt32(Request.QueryString["id"]); string username = string.Empty; string author = string.Empty; DataSet contentDs = userReg.ArticleDetails(articleId); if (contentDs.Tables[0].Rows.Count > 0) { ArticleTypehtml = contentDs.Tables[0].Rows[0]["TypeName"].ToString(); Titlehtml = contentDs.Tables[0].Rows[0]["Title"].ToString(); CreateDatehtml = contentDs.Tables[0].Rows[0]["CreateDate"].ToString(); author = contentDs.Tables[0].Rows[0]["UserName"].ToString(); Contenthtml = contentDs.Tables[0].Rows[0]["Contents"].ToString(); Authorhtml = author; if (Session["user"] != null) { username = Session["user"].ToString(); if (username == author) { Updatehtml += "<a href=\"ArticleModify.aspx?id=" + articleId + "\">" + "编辑" + "</a>"; Updatehtml += "<a href=\"ArticleModify.aspx?id=" + articleId + "\">" + "删除" + "</a>"; } else { Updatehtml = ""; } } else { Updatehtml = ""; } } else { Response.Redirect("Article.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { string keyword = Request.QueryString["keyword"]; UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet ds = null; if (keyword == null) { ds = userReg.ShowArticle(); } else { ds = userReg.SearchArticle(keyword); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int articleId = Convert.ToInt32(ds.Tables[0].Rows[i]["ArticleId"]); string title = ds.Tables[0].Rows[i]["Title"].ToString(); string crDate = ds.Tables[0].Rows[i]["CreateDate"].ToString(); string typeName = ds.Tables[0].Rows[i]["TypeName"].ToString(); string summary = ds.Tables[0].Rows[i]["Summary"].ToString(); if (summary == "") { string contents = ds.Tables[0].Rows[i]["Contents"].ToString(); contents = System.Text.RegularExpressions.Regex.Replace(contents, RegexConstant.Htmlmark, ""); if (contents.Length < 100) { summary = contents; } else { summary = contents.Substring(0, 100); summary = summary.Substring(0, 99) + System.Text.RegularExpressions.Regex.Replace(summary.Substring(99, 1), RegexConstant.AlphaNumber, ""); summary += "......"; } } Articleshtml += "<div class=\"row\">"; Articleshtml += "<div class=\"col-md-12 content-title\"><a href=\"ArticleDetail.aspx?id=" + articleId + "\">" + title + "</a></div>"; Articleshtml += "<div class=\"col-md-12 content-date\"><span>" + crDate + "</span><span>-</span><span>" + typeName + "</span></div>"; Articleshtml += "<div class=\"col-md-12 content-t\">" + summary; Articleshtml += "</div>"; Articleshtml += "</div>"; } }
private void ShowHotArticle() { UserRegisterBusiness userReg = new UserRegisterBusiness(); DataSet ds = userReg.HotArticle(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string title = ds.Tables[0].Rows[i]["Title"].ToString(); if (title.Length >= 15) { title = title.Substring(0, 15) + "..."; } RankListhtml += "<div class=\"row bt-margin\">"; RankListhtml += "<div class=\"l-read-name\"><a href=\"Articles.aspx?id=" + Convert.ToInt32(ds.Tables[0].Rows[i]["ArticleId"]) + "\">" + title + "</a></div>"; RankListhtml += "<div class=\"l-read-name-d\">(239)</div>"; RankListhtml += "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["user"] == null) { Response.Redirect("../Login.aspx"); } else { UserRegisterBusiness userReg = new UserRegisterBusiness(); BindTypeDp(); DataSet contentDs = userReg.ArticleDetails(Convert.ToInt32(Request.QueryString["id"])); txtTitle.Value = contentDs.Tables[0].Rows[0]["Title"].ToString(); txtContent.Value = contentDs.Tables[0].Rows[0]["Contents"].ToString(); DropDownList1.SelectedValue = contentDs.Tables[0].Rows[0]["TypeId"].ToString(); } } }
public void Button1_Click(object sender, EventArgs e) { UserRegisterBusiness userReg = new UserRegisterBusiness(); string validateResult = userReg.LoginValidation(txtUsername.Value.Trim(), txtPassword.Value); if (string.IsNullOrEmpty(validateResult)) { //验证码是以cookie的形式存在客户端,而浏览器是可以禁止cookie的,所以如果浏览器禁用cookie那么验证码就用不了了,所以需要先判断验证码是否正确生成了 if (Request.Cookies["CheckCode"] == null) { LoginErrorMessageshtml += "您的浏览器设置已被禁用 Cookies,您必须设置浏览器允许使用 Cookies 选项后才能使用本系统。"; } else { //判断验证码是否为空并且是否相等 if (!string.IsNullOrEmpty(txtVerify.Value) && string.Equals(txtVerify.Value.ToUpper(), Request.Cookies["CheckCode"].Value.ToUpper())) { //判断用户名密码 int i = userReg.UserLogin(txtUsername.Value.Trim(), txtPassword.Value); if (i > 0) { Session["user"] = txtUsername.Value; Response.Redirect("Index.aspx");//Article/Article } else { LoginErrorMessageshtml += "用户名密码错误"; } } else { LoginErrorMessageshtml += "验证码错误"; } } } else { LoginErrorMessageshtml += validateResult; } }
protected void Button1_Click1(object sender, EventArgs e) { UserRegisterBusiness userReg = new UserRegisterBusiness(); string validateResult = userReg.RegisterValidation(txtUsername.Value.Trim(), txtNickname.Value, txtPassword.Value, txtConfirmPassword.Value, txtMail.Value.Trim()); if (string.IsNullOrEmpty(validateResult)) { int i = userReg.CheckUserExist(txtUsername.Value.Trim()); if (i > 0) { RegisterErrorMessageshtml += "Username already exists,please register again"; } else { userReg.CreateUser(txtUsername.Value.Trim(), txtNickname.Value, txtPassword.Value, txtMail.Value.Trim()); Response.Redirect("Login.aspx"); } } else { RegisterErrorMessageshtml += validateResult; } }
protected void Button1_Click(object sender, EventArgs e) { string username = Session["user"].ToString(); UserRegisterBusiness userReg = new UserRegisterBusiness(); int userId = userReg.GetUserId(username); int typeId = Convert.ToInt32(DropDownList1.SelectedItem.Value); int articleId = Convert.ToInt32(Request.QueryString["id"]); string title = txtTitle.Value; string content = txtContent.Value; int i = userReg.ModifyArticle(title, content, typeId, articleId); if (i != 0) { Response.Redirect("Article.aspx"); } else { Response.Write("Modify Article Failed, Please Try Again"); } }
public LoginTest() { userReg = new UserRegisterBusiness(); }
public StringBuilder DevidePage(int articleNumber, int pageSize, string request, string link, out int beginRowNumber, out int endRowNumber) { UserRegisterBusiness userReg = new UserRegisterBusiness(); StringBuilder PageDevisionhtml = new StringBuilder(); int pageNumber = 0; int curPage = 0; int prePage = 0; int nextPage = 0; int x = articleNumber % pageSize; if (x > 0) { pageNumber = articleNumber / pageSize + 1; } else if (x == 0) { pageNumber = articleNumber / pageSize; } if (request != null && userReg.ValidatePageId(request)) { curPage = Convert.ToInt32(request); if (curPage == 1 && curPage == pageNumber) { prePage = curPage; nextPage = curPage; } else if (curPage == 1 && curPage != pageNumber) { prePage = curPage; nextPage = curPage + 1; } else if (curPage != 1 && curPage == pageNumber) { prePage = curPage - 1; nextPage = curPage; } else { prePage = curPage - 1; nextPage = curPage + 1; } } else { curPage = 1; prePage = curPage; if (pageNumber > 1) { nextPage = curPage + 1; } else { nextPage = curPage; } } PageDevisionhtml.Append(link + prePage.ToString() + "\">上一页</a>"); for (int j = 1; j <= pageNumber; j++) { PageDevisionhtml.Append(link + j.ToString() + "\">" + j.ToString() + "</a>"); } PageDevisionhtml.Append(link + nextPage.ToString() + "\">下一页</a>"); beginRowNumber = (curPage - 1) * pageSize + 1; endRowNumber = curPage * pageSize; return(PageDevisionhtml); }