/// <summary> /// /// </summary> /// <returns></returns> public ActionResult AptitudeWarnGrid() { string where = ""; Acc_Account account = GAccount.GetAccountInfo(); where = " and a.Unit = '" + account.UnitID + "'"; string num = UserAptitudeMan.getNewAptitudeTime(); if (num == "") { where += " and DATEDIFF(MONTH,GETDATE(),a.CertificatDate) <= '2'"; } else { where += " and DATEDIFF(MONTH,GETDATE(),a.CertificatDate) <= '" + num + "'"; } string strCurPage; string strRowNum; string UserName = Request["userName"].ToString(); string BusinessType = Request["businessType"].ToString(); string TecoName = Request["tecoName"].ToString(); if (Request["curpage"] != null) { strCurPage = Request["curpage"].ToString(); } if (Request["rownum"] != null) { strRowNum = Request["rownum"].ToString(); } else { strRowNum = "10"; } if (UserName != "") { where += " and a.UserName like '%" + UserName + "%'"; } if (BusinessType != "") { where += " and a.BusinessType = '" + BusinessType + "'"; } if (TecoName != "") { where += " and a.TecoName like '%" + TecoName + "%'"; } UIDataTable udtTask = UserAptitudeMan.getNewAptitudeGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where, account.UnitID); string strjson = GFun.Dt2Json("", udtTask.DtData); strjson = strjson.Substring(1); strjson = strjson.Substring(0, strjson.Length - 1); string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": "; jsonData += strjson + "}"; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
/// <summary> /// /// </summary> /// <returns></returns> public ActionResult AptitudeGrid() { Acc_Account account = GAccount.GetAccountInfo(); string where = ""; string strCurPage; string strRowNum; string UserID = ""; if (Request["curpage"] != null) { strCurPage = Request["curpage"].ToString(); } if (Request["rownum"] != null) { strRowNum = Request["rownum"].ToString(); } else { strRowNum = "10"; } if (Request["userid"] != null) { UserID = Request["userid"].ToString(); } if (UserID != "") { where += " and a.UserID = '" + UserID + "'"; } UIDataTable udtTask = new UIDataTable(); if (where != "") { udtTask = UserAptitudeMan.getNewAptitudeGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where, account.UnitID); } string strjson = GFun.Dt2Json("", udtTask.DtData); strjson = strjson.Substring(1); strjson = strjson.Substring(0, strjson.Length - 1); string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": "; jsonData += strjson + "}"; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }