public ActionResult GetLogGridItems(GridSettings gridSettings) { var logGridItems = _logRepository.GetLogItems(gridSettings); var totalLogGridItems = _logRepository.CountLogItems(gridSettings); var pageIndex = gridSettings.PageIndex; var pageSize = gridSettings.PageSize; var jsonData = new { total = (totalLogGridItems / pageSize) + ((totalLogGridItems % pageSize > 0) ? 1 : 0), page = pageIndex, records = totalLogGridItems, rows = (from logItem in logGridItems select new Dictionary<string, string> { { "Id", logItem.Id.ToString() }, { "Created", logItem.Created.ToString() }, { "Level", logItem.Level }, { "Username", logItem.Username }, { "Message", logItem.Message} }).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public ActionResult ContactosPendientes(GridSettings grid, string abiertas, string cerradas, string fechadesde) { ASM.BD.Models.ContactosWEB wc = new ASM.BD.Models.ContactosWEB(); int pageIndex = 0, pageSize = 0, totalRecords = 0, totalPages = 0; var data = wc.GetContactos(grid, abiertas, cerradas, fechadesde, ref pageIndex, ref pageSize, ref totalRecords, ref totalPages); var result = new { total = totalPages, page = pageIndex, records = totalRecords, rows = (from contacto in data select new { contacto.id, contacto.codplaza, contacto.contacto, contacto.cp, contacto.direccion, contacto.email, contacto.empresa, contacto.estado, contacto.fecha, contacto.peticion, contacto.poblacion, contacto.telefono, contacto.texto, contacto.Plaza, contacto.NombreEstado }).ToArray() }; return Json(result, JsonRequestBehavior.AllowGet); }
/// <summary> /// To load the bulletin and return it as a JSON data /// </summary> /// <param name="gridSettings">The grid settings.</param> /// <param name="bulletinType">Type of the bulletin.e.g. STD or FAQ</param> /// <returns></returns> public ActionResult GridDataBulletin(GridSettings gridSettings, string bulletinType = DataConstants.StandardBulletinType) { var bulletinList = PatService.GetBulletins(gridSettings, bulletinType, CanEdit); var totalBulletin = PatService.CountBulletins(gridSettings, bulletinType, CanEdit); var jsonData = new { total = AppHelper.PagesInTotal(totalBulletin, gridSettings.PageSize), page = gridSettings.PageIndex, records = totalBulletin, rows = ( from e in bulletinList.AsEnumerable() select new { id = e.BulletinId, cell = new List <string> { AppHelper.FormatInteger(e.BulletinId), AppHelper.ShortDate(e.EndDate), BulletinViewLink(e) } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GridDataBasic(GridSettings gridSettings) { var totalCustomers = db.Albums.Count(); var albums = db.Albums.ToList(); var jsonData = new { total = totalCustomers / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalCustomers, rows = ( from c in albums select new { id = c.AlbumId, cell = new[] { c.AlbumId.ToString(), c.Title, c.Artist.Name, c.Genre.Name, c.Price.ToString(), c.AlbumArtUrl } }).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
/// <summary> /// to get Questionnaires data as JSON /// </summary> /// <param name="gridSettings">The grid settings.</param> /// <param name="id">The upload Id.</param> /// <returns></returns> public ActionResult QuestionnaireGetData(MvcJqGrid.GridSettings gridSettings, int id) { try { var data = PatService.GetReviewQuestionnaireData(gridSettings, id); var totalRecords = PatService.CountReviewQuestionnairesByUploadId(id); var jsonData = new { total = AppHelper.PagesInTotal(totalRecords, gridSettings.PageSize), page = gridSettings.PageIndex, records = totalRecords, rows = ( from e in data.AsEnumerable() select new { id = 1, cell = SetQuestionnaireColumns(e) } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Elmah.ErrorLog.GetDefault(null).Log(new Elmah.Error(ex)); throw; } }
public ActionResult GetReport(GridSettings gridSettings) { using (var db = new LogDbContext()) { // create json data int pageIndex = gridSettings.PageIndex; int pageSize = gridSettings.PageSize; int totalRecords = db.Logs.Count(); var totalPages = (int) Math.Ceiling(totalRecords/(float) pageSize); var startRow = (pageIndex - 1) * pageSize; var endRow = startRow + pageSize; if (String.IsNullOrEmpty(gridSettings.SortColumn)) { gridSettings.SortColumn = "Date"; } var jsonData = new { total = totalPages, page = pageIndex, records = totalRecords, rows = db.Logs.OrderByField(gridSettings.SortColumn, gridSettings.SortOrder == "asc").Skip(startRow).Take(gridSettings.PageSize).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); } }
public string GetData(GridSettings grid) { //var query = db.WorkCenter as IQueryable<WorkCenter>; var query = (from w in db.WorkCenter select new WorkCenterViewModel { Id = w.Id, WorkCenterCode = w.WorkCenterCode, WorkCenterName = w.WorkCenterName, CostCenter = w.CostCenter, WorkRate = w.WorkRate, FactoryCode = w.FactoryCode, FactoryName = w.Factory.FactoryName }) as IQueryable<WorkCenterViewModel>; if (grid.IsSearch == false)//如果是自定义查询 { string workCenterCode = Request.QueryString["workCenterCode"]; string workCenterName = Request.QueryString["workCenterName"]; string costCenter = Request.QueryString["costCenter"]; if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); } if (!string.IsNullOrEmpty(workCenterName)) { query = query.Where(w => w.WorkCenterName.Contains(workCenterName)); } if (!string.IsNullOrEmpty(costCenter)) { query = query.Where(w => w.CostCenter.Contains(costCenter)); } } return GridSearchHelper.GetJsonResult<WorkCenterViewModel>(grid, query); }
public string GetData(GridSettings grid) { var query = db.Factory as IQueryable<Factory>; if (grid.IsSearch == false)//如果是自定义查询 { string factoryName = Request.QueryString["factoryName"]; if (!string.IsNullOrEmpty(factoryName)) { query = query.Where(w => w.FactoryName.Contains(factoryName)); } } return GridSearchHelper.GetJsonResult<Factory>(grid, query); }
public string GetData(GridSettings grid) { var query = db.CostSumByProductVersion as IQueryable<CostSumByProductVersion>; if (grid.IsSearch == false)//如果是自定义查询 { string parentNum = Request.QueryString["pn"]; if (!string.IsNullOrEmpty(parentNum)) { query = query.Where(w => w.PNumber.Contains(parentNum)); } } return GridSearchHelper.GetJsonResult<CostSumByProductVersion>(grid, query); }
public string GetData(GridSettings grid) { var query = db.RawStock as IQueryable<RawStock>; if (grid.IsSearch == false)//如果是自定义查询 { string matnr = Request.QueryString["matnr"]; string matdb = Request.QueryString["matdb"]; if (!string.IsNullOrEmpty(matnr)) { query = query.Where(w => w.MatNR.Equals(matnr)); } if (!string.IsNullOrEmpty(matdb)) { query = query.Where(w => w.MatDB.Contains(matdb)); } } return GridSearchHelper.GetJsonResult<RawStock>(grid, query); }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.Labour as IQueryable<Labour>; //工艺所可以查看所有工厂的数据 if (User.IsInRole("Factory")) { query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name)); } List<Labour> data; if (grid.IsSearch == false)//如果是自定义查询 { string matnumber = Request.QueryString["matnumber"]; string workcentercode = Request.QueryString["workcentercode"]; if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); } if (!string.IsNullOrEmpty(workcentercode)) { query = query.Where(w => w.WorkCenterCode.Contains(workcentercode)); } } GridSearchHelper.ForExcel<Labour>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 图号 = p.MatNumber, 工作中心 = p.WorkCenterCode, 工作中心描述 = p.WorkCenter.WorkCenterName,//viewmodel传来 工时 = (decimal)p.LabourHour, 版本 = (int)p.Version, 备注 = p.Remark, 工厂 = p.FactoryCode }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "工时"); return View(); }
public string GetData(GridSettings grid) { var query = db.AssignFactory as IQueryable<AssignFactory>; if (grid.IsSearch == false)//如果是自定义查询 { string matnumber = Request.QueryString["matnumber"]; string factorycode = Request.QueryString["factorycode"]; if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); } if (!string.IsNullOrEmpty(factorycode)) { query = query.Where(w => w.FactoryCode.Contains(factorycode)); } } return GridSearchHelper.GetJsonResult<AssignFactory>(grid, query); }
public string GetData(GridSettings grid) { var query = db.BOM as IQueryable<BOM>; if (grid.IsSearch == false)//如果是自定义查询 { string a = Request.Form["pn"]; string parentNum = Request.QueryString["pn"]; string childNum = Request.QueryString["cn"]; if (!string.IsNullOrEmpty(parentNum)) { query = query.Where(w => w.PNumber.Contains(parentNum)); } if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); } } return GridSearchHelper.GetJsonResult<BOM>(grid, query); }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.RawStockQty as IQueryable<RawStockQty>; //工艺所可以查看所有工厂的数据 if (User.IsInRole("Factory")) { query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name)); } List<RawStockQty> data; if (grid.IsSearch == false)//如果是自定义查询 { string matnumber = Request.QueryString["matnumber"]; string matnr = Request.QueryString["matnr"]; if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); } if (!string.IsNullOrEmpty(matnr)) { query = query.Where(w => w.MatNR.Contains(matnr)); } } GridSearchHelper.ForExcel<RawStockQty>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 图号 = p.MatNumber, 材料代码 = p.MatNR, 材料描述 = p.RawStock.MatDB, 数量 = p.Qty, 单位 = p.Unit, 版本 = p.Version, 工厂 = p.FactoryCode }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "材料消耗"); return View(); }
public void GetLogItems_AddedOneLogItem_ContainsOneLogItem() { var logRepository = new LogRepository(Session); var logger = new NLogLogger(DefaultTestApplicationSettings); var gridSettings = new GridSettings { PageSize = 10, PageIndex = 0 }; const string message = "Test"; logger.Debug(message); var logItems = logRepository.GetLogItems(gridSettings); Assert.AreEqual(1, logItems.Count); Assert.AreEqual(message, logItems[0].Message); }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.WorkCenter as IQueryable<WorkCenter>; List<WorkCenter> data; if (grid.IsSearch == false)//如果是自定义查询 { string workCenterCode = Request.QueryString["workCenterCode1"]; string workCenterName = Request.QueryString["workCenterName1"]; string costCenter = Request.QueryString["costCenter"]; if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); } if (!string.IsNullOrEmpty(workCenterName)) { query = query.Where(w => w.WorkCenterName.Contains(workCenterName)); } if (!string.IsNullOrEmpty(costCenter)) { query = query.Where(w => w.CostCenter.Contains(costCenter)); } } GridSearchHelper.ForExcel<WorkCenter>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { 生产厂=p.FactoryCode, 生产厂描述=p.Factory.FactoryName, 工作中心=p.WorkCenterCode, 工作中心描述=p.WorkCenterName, 成本中心 =p.CostCenter, 工费率=p.WorkRate }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "工作中心"); return View(); }
public void CountLogItems_AddedTenLogItems_CollectionContainsTenLogItems() { var logRepository = new LogRepository(Session); var logger = new NLogLogger(DefaultTestApplicationSettings); var gridSettings = new GridSettings { PageSize = 20, PageIndex = 0 }; const int totalMessages = 10; for (var messageCounter = 0; messageCounter < totalMessages; messageCounter++) { logger.Debug("Test"); } var logItems = logRepository.GetLogItems(gridSettings); Assert.AreEqual(10, logItems.Count); }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.VersionManagement as IQueryable<VersionManagement>; List<VersionManagement> data; if (grid.IsSearch == false)//如果是自定义查询 { string parentNum = Request.QueryString["pn1"]; string childNum = Request.QueryString["cn1"]; //string parentNum = Request.QueryString["pn"]; //string childNum = Request.QueryString["cn"]; if (!string.IsNullOrEmpty(parentNum)) { query = query.Where(w => w.PNumber.Contains(parentNum)); } if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); } } GridSearchHelper.ForExcel<VersionManagement>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 产品版本 = p.ProductVersion, 产品图号 = p.PNumber, 子项图号 = p.CNumber, 工时版本 = p.LabourVersion, 材料版本 = p.RawStockVersion }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "版本"); return View(); }
public ActionResult TrackingContacto(GridSettings grid, Int64 id) { ASM.BD.Models.ContactosWEB wc = new ASM.BD.Models.ContactosWEB(); int pageIndex = 0, pageSize = 0, totalRecords = 0, totalPages = 0; var data = wc.GetTrackingContacto(grid, id, ref pageIndex, ref pageSize, ref totalRecords, ref totalPages); var result = new { total = totalPages, page = pageIndex, records = totalRecords, rows = (from tracking in data select tracking ).ToArray() }; return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult GridDataSample(GridSettings gridSettings) { if (HttpContext.Session != null) { var sessionKey = HttpContext.Session.SessionID; var sampleList = PatService.GetSample(sessionKey); var totRecords = sampleList.Count; var rowNumber = 0; var jsonData = new { total = 1, page = gridSettings.PageIndex, records = totRecords, rows = ( from s in sampleList.AsEnumerable() select new { id = s.Id, cell = new List <String> { AppHelper.FormatInteger(++rowNumber), AppHelper.FormatLong(s.ClaimId), AppHelper.FormatLong(s.JobseekerId), AppHelper.NullableDollarAmount(s.ClaimAmount), AppHelper.FlagOut(s.ManSpecialClaimFlag), AppHelper.FlagOut(s.AutoSpecialClaimFlag), s.StatusCodeDescription, #if DEBUG s.ClaimType, AppHelper.ShortDate(s.ClaimCreationDate), s.OrgCode, s.OrgDescription, s.EsaCode, s.SiteCode, s.SiteDescription #endif } }).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } return(Json(new { error = "No HttpContext" })); }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.RawStock as IQueryable<RawStock>; List<RawStock> data; if (grid.IsSearch == false)//如果是自定义查询 { string matnr = Request.QueryString["matnr1"]; string matdb = Request.QueryString["matdb1"]; if (!string.IsNullOrEmpty(matnr)) { query = query.Where(w => w.MatNR.Contains(matnr)); } if (!string.IsNullOrEmpty(matdb)) { query = query.Where(w => w.MatDB.Contains(matdb)); } } GridSearchHelper.ForExcel<RawStock>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { 物料代码 = p.MatNR, 物料描述 = p.MatDB, 计量单位 = p.BUn, 单价 = p.UnitPrice }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "原材料"); return View(); }
public string GetLabourDetail(GridSettings grid) { var query = db.DetailLabour as IQueryable<DetailLabour>; //从上一页面获得值 string productVersion = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["ProductVersion"]; string pNumber = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["PNumber"]; if (!string.IsNullOrEmpty(productVersion)) { query = query.Where(w => w.ProductVersion.Equals(productVersion)); } if (!string.IsNullOrEmpty(pNumber)) { query = query.Where(w => w.PNumber.Equals(pNumber)); } if (grid.IsSearch == false)//如果是自定义查询 { //获得本页的查询条件 string workCenterCode = Request.QueryString["pn"]; string childNum = Request.QueryString["cn"]; if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); } if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); } } return GridSearchHelper.GetJsonResult<DetailLabour>(grid, query);//string }
public ActionResult ExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.AssignFactory as IQueryable<AssignFactory>; List<AssignFactory> data; if (grid.IsSearch == false)//如果是自定义查询 { string matnumber = Request.QueryString["matnumber"]; string factorycode = Request.QueryString["factorycode"]; if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); } if (!string.IsNullOrEmpty(factorycode)) { query = query.Where(w => w.FactoryCode.Contains(factorycode)); } } GridSearchHelper.ForExcel<AssignFactory>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 图号 = p.MatNumber, 生产厂 = p.FactoryCode, 版本 = p.Version }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "分配工厂"); return View(); }
//待处理-导出excel public ActionResult ExportToExcel1() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.UnfinishedLabour as IQueryable<UnfinishedLabour>; //加入当前用户-只导出自己的数据 query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name)); List<UnfinishedLabour> data; GridSearchHelper.ForExcel<UnfinishedLabour>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 图号 = p.MatNumber, 版本 = p.Version, 工厂 = p.FactoryCode }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "待处理"); return View(); }
/// <summary> /// Get the list of Questions & Answers data of the Questionnaire (the header data) /// </summary> /// <param name="gridSettings">The grid settings.</param> /// <param name="id">The review id.</param> /// <returns></returns> public ActionResult QuestionAnswerGetData(MvcJqGrid.GridSettings gridSettings, int id) { try { var data = PatService.GetQuestionAnswers(gridSettings, id); var totalRecords = PatService.CountQuestionAnswersByReviewId(id); var jsonData = new { total = AppHelper.PagesInTotal(totalRecords, gridSettings.PageSize), page = gridSettings.PageIndex, records = totalRecords, rows = ( from e in data.AsEnumerable() select new { id = 1, cell = new List <string> { string.Format("{0}", e.QuestionId), string.Format("{0}", e.QuestionCode), // this tabindex to make the tag able to receive tab key string.Format("<a tabindex='0' class='wrap'>{0}</a>", e.QuestionText), string.Format("{0}", e.AnswerText) } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Elmah.ErrorLog.GetDefault(null).Log(new Elmah.Error(ex)); throw; } }
public IList<LogItem> GetLogItems(GridSettings gridSettings) { return LogItemsQueryBuilder().ToSqlQuery(gridSettings, _session) .AddScalar("Id", NHibernateUtil.Guid) .AddScalar("Created", NHibernateUtil.DateTime) .AddScalar("Level", NHibernateUtil.String) .AddScalar("Environment", NHibernateUtil.String) .AddScalar("Source", NHibernateUtil.String) .AddScalar("Message", NHibernateUtil.String) .AddScalar("Details", NHibernateUtil.String) .AddScalar("Username", NHibernateUtil.String) .AddScalar("RequestMethod", NHibernateUtil.String) .AddScalar("RequestUrl", NHibernateUtil.String) .AddScalar("UrlReferrer", NHibernateUtil.String) .AddScalar("ClientBrowser", NHibernateUtil.String) .AddScalar("IpAddress", NHibernateUtil.String) .AddScalar("PostedFormValues", NHibernateUtil.String) .AddScalar("Stacktrace", NHibernateUtil.String) .AddScalar("Exception", NHibernateUtil.String) .SetResultTransformer(Transformers.AliasToBean(typeof(LogItem))) .SetFirstResult((gridSettings.PageIndex - 1) * gridSettings.PageSize) .SetMaxResults(gridSettings.PageSize) .List<LogItem>(); }
public JsonResult searchListItem(string userName , GridSettings gridSettings) { DataItemSearchFilter filter = new DataItemSearchFilter(); filter.Email = userName; if (gridSettings.IsSearch) { filter.Title = gridSettings.Where.rules.Any(r => r.field == "Title") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "Title").data : string.Empty; filter.AuthorName = gridSettings.Where.rules.Any(r => r.field == "Author") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "Author").data : string.Empty; } int totalRecords = 0; var items = dataItemService.Search(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in items select new { ID = a.ID, Title = a.Title, SubMenuName = a.MainMenu.CodeName + " > " + a.SubCategory.CodeName, Country = a.Country.CodeName, InsertDate = a.CreatedDate, EditDate = a.LastUpdatedDate, Author = a.CreatedUser.FullName } ) }; JsonResult result = Json(jsonData); return result; }
public JsonResult SearchSubMenu(int mainCode, GridSettings gridSettings) { var mainMenu = _categoryService.GetCategory(mainCode); if(mainMenu == null) { return Json(new { records = 0 }); } var subMenus = mainMenu.SubCategories; var totalRecords = subMenus.Count(); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in subMenus select new { Code = a.Code, CodeName = a.CodeName, URL = a.URL, Memo = a.Memo } ) }; return Json(jsonData); }
public JsonResult SearchMainMenu(GridSettings gridSettings) { var mainMenus = _categoryService.GetMainMenus(); if(mainMenus == null) { mainMenus = new List<MainMenu>(); } int totalRecords = mainMenus.Count(); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in mainMenus select new { Code = a.Code, CodeName = a.CodeName, URL = a.URL, Memo = a.Memo } ) }; return Json(jsonData); }
public JsonResult SearchMember(GridSettings gridSettings) { MemberSearchFilter filter = new MemberSearchFilter(); if (gridSettings.IsSearch) { filter.Email = gridSettings.Where.rules.Any(r => r.field == "Email") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "Email").data : string.Empty; filter.UserName = gridSettings.Where.rules.Any(r => r.field == "FullName") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "FullName").data : string.Empty; } filter.Role = MemberRoles.Contributor; int totalRecords = 0; var applicationUsers = _memberService.searchMember(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in applicationUsers select new { Id = a.Id, FullName = a.FullName, Email = a.Email, PhoneNumber = a.PhoneNumber, Country = a.Country.CodeName } ) }; return Json(jsonData); }
public ActionResult LabourDetailExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.DetailLabour as IQueryable<DetailLabour>; List<DetailLabour> data; //从上一页面获得值 string productVersion = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["ProductVersion"]; string pNumber = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["PNumber"]; if (!string.IsNullOrEmpty(productVersion)) { query = query.Where(w => w.ProductVersion.Equals(productVersion)); } if (!string.IsNullOrEmpty(pNumber)) { query = query.Where(w => w.PNumber.Equals(pNumber)); } if (grid.IsSearch == false)//如果是自定义查询 { //获得本页的查询条件 string workCenterCode = Request.QueryString["pn"]; string childNum = Request.QueryString["cn"]; if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); } if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); } } GridSearchHelper.ForExcel<DetailLabour>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 产品版本 = p.ProductVersion, 产品图号 = p.PNumber, 零件图号 = p.CNumber, 工作中心 = p.WorkCenterCode, 工作中心描述 = p.WorkCenterName, 工时版本 = p.LabourVersion, 工时 = p.LabourHour, 配套数 = p.CQty, 总工时 = p.LabourTotal, 工时成本 = p.LabourCost, 备注 = p.Remark }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "工时明细"); return View(); }
public ActionResult ReclamacionesPendientes(GridSettings grid, string abiertas, string cerradas, string fechadesde) { ASM.BD.Models.Calidad c = new ASM.BD.Models.Calidad(); int pageIndex=0, pageSize=0, totalRecords=0, totalPages=0; var data = c.GetReclamaciones(grid, abiertas, cerradas, fechadesde, ref pageIndex, ref pageSize, ref totalRecords, ref totalPages); var result = new { total = totalPages, page = pageIndex, records = totalRecords, rows = (from reclamacion in data select new { Id = reclamacion.id, CodPlazaReclama = reclamacion.codplazaReclama, CodPlazaReclamada = reclamacion.codplazaReclamada, CodPlazaPenalizada = reclamacion.codplazaPenalizada, CodPlazaIndemnizada = reclamacion.codplazaIndemnizada, CodExp = reclamacion.codexp, CodRecogida = reclamacion.codrecogida, FechaInicio = reclamacion.fechaInicio, PlazaReclama = reclamacion.PlazaReclama, PlazaReclamada = reclamacion.PlazaReclamada, ImportePenalizacion = reclamacion.importePenalizacion, ImporteIndemnizacion = reclamacion.importeIndemnizacion, Estado = reclamacion.Estado, }).ToArray() }; return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetData(GridSettings gridSettings, string jobno, string lotno, string datefrom, string dateto, int minus, string wcCure, string wcPart, string itemPart, string itemFG, int status) { var data = (from c in qim.tr_curing_nics join m in qim.tr_metal_job_nics on c.job_order_no equals m.job_order_no into j from m in j.DefaultIfEmpty() where c.record_status == "A" select new { job_order_no = c.job_order_no.Trim(), lotno = c.tnc_total_tag_no.Trim() + "-" + c.tnc_tag_no.Trim(), c.curing_date, line_no_cure = c.line_no.Trim(), line_no_part = m.line_no.Trim(), parts = m.parts.Trim(), finished_goods_code = m.finished_goods_code.Trim(), m.issue_qty, m.parts_job_order_no }).OrderBy(gridSettings.SortColumn + " " + gridSettings.SortOrder); // Filter Condition if (!string.IsNullOrEmpty(jobno)) { var partJobNo = jobno.Trim().Split('-')[0]; data = data.Where(w => w.job_order_no != null && w.job_order_no.Contains(partJobNo)); } if (!string.IsNullOrEmpty(lotno)) { data = data.Where(w => w.lotno.Contains(lotno.Trim())); } if (!string.IsNullOrEmpty(datefrom)) { var dfrom = util.convDateStrToInt(datefrom); data = data.Where(w => w.curing_date >= dfrom); } if (!string.IsNullOrEmpty(dateto)) { var dto = util.convDateStrToInt(dateto); data = data.Where(w => w.curing_date <= dto); } if (!string.IsNullOrEmpty(wcCure)) { data = data.Where(w => w.line_no_cure.Contains(wcCure.Trim())); } if (!string.IsNullOrEmpty(wcPart)) { data = data.Where(w => w.line_no_part.Contains(wcPart.Trim())); } if (!string.IsNullOrEmpty(itemPart)) { data = data.Where(w => w.parts.Contains(itemPart.Trim())); } if (!string.IsNullOrEmpty(itemFG)) { data = data.Where(w => w.finished_goods_code.Contains(itemFG.Trim())); } // Select Data Per Page var today = util.convDateStrToInt(DateTime.Today.Day.ToString("00") + "/" + DateTime.Today.Month.ToString("00") + "/" + DateTime.Today.Year.ToString()); //var loadingStatus = (from d in db.td_part_delivery.Where(w => w.loading_status.Trim() == "1").Select(s => new { part_job_order_no = s.part_job_order_no.Trim(), s.qty }) // group d by new { d.part_job_order_no, d.qty } into g // select new // { // part_job_order_no = g.Key.part_job_order_no, // qty = g.Key.qty // }).ToList(); var dataTmp = from d in data.ToList() //join s in loadingStatus //on d.parts_job_order_no equals s.part_job_order_no into j //from s in j.DefaultIfEmpty() select new { d.job_order_no, d.lotno, d.line_no_cure, d.parts, d.finished_goods_code, d.issue_qty, curing_date = d.curing_date != null ? util.convDateIntToStr(d.curing_date) : "", //loading = s != null ? s.part_job_order_no : "", //qty = s != null ? s.qty : 0, //status = s != null ? //("<a href='#' class='lnkJob_Complete' data-jobNo='" + (d.parts_job_order_no != null ? d.parts_job_order_no.Trim() : d.parts_job_order_no) + "'><b>Details</b></a>") : //(d.curing_date != null && d.curing_date <= (today + minus)) ? //("<a href='#' class='lnkJob_PassDue' data-jobNo='" + (d.parts_job_order_no != null ? d.parts_job_order_no.Trim() : d.parts_job_order_no) + "'><b>Details</b></a>") : //("<a href='#' class='lnkJob_Normal' data-jobNo='" + (d.parts_job_order_no != null ? d.parts_job_order_no.Trim() : d.parts_job_order_no) + "'><b>Details</b></a>") //status = "<a href='#' class='lnkJob_Normal' data-jobNo='" + (d.parts_job_order_no ?? "") + "'><b>Details</b></a>" status = (d.curing_date != null && d.curing_date <= (today + minus)) ? ("<a href='#' class='lnkJob_PassDue' data-jobNo='" + (d.parts_job_order_no != null ? d.parts_job_order_no.Trim() : d.parts_job_order_no) + "'><b>Details</b></a>") : ("<a href='#' class='lnkJob_Normal' data-jobNo='" + (d.parts_job_order_no != null ? d.parts_job_order_no.Trim() : d.parts_job_order_no) + "'><b>Normal</b></a>") }; if (status == 1) { dataTmp = dataTmp.Where(w => w.status.Contains("lnkJob_Normal")); } else if (status == 2) { dataTmp = dataTmp.Where(w => w.status.Contains("lnkJob_PassDue")); } else if (status == 3) { dataTmp = dataTmp.Where(w => w.status.Contains("lnkJob_Complete")); } // Count All Record double count = dataTmp.Count(); var selectData = dataTmp.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize) .Select(d => new { id = d.job_order_no, cell = new object[] { d.line_no_cure, d.finished_goods_code, d.job_order_no, d.lotno, d.issue_qty, d.parts, d.curing_date, d.status } }); //// Sum Record //var allQTYSum = dataTmp.Where(w => w.issue_qty != null).Sum(s => s.issue_qty); //var compQTYSum = double.Parse(dataTmp.Where(w => w.loading != null).Sum(s => s.qty).ToString()); //// Completed Percent //var completedPercent = allQTYSum > 0 ? string.Format("{0:0.00}", (compQTYSum / allQTYSum) * 100) : "0.00"; //var allQTYSumStr = string.Format("{0:n0}", allQTYSum); //var compQTYSumStr = string.Format("{0:n0}", compQTYSum); // Prepare JSON Format object jsonData = new { page = gridSettings.PageIndex, total = Math.Ceiling(count / gridSettings.PageSize), records = count, //all = allQTYSumStr, //comp = compQTYSumStr, //completedPercent = completedPercent, rows = selectData }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public ActionResult RawStockDetailExportToExcel() { GridSettings grid = new GridSettings(); grid.SortColumn = "Id"; grid.SortOrder = "asc"; if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false") { grid.IsSearch = false; } else { grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]); } string fil = Request.QueryString["myFilters"]; grid.Where = MvcJqGrid.Filter.Create(fil, "", "", ""); var query = db.DetailRawStock as IQueryable<DetailRawStock>; List<DetailRawStock> data; //从上一页面获得值 string productVersion = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["ProductVersion"]; string pNumber = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["PNumber"]; if (!string.IsNullOrEmpty(productVersion)) { query = query.Where(w => w.ProductVersion.Equals(productVersion)); } if (!string.IsNullOrEmpty(pNumber)) { query = query.Where(w => w.PNumber.Equals(pNumber)); } if (grid.IsSearch == false)//如果是自定义查询 { //获得本页的查询条件 string MatNR = Request.QueryString["pn"]; string childNum = Request.QueryString["cn"]; if (!string.IsNullOrEmpty(MatNR)) { query = query.Where(w => w.MatNR.Contains(MatNR)); } if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); } } GridSearchHelper.ForExcel<DetailRawStock>(grid, query, out data); var returnData = data; var myGrid = new System.Web.UI.WebControls.GridView(); myGrid.DataSource = from p in returnData select new { Id = p.Id, 产品版本 = p.ProductVersion, 产品图号 = p.PNumber, 零件图号 = p.CNumber, 材料代码 = p.MatNR, 材料描述 = p.MatDB, 材料版本 = p.RawStockVersion, 数量=p.Qty, 配套数 = p.CQty, 总用量 = p.RawStockTotal, 材料成本 = p.RawStockCost, 单位 = p.Unit }; myGrid.DataBind(); ImportExportData.ExportToExcel(myGrid, "材料明细"); return View(); }