public int Save(Role Role)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_Role_insert");//返回主键
db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name);
db.AddInParameter(cmd, "@DES", DbType.String, Role.DES);
object res = db.ExecuteScalar(cmd);
return res == null ? -1 :1;
}
public int SelectRolePageCount(string searchCondition)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand("select count(*) from Role where 1=1 " + searchCondition);
return Convert.ToInt32(db.ExecuteScalar(cmd));
}
private long SelectUserPageCount(string sqlWhere)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand("select count(*) from [UserInfo] where 1=1 " + sqlWhere);
return Convert.ToInt32(db.ExecuteScalar(cmd));
}
