public DataTable GetRuleDataByProgid(string progid)
{
//SQLBuilder sQLBuilder = new SQLBuilder("CodeRuleConfig");
LibDSContext dSContext = new LibDSContext("CodeRuleConfig");
var ruleconfig = dSContext["CodeRuleConfig"];
//string sql = sQLBuilder.GetSQL("CodeRuleConfig", null, sQLBuilder.Where("A.ProgId={0}", progid));
string sql = dSContext.GetSQL("CodeRuleConfig", null, dSContext.Where(ruleconfig.Columns.ProgId + "={0}", progid));
return(this.DataAccess.GetDataTable(sql));
}
///// <summary>
///// 根据账户id 获取账户下的角色及权限对象。
///// </summary>
///// <param name="userid"></param>
///// <returns></returns>
//public DataTable GetAuthority(string userid)
//{
// //SQLBuilder sQLBuilder = new SQLBuilder("Account");
// LibDSContext dSContext = new LibDSContext("Account");
// var userRole = dSContext["UserRole"];
// string sql = dSContext.GetSQL("UserRole", null, dSContext.Where(userRole.Columns.UserId + "={0}", userid));
// return this.DataAccess.GetDataTable(sql);
//}
/// <summary>
/// 根据账户id 获取账户下的角色及权限对象。
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public LibTableObj GetAuthority(string userid)
{
//SQLBuilder sQLBuilder = new SQLBuilder("Account");
LibDSContext dSContext = new LibDSContext("Account");
LibTableObj userRole = dSContext["UserRole"];
//this.DataAccess.FillTableObj(userRole.Where(userRole.Columns.UserId + "={0}", userid));
string sql = dSContext.GetSQL("UserRole", null, dSContext.Where(userRole.Columns.UserId + "={0}", userid));
DataTable dt = this.DataAccess.GetDataTable(sql);
userRole.DataTable.PrimaryKey = null;
userRole.FillData(dt);
return(userRole);
}