public ListResult <Sys_Panel> GetDataList(List <int> ids, AdminCredential User)
{
ListResult <Sys_Panel> result = new ListResult <Sys_Panel>();
result.Data = new List <Sys_Panel>();
var db = CreateDao();
List <Sys_Panel> dblist = base.GetAll().Where(e => ids.Contains(e.ID)).ToList();
foreach (var item in dblist)
{
if (item.Sql.IndexOf("@auth") != -1)
{
item.Sql = item.Sql.Replace("@auth", GetAuthSql(db, User, item.EntityID));
}
var panel = new Sys_Panel()
{
ID = item.ID,
Num = db.ExecuteScalar <int>(item.Sql),
Name = item.Name,
Sort = item.Sort,
Link = item.Link
};
result.Data.Add(panel);
}
db.CloseSharedConnection();
return(result);
}
public ActionResult AdminLogin(AdminCredential credential)
{
adminService = Injector.Container.Resolve <ICredentialService <AdminCredential> >();
if (ModelState.IsValid)
{
AdminCredential credentialFromDb = adminService.ValidateCredential(credential) as AdminCredential;
try
{
if (credentialFromDb.Status)
{
Session["USERID"] = credentialFromDb.AdminId;
Session["USER"] = "******";
return(RedirectToAction("Index", "Admin", new { id = credentialFromDb.AdminId }));
}
else
{
return(View("Blocked"));
}
}
catch (Exception)
{
return(View("Error"));
}
}
else
{
return(View(credential));
}
}
private PageOfDaTaSet GetSourceDataSet(string sql, Pagination page, AdminCredential admin)
{
var db = CreateDao();
//var _EntityName = db.ExecuteScalar<string>(new Sql("SELECT Name from Sys_entity WHERE ID=" + page.eid));
//if (sql.IndexOf(_EntityName + ".ID") == -1)
//{
// sql = sql.Replace("SELECT", "SELECT " + _EntityName + ".ID AS " + _EntityName + "$ID,");
//}
//if (sql.IndexOf(_EntityName + ".Name") == -1)
//{
// sql = sql.Replace("SELECT", "SELECT " + _EntityName + ".Name AS " + _EntityName + "$Name,");
//}
////关键字
//sql = AppendSqlForKeyWord(page.KeyWord, page.eid.Value, db, sql);
//if (page.IsSearch)
// page.Page = 1;
//if (!string.IsNullOrEmpty(page.SortField))
//{
// sql = sql + " Order By " + page.SortField + " " + page.SortType;
//}
string sqlStr = AppendListSql(page, admin, db, sql);
var result = db.DataSetPage(page.Page, page.PageSize, new Sql(sql));
return(result);
}
/// <summary>
/// 追加数据权限过滤Sql
/// </summary>
private static string AppendSqlForAuth(Pagination page, AdminCredential admin, string sqlStr, string entityName)
{
//查看权限控制
//配置了权限
if (admin.DataConfig != null && admin.DataConfig.Any(e => e.EntityID == page.eid))
{
var ViewRight = admin.DataConfig.Where(e => e.EntityID == page.eid).SingleOrDefault().ViewRight;
if (ViewRight < 4)
{
if (sqlStr.IndexOf("WHERE") != -1)
{
sqlStr += " AND (";
}
else
{
sqlStr += " WHERE (";
}
switch (ViewRight)
{
//个人级别
case 0:
case 1:
sqlStr += entityName + ".OwnerID=" + admin.ID;
break;
//部门
case 2:
sqlStr += entityName + ".DepartmentID=" + admin.DepartmentID;
break;
//上下级部门
case 3:
sqlStr += "charindex(','+rtrim(" + entityName + ".DepartmentID)+',' ," + "," + string.Join(",", admin.ChildDepartmentID) + "," + ")>0";
break;
}
//共享数据
sqlStr += " OR ','+" + entityName + ".ShareList+',' LIKE '%," + admin.ID + ",%'"; //
sqlStr += " OR " + entityName + ".OwnerID=999"; //所有人可见
sqlStr += ")";
}
}
//没有配置权限，默认个人级别
else
{
if (sqlStr.IndexOf("WHERE") != -1)
{
sqlStr += " AND (";
}
else
{
sqlStr += " WHERE (";
}
sqlStr += entityName + ".OwnerID=" + admin.ID;
//共享数据
sqlStr += " OR ','+" + entityName + ".ShareList+',' LIKE '%," + admin.ID + ",%'";//
sqlStr += ")";
}
return(sqlStr);
}
private static string AppendListSql(Pagination page, AdminCredential admin, DBDatabase db, string sql)
{
Sys_Entity entity = db.FirstOrDefault <Sys_Entity>(new Sql("SELECT * FROM Sys_Entity WHERE ID=" + page.eid));
if (sql.IndexOf(entity.Name + ".ID") == -1)
{
sql = sql.Replace("SELECT", "SELECT " + entity.Name + ".ID AS " + entity.Name + "$ID,");
}
if (sql.IndexOf(entity.Name + ".Name") == -1)
{
sql = sql.Replace("SELECT", "SELECT " + entity.Name + ".Name AS " + entity.Name + "$Name,");
}
if (sql.IndexOf(entity.Name + ".OwnerID") == -1)
{
sql = sql.Replace("SELECT", "SELECT " + entity.Name + ".OwnerID AS " + entity.Name + "$OwnerID,");
}
//Where条件
if (!string.IsNullOrEmpty(page.WhereSql))
{
if (sql.IndexOf("WHERE") != -1)
{
sql += " AND ";
}
else
{
sql += " WHERE ";
}
sql += page.WhereSql;
}
if (page.IsSearch)
{
page.Page = 1;
}
//关键字
sql = AppendSqlForKeyWord(page.KeyWord, page.eid.Value, db, sql);
//权限过滤
if (entity.IsEnableDataAuthorize)
{
sql = AppendSqlForAuth(page, admin, sql, entity.Name);
}
//Tab
if (page.pid.HasValue)
{
sql = AppendSqlForTab(page, db, sql, entity.Name);
}
//统计数据
if (entity.IsEnableSumData)
{
CacheHelper.Single.TrySave($"{page.vid}-{admin.ID}-sumdata-sql", GetSumDataSql(entity.ID, db, sql));
}
//排序
var orderSql = GetOrderSql(page, db, entity.Name);
sql += orderSql;
//表单分页
CacheHelper.Single.TrySave($"{page.vid}-{admin.ID}-formpage-sql", GetFormPageSql(entity.Name, orderSql));
CacheHelper.Single.TrySave($"{page.vid}-{admin.ID}-list-sql", sql);
return(sql);
}
/// <summary>
/// Processes the record.
/// </summary>
protected override void ProcessRecord()
{
var client = new RabbitMqRestClient(BaseUrl, AdminCredential.UserName,
AdminCredential.GetNetworkCredential().Password);
var queues = client.GetAllQueues().ToArray();
WriteObject(queues);
}
/// <summary>
/// Processes the record.
/// </summary>
protected override void ProcessRecord()
{
var client = new RabbitMqRestClient(BaseUrl, AdminCredential.UserName,
AdminCredential.GetNetworkCredential().Password);
var nodes = client.GetClusterNodes();
WriteObject(nodes);
}
public JsonResult _List(Pagination rq, AdminCredential User)
{
KendoFilterHelper.Single.SetPagination(Request.Form, rq);
return(new ListJsonResult
{
Data = JsonConvert.DeserializeObject(SystemSetService.ListDataSource.GetListDataSource(rq, User)),
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// Processes the record.
/// </summary>
protected override void ProcessRecord()
{
var client = new RabbitMqRestClient(BaseUrl, AdminCredential.UserName,
AdminCredential.GetNetworkCredential().Password);
var clusterName = client.GetHealthCheck();
WriteObject(clusterName);
}
public FileResult Export(Pagination rq, AdminCredential User)
{
#region 报表导出
var report = service.Get(rq.vid).Data;
NPOI.HSSF.UserModel.HSSFWorkbook workbook = new NPOI.HSSF.UserModel.HSSFWorkbook();
ICellStyle style = workbook.CreateCellStyle();
style.FillForegroundColor = (short)24;// NPOI.HSSF.Util.HSSFColor.LightGreen.Index;
style.FillPattern = FillPattern.SolidForeground;
style.BorderTop = BorderStyle.Thin;
style.BorderLeft = BorderStyle.Thin;
style.BorderRight = BorderStyle.Thin;
style.BorderBottom = BorderStyle.Thin;
style.Alignment = HorizontalAlignment.Center;
style.VerticalAlignment = VerticalAlignment.Center;
IFont font = workbook.CreateFont(); //创建一个字体样式对象
font.FontHeightInPoints = 10; //字体大小
font.FontName = "宋体"; //和excel里面的字体对应
font.Boldweight = short.MaxValue; //字体加粗
font.Color = NPOI.HSSF.Util.HSSFColor.White.Index;
style.SetFont(font); //将字体样式赋给样式对象
NPOI.SS.UserModel.ISheet sheet1 = workbook.CreateSheet(report.Name);
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.Height = 430;
var FieldList = JsonConvert.DeserializeObject <List <ViewFieldModel> >(service.GetReportColumns(rq.vid.Value));
int i = 0;
foreach (var item in FieldList)
{
ICell cell = row1.CreateCell(i);
cell.SetCellValue(item.Title);
cell.CellStyle = style;
i++;
}
rq.Filter = Session[rq.vid.ToString() + "Filter"].ToString();
DataTable dt = service.GetExportReportData(rq, User);
//将数据逐步写入sheet1各个行
for (int z = 0; z < dt.Rows.Count; z++)
{
var row = dt.Rows[z];
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(z + 1);
int c = 0;
foreach (var item in FieldList)
{
rowtemp.CreateCell(c++).SetCellValue(row[item.Field].ToString());
}
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
workbook.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", report.Name + ".xls"));
#endregion
}
public JsonResult _List(AdminCredential User)
{
return(new ListJsonResult
{
Data = service.GetTreeList(new Base_Category()
{
}),
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult _ReportList(Pagination rq, AdminCredential User)
{
ApplicationContext.KendoFilter.SetPagination(Request.Form, rq);
Session[rq.vid.ToString() + "Filter"] = rq.Filter;
return(new ListJsonResult
{
Data = JsonConvert.DeserializeObject(service.GetReportData(rq, User)),
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public string GetAuthSql(DBDatabase db, AdminCredential User, int EntityID)
{
if (EntityID == 0)
{
return(string.Empty);
}
string _sql = string.Empty;
var _EntityName = db.ExecuteScalar <string>(new Sql("SELECT Name from Sys_Entity WHERE ID=" + EntityID));
if (User.ID != 999)
{
//查看权限控制
//配置了权限
if (User.DataConfig.Any(e => e.EntityID == EntityID))
{
var ViewRight = User.DataConfig.Where(e => e.EntityID == EntityID).SingleOrDefault().ViewRight;
if (ViewRight < 4)
{
_sql += " AND (";
switch (ViewRight)
{
//个人级别
case 0:
case 1:
_sql += _EntityName + ".OwnerID=" + User.ID;
break;
//部门
case 2:
_sql += _EntityName + ".DepartmentID=" + User.DepartmentID;
break;
//上下级部门
case 3:
_sql += "charindex(','+rtrim(" + _EntityName + ".DepartmentID)+',' ," + "," + string.Join(",", User.ChildDepartmentID) + "," + ")>0";
break;
}
//共享数据
_sql += " OR ','+" + _EntityName + ".ShareList+',' LIKE '%," + User.ID + ",%'";//
_sql += ")";
}
}
//没有配置权限，默认个人级别
else
{
_sql += " AND (";
_sql += _EntityName + ".OwnerID=" + User.ID;
//共享数据
_sql += " OR ','+" + _EntityName + ".ShareList+',' LIKE '%," + User.ID + ",%'";//
_sql += ")";
}
}
return(_sql);
}
public ActionResult Detail(AdminCredential user, int id)
{
base.BaseDetail(id);
Base_Images entity = new Base_Images();
if (id > 0)
{
entity = service.Get(id).Data;
}
return(View(entity));
}
private PageOfDaTaSet GetSourceDataSet(Pagination page, AdminCredential admin)
{
using (var db = CreateDao())
{
var sql = new Sql();
sql = sql.Select("[Sql]").From("Sys_view").Where("ID=@0", page.vid);
var sqlStr = db.ExecuteScalar <string>(sql);
sqlStr = AppendListSql(page, admin, db, sqlStr);
PageOfDaTaSet result = db.DataSetPage(page.Page, page.PageSize, new Sql(sqlStr));
return(result);
}
}
public JsonResult _AjaxList(Sys_Schedule request, AdminCredential User)
{
request.OwnerID = User.ID;
return(new ListJsonResult
{
Data = service.GetPagingList(request, new Pagination()
{
Page = 1, PageSize = 999
}),
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
private PageOfDaTaSet GetSumDataSet(Pagination page, AdminCredential admin)
{
using (var db = CreateDao())
{
var ds = new PageOfDaTaSet();
var sqlStr = CacheHelper.Single.TryGet($"{page.vid}-{admin.ID}-sumdata-sql", 0, () => { return(""); }).ToString();
if (!string.IsNullOrEmpty(sqlStr))
{
ds = db.DataSet(sqlStr);
}
return(ds);
}
}
public ActionResult Index(AdminCredential User, int UserID, int id = 0)
{
var MenusAreas = menuareaService.GetAll().ToList().Where(e => e.SiteID == 1000 && e.StateCode == 0).ToList();
if (MenusAreas != null && MenusAreas.Count > 0)
{
//if (id == 0) { id = MenusAreas.FirstOrDefault().ID; }
}
ViewBag.AreaID = id;
ViewBag.MenusAreas = MenusAreas;
ViewBag.Menus = operationconfigService.GetAccessMenus(User.Roles, UserID).Data.Where(e => e.IsHide == false && e.SiteID == 1000).ToList();
return(View());
}
public JsonResult _Save(SysConfig entity, AdminCredential User)
{
if (entity.ID == 0)
{
return(Json(service.Insert(entity), JsonRequestBehavior.DenyGet));
}
else
{
entity.UpdateTime = DateTime.Now;
entity.UpdateUserID = User.ID;
return(Json(service.Update(entity), JsonRequestBehavior.DenyGet));
}
}
public DataTable GetExportReportData(Pagination page, AdminCredential User)
{
page.PageSize = 999999;
var result = GetExportDataDataTable(page, User);
if (result.Data.Tables.Count > 0)
{
return(result.Data.Tables[0]);
}
else
{
return(new DataTable());
}
}
/// <summary>
/// Processes the record.
/// </summary>
protected override void ProcessRecord()
{
var client = new RabbitMqRestClient(BaseUrl, AdminCredential.UserName,
AdminCredential.GetNetworkCredential().Password);
var policy = GetPolicy(GetPolicyDefinition());
client.CreatePolicy(VirtualHost, Name, policy);
WriteVerbose("Policy settings:");
policy.definition.OrderBy(pd => pd.Key).ToList().ForEach(dv => WriteVerbose($"{dv.Key} = {dv.Value}"));
WriteVerbose("Policy created/updated");
}
public JsonResult RelationAjaxList(Pagination rq, AdminCredential User)
{
KendoFilterHelper.Single.SetPagination(Request.Form, rq);
rq.WhereSql = rq.WhereSql.Replace("$", ".").Replace("__", "=");
if (!string.IsNullOrEmpty(rq.KeyWord))
{
rq.Page = 1;
}
return(new ListJsonResult
{
Data = JsonConvert.DeserializeObject(SystemSetService.ListDataSource.GetListDataSource(rq, User)),
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult _Save(Base_Tag entity, AdminCredential User)
{
if (entity.ID == 0)
{
return(Json(service.Insert(entity), JsonRequestBehavior.DenyGet));
}
else
{
ApplicationContext.Cache.Remove(EntityName + entity.ID);
entity.UpdateTime = DateTime.Now;
entity.UpdateUserID = User.ID;
return(Json(service.Update(entity), JsonRequestBehavior.DenyGet));
}
}
/// <summary>
/// 获取列表数据源
/// </summary>
/// <param name="page"></param>
/// <param name="User"></param>
/// <returns></returns>
public string GetListDataSource(string sql, Pagination page, AdminCredential User)
{
PageOfDaTaSet result = GetSourceDataSet(sql, page, User);
if (result.Data.Tables.Count > 0)
{
var sumdataset = GetSumDataSet(page, User);
return(JsonHelper.ToListResultJson(result.Data.Tables[0], sumdataset.Data, result.PageCount, result.PageSize, result.Total));
}
else
{
StringBuilder Json = new StringBuilder();
Json.Append("{\"Data\":[");
Json.Append("],\"PagesCount\": " + 0 + ",\"PageSize\": " + 0 + ",\"Total\": " + 0 + "}");
return(Json.ToString());
}
}
public ActionResult AdminDetail(AdminCredential user)
{
//Pass the data to store the record into the table
DataTable tbl = new DataTable();
tbl = dbC.CheckLogin("select * from AdminCredential where UserDetail='" + user.UserDetail + "'and PasswordDetail='" + user.PasswordDetail + "'");
if (tbl.Rows.Count > 0)
{
return(View("AdminZone"));
}
else
{
return(View("invalid"));
}
}
/// <summary>
/// 获取视图导出数据
/// </summary>
/// <param name="_sql"></param>
/// <param name="page"></param>
/// <param name="User"></param>
/// <returns></returns>
public DataTable GetViewExportData(string _sql, Pagination page, AdminCredential admin)
{
DBDatabase db = CreateDao();
PageOfDaTaSet result;
var sql = CacheHelper.Single.TryGet($"{page.vid}-{admin.ID}-list-sql", 0, () => { return(_sql); }).ToString();
result = db.DataSetPage(page.Page, page.PageSize, new Sql(sql));
db.Dispose();
if (result.Data.Tables.Count > 0)
{
return(result.Data.Tables[0]);
}
else
{
return(new DataTable());
}
}
/// <summary>
/// 获取报表数据
/// </summary>
/// <param name="page"></param>
/// <param name="User"></param>
/// <returns></returns>
public string GetReportData(Pagination page, AdminCredential User)
{
DataSet ds = new DataSet();
var result = GetExportDataDataTable(page, User);
if (result.Data != null && result.Data.Tables.Count > 0)
{
return(JsonHelper.ToListResultJson(result.Data.Tables[0], result.Page, result.PageSize, result.Total));
}
else
{
StringBuilder Json = new StringBuilder();
Json.Append("{\"List\":[");
Json.Append("],\"PagesCount\": " + 0 + ",\"PageSize\": " + 0 + ",\"Total\": " + 0 + "}");
return(Json.ToString());
}
}
//判断登录状态
public JsonResult IsLogin()
{
BaseResult result = new BaseResult();
if (Session["AdminCredential"] == null)
{
if (!ApplicationContext.AppSetting.IS_NeedLogin)
{
Session["AdminCredential"] = new AdminCredential()
{
Name = "开发帐号",
ID = 999,
};
}
}
result.Success = Session["AdminCredential"] != null;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult _Save(Base_Images entity, AdminCredential User)
{
string ThumbnailSrc = string.Empty;
ItemResult <int> result = new ItemResult <int>();
entity.UpdateTime = DateTime.Now;
entity.UpdateUserID = User.ID;
entity.CreateTime = DateTime.Now;
entity.Name = entity.Src;
if (!string.IsNullOrEmpty(entity.UserEntityName))
{
var sys_entity = SystemSetService.Entity.GetEntityItem(entity.UserEntityName);
var fieltTitle = SystemSetService.Field.GetTitle(sys_entity.ID, entity.UserFieldName);
entity.Name = string.Format("{0}-{1}", sys_entity.ShowName, fieltTitle);
entity.UserAreaName = sys_entity.AreaName;
if (!entity.IsSaveOriginalGraph && !string.IsNullOrEmpty(entity.OriginalSrc))
{
DeleteImages(entity.OriginalSrc);
entity.OriginalSrc = string.Empty;
}
if (entity.IsCreateThumbnail)
{
entity.ThumbnailSrc = CreateThumbnail(entity.Src);
}
else
{
entity.ThumbnailSrc = entity.Src;
}
}
if (entity.ID == 0)
{
result = service.Insert(entity);
}
else
{
ApplicationContext.Cache.Remove(EntityName + entity.ID);
entity.StateCode = 0;
result = service.Update(entity);
result.Data = entity.ID;
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public JsonResult _Save(Base_Attachment entity, AdminCredential User)
{
if (Request.Files.Count > 0)
{
if (Request.Files["file_Attachment"].ContentLength > 0)
{
entity.Attachment = UploadAttachment("file_Attachment", "附件", entity.Attachment);
}
}
if (entity.ID == 0)
{
return(Json(service.Insert(entity), JsonRequestBehavior.DenyGet));
}
else
{
ApplicationContext.Cache.Remove(EntityName + entity.ID);
entity.UpdateTime = DateTime.Now;
entity.UpdateUserID = User.ID;
return(Json(service.Update(entity), JsonRequestBehavior.DenyGet));
}
}
