private void SaveLoginInfo(LoginInfo lgi) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", lgi.User == null ? "-1" : lgi.User.UserName), new SqlParameter("@ServerIP", lgi.ServerIP), new SqlParameter("@ServerName", lgi.ServerName), new SqlParameter("@ClientIP", lgi.ClientIP), new SqlParameter("@ClientName", lgi.ClientName), new SqlParameter("@LoginPort", lgi.LoginPort), new SqlParameter("@LogMessage", lgi.Message), new SqlParameter("@Status", lgi.Status.GetHashCode()) }; int iLogID = (int)DataProvider.ExecuteScalar <decimal>("usp_Login", parameters); if (iLogID > 0) { lgi.SessionID = iLogID; lgi.ID = iLogID; } else { throw new ApplicationException("数据库操作失败。"); } }
public CommandResult GetUserByName(string name) { CommandResult res = new CommandResult(); try { string str = string.Format("select count(*) from EAP_User where UserName='******'", name); res.IntResult = DataProvider.ExecuteScalar <int>(str); }catch (Exception e) { res.IntResult = 0; res.Message = e.Message; } return(res); }
public CommandResult ChangePassword(int userID, string oldPassword, string newPass) { //var t = DESEncrypt.Encrypt("test"); //var t1 = DESEncrypt.Decrypt(t); CommandResult result = new CommandResult(); //SqlParameter outputPar = new SqlParameter("@Output", "") { Direction = System.Data.ParameterDirection.InputOutput,Size=32 }; //SqlParameter resultPar = new SqlParameter("@Result", 1) { Direction = System.Data.ParameterDirection.InputOutput }; //SqlParameter[] parameters = new SqlParameter[] { // new SqlParameter("@UserID",userID), // new SqlParameter("@OldPass",DESEncrypt.Encrypt(oldPassword)), // new SqlParameter("@NewPass",DESEncrypt.Encrypt(newPass)), // resultPar,outputPar //}; //DataProvider.ExecuteNonQuery("usp_ChangePassword", parameters); //result.Result = (int)resultPar.Value == 1; //result.Message = outputPar.Value.ToString(); //return result; var sql = string.Format("select [PASSWORD] from EAP_User where ID={0} ", userID); var pass = DataProvider.ExecuteScalar <string>(sql); if (DESEncrypt.Decrypt(pass) == oldPassword) { result.Result = true; sql = string.Format("update EAP_User set [PASSWORD]='{1}' where ID={0}", userID, DESEncrypt.Encrypt(newPass)); DataProvider.ExecuteNonQuery(sql); result.Message = "密码修改成功"; } else { result.Result = false; result.Message = "原密码不正确"; } return(result); }
public CommandResult AddRole(EAP_Role role) { CommandResult result = new CommandResult(); result.Result = false; string sFields = ""; string sValues = ""; if (role.Items.Count <= 0) { return(result); } /* * role.Items.ForEach(e => * { * if (!string.IsNullOrEmpty(e.K) && e.S == EntityStatus.New) * { * sFields += string.Format("[{0}],", e.K); * sValues += string.Format("'{0}',", e.V); * } * }); * */ string sql = string.Format("select count(*) from EAP_Role where RoleName='{0}'", role.RoleName); /* * string sSql = string.Format( * "INSERT INTO EAP_Role({0}) VALUES({1});SELECT CAST(scope_identity() AS int);", * sFields.Trim().TrimEnd(','), * sValues.Trim().TrimEnd(',')); * int count = DataProvider.ExecuteScalar<int>(sql); */ int count = (int)DataProvider.ExecuteScalar <decimal>(sql); if (count <= 0) { // int iPID = DataProvider.ExecuteScalar<int>(sSql); int iPID = DataProvider.DoInsert(role, "EAP_Role", true, null); if (iPID > 0) { result.Result = true; result.ReturnValue.Add(new LookupDataItem() { K = "ID", V = iPID.ToString() }); result.Message = "新增成功。"; } else { result.Result = false; result.Message = "新增失败。"; } } else { result.Result = false; result.IntResult = 1; result.Message = "该角色已经存在。"; } return(result); }