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