/// <summary> /// 绑定部门数据 /// </summary> /// <returns></returns> private string GetSHBM() { string where = string.Empty; string withWhere = string.Empty; object[] values = new object[2]; where += " and SFSC=:SFSC"; values[0] = "N"; withWhere = " FBMBM is NULL"; where += " and DWBM = :DWBM "; values[1] = base.UserInfo.DWBM; XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request); DataSet ds = bll.GetTreeList(where, withWhere, values); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0].Copy(); DataView dv = dt.DefaultView; dv.Sort = "DWBM asc,BMBM asc"; dt = dv.ToTable(); return(JsonHelper.JsonString(dt)); } else { return("[]"); } } return(ReturnString.JsonToString(Prompt.error, "获取部门列表出现错误", null)); }
/// <summary> /// 绑定数据列表 /// </summary> /// <returns></returns> private string ListBind() { string where = string.Empty; string withWhere = string.Empty; object[] values = new object[2]; where += " and SFSC=:SFSC"; values[0] = "N"; string key = Request["key"]; if (!string.IsNullOrEmpty(key)) { withWhere = " (BMMC like '%" + StringPlus.ReplaceSingle(key) + "%' or BMJC like '%" + StringPlus.ReplaceSingle(key) + "%')"; } else { withWhere = " FBMBM is NULL"; } if (!string.IsNullOrEmpty(Request["dkey"]) || base.UserInfo != null) { where += " and DWBM = :DWBM "; if (Request["dkey"] != null && !string.IsNullOrEmpty(Request["dkey"])) { values[1] = Request["dkey"].ToString(); } else { values[1] = base.UserInfo.DWBM; } } else { return(ReturnString.JsonToString(Prompt.error, "查询条件不正确", null)); } XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request); DataSet ds = bll.GetTreeList(where, withWhere, values); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { string sortname = Request.Params["sortname"]; string sortorder = Request.Params["sortorder"]; DataTable dt = ds.Tables[0].Copy(); DataView dv = dt.DefaultView; if (!string.IsNullOrEmpty(sortname) && !string.IsNullOrEmpty(sortorder)) { dv.Sort = sortname + " " + sortorder; } else { dv.Sort = "DWBM asc,BMBM asc"; } dt = dv.ToTable(); //数据日志 OperateLog.AddLog(OperateLog.LogType.部门管理Web, "获取部门列表成功", UserInfo, UserRole, this.Request); return("{\"Rows\":" + JsonHelper.JsonString(dt) + "}"); } else { return("{\"Rows\":[]}"); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.部门管理Web, "获取部门列表失败", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取部门列表出现错误", null)); }