private static string DataTableToJson(DataTable dt) { var reJson = new StringBuilder(); reJson.Append("["); if (dt != null && dt.Rows.Count > 0) { var dwbmbll = new EDRS.BLL.XT_ZZJG_DWBM(request); var bmbmbll = new EDRS.BLL.XT_ZZJG_BMBM(request); var jsbmbll = new EDRS.BLL.XT_QX_JSBM(request); var dwMoldelist = dwbmbll.DataTableToList(dt); foreach (var xtZzjgDwbm in dwMoldelist) { reJson.Append("{\"id\":\"" + xtZzjgDwbm.DWBM + "\","); reJson.Append("\"text\":\"" + xtZzjgDwbm.DWMC + "\","); reJson.Append("\"lx\":\"dw\""); //获取当前单位下的子单位 dt = GetDwNode(xtZzjgDwbm.DWBM); if (dt != null && dt.Rows.Count > 0) { reJson.Append(",\"state\":\"closed\","); var childrenstr = DataTableToJson(dt); reJson.Append("\"children\":" + childrenstr); } //获取当前单位下的部门 var bmdt = GetBmNodeBydw(xtZzjgDwbm.DWBM); if (bmdt != null && bmdt.Rows.Count > 0) { var strBmJsons = ",\"children\":" + DataTableToBmJson(bmdt); reJson.Append(strBmJsons); } reJson.Append("},"); } } var strjson = reJson.ToString(); strjson = strjson.Substring(0, strjson.Length - 1); strjson += "]"; return(strjson); }
/// <summary> /// 根据单位父节点获取父节点下的子节点集合 /// </summary> /// <param name="parentid">父节点ID</param> /// <returns>子节点集合</returns> private static DataTable GetDwNode(string parentid) { var bll = new EDRS.BLL.XT_ZZJG_DWBM(request); var sbwhere = new StringBuilder(); var objectValues = new object[1]; if (string.IsNullOrWhiteSpace(parentid)) { sbwhere.Append(" and FDWBM is null "); } else { sbwhere.Append(" and FDWBM=:FDWBM "); objectValues[0] = parentid; } var ds = bll.GetList(sbwhere.ToString(), objectValues); return(ds.Tables.Count > 0 ? ds.Tables[0] : new DataTable()); }
/// <summary> /// /// </summary> /// <param name="data"></param> /// <returns></returns> private string UserLogin() { //List<FromValue> list = JsonConvert.DeserializeObject<List<FromValue>>(data); //if (list == null || list.Count == 0) // return ReturnString.JsonToString(Prompt.error, "参数错误", ""); string type = ""; string name = ""; string value = ""; if (string.IsNullOrEmpty(Request.Form.Get("tree_select_id")) && string.IsNullOrEmpty(Request.Form.Get("tree_select_hid"))) { return(ReturnString.JsonToString(Prompt.error, "请先选择单位", "tree_select")); } if (string.IsNullOrEmpty(Request.Form.Get("txtUser"))) { return(ReturnString.JsonToString(Prompt.error, "用户名不能为空", "txtUser")); } if (!Regex.IsMatch(Request.Form.Get("txtUser").ToString(), @"^(\w){1,20}$")) { return(ReturnString.JsonToString(Prompt.error, "用户名输入不正确", "txtUser")); } if (string.IsNullOrEmpty(Request.Form.Get("txtPwd"))) { return(ReturnString.JsonToString(Prompt.error, "密码不能为空", "txtPwd")); } if (!Regex.IsMatch(Request.Form.Get("txtPwd").ToString(), @"^(\w){6,20}$")) { return(ReturnString.JsonToString(Prompt.error, "密码输入不正确", "txtPwd")); } if (string.IsNullOrEmpty(Request.Form.Get("tree_select_id"))) { type = Request.Form.Get("tree_select_hid"); } else { type = Request.Form.Get("tree_select_id").ToString(); } name = Request.Form.Get("txtUser").ToString(); value = Request.Form.Get("txtPwd").ToString(); //else if (fv.Name == "txtVCode") //{ // if (string.IsNullOrEmpty(fv.Value.ToString().Trim())) // return ReturnString.JsonToString(Prompt.error, "验证码不能为空", "txtVCode"); // if (HttpContext.Current.Session["ValidateCode"].ToString().ToLower() != fv.Value.ToString().ToLower()) // return ReturnString.JsonToString(Prompt.error, "验证码错误", "txtVCode"); //} //} //1bbd886460827015e5d605ed44252251 8个1 [a-zA-Z]\w{1,3} EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(request); string msg = string.Empty; List <EDRS.Model.XT_QX_JSBM> jsbmList; try { EDRS.BLL.XT_ZZJG_DWBM dwbmBll = new EDRS.BLL.XT_ZZJG_DWBM(request); EDRS.Model.XT_ZZJG_DWBM dwbmmodel = dwbmBll.GetModel(type); if (dwbmmodel == null) { return(ReturnString.JsonToString(Prompt.error, "选择单位不存在,请重新选择", null)); } EDRS.Model.XT_ZZJG_RYBM rybm = bll.UserLogin(type, name, value, out jsbmList, out msg); if (rybm != null) { HttpContext.Current.Session["user"] = rybm; HttpContext.Current.Session["userDwbm"] = dwbmmodel; if (jsbmList != null) { HttpContext.Current.Session["userRole"] = jsbmList; } HttpCookie cookie = new HttpCookie("login"); //cookie.Values[EDRS.Common.DEncrypt.DESEncrypt.Encrypt("UnitOption", "UnitOption")] = EDRS.Common.DEncrypt.DESEncrypt.Encrypt(rybm.DWBM, "UnitOption"); //cookie.Values[EDRS.Common.DEncrypt.DESEncrypt.Encrypt("UserName", "UserName")] = EDRS.Common.DEncrypt.DESEncrypt.Encrypt(rybm.DLBM, "UserName"); cookie.Values["UnitOption"] = rybm.DWBM; cookie.Values["UnitOptionName"] = HttpUtility.UrlEncode(rybm.DWMC, Encoding.UTF8); cookie.Values["UserName"] = HttpUtility.UrlEncode(rybm.DLBM, Encoding.UTF8); cookie.Expires = DateTime.MaxValue; HttpContext.Current.Response.Cookies.Add(cookie); OperateLog.AddLog(OperateLog.LogType.登录系统, msg, rybm, jsbmList, request); return(ReturnString.JsonToString(Prompt.win, msg, null)); } else { rybm = new EDRS.Model.XT_ZZJG_RYBM(); XT_ZZJG_DWBM dwbmbll = new XT_ZZJG_DWBM(request); EDRS.Model.XT_ZZJG_DWBM dwbm = dwbmbll.GetModel(type); if (dwbm != null) { rybm.MC = name; rybm.DWBM = dwbm.DWBM; rybm.DWMC = dwbm.DWMC; } OperateLog.AddLog(OperateLog.LogType.登录系统, msg, rybm, jsbmList, request); return(ReturnString.JsonToString(Prompt.error, msg, null)); } } catch (Exception ex) { msg = Regex.Replace(ex.Message, "[\r\n\"]", ""); return(ReturnString.JsonToString(Prompt.error, msg, null)); } }