public void OrderDateSortDesc()
{
GridPage.NavigateTo();
var allItems = GetAllItemsFromDb().OrderBy(x => x.OrderDate);
var lastOrderDate = allItems.First().OrderDate;
var newItem = CreateNewItemInDb();
newItem.OrderDate = lastOrderDate.AddDays(-1);
UpdateItemInDb(newItem);
var secondNewItem = CreateNewItemInDb(newItem.ShipName);
secondNewItem.OrderDate = lastOrderDate.AddDays(-2);
UpdateItemInDb(secondNewItem);
GridPage.Grid.Filter(GridColumns.ShipName, FilterOperator.EqualTo, newItem.ShipName);
WaitForGridToLoadAtLeast(2, GridPage.Grid);
GridPage.Grid.Sort(GridColumns.OrderDate, SortType.Desc);
Thread.Sleep(1000);
var results = GridPage.Grid.GetItems <Order>();
Assert.IsTrue(results.Count() == 2);
Assert.AreEqual(newItem.ToString(), results[0].OrderDate);
Assert.AreEqual(secondNewItem.ToString(), results[1].OrderDate);
}
public void OrderDateAfterFilter()
{
GridPage.NavigateTo();
var allItems = GetAllItemsFromDb().OrderBy(x => x.OrderDate);
var lastOrderDate = allItems.Last().OrderDate;
var newItem = CreateNewItemInDb();
newItem.OrderDate = lastOrderDate.AddDays(1);
UpdateItemInDb(newItem);
var secondNewItem = CreateNewItemInDb(newItem.ShipName);
secondNewItem.OrderDate = lastOrderDate.AddDays(2);
UpdateItemInDb(secondNewItem);
// After we filter by the unique shipping name, two items will be displayed in the grid.
// After we apply the date after filter only the second item should be visible in the grid.
GridPage.Grid.Filter(
new GridFilter(GridColumns.OrderDate, FilterOperator.IsAfter, newItem.OrderDate.ToString()),
new GridFilter(GridColumns.ShipName, FilterOperator.EqualTo, newItem.ShipName));
WaitForGridToLoadAtLeast(1, GridPage.Grid);
var results = GridPage.Grid.GetItems <Order>();
Assert.IsTrue(results.Count() == 1);
Assert.AreEqual(secondNewItem.ToString(), results[0].OrderDate);
}
/// <summary>
/// 应用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Apply_Click(object sender, RoutedEventArgs e)
{
var connect = string.Empty;
SqlWhere = string.Empty;
foreach (ChoseEx item in Tools.Items)
{
var model = item._ChoseModel;
if (model.CheckeRules && !string.IsNullOrEmpty(model.CompareValue))
{
if (!string.IsNullOrEmpty(connect))
{
SqlWhere += " " + connect;
connect = string.Empty;
}
SqlWhere += " " + model.FieldKey + " " + model.CompareRule + " '" + model.CompareValue + "'";
if (!string.IsNullOrEmpty(model.Connect))
{
connect = model.Connect;
}
}
}
if (!string.IsNullOrEmpty(SqlWhere))
{
SqlWhere = " where " + SqlWhere;
}
GridPage.Init(this);
}
public DataRes <List <ResMenuResponse> > EditMenus([FromBody] MenuRequestModel menu)
{
var res = new GridPage <List <ResMenuResponse> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ResMenu>();
if (menu.parentId != null && menu.parentId != 0)
{
menu.Parent = repository.Get(menu.parentId);
}
menu.Url = menu.path;
repository.Update(menu);
uow.SaveChanges();
res.data = null;
res.msg = "修改成功";
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
private void Globals_BingoNrChanged(object sender, EventArgs e)
{
//Update current nr
if (Globals.BingoNr == 0)
{
this.TxtBingoNr.Text = "";
}
else
{
this.TxtBingoNr.Text = Globals.BingoNr.ToString();
}
//Update history
this.TxtHistory1.Text = (Globals.NumbersDone.Count >= 2) ?
Globals.NumbersDone[1].ToString() : "";
this.TxtHistory2.Text = (Globals.NumbersDone.Count >= 3) ?
Globals.NumbersDone[2].ToString() : "";
this.TxtHistory3.Text = (Globals.NumbersDone.Count >= 4) ?
Globals.NumbersDone[3].ToString() : "";
//Update color of ellipse
object wantedItem = GridPage.FindName(ellipseName);
if (wantedItem is Ellipse)
{
Ellipse ellipse = wantedItem as Ellipse;
Random random = new Random();
ellipse.Fill = new SolidColorBrush(colors[random.Next(0, colors.Length)]);
}
}
public static GridPage <T> Delete(IUowProvider _uowProvider, object id, GridPage <T> res)
{
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <T>();
var menu = repository.Get(id);
if (menu != null)
{
repository.Remove(menu);
uow.SaveChanges();
res.data = null;
res.msg = "删除成功";
}
else
{
res.code = ResCode.NotFound;
res.data = null;
res.msg = "未找到该记录";
}
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
private void BtnRestart_Click(object sender, RoutedEventArgs e)
{
object item;
Globals.ResetNumbers();
this.BtnNextNumber.IsEnabled = true;
//Reset numbers on screen:
for (int i = 0; i < Globals.HighestNumber; i++)
{
item = GridPage.FindName(textNrName + i.ToString("D4"));
if (item is TextBlock)
{
TextBlock text = item as TextBlock;
text.FontWeight = Windows.UI.Text.FontWeights.Normal;
}
item = GridPage.FindName(borderName + i.ToString("D4"));
if (item is Border)
{
Border text = item as Border;
text.Background = new SolidColorBrush(Windows.UI.Colors.Black);
}
}
//Clear number history
this.txtCurrentNr.Text = "";
this.txtHistory1.Text = "";
this.txtHistory2.Text = "";
this.txtHistory3.Text = "";
}
public GridPage <DingNew> GetNew(int id)
{
var res = new GridPage <DingNew>()
{
code = ResCode.Success
};
var result = new GridPage <List <DingNew> >()
{
code = ResCode.Success
};
FilterNode node = new FilterNode();
node.andorop = "and";
node.binaryop = "eq";
node.key = "Id";
node.value = id;
var pageReq = new DatetimePointPageReq();
pageReq.query.Add(node);
result = DataBaseHelper <DingNew> .GetList(_uowProvider, result, pageReq, x => x.Include(a => a.DingClassify));
if (result.data.Count > 0)
{
res.data = result.data[0];
}
return(res);
}
/// <summary>
/// 获取机构分页数据
/// </summary>
/// <param name="Page"></param>
/// <param name="Rows"></param>
/// <returns></returns>
public JsonResult OrganGridJson(int page = 1, int rows = 30, string typeId = null, string level = null, string organName = null, string parentId = null)
{
JsonResult result = new JsonResult();
if (Limits.Contains(1))
{
GridPage <OrganGrid> jr = new GridPage <OrganGrid>();
var loginInfo = LoginFac.Admin.GetLoginInfo();
string pid = loginInfo.OrganId;
var haveme = false;
if (!string.IsNullOrEmpty(parentId) && loginInfo.OrganId.Split(',').Any(o => parentId.StartsWith(o)))
{
pid = parentId;
}
else
{
haveme = loginInfo.RoleId == CustomConfig.SuperRoleId;
}
var data = DbOp.GetPageList(page, rows, typeId, level, organName, pid, haveme);
jr.rows = data.Items;
jr.total = data.TotalItems;
result.Data = jr;
}
return(result);
}
public GridPage <DingClassify> addNews([FromBody] DingNew newsDetail, int classifyId)
{
var ress = new GridPage <DingClassify>()
{
code = ResCode.Success
};
//using (var mdReader = new StringReader(newsDetail.OriginalContent))
//{
// using (var html = new StringWriter())
// {
// CommonMark.CommonMarkConverter.Convert(mdReader, html);
// newsDetail.HtmlContent = html.ToString();
// }
//}
ress = DataBaseHelper <DingClassify> .Get(_uowProvider, ress, classifyId, x => x.Include(a => a.DingNews));
ress.data.DingNews.Add(newsDetail);
ress = DataBaseHelper <DingClassify> .Create(_uowProvider, ress.data, ress, true);
if (newsDetail.Status == 1)
{
OapiMessageCorpconversationAsyncsendV2Request.MsgDomain obj1 = new OapiMessageCorpconversationAsyncsendV2Request.MsgDomain();
obj1.Msgtype = "link";
OapiMessageCorpconversationAsyncsendV2Request.LinkDomain obj2 = new OapiMessageCorpconversationAsyncsendV2Request.LinkDomain();
obj2.PicUrl = newsDetail.Image;
obj2.MessageUrl = "eapp://pages/detail/index?id=" + ress.data.Id;
obj2.Text = newsDetail.SubTitle;
obj2.Title = newsDetail.Title;
obj1.Link = obj2;
var res = DingTalkHelper.PushMessage("1814645351680963", null, "", obj1);
}
return(ress);
}
public GridPage <List <DingNew> > GetNews(DatetimePointPageReq pageReq, int?id)
{
var res = new GridPage <List <DingNew> >()
{
code = ResCode.Success
};
if (id != null)
{
FilterNode node = new FilterNode();
node.andorop = "and";
node.binaryop = "eq";
node.key = "DingClassify.Id";
node.value = id;
if (pageReq == null)
{
pageReq = new DatetimePointPageReq();
}
pageReq.query.Add(node);
res = DataBaseHelper <DingNew> .GetList(_uowProvider, res, pageReq, x => x.Include(a => a.DingClassify));
}
else
{
//all
res = DataBaseHelper <DingNew> .GetList(_uowProvider, res, pageReq, x => x.Include(a => a.DingClassify));
}
return(res);
}
public DataRes <List <ResMenuResponse> > DeleteMenus(int id)
{
var res = new GridPage <List <ResMenuResponse> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ResMenu>();
var menu = repository.Get(id);
if (menu != null)
{
repository.Remove(menu);
uow.SaveChanges();
res.data = null;
res.msg = "删除成功";
}
else
{
res.code = ResCode.NotFound;
res.data = null;
res.msg = "未找到该记录";
}
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public GridPage <List <OddMinusSale> > GetOddMinusSale([FromBody] ReqTimeBetween req)
{
var res = new GridPage <List <OddMinusSale> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var sdatep = new SqlParameter("@Sdate", req.startTime);
var edatep = new SqlParameter("@Edate", req.endTime);
var repository = uow.GetRepository <OddMinusSale>();
var data = repository.FromProcedure("EXECUTE OddMinusSale_sp @Sdate,@Edate", sdatep, edatep).ToList();
res.data = data;
return(res);
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public GridPage <List <SkuSaleQueryReport> > SkuSaleQuery(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <SkuSaleQueryReport> > {
code = ResCode.Success
};
StringBuilder sbCommon = new StringBuilder();
List <FilterNode> list = new List <FilterNode>();
foreach (var item in pageReq.query)
{
if (item.value != null)
{
switch (item.key.ToLower())
{
case "storename":
sbCommon.Append($" {item.andorop} PlatformUserName in ({item.value}) ");
break;
case "sku":
sbCommon.Append($" {item.andorop} PcrProductSku {Operate.GetSqlOperate(item.binaryop)} '{item.value}' ");
break;
default:
sbCommon.Append($" {item.andorop} {item.key} {Operate.GetSqlOperate(item.binaryop)} '{item.value}' ");
break;
}
}
}
var whereSql = new SqlParameter("@whereSql", sbCommon.ToString());
pageReq.query = list;
res = DataBaseHelper <SkuSaleQueryReport> .GetFromProcedure(_uowProvider, res, pageReq, false, "EXECUTE SkuSaleQuery_sp @whereSql", whereSql);
return(res);
}
public void ExportOrderCostTotal(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <OrderCostTotalReport> > {
code = ResCode.Success
};
StringBuilder sbCommon = new StringBuilder();
List <FilterNode> list = new List <FilterNode>();
foreach (var item in pageReq.query)
{
if (item.value != null)
{
switch (item.key.ToLower())
{
case "storename":
sbCommon.Append($" {item.andorop} PlatformUserName {Operate.GetSqlOperate(item.binaryop)} '{item.value}' ");
break;
default:
sbCommon.Append($" {item.andorop} {item.key} {Operate.GetSqlOperate(item.binaryop)} '{item.value}' ");
break;
}
}
}
var whereSql = new SqlParameter("@whereSql", sbCommon.ToString());
pageReq.query = list;
res = DataBaseHelper <OrderCostTotalReport> .GetFromProcedure(_uowProvider, res, pageReq, true, "EXECUTE OrderCostStore_sp @whereSql", whereSql);
Response.Headers.Add("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("OrderCostTotalReport.xlsx"));
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8";
Response.Body.Write(ExcelHelper <OrderCostTotalReport> .NpoiListToExcel(res.data));
Response.Body.Flush();
Response.Body.Close();
}
public DataRes <List <ResMenuResponse> > GetMenus()
{
var res = new GridPage <List <ResMenuResponse> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ResMenu>();
var repoResult = repository.GetAll().ToList();
var result = TreeHelper.ToTreeResponse(repoResult);
var finallResult = TreeHelper.ToTree(result);
res.data = finallResult;
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public void FreightLessThanOrEqualToFilter()
{
GridPage.NavigateTo();
var allItems = GetAllItemsFromDb().OrderBy(x => x.Freight);
var smallestFreight = allItems.First().Freight;
var newItem = CreateNewItemInDb();
newItem.Freight = Math.Round(smallestFreight - GetUniqueNumberValue(), 3, MidpointRounding.AwayFromZero);
UpdateItemInDb(newItem);
var secondNewItem = CreateNewItemInDb(newItem.ShipName);
secondNewItem.Freight = Math.Round(newItem.Freight - 0.01, 3, MidpointRounding.AwayFromZero);
UpdateItemInDb(secondNewItem);
GridPage.Grid.Filter(GridColumns.Freight, FilterOperator.LessThanOrEqualTo, newItem.Freight.ToString());
WaitForGridToLoadAtLeast(2, GridPage.Grid);
var results = GridPage.Grid.GetItems <AdvancedReuseTacticsGridControlsAutomatedTests.Order>();
Assert.IsTrue(results.Count() == 2);
// We assume that there isn't default sorting for this column so we cannot expect that the order will be the same every time.
Assert.AreEqual(1, results.Count(x => x.Freight == secondNewItem.Freight));
Assert.AreEqual(1, results.Count(x => x.Freight == newItem.Freight));
}
public void FreightGreaterThanFilter()
{
GridPage.NavigateTo();
var allItems = GetAllItemsFromDb().OrderBy(x => x.Freight);
var biggestFreight = allItems.Last().Freight;
var newItem = CreateNewItemInDb();
newItem.Freight = biggestFreight + GetUniqueNumberValue();
UpdateItemInDb(newItem);
var secondNewItem = CreateNewItemInDb(newItem.ShipName);
secondNewItem.Freight = newItem.Freight + 1;
UpdateItemInDb(secondNewItem);
GridPage.Grid.Filter(GridColumns.Freight, FilterOperator.GreaterThan, newItem.Freight.ToString());
WaitForGridToLoadAtLeast(1, GridPage.Grid);
var results = GridPage.Grid.GetItems <AdvancedReuseTacticsGridControlsAutomatedTests.Order>();
Assert.IsTrue(results.Count() == 1);
// We assume that there isn't default sorting for this column so we cannot expect that the order will be the same every time.
Assert.AreEqual(1, results.Count(x => x.Freight == secondNewItem.Freight));
}
public GridPage <List <ECHeadTripLine> > GetECHeadTripLinesPage(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <ECHeadTripLine> >()
{
code = ResCode.Success
};
StringBuilder sbCommon = new StringBuilder();
StringBuilder sbLoandate = new StringBuilder();
List <FilterNode> list = new List <FilterNode>();
foreach (var item in pageReq.query)
{
if (item.value != null)
{
switch (item.key.ToLower())
{
case "addtime":
if (item.binaryop == "gt")
{
sbCommon.Append($" and t1.AddTime >= '{item.value}'");
}
if (item.binaryop == "lt")
{
sbCommon.Append($" and t1.AddTime <= '{item.value}'");
}
break;
case "itemsku":
sbCommon.Append($" and t4.PcrProductSku {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
case "storename":
sbCommon.Append($" and t1.PlatformUserName {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
case "towarehouse":
sbCommon.Append($" and ToWarehouse {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
case "warehouse":
sbCommon.Append($" and Warehouse {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
case "ordercode":
sbCommon.Append($" and t1.Ordercode {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
case "companyname":
sbCommon.Append($" and company {Operate.GetSqlOperate(item.binaryop)} '{item.value}'");
break;
}
}
}
var whereSql = new SqlParameter("@whereSql", sbCommon.ToString());
res = DataBaseHelper <ECHeadTripLine> .GetFromProcedure(_uowProvider, res, pageReq, false, "EXECUTE ShipBatckQuery_sp @whereSql", whereSql);
return(res);
}
public JsonResult OrganComboGridJson(int page = 1, int rows = 30, string typeId = null, string level = null, string organName = null)
{
GridPage<OrganGrid> jr = new GridPage<OrganGrid>();
var data = DbOp.GetPageList(page, rows, typeId, level, organName,LoginFac.Admin.GetLoginInfo().OrganId, true);
jr.rows = data.Items;
jr.total = data.TotalItems;
return Json(jr);
}
public GridPage <List <ECRepeatCust> > GetRepeatCustList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <ECRepeatCust> >()
{
code = ResCode.Success
};
return(DataBaseHelper <ECRepeatCust> .GetList(_uowProvider, res, pageReq));
}
public GridPage <List <BnsPaypalTransactionDetail> > GetPaypalList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <BnsPaypalTransactionDetail> >()
{
code = ResCode.Success
};
return(DataBaseHelper <BnsPaypalTransactionDetail> .GetList(_uowProvider, res, pageReq, x => x.Include(a => a.BnsPaypalTransactionDetailsCartInfos)));
}
public GridPage <List <BnsAmazonReport> > GetAmazonList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <BnsAmazonReport> >()
{
code = ResCode.Success
};
return(DataBaseHelper <BnsAmazonReport> .GetList(_uowProvider, res, pageReq));
}
public GridPage <List <BnsSendDeliverdToEc> > GetDeliverList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <BnsSendDeliverdToEc> >()
{
code = ResCode.Success
};
return(DataBaseHelper <BnsSendDeliverdToEc> .GetList(_uowProvider, res, pageReq));
}
public IActionResult DocView(GridPage gridPage, string keyWord)
{
var list = _menuRepository.GetMenusList(ref gridPage, keyWord);
ViewBag.List = list;
ViewBag.Page = gridPage;
ViewBag.PageList = PageHelper.GetPageList(gridPage.Page, gridPage.Total, 10);
return(View());
}
public GridPage <List <ECShipBatch> > GetList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <ECShipBatch> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECShipBatch>();
if (pageReq == null)
{
res.data = repository.GetPage(0, 50).ToList();
return(res);
}
else
{
if (pageReq.pageSize == 0)
{
pageReq.pageSize = 1;
}
if (pageReq.pageNum == 0)
{
pageReq.pageNum = 1;
}
}
int startRow = (pageReq.pageNum - 1) * pageReq.pageSize;
Filter <ECShipBatch> filter = new Filter <ECShipBatch>(null);
if (pageReq.query.Count > 0)
{
var fuc = FilterHelper <ECShipBatch> .GetExpression(pageReq.query, "OmsReceivingPage");
filter = new Repository.Filter <ECShipBatch>(fuc);
}
OrderBy <ECShipBatch> orderBy = new OrderBy <ECShipBatch>(null);
if (pageReq.order != null)
{
orderBy = new Repository.OrderBy <ECShipBatch>(pageReq.order.columnName, pageReq.order.reverse);
}
res.totalCount = repository.Query(filter.Expression, orderBy.Expression).Count();
res.data = repository.QueryPage(startRow, pageReq.pageSize, filter.Expression, orderBy.Expression,
x =>
x.Include(a => a.PackingInfo)
.Include(a => a.ProductInfo)).ToList();
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public GridPage <List <ECAliexpressLoaninfo> > GetAliLoanList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <ECAliexpressLoaninfo> >()
{
code = ResCode.Success
};
return(DataBaseHelper <ECAliexpressLoaninfo> .GetList(_uowProvider, res, pageReq));
}
public JsonResult OrganComboGridJson(int page = 1, int rows = 30, string typeId = null, string level = null, string organName = null)
{
GridPage <OrganGrid> jr = new GridPage <OrganGrid>();
var data = DbOp.GetPageList(page, rows, typeId, level, organName, LoginFac.Admin.GetLoginInfo().OrganId, true);
jr.rows = data.Items;
jr.total = data.TotalItems;
return(Json(jr));
}
public IActionResult DocView(GridPage gridPage, string keyWord, string menuId)
{
var list = _articleRepository.GetArticlesPage(ref gridPage, keyWord, menuId);
ViewBag.List = list;
ViewBag.Page = gridPage;
ViewBag.PageList = PageHelper.GetPageList(gridPage.Page, gridPage.Total, 10);
return(View());
}
private void NavigateToGridInitialPage(int initialPageNumber)
{
GridPage.NavigateTo();
GridPage.Grid.Filter(GridColumns.ShipName, FilterOperator.EqualTo, _uniqueShippingName);
GridPage.Grid.ChangePageSize(1);
WaitForGridToLoad(1, GridPage.Grid);
GridPage.Grid.NavigateToPage(initialPageNumber);
WaitForPageToLoad(initialPageNumber, GridPage.Grid);
AssertPagerInfoLabel(initialPageNumber, initialPageNumber, _testPagingItems.Count);
}
private string GetTranslatedString(ITranslator translator, string name, GridPage page, bool isTooltip)
{
string retVal = translator.GetTranslatedString(name);
if (retVal == "UNKNOWN CHARACTER")
{
return(isTooltip ? page.MenuToolTip : page.MenuTitle);
}
return(retVal);
}
//获取字典分页列表
public JsonResult GetDictPageJson(int page = 1, int rows = 30)
{
JsonResult result = new JsonResult();
if (Limits.Contains(1))
{
GridPage<Dict> data = new GridPage<Dict>();
var list = DbOp.GetDictPageList(0, page, rows);
data.total = list.TotalItems;
data.rows = list.Items;
result.Data = data;
}
return result;
}
//获取配置分页列表
public JsonResult GetConfSetData()
{
if (Limits.Contains(1))
{
var confs = DbOp.GetConfList();
var options = DbOptionOp.GetOptionList();
foreach (var c in confs)
{
if (c.CType == 0 || c.CType == 1)
{
c.Options = options.Where(o => o.ConfigId == c.ConfigId).ToList();
}
}
GridPage<ConfigSet> data = new GridPage<ConfigSet>();
data.total = confs.Count();
data.rows = confs;
return Json(data);
}
else
return null;
}
//获取配置内容分页列表
public JsonResult GetConfOptionPageJson(int page = 1, int rows = 30, int groupId = 0, int configId = 0, string optionName = null)
{
if (Limits.Contains(1))
{
GridPage<ConfigOptionGrid> data = new GridPage<ConfigOptionGrid>();
var list = DbOp.GetPageList(page, rows, groupId, configId, optionName);
data.total = list.TotalItems;
data.rows = list.Items;
return Json(data);
}
else
return null;
}
//获取权限分页列表
public JsonResult GetLimitPageJson(int moduleId, int page = 1, int rows = 30)
{
JsonResult jresult = new JsonResult();
if (Limits.Contains(1))
{;
var data = DbOp.GetPageList(moduleId, page, rows);
GridPage<LimitModuleName> result = new GridPage<LimitModuleName>();
result.total = data.TotalItems;
result.rows = data.Items;
jresult.Data = result;
}
return jresult;
}
/// <summary>
/// 获取机构分页数据
/// </summary>
/// <param name="Page"></param>
/// <param name="Rows"></param>
/// <returns></returns>
public JsonResult OrganGridJson(int page = 1, int rows = 30, string typeId = null, string level = null,string organName = null,string parentId=null)
{
JsonResult result = new JsonResult();
if (Limits.Contains(1))
{
GridPage<OrganGrid> jr = new GridPage<OrganGrid>();
var loginInfo = LoginFac.Admin.GetLoginInfo();
string pid =loginInfo.OrganId;
var haveme = false;
if (!string.IsNullOrEmpty(parentId)&&loginInfo.OrganId.Split(',').Any(o=> parentId.StartsWith(o)))
{
pid = parentId;
}
else
{
haveme = loginInfo.RoleId == CustomConfig.SuperRoleId;
}
var data = DbOp.GetPageList(page, rows, typeId, level, organName, pid, haveme);
jr.rows = data.Items;
jr.total = data.TotalItems;
result.Data = jr;
}
return result;
}
//角色信息获取
public JsonResult RolePageJson(int Page = 1, int rows = 30)
{
JsonResult JR = new JsonResult();
if (Limits.Contains(1))
{
var data = DbOp.GetPageList(Page, rows);
GridPage<RoleGrid> result = new GridPage<RoleGrid>();
result.total = data.TotalItems;
result.rows=data.Items;
JR.Data = result;
}
return JR;
}
/// <summary>
/// 获取用户分页数据
/// </summary>
/// <param name="Page"></param>
/// <param name="Rows"></param>
/// <returns></returns>
public JsonResult UserGridJson(int page = 1, int rows = 30, string username = null, string sex = null, string states = null, string usertype = null, string regionid = null, string organid = null, string roleid = null, DateTime? starttime = null, DateTime? endtime = null)
{
JsonResult result = new JsonResult();
if (Limits.Contains(1))
{
GridPage<UserGrid> jr = new GridPage<UserGrid>();
var oIds = LoginFac.Admin.GetLoginInfo().OrganId;
if (!string.IsNullOrEmpty(organid)&&oIds.Split(',').Any(o => organid.StartsWith(o)))
oIds = organid;
var data = DbOp.GetPageList(page, rows, username, sex, states, usertype, regionid, oIds, roleid, starttime, endtime);
jr.rows = data.Items;
jr.total = data.TotalItems;
result.Data = jr;
}
return result;
}
//获取配置分页列表
public JsonResult GetConfPageJson(int page = 1, int rows = 30,int groupId = 0,string opType=null,string confName=null)
{
if (Limits.Contains(1))
{
GridPage<ConfigGrid> data = new GridPage<ConfigGrid>();
int type = string.IsNullOrEmpty(opType) ? -1 : int.Parse(opType);
var list = DbOp.GetPageList(page, rows, groupId, type, confName);
data.total = list.TotalItems;
data.rows = list.Items;
return Json(data);
}
else
return null;
}
