/// <summary> /// 获取模板 /// </summary> /// <returns></returns> private string GetMBList() { string ajlb = Request.Form.Get("ajlb"); string strWhere = ""; if (string.IsNullOrEmpty(ajlb)) { if (string.IsNullOrEmpty(ajlb)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } else { strWhere += " and ajlbbm='" + StringPlus.ReplaceSingle(ajlb) + "'"; } strWhere += " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0"; XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); int count; DataSet ds = bll.GetDwAjList(out count, strWhere, "dwbm", 0, int.MaxValue, null); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0].Copy(); dt.Columns["DOSSIERTYPEVALUEMEMBER"].ColumnName = "id"; dt.Columns["DOSSIERTYPEDISPLAYMEMBER"].ColumnName = "text"; return(JsonHelper.JsonString(dt)); } return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
private string GetDwAjData() { EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request); DataSet ds = null; string json = "{\"Rows\":" + "[]" + ",\"Total\":" + 0 + "}"; string orderBy = Request["sortName"] + " " + Request["sortOrder"]; int page = Convert.ToInt32(Request["page"]); int pageSize = Convert.ToInt32(Request["pagesize"]); string strWhere = ""; string dwbm = Request["dwbm"]; string caseajlb = Request["ajlb"]; strWhere += " and trim(qxbm) in(select distinct trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH1 and b.dwbm=:DWBM1 and a.qxlx=0)"; //strWhere += " and trim(ajlbbm) in ( select distinct trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH2 and b.dwbm=:DWBM2 and a.qxlx=1) "; object[] param = new object[] { UserInfo.GH, UserInfo.DWBM //, //UserInfo.GH, //UserInfo.DWBM }; //strWhere += " and ajlbbm in (select qxbm from xt_dm_qx where DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 1)"; if (!string.IsNullOrEmpty(dwbm)) { string dwbms = dwbm.Replace(";", ","); strWhere += " and trim(qxbm) in (" + StringPlus.ReplaceSingle(dwbms) + ")"; } if (!string.IsNullOrEmpty(caseajlb)) { string caseajlbs = caseajlb.Replace(";", ","); strWhere += " and trim(ajlbbm) in (" + caseajlbs + ")"; } if (string.IsNullOrEmpty(orderBy.Trim())) { orderBy = "dwbm"; } try { int count = 0; ds = bll.GetDwAjList(out count, strWhere, orderBy, pageSize * (page - 1), pageSize * page, param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { json = "{\"Rows\":" + ds.Tables[0].ToDatagridJson() + ",\"Total\":" + count + "}"; } } catch (Exception ex) { } return(json); }