public ActionResult Search(GetZjCheckGPSByArea model)
{
DhtmlxGrid grid = new DhtmlxGrid();
if (model.Area.IsNullOrEmpty())
{
model.Area = "南宁市";
}
var client = new JsonServiceClient(GetSceneDataUrl);
var response = client.Get(model);
int index = 1;
if (response.IsSucc)
{
foreach (var item in response.gpsPileInfo)
{
DhtmlxGridRow row = new DhtmlxGridRow(index + "," + item.GpsLongitude + "," + item.GpsLatitude);
row.AddCell(index);
row.AddCell(item.projectname);
row.AddCell(item.SerialNo);
row.AddCell(item.PileNo);
row.AddCell(item.areaname);
grid.AddGridRow(row);
index++;
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
private static string GetGridXmlString(List <SysDict> sysDicts)
{
DhtmlxGrid grid = new DhtmlxGrid();
foreach (var item in sysDicts.Where(p => p.CategoryId < 0))
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id);
row.AddCell(item.Name);
row.AddCell(item.KeyValue);
row.AddCell("");
row.AddCell(item.Status);
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
foreach (var subItem in sysDicts.Where(p => p.CategoryId == item.Id))
{
DhtmlxGridRow subRow = new DhtmlxGridRow(subItem.Id.ToString());
subRow.AddCell(subItem.Name);
subRow.AddCell(subItem.KeyValue);
subRow.AddCell(subItem.OrderNo);
subRow.AddCell(subItem.Status);
subRow.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
subRow.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
row.AddRow(subRow);
}
grid.AddGridRow(row);
}
return(grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting));
}
public ActionResult Search()
{
DhtmlxGrid grid = new DhtmlxGrid();
Dictionary <int, string> dicts = new Dictionary <int, string>();
dicts.Add(1, "机构名称缓存");
dicts.Add(2, "检测项目名称缓存");
dicts.Add(3, "模块缓存");
dicts.Add(4, "按钮缓存");
dicts.Add(5, "角色缓存");
dicts.Add(6, "用户地区缓存");
dicts.Add(7, "字典缓存");
dicts.Add(8, "地区缓存");
//dicts.Add(9, "修改列缓存");
dicts.Add(9, "监督编号缓存");
dicts.Add(10, "二维码缓存");
foreach (var item in dicts)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Key.ToString());
row.AddCell(item.Key.ToString());
row.AddCell(item.Value);
row.AddLinkJsCell("清除缓存", " ClearCache({0})".Fmt(item.Key));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(PileUpdataInfo model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
var client = new JsonServiceClient(GetSceneDataUrl);
var response = client.Get(model);
DhtmlxGrid grid = new DhtmlxGrid();
if (response.IsSucc)
{
int totalCount = (int)response.totalCount;
grid.AddPaging(totalCount, pos);
int index = pos;
foreach (var item in response.datas)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.id);
row.AddCell(++index);
row.AddCell(item.customname);
row.AddCell(item.basicinfoid);
row.AddCell(item.utype);
row.AddCell(item.ordervalue);
row.AddCell(item.newvalue);
row.AddCell(item.addtime.HasValue ? item.addtime.Value.ToString("yyyy-MM-dd'T'HH:mm:ss") : string.Empty);
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult GetProgrammeReports(string checknum, string projectnum)
{
DhtmlxGrid grid = new DhtmlxGrid();
GetProgrammeReports request = new GetProgrammeReports()
{
checknum = checknum,
projectnum = projectnum
};
var client = new JsonServiceClient(GetSceneDataUrl);
var response = client.Get(request);
var index = 1;
if (response.IsSucc)
{
foreach (var item in response.reports)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id);
row.AddCell(index++);
row.AddCell(item.checknum);
row.AddCell(item.reportnum);
row.AddLinkJsCell("查看", "Details(\"{0}\",\"{1}\")".Fmt(item.customid, item.reportnum));
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult GridSearch(CheckStatisDataGridSearchModel model)
{
var response = GetGridSerarchResponse(model);
DhtmlxGrid grid = new DhtmlxGrid();
var allInsts = checkUnitService.GetAllCheckUnit();
var allItems = itemNameService.GetAllItemName();
var pos = model.posStart.HasValue ? model.posStart.Value : 0;
int index = pos + 1;
if (response.IsValid)
{
var totalCount = (int)response.Total;
grid.AddPaging(totalCount, pos);
foreach (var item in response.Documents)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell(index++);
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allInsts, item.CUSTOMID));
row.AddCell(item.PROJECTNAME);
row.AddCell(itemNameService.GetItemCNNameFromAll(allItems, item.REPORTJXLB, item.ITEMNAME));
row.AddCell(GetUIDtString(item.CHECKDATE));
row.AddCell(GetUIDtString(item.PRINTDATE));
row.AddLinkJsCell(item.REPORTNUM, "getPKRReport(\"{0}\")".Fmt(item.REPORTNUM));
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text /xml"));
}
public ActionResult DetailsReport(string checknum, string projectnum)
{
GetReports model = new GetReports()
{
checknum = checknum,
projectnum = projectnum,
};
var client = new JsonServiceClient(GetSceneDataUrl);
var data = client.Get(model);
DhtmlxGrid grid = new DhtmlxGrid();
int index = 1;
foreach (var item in data.Reports)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id.ToString());
row.AddCell(index++);
row.AddCell(item.checknum);
row.AddCell(item.reportnum);
row.AddLinkJsCell("查看", "Details(\"{0}\",\"{1}\")".Fmt(item.customid, item.reportnum));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult SearchGjcq(int gjId)
{
var gjcqDatas = gjcqRep.GetByCondition(w => w.gjid == gjId);
DhtmlxGrid grid = new DhtmlxGrid();
if (gjcqDatas.Count > 0)
{
int index = 0;
foreach (var item in gjcqDatas)
{
DhtmlxGridRow row = new DhtmlxGridRow(Guid.NewGuid().ToString());
row.AddCell((++index).ToString());
row.AddCell(item.cqno);
row.AddLinkJsCell("详情", "gjcqView(\"{0}\",\"{1}\")".Fmt(item.gjid, item.id));
grid.AddGridRow(row);
}
grid.Header = new DhtmlxGridHeader();
grid.Header.AddColumn(new DhtmlxGridColumn("测区")
{
ColumnType = "ro", Width = "*", ColumnSort = "str"
});
grid.Header.AddColumn(new DhtmlxGridColumn("")
{
ColumnType = "jslink", Width = "150", ColumnSort = "str"
});
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(ZJCheckSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
GetZJCheckList searchdata = new GetZJCheckList()
{
CheckUnitName = model.CheckUnitName,
CheckEquip = model.CheckEquip,
CheckPeople = model.CheckPeople,
Area = model.Area,
Report = model.Report,
ZX = model.ZX,
posStart = model.posStart,
count = model.count,
ProjectName = model.ProjectName,
StartDate = model.StartDate,
EndDate = model.EndDate
};
var response = zJCheckService.GetZJCheck(searchdata);
int totalCount = (int)response.totalCount;
DhtmlxGrid grid = new DhtmlxGrid();
grid.AddPaging(totalCount, pos);
int index = pos;
foreach (var item in response.datas)
{
var strpeople = string.Empty;
if (!item.testingpeople.IsNullOrEmpty())
{
var names = JsonConvert.DeserializeObject <List <LiftingEquipmentPeopleModel> >(item.testingpeople);
List <string> testingPeople = new List <string>();
foreach (var name in names)
{
testingPeople.Add(name.name);
}
strpeople = testingPeople.Join(",");
}
DhtmlxGridRow row = new DhtmlxGridRow(item.Id);
row.AddCell(++index);
row.AddCell(item.customname);
row.AddCell(item.projectname);
row.AddCell(item.areainfo);
row.AddCell((int)item.pilenum);
row.AddCell(strpeople);
row.AddCell(string.Empty);
row.AddCell(item.testingequipment);
row.AddCell(item.checknum);
row.AddCell(item.reportcount);
row.AddCell(item.filepath.IsNullOrEmpty() ? "否" : "是");
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(STCheckEquipModels model)
{
var data = GetSearchResult(model);
DhtmlxGrid grid = new DhtmlxGrid();
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
grid.AddPaging(data.TotalCount, pos);
var buttons = GetCurrentUserPathActions();
var allSTUnit = GetCurrentInstsST();
var compayTypes = sysDictServcie.GetDictsByKey("customStatus");
for (int i = 0; i < data.Results.Count; i++)
{
var equip = data.Results[i];
var start = equip.timestart.HasValue? GetUIDtString(equip.timestart.Value, "yyyy-MM-dd"):"";
var end = equip.timeend.HasValue? GetUIDtString(equip.timeend.Value, "yyyy-MM-dd"): "";
DhtmlxGridRow row = new DhtmlxGridRow(equip.id.ToString());
row.AddCell("");
row.AddCell(pos + i + 1);
row.AddCell(equip.EquName + equip.Equtype + equip.Equspec);
row.AddCell(sTCustomService.GetSTUnitByIdFromAll(allSTUnit, equip.customid));
if (start != "" && end != "")
{
row.AddCell(start + "至" + end);
}
else
{
row.AddCell(string.Empty);
}
row.AddCell(SysDictUtility.GetKeyFromDic(compayTypes, equip.approvalstatus));
Dictionary <string, string> dict = new Dictionary <string, string>();
if (HaveButtonFromAll(buttons, "ApplyChange") && sTCheckEquipService.CanApplyChangeCustom(equip.approvalstatus))
{
dict.Add("[申请修改]", "applyChange({0},\"{1}\")".Fmt(equip.id, equip.EquName));
}
if (HaveButtonFromAll(buttons, "ConfirmApplyChange") && (equip.approvalstatus == "5"))
{
dict.Add("[审核申请修改]", "confirmApplyChange({0},\"{1}\")".Fmt(equip.id, equip.EquName));
}
row.AddLinkJsCells(dict);
if (HaveButtonFromAll(buttons, "Edit") && (equip.approvalstatus == "0" || equip.approvalstatus == "5"))// && checkUnitService.CanEditCustom(custom.APPROVALSTATUS))
{
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
}
else
{
row.AddCell(string.Empty);
}
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult StatisGrid(SysSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
model.GroupType = "Item";
var response = GetStatisData(model);
DhtmlxGrid grid = new DhtmlxGrid();
if (response.IsValid)
{
int index = pos;
var bucks = response.Aggs.Terms(aggeKey).Buckets;
var allItems = itemNameService.GetAllItemName();
int totalCount = bucks.Count;
grid.AddPaging(totalCount, pos);
string CustomId = InstUserCustomId();
string itemValue = string.Empty;
foreach (var item in bucks)
{
string itemKey = item.Key;
switch (aggeKey)
{
case "ItemNum":
var itemKeys = item.Key.Split('|');
var jxlb = itemKeys[0];
var itemCode = itemKeys[1];
itemValue = itemNameService.GetItemCNNameFromAll(allItems, jxlb, itemCode);
break;
case "Custom":
itemValue = checkUnitService.GetCheckUnitById(item.Key);
break;
case "Project":
itemValue = item.Key;
//item.Key= HttpUtility.UrlEncode(item.Key);
break;
}
DhtmlxGridRow row = new DhtmlxGridRow(item.Key);
row.AddCell((index + 1).ToString());
row.AddCell(itemValue);
row.AddCell((item.DocCount.HasValue ? item.DocCount.Value : 0).ToString());
row.AddLinkJsCell("材料动态分析表查看", "showUnquailfyAnalysis(\"{0}\",\"{1}\")".Fmt(itemKey, itemValue));
grid.AddGridRow(row);
index++;
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult GetPileDataList(string checknum, string customid)
{
DhtmlxGrid grid = new DhtmlxGrid();
var client = new JsonServiceClient(GetSceneDataUrl);
var response = client.Get(new TestSiteDetails()
{
CheckNum = checknum,
CustomId = customid,
IsTesting = 0
});
if (response.IsSucc)
{
foreach (var item in response.datas)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id);
row.AddCell(item.projectname);
row.AddCell(item.TestType);
row.AddCell(item.PileNo);
row.AddCell(GetUIDtString(item.StartTime));
row.AddCell(GetUIDtString(item.CreateTime));
row.AddCell(string.Empty);
row.AddCell(item.MachineId);
row.AddCell(item.GpsIsValid == 1 ? new DhtmlxGridCell("已定位", false).AddCellAttribute("style", "color:green") : new DhtmlxGridCell("未定位", false).AddCellAttribute("style", "color:red"));
row.AddCell(string.Empty);//修改记录找不到字段和判断方法，先设置为空
if (item.nn > 0)
{
if (item.nn >= 6)
{
row.AddCell(new DhtmlxGridCell("有照片", false).AddCellAttribute("style", "color:green"));
}
else
{
row.AddCell(new DhtmlxGridCell("不完整({0})".Fmt(item.nn), false).AddCellAttribute("style", "color:red"));
}
}
else
{
row.AddCell(new DhtmlxGridCell("无照片", false).AddCellAttribute("style", "color:red"));
}
row.AddLinkJsCell("查看", "detailsUpload(\"{0}\",\"{1}\",\"{2}\")".Fmt(item.Id, item.checknum, item.PileNo));
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(SysSearchModel model)
{
ISearchResponse <es_t_bp_item> response = GetSearchResult(model);
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int totalCount = (int)response.Total;
DhtmlxGrid grid = new DhtmlxGrid();
grid.AddPaging(totalCount, pos);
int index = pos;
var allItems = itemNameService.GetAllItemName();
var allInsts = checkUnitService.GetAllCheckUnit();
var reportConclusions = sysDictService.GetDictsByKey("ReportConclusionCode");
foreach (var item in response.Documents)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell(index + 1);
if (item.CONCLUSIONCODE == "Y")
{
row.AddCell(item.PROJECTNAME);
}
else
{
row.AddCell(new DhtmlxGridCell("{0}".Fmt(item.PROJECTNAME), false).AddCellAttribute("style", "color:red"));
//row.AddCell(item.PROJECTNAME);
}
row.AddCell(SysDictUtility.GetKeyFromDic(reportConclusions, item.CONCLUSIONCODE, "/"));
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allInsts, item.CUSTOMID));
if (item.ITEMCHNAME.IsNullOrEmpty())
{
row.AddCell(itemNameService.GetItemCNNameFromAll(allItems, item.REPORTJXLB, item.ITEMNAME));
}
else
{
row.AddCell(item.ITEMCHNAME);
}
row.AddLinkJsCell(item.REPORTNUM, "detailsReport(\"{0}\")".Fmt(item.SYSPRIMARYKEY));
row.AddCell(item.SAMPLENUM);
row.AddCell(item.ENTRUSTDATE.HasValue ? item.ENTRUSTDATE.Value.ToString("yyyy-MM-dd") : "/");
row.AddCell(item.CHECKDATE.HasValue ? item.CHECKDATE.Value.ToString("yyyy-MM-dd") : "/");
row.AddCell(reportService.GetReportDataStatus(item.SAMPLEDISPOSEPHASEORIGIN));
index++;
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(STCheckPeopleSearchModel model)
{
var data = GetSearchResult(model);
DhtmlxGrid grid = new DhtmlxGrid();
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
grid.AddPaging(data.TotalCount, pos);
var buttons = GetCurrentUserPathActions();
var allSTUnit = GetCurrentInstsST();
var compayTypes = sysDictServcie.GetDictsByKey("customStatus");
for (int i = 0; i < data.Results.Count; i++)
{
var people = data.Results[i];
DhtmlxGridRow row = new DhtmlxGridRow(people.Id.ToString());
row.AddCell("");
row.AddCell(pos + i + 1);
row.AddCell(people.Name);
row.AddCell(sTCustomService.GetSTUnitByIdFromAll(allSTUnit, people.Customid));
row.AddCell(people.SelfNum);
row.AddCell(people.PostNum);
row.AddCell(people.Tel);
row.AddCell(SysDictUtility.GetKeyFromDic(compayTypes, people.Approvalstatus));
Dictionary <string, string> dict = new Dictionary <string, string>();
if (HaveButtonFromAll(buttons, "ApplyChange") && sTCheckPeopleService.CanApplyChangeCustom(people.Approvalstatus))
{
dict.Add("[申请修改]", "applyChange({0},\"{1}\")".Fmt(people.Id, people.Name));
}
if (HaveButtonFromAll(buttons, "ConfirmApplyChange") && (people.Approvalstatus == "5"))
{
dict.Add("[审核申请修改]", "confirmApplyChange({0},\"{1}\")".Fmt(people.Id, people.Name));
}
row.AddLinkJsCells(dict);
if (HaveButtonFromAll(buttons, "Edit") && (people.Approvalstatus == "0" || people.Approvalstatus == "6"))// && checkUnitService.CanEditCustom(custom.APPROVALSTATUS))
{
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
}
else
{
row.AddCell(string.Empty);
}
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(DetailQualifyFiveSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int count = model.count.HasValue ? model.count.Value : 30;
PagingOptions <t_D_UserTableFive> pagingOption = new PagingOptions <t_D_UserTableFive>(pos, count, t => new { t.id });
DhtmlxGrid grid = new DhtmlxGrid();
var userTableFive = repFive.GetByConditonPage(r => r.pid == model.pid, pagingOption);
grid.AddPaging(pagingOption.TotalItems, pos);
int index = pos + 1;
foreach (var item in userTableFive)
{
var zczshpath = string.Empty;
var sgzshpath = string.Empty;
var zcpath = string.Empty;
var xlpath = string.Empty;
var data = JsonConvert.DeserializeObject <DetailQualifyFiveSearchViewModel>(item.gzjl);
DhtmlxGridRow row = new DhtmlxGridRow(item.id);
row.AddCell(index);
row.AddCell(data.jclb);
row.AddCell(data.jclr);
row.AddCell(data.name);
row.AddCell(data.zgzsh);
row.AddCell(data.sgzsh);
row.AddCell(data.zcdwmc);
row.AddCell(data.zc);
row.AddCell(data.zy);
row.AddCell(data.xl);
row.AddCell(data.jcnx);
row.AddCell(data.detectnumstartdate + "至" + data.detectnumenddate);
row.AddCell(data.bz);
row.AddLinkJsCell("注册证书附件查看", "uploadFile(\"{0}\")".Fmt(data.zgzshpath + "+" + "注册证书附件"));
row.AddLinkJsCell("上岗证书附件查看", "uploadFile(\"{0}\")".Fmt(data.sgzshpath + "+" + "上岗证书附件"));
row.AddLinkJsCell("职称附件查看", "uploadFile(\"{0}\")".Fmt(data.zcpath + "+" + "职称附件"));
row.AddLinkJsCell("学历附件查看", "uploadFile(\"{0}\")".Fmt(data.xlpath + "+" + "学历附件"));
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
index++;
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult CreateQualifySixSearch(DetailQualifyFiveSearchModel model)
{
var instDicts = checkUnitService.GetAllCheckUnit();
var workStatus = sysDictServcie.GetDictsByKey("workStatus");
var personnelTitles = sysDictServcie.GetDictsByKey("personnelTitles");
var personnelStatus = sysDictServcie.GetDictsByKey("personnelStatus");
var unitcode = repOne.GetById(model.pid);
var peoples = peopleRep.GetByCondition(r => r.Customid == unitcode.unitCode && r.Approvalstatus == "3");
//var peoples = peopleRep.GetByCondition(r => r.Customid == "1900021");
DhtmlxGrid grid = new DhtmlxGrid();
string customname = string.Empty;
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int index = pos;
foreach (var item in peoples)
{
customname = checkUnitService.GetCheckUnitByIdFromAll(instDicts, item.Customid);
DhtmlxGridRow row = new DhtmlxGridRow(item.id.ToString());
//勾选,序号,姓名,性别,年龄,学历,专业,身份证号,从事检测工作类别,从事检测工作年限,社会保险证号,岗位证书编号,职务,职称,在职状况,状态
row.AddCell("");
row.AddCell((++index).ToString());
row.AddCell(item.Name);
row.AddCell(item.Sex);
row.AddCell(item.age);
row.AddCell(item.Education);
row.AddCell(item.Professional);
//row.AddCell(customname);
row.AddCell(item.SelfNum);
row.AddCell(string.Empty);
row.AddCell(item.gznx);
row.AddCell(item.SBNum);
row.AddCell(item.PostNum);
row.AddCell(item.zw);
row.AddCell(SysDictUtility.GetKeyFromDic(personnelTitles, item.Title));
row.AddCell(SysDictUtility.GetKeyFromDic(workStatus, item.iscb));
row.AddCell(SysDictUtility.GetKeyFromDic(personnelStatus, item.Approvalstatus));
row.AddCell(item.educationpath);
row.AddCell(item.titlepath);
row.AddCell(item.selfnumPath);
row.AddCell(item.PostPath);
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(SysSoftwareVersSearchModel model)
{
var data = GetSearchResult(model);
DhtmlxGrid grid = new DhtmlxGrid();
var buttons = GetCurrentUserPathActions();
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
grid.AddPaging(data.TotalCount, pos);
for (int i = 0; i < data.Results.Count; i++)
{
var softwareVers = data.Results[i];
DhtmlxGridRow row = new DhtmlxGridRow(softwareVers.id.ToString());
row.AddCell(pos + i + 1);
row.AddCell(softwareVers.usercode);
row.AddCell(softwareVers.name);
row.AddCell(softwareVers.FileVersion);
row.AddCell(softwareVers.FileVersionDate);
row.AddCell(softwareVers.EndDate);
///暂时未找到数据来源
row.AddCell(string.Empty);
row.AddCell(string.Empty);
row.AddCell(string.Empty);
if (HaveButtonFromAll(buttons, "Edit"))
{
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
}
else
{
row.AddCell(string.Empty);
}
//if (HaveButtonFromAll(buttons, "Delete"))
//{
// row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
//}
//else
//{
// row.AddCell(string.Empty);
//}
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(SysLogViewModels searchModel)
{
var predicate = PredicateBuilder.True <SysLog>();
if (!string.IsNullOrWhiteSpace(searchModel.LogUserName))
{
predicate = predicate.And(p => p.UerName.Contains(searchModel.LogUserName));
}
if (!string.IsNullOrWhiteSpace(searchModel.LogType))
{
predicate = predicate.And(p => p.LogEvent.Contains(searchModel.LogType));
}
if (searchModel.LogStartDt.HasValue)
{
predicate = predicate.And(p => p.LogTime >= searchModel.LogStartDt.Value);
}
if (searchModel.LogEndDt.HasValue)
{
predicate = predicate.And(p => p.LogTime <= searchModel.LogEndDt.Value.AddDays(1));
}
int pos = searchModel.posStart.HasValue ? searchModel.posStart.Value : 0;
int count = searchModel.count.HasValue ? searchModel.count.Value : 30;
PagingOptions <SysLog> pagingOption = new PagingOptions <SysLog>(pos, count, u => new { u.LogTime }, true);
var logs = rep.GetByConditonPage(predicate, pagingOption);
DhtmlxGrid grid = new DhtmlxGrid();
grid.AddPaging(pagingOption.TotalItems, pos);
for (int i = 0; i < logs.Count; i++)
{
var log = logs[i];
DhtmlxGridRow row = new DhtmlxGridRow(log.Id.ToString());
row.AddCell((pos + i + 1).ToString());
row.AddCell(log.UerName);
row.AddCell(log.IpAddress);
row.AddCell(log.LogEvent);
row.AddCell(log.LogType);
row.AddCell(log.LogTime.ToString("yyyy-MM-dd HH:mm:ss"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(SysSearchModel model)
{
model.modelType = SysSearchModelModelType.CheckStatis;
var response = GetSearchResponse(model);
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int index = pos + 1;
DhtmlxGrid grid = new DhtmlxGrid();
var allInsts = checkUnitService.GetAllCheckUnit();
var allItems = itemNameService.GetAllItemName();
if (response.IsValid)
{
int totalCount = (int)response.Total;
grid.AddPaging(totalCount, pos);
var pkrReports = reportService.GetPkrReportNums(response.Documents);
foreach (var item in response.Documents)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell(index++);
row.AddCell(item.ENTRUSTUNIT);
row.AddCell(item.CONSTRACTUNIT);
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allInsts, item.CUSTOMID));
row.AddCell(item.PROJECTNAME);
row.AddCell(item.STRUCTPART);
row.AddCell(itemNameService.GetItemCNNameFromAll(allItems, item.REPORTJXLB, item.ITEMNAME));
row.AddCell(item.CHECKTYPE);
row.AddCell(GetUIDtString(item.ENTRUSTDATE, "yyyy-MM-dd"));
row.AddCell(GetUIDtString(item.CHECKDATE, "yyyy-MM-dd"));
row.AddCell(GetUIDtString(item.PRINTDATE, "yyyy-MM-dd"));
BuildReportNumRow(reportService, pkrReports, item, row);
row.AddCell(item.CHECKCONCLUSION);
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult StatisUserCustomGrid(int id)
{
DhtmlxGrid grid = new DhtmlxGrid();
var userCustoms = userCustomrep.GetByCondition(r => r.UserId == id && r.UserCustomType == UserCustomType.UserLogCustom);
var allInsts = checkUnitService.GetAllCheckUnit();
foreach (var userCustom in userCustoms)
{
DhtmlxGridRow row = new DhtmlxGridRow(userCustom.CustomId);
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allInsts, userCustom.CustomId));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult SearchImport(ApplyQualifyFiveSearchModel model)
{
DhtmlxGrid grid = new DhtmlxGrid();
var precadite = PredicateBuilder.True <t_bp_People>();
if (!model.CustomId.IsNullOrEmpty())
{
precadite = precadite.And(tt => tt.Customid == model.CustomId.Trim());
}
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int count = model.count.HasValue ? model.count.Value : 30;
var paging = new PagingOptions <t_bp_People>(pos, count, t => t.id);
var datas = peopleRep.GetByConditonPage(precadite, paging);
var totalCount = (int)paging.TotalItems;
var PersonnelTitles = sysDictServcie.GetDictsByKey("personnelTitles");
grid.AddPaging(totalCount, pos);
var index = 1;
foreach (var item in datas)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.id);
row.AddCell(string.Empty);
row.AddCell(index++);
row.AddCell(item.Name);
row.AddCell(string.Empty);
row.AddCell(string.Empty);
row.AddCell(string.Empty);
row.AddCell(SysDictUtility.GetKeyFromDic(PersonnelTitles, item.Title));
row.AddCell(item.Professional);
row.AddCell(item.Education);
row.AddCell(string.Empty);
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
row.AddCell(string.Empty);
row.AddCell(string.Empty);
row.AddCell(item.titlepath);
row.AddCell(item.educationpath);
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult SearchGrid(SysSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
DhtmlxGrid grid = new DhtmlxGrid();
var response = GetStatisDetailData(model);
if (response.IsValid)
{
int totalCount = (int)response.Total;
grid.AddPaging(totalCount, pos);
int index = pos;
var allInst = checkUnitService.GetAllCheckUnit();
var allItems = itemNameService.GetAllItemName();
var pkrReports = reportService.GetPkrReportNums(response.Documents);
foreach (var item in response.Documents)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell((index + 1).ToString());
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allInst, item.CUSTOMID));
row.AddCell(item.PROJECTNAME);
if (item.ITEMCHNAME.IsNullOrEmpty())
{
row.AddCell(itemNameService.GetItemCNNameFromAll(allItems, item.REPORTJXLB, item.ITEMNAME));
}
else
{
row.AddCell(item.ITEMCHNAME);
}
row.AddCell(GetUIDtString(item.PRINTDATE));
BuildReportNumRow(reportService, pkrReports, item, row);
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
index++;
grid.AddGridRow(row);
}
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(CheckStatisHNKYSearchModel model)
{
var response = GetResult(model);
var totalCount = response.Total;
int pos = model.posStart ?? 0;
DhtmlxGrid grid = new DhtmlxGrid();
grid.AddPaging((int)totalCount, pos);
var allCustoms = checkUnitService.GetAllCheckUnit();
var index = 1;
foreach (var item in response.Documents)
{
var customName = string.Empty;
allCustoms.TryGetValue(item.CUSTOMID, out customName);
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell(index++);
row.AddCell(item.PROJECTNAME);
row.AddCell(item.STRUCTPART);
row.AddCell(checkUnitService.GetCheckUnitByIdFromAll(allCustoms, item.CUSTOMID));
row.AddCell(GetUIDtString(item.CHECKDATE, "yyyy-MM-dd"));
row.AddLinkJsCell(item.REPORTNUM, "detailsReport(\"{0}\")".Fmt(item.SYSPRIMARYKEY));
row.AddCell(item.LINQI);
row.AddCell(item.SHEJIDENGJI);
row.AddCell(item.QIANGDUDAIBIAOZHI);
if (model.qiangduwuxiao.HasValue && model.qiangduwuxiao == 1)
{
row.AddCell(string.Empty);
}
else
{
row.AddCell(item.BAIFENGBI.ToString());
}
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(GetXCProjectInfos model)
{
var client = new JsonServiceClient(GetSceneDataUrl);
var data = client.Get(model);
DhtmlxGrid grid = new DhtmlxGrid();
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int index = pos;
grid.AddPaging(data.totalCount, pos);
foreach (var item in data.datas)
{
//循环内处理单位名称、见证人员处理
DhtmlxGridRow row = new DhtmlxGridRow(item.Id.ToString());
row.AddCell((++index).ToString());
row.AddCell(item.customname);
row.AddCell(item.projectname);
if (!item.witnesspeople.IsNullOrEmpty())
{
var witnesspeople = JsonConvert.DeserializeObject <List <witnesspeopleModels> >(item.witnesspeople);
List <string> names = new List <string>();
foreach (var name in witnesspeople)
{
names.Add(name.name);
}
row.AddCell(names.Join(","));
}
else
{
row.AddCell(string.Empty);
}
row.AddCell(item.areainfo);
row.AddCell(new DhtmlxGridCell("[查看]", false).AddCellAttribute("title", "查看"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(SysInfoSearchModel model)
{
var data = GetSearchResult(model);
DhtmlxGrid grid = new DhtmlxGrid();
var buttons = GetCurrentUserPathActions();
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
grid.AddPaging(data.TotalCount, pos);
for (int i = 0; i < data.Results.Count; i++)
{
var information = data.Results[i];
DhtmlxGridRow row = new DhtmlxGridRow(information.Id.ToString());
row.AddCell(pos + i + 1);
row.AddCell(information.Name);
row.AddCell(information.Content);
row.AddCell(GetUIDtString(information.Time));
if (HaveButtonFromAll(buttons, "Edit"))
{
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
}
else
{
row.AddCell(string.Empty);
}
if (HaveButtonFromAll(buttons, "Delete"))
{
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
}
else
{
row.AddCell(string.Empty);
}
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
private static string GetGridXmlString(List <Path> paths, List <Pkpm.Entity.Action> actions)
{
DhtmlxGrid grid = new DhtmlxGrid();
foreach (var item in paths.OrderBy(p => p.OrderNo))
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id.ToString());
row.AddCell(item.Name);
row.AddCell(item.Url);
row.AddCell(item.OrderNo.ToString());
row.AddCell(item.Status.ToString());
row.AddLinkJsCell("按钮", "actionInPath({0})".Fmt(item.Id.ToString()));
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
var pathActions = actions.Where(a => a.PathId == item.Id).ToList();
foreach (var pathAction in pathActions)
{
DhtmlxGridRow actionRow = new DhtmlxGridRow(string.Format("Action,{0}", pathAction.Id));
actionRow.AddCell(pathAction.Name);
actionRow.AddCell(pathAction.Url);
actionRow.AddCell(string.Empty);
actionRow.AddCell(pathAction.Status.ToString());
actionRow.AddCell(string.Empty);
actionRow.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
actionRow.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
row.AddRow(actionRow);
}
grid.AddGridRow(row);
}
return(grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting));
}
public ActionResult ParmDetails(string id)
{
var parms = rep.GetByCondition(t => t.typecode == id);
DhtmlxGrid grid = new DhtmlxGrid();
for (int i = 0; i < parms.Count; i++)
{
var parm = parms[i];
DhtmlxGridRow row = new DhtmlxGridRow(parm.Id.ToString());
row.AddCell((i + 1).ToString());
row.AddCell(parm.typecode);
row.AddCell(parm.itemcode);
row.AddCell(parm.ItemName);
row.AddCell(parm.itemtype);
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
private string GetGridXmlString(List <Role> roles)
{
DhtmlxGrid grid = new DhtmlxGrid();
int index = 1;
foreach (var item in roles)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.Id.ToString());
row.AddCell(index.ToString());
row.AddCell(item.Name);
row.AddCell(item.Description);
row.AddCell(item.Code);
row.AddLinkJsCells(GetOpDicts(item.Id.ToString()));
row.AddCell(new DhtmlxGridCell("编辑", false).AddCellAttribute("title", "编辑"));
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
grid.AddGridRow(row);
index++;
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(str);
}
public ActionResult Search(STSysSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
ISearchResponse <es_t_bp_item> response = GetSearchResult(model);
int totalCount = (int)response.Total;
DhtmlxGrid grid = new DhtmlxGrid();
grid.AddPaging(totalCount, pos);
int index = pos;
var allCheckItems = sHItemNameService.GetAllSHItemName();
var reportConclusions = sysDictService.GetDictsByKey("ReportConclusionCode");
foreach (var item in response.Documents)
{
DhtmlxGridRow row = new DhtmlxGridRow(item.SYSPRIMARYKEY);
row.AddCell(index + 1);
row.AddCell(item.PROJECTNAME);
row.AddCell(SysDictUtility.GetKeyFromDic(reportConclusions, item.CONCLUSIONCODE, "/"));
row.AddCell(checkUnitService.GetSTCheckUnitById(item.CUSTOMID));
row.AddCell(item.STRUCTPART);
row.AddCell(sHItemNameService.GetItemSHNameFromAll(allCheckItems, item.ITEMNAME));
row.AddCell(item.REPORTNUM);
row.AddCell(item.QRCODEBAR);
row.AddCell(GetUIDtString(item.CHECKDATE, "yyyy-MM-dd"));
row.AddCell(GetUIDtString(item.APPROVEDATE, "yyyy-MM-dd"));
row.AddCell(reportService.GetReportDataStatus(item.SAMPLEDISPOSEPHASEORIGIN));
row.AddCell(new DhtmlxGridCell("查看", false).AddCellAttribute("title", "查看"));
index++;
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
public ActionResult Search(QualifysixSearchModel model)
{
int pos = model.posStart.HasValue ? model.posStart.Value : 0;
int count = model.count.HasValue ? model.count.Value : 30;
PagingOptions <t_D_UserTableSix> pagingOption = new PagingOptions <t_D_UserTableSix>(pos, count, t => new { t.id });
DhtmlxGrid grid = new DhtmlxGrid();
var userTableSix = repSix.GetByCondition(r => r.pid == model.pid);
grid.AddPaging(pagingOption.TotalItems, pos);
int index = pos + 1;
var currentUserRole = GetCurrentUserRole();
List <int?> Ids = new List <int?>();
foreach (var item in userTableSix)
{
if (item.PeopleId.HasValue)
{
Ids.Add(item.PeopleId.Value);
}
}
var fileUrls = peopleRep.GetByConditon <PeopleSearchModel>(t => Ids.Contains(t.id), t => new { t.id, t.educationpath, t.selfnumPath, t.titlepath, t.PostPath });
foreach (var item in userTableSix)
{
var data = JsonConvert.DeserializeObject <ApplyQualifSixData>(item.gzjl);
var rowId = item.PeopleId.HasValue ? item.PeopleId.Value : item.id;
DhtmlxGridRow row = new DhtmlxGridRow(rowId);
//row.AddCell(index);
row.AddCell(data.xm);
row.AddCell(data.xb);
row.AddCell(data.nl);
row.AddCell(data.zw);
row.AddCell(data.xl);
row.AddCell(data.zy);
row.AddCell(data.zc);
row.AddCell(data.sfzhm);
row.AddCell(data.sgzsh);
row.AddCell(data.csjflb);
row.AddCell(data.csjfnx);
row.AddCell(data.shbxzh);
row.AddCell(data.xlpath);
row.AddCell(data.zcpath);
row.AddCell(data.sfzhmpath);
row.AddCell(data.sgzshpath);
if (Ids.Contains(item.PeopleId))
{
var fileUrl = fileUrls.Where(t => t.id == item.PeopleId);
if (fileUrl != null && fileUrl.Count() > 0)
{
var filePath = fileUrl.First();
Dictionary <string, string> dict = new Dictionary <string, string>();
if (!filePath.educationpath.IsNullOrEmpty())
{
dict.Add("学历证书", "uploadFile(\"{0}\")".Fmt(filePath.educationpath));
}
if (!filePath.titlepath.IsNullOrEmpty())
{
dict.Add("职称证书", "uploadFile(\"{0}\")".Fmt(filePath.titlepath));
}
if (!filePath.PostPath.IsNullOrEmpty())
{
dict.Add("上岗证书", "uploadFile(\"{0}\")".Fmt(filePath.PostPath));
}
if (!filePath.selfnumPath.IsNullOrEmpty())
{
dict.Add("身份证扫描", "uploadFile(\"{0}\")".Fmt(filePath.selfnumPath));
}
row.AddLinkJsCells(dict);
}
else
{
row.AddCell(string.Empty);
}
}
else
{
row.AddCell(string.Empty);
}
row.AddCell(string.Empty);
row.AddCell(string.Empty);
if (currentUserRole.Code == "JCZXYH")
{
row.AddCell(new DhtmlxGridCell("删除", false).AddCellAttribute("title", "删除"));
}
else
{
row.AddCell(string.Empty);
}
index++;
grid.AddGridRow(row);
}
string str = grid.BuildRowXml().ToString(System.Xml.Linq.SaveOptions.DisableFormatting);
return(Content(str, "text/xml"));
}
