/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into users("); strSql.Append("sid,userID,PassWord,RealName,CreatedTime)"); strSql.Append(" values ("); strSql.Append("@sid,@userID,@PassWord,@RealName,@CreatedTime)"); SqlParameter[] parameters = { new SqlParameter("@sid", SqlDbType.NVarChar, 50), new SqlParameter("@userID", SqlDbType.NVarChar, 50), new SqlParameter("@PassWord", SqlDbType.NVarChar, 50), new SqlParameter("@RealName", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedTime", SqlDbType.DateTime) }; parameters[0].Value = model.sid; parameters[1].Value = model.userID; parameters[2].Value = model.PassWord; parameters[3].Value = model.RealName; parameters[4].Value = DateTime.Now.ToString(); int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void Submit_Click(object sender, EventArgs e) { entity_users user = new entity_users(); user.sid = Guid.NewGuid().ToString(); user.userID = this.adminName.Text.Trim(); user.RealName = this.realName.Text.Trim(); user.PassWord = Common.passwordHelp.Encrypt(this.adminPwd.Text.ToString().Trim()); string where = " userID='" + user.userID + "'"; if (u_bll.Exists(where)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('帐号已存在,请从更换帐号!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('帐号已存在,请从更换帐号')", true); return; } else { if (u_bll.Add(user)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加成功')", true); Response.Redirect("selectdAdmin.aspx", true); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加失败!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加失败')", true); } } }
/// <summary> /// 管理员登录 /// </summary> /// <param name="admin"></param> /// <returns></returns> public int adminLogin(entity_users admin) { string sql = "select count(*) from dbo.users where userID='" + admin.userID + "' and PassWord='******'"; int count = Convert.ToInt32(DbHelperSQL.GetSingle(sql)); return(count); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (HttpContext.Current.Session["adminName"] == null) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('未登录!');</script>"); ///////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('未登录!')", true); Response.Redirect("login.aspx"); } else { entity_users admin = HttpContext.Current.Session["adminName"] as entity_users; if (admin.sid.Equals("0000-0000-0000-0000")) { this.adminData.Visible = false; } this.lab_adminName.Text = admin.RealName; } } else { if (HttpContext.Current.Session["adminName"] == null) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('未登录!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('未登录!')", true); Response.Redirect("login.aspx"); } else { //admin = HttpContext.Current.Session["adminName"] as Administrator; //this.lab_adminName.Text = admin.AdminName; } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update users set "); strSql.Append("userID=@userID,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("RealName=@RealName"); strSql.Append(" where sid=@sid "); SqlParameter[] parameters = { new SqlParameter("@userID", SqlDbType.NVarChar, 50), new SqlParameter("@PassWord", SqlDbType.NVarChar, 50), new SqlParameter("@sid", SqlDbType.NVarChar, 50), new SqlParameter("@RealName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.userID; parameters[1].Value = model.PassWord; parameters[2].Value = model.sid; parameters[3].Value = model.RealName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void Repeater_ItemCommand(object source, RepeaterCommandEventArgs e) { entity_users user = HttpContext.Current.Session["adminName"] as entity_users; if (!user.sid.Equals("1111-1111-1111-1111")) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('对不起,您没有权限删除用户');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('对不起,您没有权限删除用户')", true); return; } string id = ((ImageButton)e.Item.FindControl("Delete")).CommandArgument.ToString(); if (e.CommandName == "Delete") { string news = ""; bool IsTrue = bll.Delete(id); if (IsTrue) { news = "删除成功"; } else { news = "删除失败"; } Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('" + news + "');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('" + news + "')", true); pagelist_chang(null, null); } }
protected void Submit_Click(object sender, EventArgs e) { if (this.CreateTime.Value == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('创建时间不能为空!');</script>"); return; } entity_users user = Session["adminName"] as entity_users; entity_News news = new entity_News(); news.Content = Common.StringHelp.HTMLToText(this.newsContent.Value.Trim()); news.sid = ViewState["sid"].ToString(); news.type = ""; news.title = this.newsName.Text.Trim(); news.CreateTime = this.CreateTime.Value; news.CreatePeople = user.userID; if (this.FileUpload.FileName != null) { //img.Add(); } if (bll.Add(news)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功');</script>"); ////// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加成功')", true); Response.Redirect("selectedNews.aspx"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加失败');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加失败')", true); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_users DataRowToModel(DataRow row) { entity_users model = new entity_users(); if (row != null) { if (row["sid"] != null) { model.sid = row["sid"].ToString(); } if (row["userID"] != null) { model.userID = row["userID"].ToString(); } if (row["PassWord"] != null) { model.PassWord = row["PassWord"].ToString(); } if (row["RealName"] != null) { model.RealName = row["RealName"].ToString(); } if (row["CreatedTime"] != null) { model.CreatedTime = Convert.ToDateTime(row["CreatedTime"].ToString()); } } return(model); }
/// <summary> /// 管理员登录 /// </summary> /// <param name="admin"></param> /// <returns></returns> public bool adminLogin(entity_users admin) { int count = dal.adminLogin(admin); if (count == 1) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (HttpContext.Current.Session["adminName"] == null) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('未登录');</script>"); ////// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('未登录!')", true); Response.Redirect("login.aspx"); } entity_users user = HttpContext.Current.Session["adminName"] as entity_users; if (user.sid.Equals("1111-1111-1111-1111")) { IsTrue = "true"; } pagelist_chang(null, null); } }
protected void user_submit_Click(object sender, EventArgs e) { entity_users user = new entity_users(); user.userID = this.username.Text.Trim(); user.PassWord = Common.passwordHelp.Encrypt(this.userpassword.Text.Trim()); if (bll.adminLogin(user)) { string where = "userID='" + user.userID + "'"; entity_users user_admin = bll.GetEntity(user.userID); HttpContext.Current.Session["adminName"] = user_admin; Response.Redirect("Default.aspx"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('密码或帐号错误!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('')", true); } }
/// <summary> /// 批量删除 /// </summary> public void batchDelete() { entity_users user = HttpContext.Current.Session["adminName"] as entity_users; if (!user.sid.Equals("1111-1111-1111-1111")) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('对不起,您没有权限删除用户');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('对不起,您没有权限删除用户')", true); return; } for (int i = 0; i < Repeater.Items.Count; i++) { HtmlInputCheckBox ckb = (HtmlInputCheckBox)Repeater.Items[i].FindControl("checkbox"); string id = ckb.Value; if (ckb.Checked == true) { if (id.Equals("1111-1111-1111-1111")) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('无权限删除超级管理员');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('无权限删除超级管理员')", true) continue; } string news = ""; bool IsTrue = bll.Delete(id); if (IsTrue) { news = "删除成功"; } else { news = "删除失败"; } Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('" + news + "');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('" + news + "')", true); } } pagelist_chang(null, null); }
/// <summary> /// 提交按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Submit_Click(object sender, EventArgs e) { entity_users user = Session["adminName"] as entity_users; entity_News news = bll.GetModel(sid); news.Content = Common.StringHelp.HTMLToText(this.newsContent.Value.Trim()); news.title = this.newsName.Text.Trim(); news.type = type; news.CreateTime = this.CreateTime.Value; news.CreatePeople = user.userID; if (bll.Update(news)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('修改成功');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('修改成功')", true); Response.Redirect("selectedNews.aspx?type=" + type); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('修改失败');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('修改失败')", true); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_users GetEntity(string userID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from users "); strSql.Append(" where userID=@userID "); SqlParameter[] parameters = { new SqlParameter("@userID", SqlDbType.NVarChar, 50) }; parameters[0].Value = userID; entity_users model = new entity_users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void adminData_Click(object sender, EventArgs e) { entity_users user = HttpContext.Current.Session["adminName"] as entity_users; Response.Redirect("UpdateAdmin.aspx?id=" + user.sid); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_users model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_users model) { return(dal.Add(model)); }