public LigerGrid RoleAddGrid(string systemName, LigerGrid grid)
{
SecRoleQuery query = new SecRoleQuery();
query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryTable <SecRoleEntity>(query.RoleAddSQL(), grid);
return(grid);
}
/// <summary>
/// 获取用户角色
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
public LigerGrid UserRoleGrid(string systemName, LigerGrid grid)
{
QueryUser query = new QueryUser();
query.ligerGrid = grid;
query.systemName = systemName;
grid = QueryTableHelper.QueryTable <CasUserEntity>(query.GetUserRoleSQL(), grid);
return(grid);
}
public ActionResult RoleAdd(LigerGrid grid, FormCollection data, string id)
{
grid.ConvertParams(data);
ViewBag.UserId = id;
if (IsPost)
{
return(Json(SystemService.FunctionRoleService.RoleAddGrid("MDM", grid)));
}
return(View());
}
public ActionResult Export(LigerGrid grid, FormCollection data)
{
string strError = "";
grid.ConvertParams(data);
eContract.Common.ExcelConvertHelper.ExcelContext context = new ExcelConvertHelper.ExcelContext();
if (SystemService.FunctionRoleService.ExportExcel(grid, ref context, ref strError))
{
return(Json(AjaxResult.Success()));
}
return(Json(AjaxResult.Error(strError)));
}
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error)
{
QueryUser query = new QueryUser();
query.ligerGrid = grid;
eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList();
columns.Add(CasUserTable.C_USER_ACCOUNT, "登录名");
columns.Add(CasUserTable.C_ENGLISH_NAME, "姓名");
context = new ExcelConvertHelper.ExcelContext();
context.FileName = "UserList" + ".xls";
context.Title = "用户列表";
//context.Data = DataAccess.QueryDataSet(query);
WhereBuilder where = query.ParseSQL();
context.Data = DataAccess.Select(where.SQLString, where.Parameters).Tables[0];
if (columns != null)
{
context.Columns.Add(columns);
}
CacheHelper.Instance.Set(WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT, context);
return(true);
}
public virtual bool ExportExcel(LigerGrid grid, ref ExcelConvertHelper.ExcelContext context, ref string Error)
{
SecRoleQuery query = new SecRoleQuery();
query.ligerGrid = grid;
eContract.Common.ExcelConvertHelper.ColumnList columns = new eContract.Common.ExcelConvertHelper.ColumnList();
columns.Add(SecRoleTable.C_ROLE_ID, "角色编号");
columns.Add("role_type_name", "角色类型");
columns.Add(SecRoleTable.C_ROLE_NAME, "角色名称");
columns.Add(SecRoleTable.C_REMARK, "角色描述");
context = new ExcelConvertHelper.ExcelContext();
context.FileName = "RoleList" + ".xls";
context.Title = "角色列表";
WhereBuilder where = query.ParseSQL();
context.Data = DataAccess.Select(where.SQLString, where.Parameters).Tables[0];
if (columns != null)
{
context.Columns.Add(columns);
}
CacheHelper.Instance.Set(WebCaching.UserId + "_" + ExcelHelper.EXPORT_EXCEL_CONTEXT, context);
return(true);
}
public static LigerGrid ExcuteTable <T>(string hql, DataAccessParameterCollection lstParameter, LigerGrid grid, DataAccessBroker broker) where T : EntityBase, new()
{
object total = broker.ExecuteScalar("select count(1) as Total from (" + hql + ") as ttable", lstParameter, CommandType.Text);
StringBuilder strsql = new StringBuilder();
if (grid.pageIndex != 0 && grid.pageSize != 0)
{
strsql.Append("select * from ( select top " + (grid.pageIndex * grid.pageSize) + " row_number() over(order by " + grid.sortName + " " + grid.sortOrder.ToLower() + ") as Row_Number, ");
strsql.Append(hql.Replace(":", "@").Substring(7));
if (!string.IsNullOrEmpty(grid.Where))
{
strsql.Append(" and (" + grid.Where.Replace(":", "@") + ")");;
}//as
strsql.Append(" ) ttable where Row_Number between " + (((grid.pageIndex - 1) * grid.pageSize) + 1) + " and " + ((grid.pageIndex) * grid.pageSize));
}
else
{
strsql.Append(hql);
if (!string.IsNullOrEmpty(grid.sortName))
{
strsql.Append(" order by " + grid.sortName);
if (!string.IsNullOrEmpty(grid.sortOrder))
{
strsql.Append(" " + grid.sortOrder);
}
else
{
strsql.Append(" ASC");
}
}
}
DataSet ds = broker.FillSQLDataSet(strsql.ToString(), lstParameter);
EntityCollection <T> lstEntity = new EntityCollection <T>();
List <Dictionary <string, object> > dicLstRow = new List <Dictionary <string, object> >();
ToEntityList <T>(ds.Tables[0], ref dicLstRow, ref lstEntity);
if (grid.IsDataEntity)
{
grid.Rows = lstEntity;
}
else
{
grid.Rows = dicLstRow;
}
grid.Total = (total != null ? Convert.ToInt32(total) : 0);
return(grid);
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sqlString">必须带上where 1=1</param>
/// <param name="lstParameter"></param>
/// <param name="grid"></param>
/// <param name="DbInstanceName">数据库实例</param>
/// <returns></returns>
public static LigerGrid QueryTable <T>(string sqlString, DataAccessParameterCollection lstParameter, LigerGrid grid, string DbInstanceName = "") where T : EntityBase, new()
{
string hql = sqlString;
string where = grid.Where;
if (!string.IsNullOrEmpty(where))
{
hql += " and (" + where + ")";
}
if (lstParameter == null)
{
lstParameter = new DataAccessParameterCollection();
}
if (grid != null && grid.LstParms != null && grid.LstParms.Count > 0)
{
foreach (var item in grid.LstParms)
{
lstParameter.Add(item.Name, new DataAccessParameter(item.Name, item.Value));
}
}
if (!string.IsNullOrEmpty(DbInstanceName))
{
using (DataAccessBroker broker = DataAccessFactory.Instance(DbInstanceName))
{
return(ExcuteTable <T>(hql, lstParameter, grid, broker));
}
}
else
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
return(ExcuteTable <T>(hql, lstParameter, grid, broker));
}
}
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="wb"></param>
/// <param name="grid"></param>
/// <param name="DbInstanceName"></param>
/// <returns></returns>
public static LigerGrid QueryTable <T>(WhereBuilder wb, LigerGrid grid, string DbInstanceName = "") where T : EntityBase, new()
{
return(QueryTable <T>(wb.SQLString, wb.Parameters, grid, DbInstanceName));
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="grid"></param>
/// <returns></returns>
public static LigerGrid QueryTable <T>(IQuery queryObj, LigerGrid grid) where T : EntityBase, new()
{
WhereBuilder wb = queryObj.ParseSQL();
return(QueryTable <T>(wb, grid, grid.DbInstanceName));
}
