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