public ActionResult GetKnowledgesJsonData(int kType) { //提取DataTable参数 ToolsLib.Utility.Jquery.DataTableUtils.DataTableModel dtm = ToolsLib.Utility.Jquery.DataTableUtils.GetJquerydataTableParams(); //构造输入参数 PagingModel paging = new PagingModel(); paging.FieldOrder = "KnowledgeId desc"; paging.PageSize = dtm.PageSize; paging.PageCurrent = dtm.PageIndex; //数据库查询数据 object ob = new object(); string[] fieldCondition = new string[4]; fieldCondition[0] = Request["searchTitle"]; fieldCondition[1] = Request["searchAbstract"]; fieldCondition[2] = Request["searchCreatDate1"]; fieldCondition[3] = Request["searchCreatDate2"]; string StrResult = WSProvider.EbusinessProvider.GetKnowledgeListForPaging(paging, fieldCondition, kType, Global.Business.ServiceProvider.ParamService.GetaccessToken(Instrument.Common.Constants.SysParamType.CompanyInfo)); Dictionary <string, object> dic = ToolsLib.Utility.CommonUtils.JsonDeserialize(StrResult, typeof(Dictionary <string, object>)) as Dictionary <string, object>; dtm.aaData = new List <List <string> >(); if (dic["Msg"].ToString() != "OK") { JsonResult jrNull = Json(new { sEcho = dtm.sEcho, iTotalRecords = 0, iTotalDisplayRecords = dtm.iTotalDisplayRecords, aaData = dtm.aaData }, JsonRequestBehavior.AllowGet); return(jrNull); } IList <KnowledgesModel> knowledgeList = ToolsLib.Utility.CommonUtils.JsonDeserialize(dic["Data"].ToString(), typeof(IList <KnowledgesModel>)) as IList <KnowledgesModel>; //Json数据格式组装 dtm.iTotalRecords = paging.RecordCount; dtm.iTotalDisplayRecords = Convert.ToInt32(dic["RecordCount"].ToString()); if (knowledgeList != null) { foreach (KnowledgesModel model in knowledgeList) { dtm.aaData.Add(new List <string>()); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<a href='#' onclick=fnDetail(this) id='{0}'>查看</a>", model.KnowledgeId)); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", model.Title)); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", model.Abstract)); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:d}", model.CreatDate)); } } JsonResult jr = Json(new { sEcho = dtm.sEcho, iTotalRecords = dtm.iTotalRecords, iTotalDisplayRecords = dtm.iTotalDisplayRecords, aaData = dtm.aaData }, JsonRequestBehavior.AllowGet); return(jr); }
public ActionResult GetCertListForJsonData() { //提取DataTable参数 ToolsLib.Utility.Jquery.DataTableUtils.DataTableModel dtm = ToolsLib.Utility.Jquery.DataTableUtils.GetJquerydataTableParams(); //构造输入参数 PagingModel paging = new PagingModel(); paging.FieldOrder = "CertificateId desc"; paging.PageSize = dtm.PageSize; paging.PageCurrent = dtm.PageIndex; //数据库查询数据 object ob = new object(); string[] fieldCondition = new string[8]; fieldCondition[0] = Request["searchOrderNumber"]; fieldCondition[1] = Request["searchCertificateNumber"]; fieldCondition[2] = Request["searchMadeNumber"]; fieldCondition[3] = Request["searchInstrumentName"]; fieldCondition[4] = Request["searchSpecification"]; fieldCondition[5] = Request["searchManageNumber"]; fieldCondition[6] = Request["searchIsComplete"]; fieldCondition[7] = Request["searchIsCertComplete"]; string StrResult = WSProvider.MeasureLabProvider.GetCertListForPage(paging, fieldCondition, Global.Business.ServiceProvider.ParamService.GetCompanyCode(Instrument.Common.Constants.SysParamType.CompanyInfo), Global.Business.ServiceProvider.ParamService.GetaccessToken(Instrument.Common.Constants.SysParamType.CompanyInfo)); Dictionary <string, object> dic = ToolsLib.Utility.CommonUtils.JsonDeserialize(StrResult, typeof(Dictionary <string, object>)) as Dictionary <string, object>; dtm.aaData = new List <List <string> >(); if (dic["Msg"].ToString() != "OK") { JsonResult jrNull = Json(new { sEcho = dtm.sEcho, iTotalRecords = 0, iTotalDisplayRecords = dtm.iTotalDisplayRecords, aaData = dtm.aaData }, JsonRequestBehavior.AllowGet); return(jrNull); } IList <Hashtable> orderList = ToolsLib.Utility.CommonUtils.JsonDeserialize(dic["Data"].ToString(), typeof(IList <Hashtable>)) as IList <Hashtable>; //Json数据格式组装 dtm.iTotalRecords = paging.RecordCount; dtm.iTotalDisplayRecords = Convert.ToInt32(dic["RecordCount"].ToString()); if (orderList != null) { foreach (Hashtable row in orderList) { dtm.aaData.Add(new List <string>()); //下载条件:仪器完工,证书完工,仪器有报价,证书文件有上传,客户端允许下载 if (Convert.ToBoolean(row["IsDownLoad"]) && LoginHelper.LoginUserAuthorize.ContainsKey("/Order/Download".ToLower())) { dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<a href='#' onclick=fnDownloadPDF(this) CertificateNumber='{1}' id='{0}'>下载证书</a>", UtilsHelper.Encrypt(row["CertificatePDFFileId"].ToString()), row["CertificateNumber"].ToString())); } else { dtm.aaData[dtm.aaData.Count - 1].Add(""); } dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["OrderNumber"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["CertificateNumber"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["MadeNumber"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["InstrumentName"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["Specification"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["ManageNumber"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", Convert.ToBoolean(row["IsComplete"]) ? "已完工" : "未完工")); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", Convert.ToBoolean(row["IsCertComplete"]) ? "已完工" : "未完工")); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["SaleName"])); dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:d}", row["CreateDate"])); } } JsonResult jr = Json(new { sEcho = dtm.sEcho, iTotalRecords = dtm.iTotalRecords, iTotalDisplayRecords = dtm.iTotalDisplayRecords, aaData = dtm.aaData }, JsonRequestBehavior.AllowGet); return(jr); }