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();
}
