private void AddUserInfoToClientList(PEIS.Model.SYSOpUser tempLoginUser) { DateTime now = DateTime.Now; if (tempLoginUser != null) { try { ClientInfo clientInfo = new ClientInfo(); clientInfo.GUID = tempLoginUser.LoginName; clientInfo.UserName = tempLoginUser.UserName; clientInfo.LoginUserName = tempLoginUser.LoginName; clientInfo.UserID = tempLoginUser.UserID.ToString(); clientInfo.IpAddress = Public.GetClientIP(); clientInfo.LoginState = LoginState.已成功登陆; ClientListManagement.Instance().AddClientInfo(clientInfo); } catch (Exception ex) { DateTime now2 = DateTime.Now; string dateDiff = Public.GetDateDiff(ex.Message, now, now2); Log4J.Instance.Info(string.Concat(new string[] { "设置在线人员信息出错:", Public.GetClientIP(), ",", tempLoginUser.UserName, ",", dateDiff })); } } }
public void GetUserLoginInfo() { int userID = base.GetUserID(); if (userID <= 0) { base.Response.Clear(); this.OutPutMessage("-9999"); } else { PEIS.Model.SYSOpUser model = PEIS.BLL.SYSOpUser.Instance.GetModel(userID); if (model != null) { string str = (!model.OperateLevel.HasValue) ? "" : model.OperateLevel.ToString(); string str2 = (!model.VocationType.HasValue) ? "" : model.VocationType.ToString(); string text = model.UserID.ToString() + "|"; text = text + model.LoginName + "|"; text = text + model.UserName + "|"; text = text + str + "|"; text = text + str2 + "|"; text += this.Session.SessionID; this.OutPutMessage(text.ToString()); } } }
public int Add(PEIS.Model.SYSOpUser model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into SYSOpUser("); stringBuilder.Append("ID_Section,UserName,LoginName,PassWord,CreateTime,LastLoginTime,TotalNum,FailCount,OperateLevel,Note,DisDate,Signature,DisCountRate,sex,Is_Del,VocationType)"); stringBuilder.Append(" values ("); stringBuilder.Append("@SectionID,@UserName,@LoginName,@PassWord,@CreateTime,@LastLoginTime,@TotalNum,@FailCount,@OperateLevel,@Note,@DisDate,@Signature,@DisCountRate,@sex,@Is_Del,@VocationType)"); stringBuilder.Append(";select @@IDENTITY"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@SectionID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 256), new SqlParameter("@LoginName", SqlDbType.VarChar, 30), new SqlParameter("@PassWord", SqlDbType.VarChar, 256), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@TotalNum", SqlDbType.Int, 4), new SqlParameter("@FailCount", SqlDbType.Int, 4), new SqlParameter("@OperateLevel", SqlDbType.Int, 4), new SqlParameter("@Note", SqlDbType.VarChar, 200), new SqlParameter("@DisDate", SqlDbType.DateTime), new SqlParameter("@Signature", SqlDbType.Image), new SqlParameter("@DisCountRate", SqlDbType.Int, 4), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@Is_Del", SqlDbType.Int, 4), new SqlParameter("@VocationType", SqlDbType.Int, 4) }; array[0].Value = model.SectionID; array[1].Value = model.UserName; array[2].Value = model.LoginName; array[3].Value = model.PassWord; array[4].Value = model.CreateTime; array[5].Value = model.LastLoginTime; array[6].Value = model.TotalNum; array[7].Value = model.FailCount; array[8].Value = model.OperateLevel; array[9].Value = model.Note; array[10].Value = model.DisDate; array[11].Value = model.Signature; array[12].Value = model.DisCountRate; array[13].Value = model.Sex; array[14].Value = model.Is_Del; array[15].Value = model.VocationType; object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array); int result; if (single == null) { result = 0; } else { result = Convert.ToInt32(single); } return(result); }
protected void GetEditUserInfo(int UserID, ref VelocityContext vltContext) { PEIS.Model.SYSOpUser model = PEIS.BLL.SYSOpUser.Instance.GetModel(UserID); if (model != null) { vltContext.Put("UserID", model.UserID); vltContext.Put("UserName", model.UserName); vltContext.Put("SectionID", model.SectionID); vltContext.Put("DisCountRate", model.DisCountRate); vltContext.Put("OperateLevel", model.OperateLevel); vltContext.Put("VocationType", model.VocationType); vltContext.Put("Sex", model.Sex); vltContext.Put("Signature", model.Signature); vltContext.Put("Is_Del", model.Is_Del); vltContext.Put("Note", model.Note); string sectionName = CommonSystemInfo.Instance.GetSectionName(int.Parse(model.SectionID.ToString())); vltContext.Put("SectionName", sectionName); } }
private void JudgeLoginInfo(PEIS.Model.SYSOpUser tempLoginUser, string currUserPassword) { DateTime now = DateTime.Now; if (2 == tempLoginUser.Is_Del) { this.OutPutMessage(EnumUserLoginState.该用户名已被禁用.ToString()); } else if (1 == tempLoginUser.Is_Del) { this.OutPutMessage(EnumUserLoginState.该用户名已被删除.ToString()); } else if (5 < tempLoginUser.FailCount) { this.OutPutMessage(EnumUserLoginState.连续登录错误次数超过3次请与管理员联系.ToString()); } else if (tempLoginUser != null && tempLoginUser.PassWord == currUserPassword) { tempLoginUser.LastLoginTime = new DateTime?(DateTime.Now); if (!tempLoginUser.TotalNum.HasValue || tempLoginUser.TotalNum.ToString() == "") { tempLoginUser.TotalNum = new int?(1); } else { tempLoginUser.TotalNum++; } tempLoginUser.FailCount = new int?(0); bool flag = false; try { flag = PEIS.BLL.SYSOpUser.Instance.Update(tempLoginUser); } catch (Exception ex) { now = DateTime.Now; string dateDiff = Public.GetDateDiff(ex.Message, this.logBeginTime, now); Log4J.Instance.Info(string.Concat(new string[] { Public.GetClientIP(), ",", tempLoginUser.UserName, ",", dateDiff })); } if (flag) { try { string cacheKey = "SYSOpUserModel-" + tempLoginUser.UserID; DataCache.DeleteCache(cacheKey); this.Session["UserID"] = tempLoginUser.UserID; this.Session["UserName"] = tempLoginUser.UserName; tempLoginUser.PassWord = ""; this.LoginUserModel = tempLoginUser; BasePage.SetCookie(this.LoginUserModel, true, ""); this.AddUserInfoToClientList(tempLoginUser); now = DateTime.Now; string dateDiff = Public.GetDateDiff("登录成功", this.logBeginTime, now); Log4J.Instance.Info(string.Concat(new string[] { Public.GetClientIP(), ",", tempLoginUser.UserName, ",", dateDiff })); this.OutPutMessage(EnumUserLoginState.登录成功.ToString()); } catch (Exception ex) { now = DateTime.Now; string dateDiff = Public.GetDateDiff(ex.Message, this.logBeginTime, now); Log4J.Instance.Info(string.Concat(new string[] { Public.GetClientIP(), ",", tempLoginUser.UserName, ",", dateDiff })); } } } else { try { tempLoginUser.LastLoginTime = new DateTime?(DateTime.Now); tempLoginUser.FailCount++; PEIS.BLL.SYSOpUser.Instance.Update(tempLoginUser); this.OutPutMessage(EnumUserLoginState.密码输入错误请重新输入.ToString()); } catch (Exception ex) { now = DateTime.Now; string dateDiff = Public.GetDateDiff(ex.Message, this.logBeginTime, now); Log4J.Instance.Info(string.Concat(new string[] { Public.GetClientIP(), ",", tempLoginUser.UserName, ",", dateDiff })); } } }
public int SaveUser(PEIS.Model.SYSOpUser UserModel) { return(CommonConfig.dal.SaveUser(UserModel)); }
public bool Update(PEIS.Model.SYSOpUser model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update SYSOpUser set "); stringBuilder.Append("SectionID=@SectionID,"); stringBuilder.Append("UserName=@UserName,"); stringBuilder.Append("LoginName=@LoginName,"); stringBuilder.Append("PassWord=@PassWord,"); stringBuilder.Append("CreateTime=@CreateTime,"); stringBuilder.Append("LastLoginTime=@LastLoginTime,"); stringBuilder.Append("TotalNum=@TotalNum,"); stringBuilder.Append("FailCount=@FailCount,"); stringBuilder.Append("OperateLevel=@OperateLevel,"); stringBuilder.Append("Note=@Note,"); stringBuilder.Append("DisDate=@DisDate,"); stringBuilder.Append("Signature=@Signature,"); stringBuilder.Append("DisCountRate=@DisCountRate,"); stringBuilder.Append("sex=@sex,"); stringBuilder.Append("Is_Del=@Is_Del,"); stringBuilder.Append("VocationType=@VocationType"); stringBuilder.Append(" where UserID=@UserID"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@SectionID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 256), new SqlParameter("@LoginName", SqlDbType.VarChar, 30), new SqlParameter("@PassWord", SqlDbType.VarChar, 256), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@TotalNum", SqlDbType.Int, 4), new SqlParameter("@FailCount", SqlDbType.Int, 4), new SqlParameter("@OperateLevel", SqlDbType.Int, 4), new SqlParameter("@Note", SqlDbType.VarChar, 200), new SqlParameter("@DisDate", SqlDbType.DateTime), new SqlParameter("@Signature", SqlDbType.Image), new SqlParameter("@DisCountRate", SqlDbType.Int, 4), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@Is_Del", SqlDbType.Int, 4), new SqlParameter("@VocationType", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4) }; array[0].Value = model.SectionID; array[1].Value = model.UserName; array[2].Value = model.LoginName; array[3].Value = model.PassWord; array[4].Value = model.CreateTime; array[5].Value = model.LastLoginTime; array[6].Value = model.TotalNum; array[7].Value = model.FailCount; array[8].Value = model.OperateLevel; array[9].Value = model.Note; array[10].Value = model.DisDate; array[11].Value = model.Signature; array[12].Value = model.DisCountRate; array[13].Value = model.Sex; array[14].Value = model.Is_Del; array[15].Value = model.VocationType; array[16].Value = model.UserID; int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array); return(num > 0); }
public PEIS.Model.SYSOpUser GetModel(int UserID) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 [UserID],[SectionID],[UserName],[LoginName],[PassWord],[LastLoginTime],[Note],[DisDate],[Signature],[DisCountRate],[Sex],[Is_Del],[VocationType],[OperateLevel],[TotalNum],[FailCount],[CreateTime] from SYSOpUser "); stringBuilder.Append(" where UserID=@UserID"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4) }; array[0].Value = UserID; PEIS.Model.SYSOpUser sysopUser = new PEIS.Model.SYSOpUser(); DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array); PEIS.Model.SYSOpUser result; if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows[0]["UserID"].ToString() != "") { sysopUser.UserID = int.Parse(dataSet.Tables[0].Rows[0]["UserID"].ToString()); } if (dataSet.Tables[0].Rows[0]["SectionID"].ToString() != "") { sysopUser.SectionID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["SectionID"].ToString())); } sysopUser.UserName = dataSet.Tables[0].Rows[0]["UserName"].ToString(); sysopUser.LoginName = dataSet.Tables[0].Rows[0]["LoginName"].ToString(); sysopUser.PassWord = dataSet.Tables[0].Rows[0]["PassWord"].ToString(); if (dataSet.Tables[0].Rows[0]["CreateTime"].ToString() != "") { sysopUser.CreateTime = DateTime.Parse(dataSet.Tables[0].Rows[0]["CreateTime"].ToString()); } if (dataSet.Tables[0].Rows[0]["LastLoginTime"].ToString() != "") { sysopUser.LastLoginTime = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["LastLoginTime"].ToString())); } if (dataSet.Tables[0].Rows[0]["TotalNum"].ToString() != "") { sysopUser.TotalNum = new int?(int.Parse(dataSet.Tables[0].Rows[0]["TotalNum"].ToString())); } if (dataSet.Tables[0].Rows[0]["FailCount"].ToString() != "") { sysopUser.FailCount = new int?(int.Parse(dataSet.Tables[0].Rows[0]["FailCount"].ToString())); } if (dataSet.Tables[0].Rows[0]["OperateLevel"].ToString() != "") { sysopUser.OperateLevel = new int?(int.Parse(dataSet.Tables[0].Rows[0]["OperateLevel"].ToString())); } sysopUser.Note = dataSet.Tables[0].Rows[0]["Note"].ToString(); if (dataSet.Tables[0].Rows[0]["DisDate"].ToString() != "") { sysopUser.DisDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["DisDate"].ToString())); } if (dataSet.Tables[0].Rows[0]["Signature"].ToString() != "") { sysopUser.Signature = (byte[])dataSet.Tables[0].Rows[0]["Signature"]; } if (dataSet.Tables[0].Rows[0]["DisCountRate"].ToString() != "") { sysopUser.DisCountRate = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DisCountRate"].ToString())); } if (dataSet.Tables[0].Rows[0]["Sex"].ToString() != "") { sysopUser.Sex = new int?(int.Parse(dataSet.Tables[0].Rows[0]["Sex"].ToString())); } if (dataSet.Tables[0].Rows[0]["Is_Del"].ToString() != "") { sysopUser.Is_Del = new int?(int.Parse(dataSet.Tables[0].Rows[0]["Is_Del"].ToString())); } if (dataSet.Tables[0].Rows[0]["VocationType"].ToString() != "") { sysopUser.VocationType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["VocationType"].ToString())); } result = sysopUser; } else { result = null; } return(result); }
public bool Update(PEIS.Model.SYSOpUser model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.SYSOpUser model) { return(this.dal.Add(model)); }
public List <PEIS.Model.SYSOpUser> DataTableToList(DataTable dt) { List <PEIS.Model.SYSOpUser> list = new List <PEIS.Model.SYSOpUser>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.SYSOpUser sysopUser = new PEIS.Model.SYSOpUser(); if (dt.Rows[i]["UserID"].ToString() != "") { sysopUser.UserID = int.Parse(dt.Rows[i]["UserID"].ToString()); } if (dt.Rows[i]["SectionID"].ToString() != "") { sysopUser.SectionID = new int?(int.Parse(dt.Rows[i]["SectionID"].ToString())); } sysopUser.UserName = dt.Rows[i]["UserName"].ToString(); sysopUser.LoginName = dt.Rows[i]["LoginName"].ToString(); sysopUser.PassWord = dt.Rows[i]["PassWord"].ToString(); if (dt.Rows[i]["CreateTime"].ToString() != "") { sysopUser.CreateTime = DateTime.Parse(dt.Rows[i]["CreateTime"].ToString()); } if (dt.Rows[i]["LastLoginTime"].ToString() != "") { sysopUser.LastLoginTime = new DateTime?(DateTime.Parse(dt.Rows[i]["LastLoginTime"].ToString())); } if (dt.Rows[i]["TotalNum"].ToString() != "") { sysopUser.TotalNum = new int?(int.Parse(dt.Rows[i]["TotalNum"].ToString())); } if (dt.Rows[i]["FailCount"].ToString() != "") { sysopUser.FailCount = new int?(int.Parse(dt.Rows[i]["FailCount"].ToString())); } if (dt.Rows[i]["OperateLevel"].ToString() != "") { sysopUser.OperateLevel = new int?(int.Parse(dt.Rows[i]["OperateLevel"].ToString())); } sysopUser.Note = dt.Rows[i]["Note"].ToString(); if (dt.Rows[i]["DisDate"].ToString() != "") { sysopUser.DisDate = new DateTime?(DateTime.Parse(dt.Rows[i]["DisDate"].ToString())); } if (dt.Rows[i]["Signature"].ToString() != "") { sysopUser.Signature = (byte[])dt.Rows[i]["Signature"]; } if (dt.Rows[i]["DisCountRate"].ToString() != "") { sysopUser.DisCountRate = new int?(int.Parse(dt.Rows[i]["DisCountRate"].ToString())); } if (dt.Rows[i]["Sex"].ToString() != "") { sysopUser.Sex = new int?(int.Parse(dt.Rows[i]["Sex"].ToString())); } if (dt.Rows[i]["Is_Del"].ToString() != "") { sysopUser.Is_Del = new int?(int.Parse(dt.Rows[i]["Is_Del"].ToString())); } if (dt.Rows[i]["VocationType"].ToString() != "") { sysopUser.VocationType = new int?(int.Parse(dt.Rows[i]["VocationType"].ToString())); } list.Add(sysopUser); } } return(list); }
public int UpdateLisCustFeeExamItem(long ID_Customer, int ID_Section, PEIS.Model.SYSOpUser LoginUserModel) { return(CommonCustExam.dal.UpdateLisCustFeeExamItem(ID_Customer, ID_Section, LoginUserModel)); }
public int UpdateSectionSummaryCheckState(PEIS.Model.SYSOpUser UserModel, int CheckState, List <int> IDList) { return(CommonCustExam.dal.UpdateSectionSummaryCheckState(UserModel, CheckState, IDList)); }