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