// GET: QCSelect
public ActionResult Index(QCSelectIndexModel model, int?PageIndex, int?PageSize = 30)
{
ViewBag.Line = CommonHelp.list;
// if (!string.IsNullOrEmpty(Request.QueryString["Area"]))
// Session["Area"] = "123";//Request.QueryString["Area"];
// string area = Session["Area"].ToString();
// ViewBag.title= Session["Area"].ToString();
if (!model.Area.IsNullOrEmpty())
{
list = DapperService.SqlHelp.QCSelect(model);
foreach (var item in list)
{
item.area = model.Area;
}
ViewBag.list = list.Take(30).ToList();
ViewBag.totalcount = list.Count;
// return Json(list, JsonRequestBehavior.AllowGet);
}
if (PageIndex != null)
{
var model1 = new PageInfoModel <QCSelectDto>();
model1.List = list;
model1.PageSize = PageSize;
model1.PageIndex = PageIndex;
var res = CommonHelp.PageList(model1);
return(Json(res, JsonRequestBehavior.AllowGet));
}
return(View());
}
public IHttpActionResult GetForOwners(string owners, [FromUri] PageInfoModel pageInfo)
{
if (string.IsNullOrWhiteSpace(owners))
{
return(BadRequest("No owners specified."));
}
var splitted = owners.SplitCommaSeparated();
if (splitted.Length > MAX_NUMBER_OWNERS_ALLOWED)
{
return(BadRequest($"Maximum {MAX_NUMBER_OWNERS_ALLOWED} owners can be specified."));
}
pageInfo = pageInfo ?? new PageInfoModel();
var paging = MappingHelper.MapToPageInfo(pageInfo);
if (!paging.OrderBy.IsValidFor(_assetRepo.Columns))
{
return(BadRequest($"Unknown field : {paging.OrderBy.Name}."));
}
var pagedResult = _assetRepo.ForOwners(paging, splitted);
return(CreateActionResultFor(pagedResult));
}
public ActionResult ListPartial(int page = 1, string sortCol = "RoleID", string sortType = "asc")
{
string err;
try {
var result = MBFDB.GetRolePageList <RoleViewModel>(out err, page, MBFDB.PageSize, sortCol, sortType);
ViewBag.Page = page;
ViewBag.SortCol = sortCol;
ViewBag.SortType = sortType;
//
Session["PageInfo"] = new PageInfoModel(page, sortCol, sortType);
if (string.IsNullOrEmpty(err))
{
Response.StatusCode = (int)HttpStatusCode.OK;
return(PartialView("ListPartial", result));
}
else
{
LOG.Trace(ERRHD.BuildTraceMessage(ExceptionHandle.MBF_ERROR.ERR_DB_ACCESS, "MBFDB.GetRolePageList"));
return(new HttpStatusCodeResult(500, ERRHD.BuildUserMsg(ExceptionHandle.MBF_ERROR.ERR_DB_ACCESS)));
}
}
catch (Exception ex) {
LOG.Fatal(ERRHD.BuildExceptionMessage(ex));
return(new HttpStatusCodeResult(500, "exception error."));
}
}
public static List <AssembleSearchDto> list = new List <AssembleSearchDto>();// { get; set; }
// 页面初次加载
public ActionResult Index(ForAssemblyModel model, int?PageIndex, int?PageSize = 30)
{
try
{
ViewBag.totalcount = 0;
ViewBag.Line = CommonHelp.list;
if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Area))
{
model.EndTime = Convert.ToDateTime(model.EndTime);
model.StartTime = Convert.ToDateTime(model.StartTime);
model.Area = model.Area;
list = GetAssemblyList(model);
foreach (var item in list)
{
item.area = model.Area;
}
ViewBag.totalcount = list.Count;
ViewBag.list = list.Take(30).ToList();
}
if (PageIndex != null)
{
var model1 = new PageInfoModel <AssembleSearchDto>();
model1.List = list;;
model1.PageSize = PageSize;
model1.PageIndex = PageIndex;
var res = CommonHelp.PageList(model1);
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
}
return(View());
}
protected virtual IQueryable <TEntity> QueryDb(Expression <Func <TEntity, bool> > filter,
Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null,
PageInfoModel pagedInfo = null,
params Expression <Func <TEntity, object> >[] includeProperties)
{
IQueryable <TEntity> query = Context
.Set <TEntity>()
.AsNoTracking();
if (filter != null)
{
query = query.Where(filter);
}
foreach (var includeProperty in includeProperties)
{
query = query.Include(includeProperty);
}
if (orderBy != null)
{
query = orderBy(query);
}
var isAdditionalOrder =
!string.IsNullOrEmpty(pagedInfo?.SortDir) && !string.IsNullOrEmpty(pagedInfo.SortKey);
if (isAdditionalOrder)
{
query = pagedInfo.SortDir == "desc" ? query.SortDesc(pagedInfo.SortKey) : query.Sort(pagedInfo.SortKey);
}
return(query);
}
public IHttpActionResult Get(
[FromUri] ProductFilterModel filter,
[FromUri] PageInfoModel pageInfo)
{
filter = filter ?? new ProductFilterModel();
pageInfo = pageInfo ?? new PageInfoModel();
PagedResult <ProductDto> pagedResult;
var paging = MappingHelper.MapToPageInfo(pageInfo);
if (!paging.OrderBy.IsValidFor(_repo.Columns))
{
return(BadRequest($"Unknown field : {paging.OrderBy.Name}."));
}
if (filter.IsEmpty())
{
pagedResult = _repo.PagedQuery(paging);
return(CreateActionResultFor(pagedResult));
}
// Apply filter.
var query = MapToQuery(filter);
pagedResult = _repo.PagedQuery(paging, query);
return(CreateActionResultFor(pagedResult));
}
//[ValidateAntiForgeryToken]
public string QueryACBJ(PageInfoModel pgingModel, ACBJViewModel model)
{
string result = string.Empty;
this.db = new GWEB_TESTEntities();
try
{
//PAGING//
//var queryResult = (from p in db.ACBJ select p).OrderBy(x => x.TPID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize);
//NO PAGING//
var queryResult = (from p in db.ACBJ select p);
//FILTER ONLY WITH PRIMARY K,.. NOT REALLY EXACTLY/FULLY RIGHT//
if (model.TPID != "" & model.TPID != null)
{
queryResult = queryResult.Where(x => x.TPID == model.TPID);
}
if (model.SQID != "" & model.SQID != null)
{
queryResult = queryResult.Where(x => x.SQID == model.SQID);
}
if (model.ACID != "" & model.ACID != null)
{
queryResult = queryResult.Where(x => x.ACID == model.ACID);
}
if (model.SBID != "" & model.SBID != null)
{
queryResult = queryResult.Where(x => x.SBID == model.SBID);
}
if (model.SQNO != "" & model.SQNO != null)
{
queryResult = queryResult.Where(x => x.SQNO == model.SQNO);
}
if (model.PJID != "" & model.PJID != null)
{
queryResult = queryResult.Where(x => x.PJID == model.PJID);
}
if (model.PJSQ != "" & model.PJSQ != null)
{
queryResult = queryResult.Where(x => x.PJSQ == model.PJSQ);
}
result = new JavaScriptSerializer().Serialize(queryResult.ToList());
}
catch (Exception)
{
//TODO:
throw;
}
finally { db.Dispose(); }
return(result);
}
// GET: GetPartByDate
public ActionResult Index(PartDataModel model, int?PageIndex, int?PageSize = 30)
{
try
{
ViewBag.totalcount = 0;
ViewBag.Line = CommonHelp.list;
if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Line))
{
string key = Guid.NewGuid().ToString() + model.Line;
CommonHelp.key = key;
if (model.EndTime.Month - model.StartTime.Month > 0)
{
CommonHelp.StarMon = model.StartTime.ToString("yyyy MMMM dd") + "~" +
model.EndTime.ToString("yyyy MMMM dd");
CommonHelp.EndMon = CommonHelp.list.Where(p => p.Area.Equals(model.Line)).FirstOrDefault()
.DesCribe;
}
else
{
CommonHelp.StarMon = model.StartTime.Month + "月";
CommonHelp.EndMon = CommonHelp.list.Where(p => p.Area.Equals(model.Line)).FirstOrDefault()
.DesCribe;
}
if (CommonBuffer.Exist(key))
{
CommonHelp.list2 = CommonBuffer.Get <List <PartDataDto> >(key);
ViewBag.count = CommonHelp.list2.Count;
ViewBag.Data = CommonHelp.list2.Take(30).ToList();
}
else
{
CommonHelp.list2 = CommonBuffer.FindT(key, DapperService.SqlHelp.PartDataBase, model);
ViewBag.count = CommonHelp.list2.Count;
ViewBag.Data = CommonHelp.list2.Take(30).ToList();
}
}
if (PageIndex != null)
{
var model1 = new PageInfoModel <PartDataDto>();
model1.List = CommonHelp.list2;
model1.PageSize = PageSize;
model1.PageIndex = PageIndex;
var res = CommonHelp.PageList(model1);
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
}
return(View());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PageInfoModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update CORE.dbo.PageInfo set ");
strSql.Append(" PageId = @PageId , ");
strSql.Append(" PageName = @PageName , ");
strSql.Append(" PageMemo = @PageMemo , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" MerId = @MerId , ");
strSql.Append(" Invalid = @Invalid , ");
strSql.Append(" PageLabel = @PageLabel , ");
strSql.Append(" BranchId = @BranchId , ");
strSql.Append(" ZoneId = @ZoneId ");
strSql.Append(" where PageId=@PageId ");
SqlParameter[] parameters =
{
new SqlParameter("@PageId", SqlDbType.VarChar, 50),
new SqlParameter("@PageName", SqlDbType.VarChar, 50),
new SqlParameter("@PageMemo", SqlDbType.VarChar, 500),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@MerId", SqlDbType.Decimal, 9),
new SqlParameter("@Invalid", SqlDbType.Bit, 1),
new SqlParameter("@PageLabel", SqlDbType.VarChar, 50),
new SqlParameter("@BranchId", SqlDbType.VarChar, 50),
new SqlParameter("@ZoneId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.PageId;
parameters[1].Value = model.PageName;
parameters[2].Value = model.PageMemo;
parameters[3].Value = model.OrderNo;
parameters[4].Value = model.MerId;
parameters[5].Value = model.Invalid;
parameters[6].Value = model.PageLabel;
parameters[7].Value = model.BranchId;
parameters[8].Value = model.ZoneId; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
public IActionResult ListBooks([FromForm] PageInfoModel pageInfo, [FromForm] SearchViewModel model)
{
try
{
if (ModelState.IsValid)
{
ListBooksViewModel result = null;
switch (pageInfo.ActionName.Replace("/", ""))
{
case "AllBooks":
result = _libraryLogic.GetAllBook(this.CurrentUser(), model);
break;
case "CurrentReadList":
result = _libraryLogic.GetCurrentReadBooks(this.CurrentUser(), model);
break;
case "PreviousReadList":
result = _libraryLogic.GetPreviousReadBooks(this.CurrentUser(), model);
break;
}
if (result != null)
{
result.PageView = pageInfo.PageItems;
if (pageInfo.PageItems == 1)
{
pageInfo.PageItems = 4;
}
result.Search = model;
ViewBag.Pagination = Pagination(pageInfo, result);
result.Books = result.Books.OrderByDescending(book => (book.Aviable != 0)).ThenBy(book => book.Title).Skip((pageInfo.Page - 1) * pageInfo.PageItems).Take(pageInfo.PageItems).ToList();
return(PartialView(result));
}
return(PartialView(result));
}
else
{
return(BadRequest());
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(PageInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CORE.dbo.PageInfo (");
strSql.Append("PageId,PageName,PageMemo,OrderNo,MerId,Invalid,PageLabel,BranchId,ZoneId");
strSql.Append(") values (");
strSql.Append("@PageId,@PageName,@PageMemo,@OrderNo,@MerId,@Invalid,@PageLabel,@BranchId,@ZoneId");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@PageId", SqlDbType.VarChar, 50),
new SqlParameter("@PageName", SqlDbType.VarChar, 50),
new SqlParameter("@PageMemo", SqlDbType.VarChar, 500),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@MerId", SqlDbType.Decimal, 9),
new SqlParameter("@Invalid", SqlDbType.Bit, 1),
new SqlParameter("@PageLabel", SqlDbType.VarChar, 50),
new SqlParameter("@BranchId", SqlDbType.VarChar, 50),
new SqlParameter("@ZoneId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.PageId;
parameters[1].Value = model.PageName;
parameters[2].Value = model.PageMemo;
parameters[3].Value = model.OrderNo;
parameters[4].Value = model.MerId;
parameters[5].Value = model.Invalid;
parameters[6].Value = model.PageLabel;
parameters[7].Value = model.BranchId;
parameters[8].Value = model.ZoneId;
bool result = false;
try
{
helper.ExecSqlReInt(strSql.ToString(), parameters);
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public PageInfoModel GetModel(string PageId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PageId, PageName, PageMemo, OrderNo, MerId, Invalid, PageLabel, BranchId, ZoneId ");
strSql.Append(" from CORE.dbo.PageInfo ");
strSql.Append(" where PageId=@PageId ");
SqlParameter[] parameters =
{
new SqlParameter("@PageId", SqlDbType.VarChar, 50)
};
parameters[0].Value = PageId;
PageInfoModel model = new PageInfoModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.PageId = ds.Tables[0].Rows[0]["PageId"].ToString();
model.PageName = ds.Tables[0].Rows[0]["PageName"].ToString();
model.PageMemo = ds.Tables[0].Rows[0]["PageMemo"].ToString();
if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString());
}
if (ds.Tables[0].Rows[0]["MerId"].ToString() != "")
{
model.MerId = decimal.Parse(ds.Tables[0].Rows[0]["MerId"].ToString());
}
if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true"))
{
model.Invalid = true;
}
else
{
model.Invalid = false;
}
}
model.PageLabel = ds.Tables[0].Rows[0]["PageLabel"].ToString();
model.BranchId = ds.Tables[0].Rows[0]["BranchId"].ToString();
model.ZoneId = ds.Tables[0].Rows[0]["ZoneId"].ToString();
return(model);
}
else
{
return(model);
}
}
public async Task <PagedEntityResult <Account> > LoadAll(PageInfoModel pageInfo = null)
{
var items = await _repository.PagedQuery(null, null, pageInfo);
var result = new PagedEntityResult <Account>
{
Result = items.Result,
TotalCount = items.TotalCount,
PagingInfo = items.PagingInfo
};
return(result);
}
public async Task <ApiResModel> UsageAmountDailyReport(long usageAccountId, int?currentPage, int?pageCount)
{
ApiResModel apiResModel = new ApiResModel();
var lineItems = await _reportService.UsageAmountDailyReport(usageAccountId);
var pageInfo = new PageInfoModel(currentPage, pageCount);
lineItems = pageInfo.ComputePage(lineItems);
apiResModel.PageInfo = pageInfo;
apiResModel.Result = lineItems;
return(apiResModel);
}
public void AddKeywords()
{
// Arrange
const string keywords = "keyword01, keyword02, keyword03";
var pageInfoModel = new PageInfoModel("PageTitle");
pageInfoModel.AddKeywords(keywords);
// Act
var keywordsResult = pageInfoModel.GetKeywords().ToHtmlString();
// Assert
Assert.That(keywordsResult, Is.Not.Null.Or.Empty);
Assert.AreEqual(keywords, keywordsResult);
}
public static ResPageInfoDto <T> PageList <T>(PageInfoModel <T> model)
{
var res = new ResPageInfoDto <T>();
if (model.PageIndex <= model.List.Count / 30)
{
res.List = model.List.Skip(model.PageIndex ?? 0 - 1).Take(model.PageSize ?? 30).ToList();
}
else
{
var last = model.List.Count - (model.PageIndex - 1) * 30;
res.List = model.List.Skip(model.PageIndex ?? 0 - 1).Take(last ?? 30).ToList();
}
res.TotalCount = model.List.Count;
return(res);
}
/// <summary>
/// Возвращает модель пагинации страницы
/// </summary>
/// <param name="pageInfo"> Информация о странице </param>
/// <param name="books"> Список книг страницы </param>
/// <returns> Модель пагинации страницы</returns>
public static Pagination Pagination(PageInfoModel pageInfo, ListBooksViewModel books)
{
Pagination pagination = new Pagination
{
PageItemsAmount = pageInfo.PageItems,
CurrentPage = pageInfo.Page,
ControllerName = "Library",
ActionName = pageInfo.ActionName.Replace("/", ""),
ShowLastAndFirstPages = true
};
pagination.ItemsAmount = books.Books.Count();
pagination.Refresh();
return(pagination);
}
public void Ctor_PageInfoData_PageInfoModelInstance()
{
// Arrange
const string pageTitle = "PageTitle";
const string pageDescription = "PageDescription";
// Act
var pageInfoModel = new PageInfoModel(pageTitle)
{
Description = pageDescription
};
// Assert
Assert.IsNotNull(pageInfoModel);
Assert.AreEqual(pageTitle, pageInfoModel.Title);
Assert.AreEqual(pageDescription, pageInfoModel.Description);
}
public FriendListViewModel GetFriendsByMessageRegime(long accountId, MessageRegime?messageRegime, int pageNumber, int pageSize)
{
var account = _accountManager.GetAccountById(accountId);
var friends = new GetFriendsByMessageRegimeQueryHandler(new DataBaseContext()).Handle(new GetFriendsByMessageRegimeQuery
{
AccountId = accountId,
GroupSettingsId = account.GroupSettingsId,
MessageRegime = messageRegime,
Page = new PageModel {
PageNumber = pageNumber, PageSize = pageSize
}
});
var pageInfo = new PageInfoModel
{
PageNumber = pageNumber,
PageSize = pageSize,
TotalItems = friends.CountAllFriends
};
var result = new FriendListViewModel
{
AccountId = accountId,
Friends = friends.Friends.Select(model => new FriendViewModel
{
AddDateTime = model.AddedDateTime,
Id = model.Id,
Deleted = model.Deleted,
FacebookId = model.FacebookId,
MessagesEnded = model.DialogIsCompleted,
Name = model.FriendName,
Href = model.Href,
IsAddedToGroups = model.IsAddedToGroups,
IsAddedToPages = model.IsAddedToPages,
IsWinked = model.IsWinked,
MessageRegime = model.MessageRegime,
AddedToRemoveDateTime = model.AddedToRemoveDateTime,
CountWinksToFriends = model.CountWinksToFriends
}).ToList(),
PageInfo = pageInfo
};
return(result);
}
public static MvcHtmlString PageLinks(this HtmlHelper html, PageInfoModel pageInfo, Func <int, string> pageUrl)
{
var result = new StringBuilder();
for (int i = 1; i <= pageInfo.TotalPages; i++)
{
var tag = new TagBuilder("a");
tag.MergeAttribute("href", pageUrl(i));
tag.InnerHtml = i.ToString();
if (i == pageInfo.PageNumber)
{
tag.AddCssClass("selected");
tag.AddCssClass("btn-primary");
}
tag.AddCssClass("btn btn-default");
result.Append(tag);
}
return(MvcHtmlString.Create(result.ToString()));
}
public AntdInfoModule()
{
Get["/info"] = x => {
var versionOs = Bash.Execute("uname -a");
var aosInfo = MachineInfo.GetAosrelease();
var uptime = MachineInfo.GetUptime();
var gentooRelease = File.ReadAllText("/etc/gentoo-release");
var lsbRelease = File.ReadAllText("/etc/lsb-release");
var osRelease = File.ReadAllText("/etc/os-release");
var model = new PageInfoModel {
VersionOs = versionOs,
AosInfo = aosInfo,
Uptime = uptime,
GentooRelease = gentooRelease,
LsbRelease = lsbRelease,
OsRelease = osRelease
};
return(JsonConvert.SerializeObject(model));
};
}
// GET: ScanRate
public ActionResult Index(PartDataModel model, int?PageIndex, int?PageSize = 30)
{
try
{
List <ResScnRateDto> listend = new List <ResScnRateDto>();
ViewBag.totalcount = 0;
ViewBag.Line = CommonHelp.list;
if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Line))
{
string key = Guid.NewGuid().ToString() + model.Line;
CommonHelp.key = key;
if (CommonBuffer.Exist(key))
{
CommonHelp.Listone <ResScnRateDto> .List = CommonBuffer.Get <List <ResScnRateDto> >(key);
ViewBag.count = CommonHelp.Listone <ResScnRateDto> .List.Count;
ViewBag.Data = CommonHelp.Listone <ResScnRateDto> .List.Take(30).ToList();
}
else
{
CommonHelp.Listone <ResScnRateDto> .List = CommonBuffer.FindT(key, DapperService.SqlHelp.ScanRate, model);
ViewBag.count = CommonHelp.Listone <ResScnRateDto> .List.Count;
ViewBag.Data = CommonHelp.Listone <ResScnRateDto> .List.Take(30).ToList();
}
}
if (PageIndex != null)
{
var model1 = new PageInfoModel <ResScnRateDto>();
model1.List = CommonHelp.Listone <ResScnRateDto> .List;
model1.PageSize = PageSize;
model1.PageIndex = PageIndex;
var res = CommonHelp.PageList(model1);
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
}
return(View());
}
public PageInfoModel GetPrincipals(int CurrentPage = 1, int PageSize = 3, string principalName = "")
{
var list = bll.GetPrincipals();
if (!string.IsNullOrEmpty(principalName))
{
list = list.Where(s => s.PrincipalName.Contains(principalName)).ToList();
}
//实例化分页类
var p = new PageInfoModel();
//总记录数
p.TotalCount = list.Count();
//计算总页数
if (p.TotalCount == 0)
{
p.TotalPage = 1;
}
else if (p.TotalCount % PageSize == 0)
{
p.TotalPage = p.TotalCount / PageSize;
}
else
{
p.TotalPage = (p.TotalCount / PageSize) + 1;
}
//纠正当前页不正确的值
if (CurrentPage < 1)
{
CurrentPage = 1;
}
if (CurrentPage > p.TotalPage)
{
CurrentPage = p.TotalPage;
}
p.PrincipalModels = list.Skip(PageSize * (CurrentPage - 1)).Take(PageSize).ToList();
p.CurrentPage = CurrentPage;
return(p);
}
public void GetKeywords_Keywords_CommaSeparatedKeywords()
{
// Arrange
const string keyword01 = "keyword01";
const string keyword02 = "keyword02";
const string keyword03 = "keyword03";
var pageInfoModel = new PageInfoModel("PageTitle");
pageInfoModel.AddKeyword(keyword01)
.AddKeyword(keyword02)
.AddKeyword(keyword03);
// Act
var keywords = pageInfoModel.GetKeywords().ToHtmlString();
// Assert
Assert.That(keywords, Is.Not.Null.Or.Empty);
Assert.IsTrue(keywords.Contains(keyword01));
Assert.IsTrue(keywords.Contains(keyword02));
Assert.IsTrue(keywords.Contains(keyword03));
Assert.IsTrue(keywords.Contains(","));
}
public ActionResult Query(PageInfoModel pgingModel, ACHDViewModel model)
{
string result = string.Empty;
IndexViewModel outputModel = new IndexViewModel();
try
{
List <ACHD> queryResult = new JavaScriptSerializer().Deserialize <List <ACHD> >(this.QueryACHD(pgingModel, model));
//outputModel
if (queryResult != null && queryResult.Count() > 0)
{
//this.QueryACBD
}
}
catch (Exception ex)
{
throw;
}
return(Json(new { data = result }, JsonRequestBehavior.AllowGet));
//return View("Index", outputModel);
}
public async Task <PagedEntityResult <TEntity> > PagedQuery(Expression <Func <TEntity, bool> > filter,
Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null,
PageInfoModel pageInfo = null,
params Expression <Func <TEntity, object> >[] includeProperties
)
{
var query = QueryDb(filter, orderBy, pageInfo, includeProperties);
int?skipCount = null;
if (pageInfo != null && pageInfo.PageNumber.HasValue && pageInfo.PageSize.HasValue)
{
skipCount = pageInfo.PageNumber * pageInfo.PageSize;
}
var pagedEntity = new PagedEntityResult <TEntity>(query.AsQueryable(),
new PageInfoModel
{
PageSize = pageInfo?.PageSize.GetValueOrDefault(),
PageNumber = pageInfo?.PageNumber.GetValueOrDefault(),
SortKey = pageInfo?.SortKey,
SortDir = pageInfo?.SortDir
});
if (skipCount.HasValue)
{
query = query.Skip(skipCount.Value);
}
if (pageInfo != null && pageInfo.PageSize.HasValue)
{
query = query.Take(pageInfo.PageSize.Value);
}
pagedEntity.Result = await query.AsNoTracking().ToListAsync();
return(pagedEntity);
}
public async Task <IActionResult> Get([FromQuery] PageInfoModel pageInfo)
{
var users = await _service.LoadAll(pageInfo);
return(users != null?Ok(_mapper.Map <UserResultViewModel>(users)) : EntitiesNotFound());
}
public static PageInfo MapToPageInfo(PageInfoModel input) =>
new PageInfo(
input.PageNumber,
input.RowsPerPage,
input.OrderBy);
//[ValidateAntiForgeryToken]
//public ActionResult Edit(EditViewModel model)
//{
// EditViewModel outputModel = new VoucherViewModel();
// //this.db = new GWEB_TESTEntities();
// //ACHD achd = new ACHD();
// //achd.ACID = model.ACID;
// //achd.CKAM = Convert.ToDecimal(model.CKAM);
// //achd.CKID = model.CKID;
// //achd.CKYM = model.CKYM;
// //achd.DATE = model.DATE;
// //achd.JSKD = model.JSKD;
// //achd.NIKD = model.NIKD;
// //achd.NOTE = model.NOTE;
// //achd.PSID = model.PSID;
// //achd.REM1 = model.REM1;
// //achd.REM2 = model.REM2;
// //achd.SBID = model.SBID;
// //achd.SQID = model.SQID;
// //achd.TPID = model.TPID;
// //achd.TPNM = model.TPNM;
// //achd.YYMM = model.YYMM;
// //db.ACHD.Add(achd);
// //db.SaveChanges();
// return View(outputModel);
//}
//Query ACHD >> using ACHD MODEL//
//[ValidateAntiForgeryToken]
//[NonAction]
public string QueryACHD(PageInfoModel pgingModel, ACHDViewModel model)
{
string result = string.Empty;
this.db = new GWEB_TESTEntities();
try
{
//PAGING//
//var queryResult = (from p in db.ACHD select p).OrderBy(x=>x.ACID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize);
//NO PAGING//
var queryResult = (from p in db.ACHD select p);
if (model.ACID != "" & model.ACID != null)
{
queryResult = queryResult.Where(x => x.ACID == model.ACID);
}
if (model.CKAM != "" & model.CKAM != null)
{
//decimal ckam = 0m;
//if (Decimal.TryParse(model.CKAM, out ckam))
//{
// queryResult = queryResult.Where(x => x.CKAM == ckam);
queryResult = queryResult.Where(x => x.CKAM == Convert.ToDecimal(model.CKAM));
//}
//else
//{
// //TODO:
// //NOTHING//
//}
}
if (model.CKID != "" & model.CKID != null)
{
queryResult = queryResult.Where(x => x.CKID == model.CKID);
}
if (model.CKYM != "" & model.CKYM != null)
{
queryResult = queryResult.Where(x => x.CKYM == model.CKYM);
}
if (model.DATE != "" & model.DATE != null)
{
DateTime date = CcDevConst.DATEINIVALUE;
if (DateTime.TryParse(model.DATE, out date))
{
queryResult = queryResult.Where(x => x.DATE == date);
}
else
{
//TODO:
//NOTHING//
}
}
if (model.JSKD != "" & model.JSKD != null)
{
queryResult = queryResult.Where(x => x.JSKD == model.JSKD);
}
if (model.NIKD != "" & model.NIKD != null)
{
queryResult = queryResult.Where(x => x.NIKD == model.NIKD);
}
if (model.NOTE != "" & model.NOTE != null)
{
queryResult = queryResult.Where(x => x.NOTE == model.NOTE);
}
if (model.PSID != "" & model.PSID != null)
{
queryResult = queryResult.Where(x => x.PSID == model.PSID);
}
if (model.REM1 != "" & model.REM1 != null)
{
queryResult = queryResult.Where(x => x.REM1 == model.REM1);
}
if (model.REM2 != "" & model.REM2 != null)
{
queryResult = queryResult.Where(x => x.REM2 == model.REM2);
}
if (model.SBID != "" & model.SBID != null)
{
queryResult = queryResult.Where(x => x.SBID == model.SBID);
}
if (model.SQID != "" & model.SQID != null)
{
queryResult = queryResult.Where(x => x.SQID == model.SQID);
}
if (model.TPID != "" & model.TPID != null)
{
queryResult = queryResult.Where(x => x.TPID == model.TPID);
}
if (model.TPNM != "" & model.TPNM != null)
{
queryResult = queryResult.Where(x => x.TPNM == model.TPNM);
}
if (model.YYMM != "" & model.YYMM != null)
{
queryResult = queryResult.Where(x => x.YYMM == model.YYMM);
}
result = new JavaScriptSerializer().Serialize(queryResult.OrderBy(x => x.TPID).OrderBy(x => x.SQID).ToList());
}
catch (Exception)
{
//TODO:
throw;
}
finally { db.Dispose(); }
return(result);
}
//[ValidateAntiForgeryToken]
public string QueryACBD(PageInfoModel pgingModel, ACBDViewModel model)
{
string result = string.Empty;
this.db = new GWEB_TESTEntities();
try
{
//PAGING//
//var queryResult = (from p in db.ACBD select p).OrderBy(x => x.ACID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize);
//NOPAGING//
var queryResult = (from p in db.ACBD select p);
if (model.ACID != "" & model.ACID != null)
{
queryResult = queryResult.Where(x => x.ACID == model.ACID);
}
if (model.TPID != "" & model.TPID != null)
{
queryResult = queryResult.Where(x => x.TPID == model.TPID);
}
if (model.SQID != "" & model.SQID != null)
{
queryResult = queryResult.Where(x => x.SQID == model.SQID);
}
if (model.SBID != "" & model.SBID != null)
{
queryResult = queryResult.Where(x => x.SBID == model.SBID);
}
if (model.DATE != "" & model.DATE != null)
{
queryResult = queryResult.Where(x => x.DATE == Convert.ToDateTime(model.DATE));
}
//queryResult = queryResult.Where(x => x.DATE == DateTime.ParseExact(model.DATE, "yyyyMMdd", null));
if (model.SQNO != "" & model.SQNO != null)
{
queryResult = queryResult.Where(x => x.SQNO == model.SQNO);
}
if (model.CAMT != null)
{
queryResult = queryResult.Where(x => x.CAMT == model.CAMT);
}
if (model.DAMT != null)
{
queryResult = queryResult.Where(x => x.DAMT == model.DAMT);
}
if (model.TPNM != "" & model.TPNM != null)
{
queryResult = queryResult.Where(x => x.TPNM == model.TPNM);
}
if (model.YYMM != "" & model.YYMM != null)
{
queryResult = queryResult.Where(x => x.YYMM == model.YYMM);
}
if (model.ITID != "" & model.ITID != null)
{
queryResult = queryResult.Where(x => x.ITID == model.ITID);
}
result = new JavaScriptSerializer().Serialize(queryResult.ToList());
}
catch (Exception)
{
//TODO:
throw;
}
finally { db.Dispose(); }
return(result);
}
