/// <summary> /// 得到一个对象实体 /// </summary> public Model.AdminInfo DataRowToModel(DataRow row) { //Name,Number,PWD,CommunityID,Types Model.AdminInfo model = new Model.AdminInfo(); if (row != null) { if (row["ID"] != null) { model.Id = (int)row["ID"]; } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Number"] != null) { model.Number = (int)row["Number"]; } if (row["PWD"] != null) { model.PWD = (string)row["PWD"]; } if (row["CommunityID"] != null && row["CommunityID"].ToString() != "") { model.CommunityID = (int)row["CommunityID"]; } if (row["Types"] != null) { model.Types = (int)row["Types"]; } } return(model); }
protected void Button1_Click(object sender, EventArgs e) { String realname, password; int kind = 0, username, community; username = int.Parse(TextBox2.Text); realname = TextBox3.Text; password = TextBox4.Text; community = int.Parse(ddlshequID.SelectedValue); //kind = int.Parse(RadioButtonList1.SelectedValue); Model.AdminInfo admin = new Model.AdminInfo(); admin.Name = realname; admin.PWD = password; admin.Types = kind; admin.Number = username; admin.CommunityID = community; BLL.B_AdminInfo b_admin = new BLL.B_AdminInfo(); bool result = b_admin.InsertAdmin(admin); if (result == true) { webclass.Show(this, "插入成功"); GridView1.DataBind(); } else { webclass.Show(this, "插入失败"); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">信息</param> /// <returns>是否添加成功</returns> public bool Add(Model.AdminInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AdminInfo("); strSql.Append("Name,Number,PWD,CommunityID,Types)"); strSql.Append(" values ("); strSql.Append("@Name,@Number,@PWD,@CommunityID,@Types)"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 30), new SqlParameter("@Number", SqlDbType.NVarChar, 30), new SqlParameter("@PWD", SqlDbType.NVarChar, 30), new SqlParameter("@CommunityID", SqlDbType.Int), new SqlParameter("@Types", SqlDbType.Int) }; parameters[0].Value = model.Name; parameters[1].Value = model.Number; parameters[2].Value = model.PWD; parameters[3].Value = model.CommunityID; parameters[4].Value = model.Types; int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="strSql"></param> /// <returns></returns> public Model.AdminInfo GetModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from AdminInfo "); strSql.Append(" where "); strSql.Append(strWhere); Model.AdminInfo model = new Model.AdminInfo(); DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), DB.DbHelperSQL.maindataConnectionString); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">信息</param> /// <returns>是否更新成功</returns> public bool Update(Model.AdminInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AdminInfo set "); strSql.Append("Name=@Name,"); strSql.Append("Number=@Number,"); strSql.Append("PWD=@PWD,"); strSql.Append("CommunityID=@CommunityID"); strSql.Append("Types=@Types"); strSql.Append(" Where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 30), new SqlParameter("@Number", SqlDbType.NVarChar, 30), new SqlParameter("@PWD", SqlDbType.NVarChar, 30), new SqlParameter("@CommunityID", SqlDbType.Int), new SqlParameter("@Types", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.Name; parameters[1].Value = model.Number; parameters[2].Value = model.PWD; parameters[3].Value = model.CommunityID; parameters[4].Value = model.Types; parameters[5].Value = model.Id; int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="id">ID</param> /// <returns>信息</returns> public Model.AdminInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from AdminInfo "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = id; Model.AdminInfo model = new Model.AdminInfo(); DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 登陆 /// </summary> /// <param name="name">用户名-工号</param> /// <param name="password">密码</param> /// <returns>返回ID和管理员类别 ID -1:不存在用户 0:密码错误 类别 0:社区 1:街道 2:总管理员</returns> public int[] login(string number, string password) { int[] idAndTypes = new int[2]; if (d_admin.Exists("Number='" + number + "'")) { Model.AdminInfo model = d_admin.GetModel("Number='" + number + "' and PWD='" + password + "'"); if (model != null) { idAndTypes[0] = model.Id; idAndTypes[1] = model.Types; } else { idAndTypes[0] = 0; idAndTypes[1] = 0; } } else { idAndTypes[0] = -1; idAndTypes[1] = 0; } return(idAndTypes); }
/// <summary> /// 把Admin信息存储在Session或Cookies中 /// </summary> /// <param name="adminInfo"></param> public static void Set(Model.AdminInfo adminInfo) { System.Web.HttpContext.Current.Session["Admin"] = adminInfo; }
public bool InsertAdmin(Model.AdminInfo admin) { return(d_admin.Add(admin)); }