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