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