protected void Button1_Click(object sender, EventArgs e)
{
if(Page.IsValid)
{
//string str = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ConnectionString;
//SqlConnection conn = new SqlConnection(str);
//string okmima = "", xingbie = "", tiwent = "", daane = "";
//okmima = XMM.Text.Trim();
//xingbie = xb1.SelectedItem.Text.ToString();
//tiwent = DropDownListTW.SelectedItem.Text.ToString();
//daane = daan.Text.Trim();
//string sql = "update [userinfo] set yonghuming=@yonghuming, mima=@okmima ,xingbie=@xingbie ,mimatiwen=@mimatiwen ,daan=@daan where id ='" + Convert.ToInt32(Request.QueryString["id"]) + "'";
//SqlCommand com = new SqlCommand(sql, conn);
//com.Parameters.Add(new SqlParameter("@okmima", SqlDbType.VarChar)).Value = okmima;
//com.Parameters.Add(new SqlParameter("@xingbie", SqlDbType.VarChar)).Value = xingbie;
//com.Parameters.Add(new SqlParameter("@mimatiwen", SqlDbType.VarChar)).Value = tiwent;
//com.Parameters.Add(new SqlParameter("@daan", SqlDbType.VarChar)).Value = daane;
//com.Parameters.Add(new SqlParameter("@yonghuming", SqlDbType.VarChar, 50)).Value = yhm.Text;
//conn.Open();
//com.ExecuteNonQuery();
///利用架构实现
Daxu.Entity.admin admintmodel = new Daxu.Entity.admin();
admintmodel.Pswd = _Okpsw.Text;
admintmodel.id = Convert.ToInt32(Request.QueryString["id"]);
int t = Daxu.BLL.adminBLL.UpdateIadmin(admintmodel);
Response.Redirect("userlist.aspx");
}
}
protected void Loadinfo()
{
string sql = "select * from admin where Groupsid='3'";
Daxu.Entity.admin admininfo = new Daxu.Entity.admin();
kfinfo.DataSource = Daxu.BLL.adminBLL.GetIadminDataTable(sql);
kfinfo.DataTextField = "admin";
kfinfo.DataValueField = "id";
kfinfo.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (adminpd(_admin.Text) == 0)
{
Daxu.Entity.admin admininfo = new Daxu.Entity.admin();
admininfo.Admin = _admin.Text;
admininfo.Pswd = _pswd.Text;
admininfo.Role = "0";
Daxu.BLL.adminBLL.InsertIadmin(admininfo);
Response.Write("<script>alert(\"添加成功！\");location.href='../admin/Management.aspx';</script>");
}
else
{
Response.Write("<script>alert(\"对不起，用名已存在！\");location.href='../admin/CreateMan.aspx';</script>");
}
}
public void asd()
{
//string str = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ConnectionString;
//SqlConnection conn = new SqlConnection(str);
//SqlCommand cmd = new SqlCommand(sql, conn);
//conn.Open();
//SqlDataReader ret= cmd.ExecuteReader();
YHM.Text = Session["username"].ToString();
string sql = "select * from [admin] where Admin='" + YHM.Text.ToString() + "'";
SqlDataReader read = Daxu.BLL.adminBLL.GetIadminDataReader(sql);
read.Read();
pswd.Text = read["Pswd"].ToString();
dLcount.Text = read["DLcount"].ToString();
read.Close();
//实现登陆统计
Daxu.Entity.admin admininfo = new Daxu.Entity.admin();
admininfo.DLcount = Convert.ToInt32(dLcount.Text) + 1;
admininfo.id = 1;
Daxu.BLL.adminBLL.UpdateIadmin(admininfo);
}
protected void submit_Click(object sender, EventArgs e)
{
Daxu.Entity.admin admininfo = new Daxu.Entity.admin();
admininfo.Admin = _admin.Text;
admininfo.Pswd = _pswd.Text;
if (_state.Checked)
{
admininfo.state = "1";
}
else
{
admininfo.state = "0";
}
admininfo.dateTime = DateTime.Now;
admininfo.Groups = _Groups.SelectedItem.Text;
admininfo.Groupsid = _Groups.SelectedValue;
admininfo.Role = _Role.SelectedItem.Text;
admininfo.Roleid = _Role.SelectedValue;
if (pdinfo.Value == "00")
{
Daxu.BLL.adminBLL.InsertIadmin(admininfo);
Response.Write("<script>alert(\"添加成功！\");location.href='administratormanage.aspx';</script>");
}
else
{
admininfo.id = Convert.ToInt32(pdinfo.Value);
Daxu.BLL.adminBLL.UpdateIadmin(admininfo);
Response.Write("<script>alert(\"修改成功！\");location.href='administratormanage.aspx';</script>");
}
}
