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