/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_ZZJG_RYBM GetModel(string GH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select GH,DWBM,MC,DLBM,KL,YDDHHM,DZYJ,GZZH,YDWBM,YDWMC,SFLSRY,SFTZ,SFSC,XB,CAID from XT_ZZJG_RYBM "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where GH=:GH "); OracleParameter[] parameters = { new OracleParameter(":GH", OracleType.Char, 4) }; parameters[0].Value = GH; EDRS.Model.XT_ZZJG_RYBM model = new EDRS.Model.XT_ZZJG_RYBM(); DataSet ds = null; try { ds = DbHelperOra.Query(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_ZZJG_RYBM GetModel(string GH)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 密码修改 /// </summary> /// <returns></returns> private string AlterPwd() { string before = Request.Form.Get("pwd_before"); string news = Request.Form.Get("pwd_news"); string newsto = Request.Form.Get("pwd_newsTo"); //验证旧密码 if (before == null || string.IsNullOrEmpty(before)) { return(ReturnString.JsonToString(Prompt.error, "旧密码不能为空", "pwd_before")); } if (!Regex.IsMatch(before, @"^(\w){6,20}$")) { return(ReturnString.JsonToString(Prompt.error, "旧密码输入不正确", "pwd_before")); } //验证新密码 if (news == null || string.IsNullOrEmpty(news)) { return(ReturnString.JsonToString(Prompt.error, "新密码不能为空", "pwd_news")); } if (!Regex.IsMatch(news, @"^(\w){6,20}$")) { return(ReturnString.JsonToString(Prompt.error, "新密码输入不正确", "pwd_news")); } //验证新密码与旧密码相同 if (!news.Equals(newsto)) { return(ReturnString.JsonToString(Prompt.error, "新密码与确认密码不一致!", "pwd_newsTo")); } //判断新密码与旧密码是否相同 if (before.Equals(news)) { return(ReturnString.JsonToString(Prompt.error, "旧密码与新密码相同无须修改!", "pwd_news")); } EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(this.Request); string msg = string.Empty; List <EDRS.Model.XT_QX_JSBM> jsbmList; EDRS.Model.XT_ZZJG_RYBM rybm = bll.UserLogin(UserInfo.DWBM, UserInfo.DLBM, before, out jsbmList, out msg); if (rybm != null) { rybm.KL = MD5Encrypt.Encrypt(news).ToLower(); if (bll.Update(rybm)) { return(ReturnString.JsonToString(Prompt.win, "密码修改成功,重新登录生效!", null)); } return(ReturnString.JsonToString(Prompt.error, "密码修改失败!", null)); } else { return(ReturnString.JsonToString(Prompt.error, msg, null)); } }
public virtual void ProcessRequest(HttpContext context) { if (null == context.Session["user"]) { return; } _userInfo = context.Session["user"] as EDRS.Model.XT_ZZJG_RYBM; if (null == context.Session["userDwbm"]) { return; } _userDwbm = context.Session["userDwbm"] as EDRS.Model.XT_ZZJG_DWBM; if (null == context.Session["userRole"]) { return; } _userRole = context.Session["userRole"] as List <EDRS.Model.XT_QX_JSBM>; string jsbms = ""; string bmbms = ""; for (int i = 0; i < UserRole.Count; i++) { jsbms += "'" + UserRole[i].JSBM + "'"; bmbms += "'" + UserRole[i].BMBM + "'"; if (i < UserRole.Count - 1) { jsbms += ","; bmbms += ","; } } this.jsbms = jsbms; this.bmbms = bmbms; }
/// <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)); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.XT_ZZJG_RYBM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XT_ZZJG_RYBM("); strSql.Append("GH,DWBM,MC,DLBM,KL,YDDHHM,DZYJ,GZZH,YDWBM,YDWMC,SFLSRY,SFTZ,ZP,SFSC,XB,CAID)"); strSql.Append(" values ("); strSql.Append(":GH,:DWBM,:MC,:DLBM,:KL,:YDDHHM,:DZYJ,:GZZH,:YDWBM,:YDWMC,:SFLSRY,:SFTZ,:ZP,:SFSC,:XB,:CAID)"); OracleParameter[] parameters = { new OracleParameter(":GH", OracleType.Char, 4), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":DLBM", OracleType.VarChar, 60), new OracleParameter(":KL", OracleType.VarChar, 128), new OracleParameter(":YDDHHM", OracleType.VarChar, 60), new OracleParameter(":DZYJ", OracleType.VarChar, 60), new OracleParameter(":GZZH", OracleType.VarChar, 20), new OracleParameter(":YDWBM", OracleType.VarChar, 50), new OracleParameter(":YDWMC", OracleType.VarChar, 300), new OracleParameter(":SFLSRY", OracleType.Char, 1), new OracleParameter(":SFTZ", OracleType.Char, 1), new OracleParameter(":ZP", OracleType.Blob), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":XB", OracleType.Char, 1), new OracleParameter(":CAID", OracleType.VarChar, 100) }; parameters[0].Value = model.GH; parameters[1].Value = model.DWBM; parameters[2].Value = model.MC; parameters[3].Value = model.DLBM; parameters[4].Value = model.KL; parameters[5].Value = model.YDDHHM; parameters[6].Value = model.DZYJ; parameters[7].Value = model.GZZH; parameters[8].Value = model.YDWBM; parameters[9].Value = model.YDWMC; parameters[10].Value = model.SFLSRY; parameters[11].Value = model.SFTZ; parameters[12].Value = model.ZP.Length == 0 ? new byte[1] : model.ZP; parameters[13].Value = model.SFSC; parameters[14].Value = model.XB; parameters[15].Value = model.CAID; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_ZZJG_RYBM model)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_ZZJG_RYBM DataRowToModel(DataRow row) { EDRS.Model.XT_ZZJG_RYBM model = new EDRS.Model.XT_ZZJG_RYBM(); if (row != null) { if (row["GH"] != null) { model.GH = row["GH"].ToString(); } if (row["DWBM"] != null) { model.DWBM = row["DWBM"].ToString(); } if (row["DWMC"] != null) { model.DWMC = row["DWMC"].ToString(); } if (row["MC"] != null) { model.MC = row["MC"].ToString(); } if (row["DLBM"] != null) { model.DLBM = row["DLBM"].ToString(); } if (row["KL"] != null) { model.KL = row["KL"].ToString(); } if (row["YDDHHM"] != null) { model.YDDHHM = row["YDDHHM"].ToString(); } if (row["DZYJ"] != null) { model.DZYJ = row["DZYJ"].ToString(); } if (row["GZZH"] != null) { model.GZZH = row["GZZH"].ToString(); } if (row["YDWBM"] != null) { model.YDWBM = row["YDWBM"].ToString(); } if (row["YDWMC"] != null) { model.YDWMC = row["YDWMC"].ToString(); } if (row["SFLSRY"] != null) { model.SFLSRY = row["SFLSRY"].ToString(); } if (row["SFTZ"] != null) { model.SFTZ = row["SFTZ"].ToString(); } if (row.Table.Columns.Contains("ZP") && row["ZP"] != null && row["ZP"].ToString() != "") { model.ZP = (byte[])row["ZP"]; } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } if (row["XB"] != null) { model.XB = row["XB"].ToString(); } if (row["CAID"] != null) { model.CAID = row["CAID"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.XT_ZZJG_RYBM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XT_ZZJG_RYBM set "); strSql.Append("MC=:MC,"); strSql.Append("DLBM=:DLBM,"); strSql.Append("KL=:KL,"); strSql.Append("YDDHHM=:YDDHHM,"); strSql.Append("DZYJ=:DZYJ,"); strSql.Append("GZZH=:GZZH,"); strSql.Append("YDWBM=:YDWBM,"); strSql.Append("YDWMC=:YDWMC,"); strSql.Append("SFLSRY=:SFLSRY,"); strSql.Append("SFTZ=:SFTZ,"); strSql.Append("ZP=:ZP,"); strSql.Append("SFSC=:SFSC,"); strSql.Append("XB=:XB,"); strSql.Append("CAID=:CAID"); strSql.Append(" where DWBM=:DWBM and GH=:GH "); OracleParameter[] parameters = { new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":DLBM", OracleType.VarChar, 60), new OracleParameter(":KL", OracleType.VarChar, 128), new OracleParameter(":YDDHHM", OracleType.VarChar, 60), new OracleParameter(":DZYJ", OracleType.VarChar, 60), new OracleParameter(":GZZH", OracleType.VarChar, 20), new OracleParameter(":YDWBM", OracleType.VarChar, 50), new OracleParameter(":YDWMC", OracleType.VarChar, 300), new OracleParameter(":SFLSRY", OracleType.Char, 1), new OracleParameter(":SFTZ", OracleType.Char, 1), new OracleParameter(":ZP", OracleType.Blob), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":XB", OracleType.Char, 1), new OracleParameter(":CAID", OracleType.VarChar, 100), new OracleParameter(":GH", OracleType.Char, 4) }; parameters[0].Value = model.DWBM; parameters[1].Value = model.MC; parameters[2].Value = model.DLBM; parameters[3].Value = model.KL; parameters[4].Value = model.YDDHHM; parameters[5].Value = model.DZYJ; parameters[6].Value = model.GZZH; parameters[7].Value = model.YDWBM; parameters[8].Value = model.YDWMC; parameters[9].Value = model.SFLSRY; parameters[10].Value = model.SFTZ; parameters[11].Value = model.ZP == null ? new byte[1] : model.ZP; parameters[12].Value = model.SFSC; parameters[13].Value = model.XB; parameters[14].Value = model.CAID; parameters[15].Value = model.GH; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.XT_ZZJG_RYBM model)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }