?? roleservice.cs
字號:
using System;
using System.Collections.Generic;
using System.Text;
using MyCRM.IDAL;
using MyCRM.Models;
using System.Data;
using System.Data.SqlClient;
using MyCRM.DBUtility;
namespace MyCRM.DAL
{
/// <summary>
/// 用戶角色數據層
/// </summary>
public class RoleService:IRole
{
/// <summary>
/// 查詢所有用戶角色
/// </summary>
/// <returns>返回集合</returns>
public List<Sys_role> GetAllRoles()
{
string sql = "select * from Sys_role";
return GetRolesBySql(sql);
}
/// <summary>
/// 根據角色id獲得角色信息
/// </summary>
/// <param name="roleId">角色id</param>
/// <returns>角色對象</returns>
public Sys_role GetRoleInfoById(int roleId)
{
string sql = "select * from Sys_role where Role_id = @roleId";
try
{
SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@roleId", roleId));
if (reader.Read())
{
Sys_role role = new Sys_role();
role.Role_id = (int)reader["Role_id"];
role.Role_name = (string)reader["Role_name"];
role.Role_desc = (string)reader["Role_desc"];
role.Role_flag = (int)reader["Role_flag"];
reader.Close();
reader.Dispose();
return role;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
/// <summary>
/// 根據sql查詢角色信息
/// </summary>
/// <param name="safeSql">sql語句</param>
/// <returns>返回集合</returns>
private List<Sys_role> GetRolesBySql(string safeSql)
{
List<Sys_role> list = new List<Sys_role>();
using (DataTable table = DBHelper.GetDataSet(safeSql))
{
foreach (DataRow row in table.Rows)
{
Sys_role role = new Sys_role();
role.Role_id = (int)row["Role_id"];
role.Role_name = (string)row["Role_name"];
role.Role_desc = (string)row["Role_desc"];
role.Role_flag=(int)row["Role_flag"];
list.Add(role);
}
return list;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -