public class Sys_role
{
private int _id;
/// <summary>
/// 主键:ID
/// </summary>
public int Id
{
get { return _id; }
set { _id = value; }
} private string _role_name;
/// <summary>
/// 角色名
/// </summary>
public string Role_name
{
get { return _role_name; }
set { _role_name = value; }
} private string _role_desc;
/// <summary>
/// 角色描述
/// </summary>
public string Role_desc
{
get { return _role_desc; }
set { _role_desc = value; }
}
} public class Sys_roleService
{
private static IList<Sys_role> GetSys_rolesBySQL(string strsql)
{
IList<Sys_role> roles = new List<Sys_role>();
DataTable dt = DBHelper.GetDataTable(strsql);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Sys_role role = new Sys_role();
role.Id =int.Parse( dt.Rows[i]["Id"].ToString());
role.Role_name = dt.Rows[i]["role_name"].ToString();
role.Role_Desc = dt.Rows[i]["role_desc"].ToString();
roles.Add(role);
}
} return roles;
}
/// <summary>
/// 根据主键ID得到某个角色
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Sys_role GetSys_roleById(int id)
{
string strsql = "select * from Sys_role where ID=" + id.ToString();
try
{
return GetSys_rolesBySQL(strsql)[0]; //这里最后的[0]是什么意思? }
catch
{
return null;
} }
{
private int _id;
/// <summary>
/// 主键:ID
/// </summary>
public int Id
{
get { return _id; }
set { _id = value; }
} private string _role_name;
/// <summary>
/// 角色名
/// </summary>
public string Role_name
{
get { return _role_name; }
set { _role_name = value; }
} private string _role_desc;
/// <summary>
/// 角色描述
/// </summary>
public string Role_desc
{
get { return _role_desc; }
set { _role_desc = value; }
}
} public class Sys_roleService
{
private static IList<Sys_role> GetSys_rolesBySQL(string strsql)
{
IList<Sys_role> roles = new List<Sys_role>();
DataTable dt = DBHelper.GetDataTable(strsql);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Sys_role role = new Sys_role();
role.Id =int.Parse( dt.Rows[i]["Id"].ToString());
role.Role_name = dt.Rows[i]["role_name"].ToString();
role.Role_Desc = dt.Rows[i]["role_desc"].ToString();
roles.Add(role);
}
} return roles;
}
/// <summary>
/// 根据主键ID得到某个角色
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Sys_role GetSys_roleById(int id)
{
string strsql = "select * from Sys_role where ID=" + id.ToString();
try
{
return GetSys_rolesBySQL(strsql)[0]; //这里最后的[0]是什么意思? }
catch
{
return null;
} }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货