public int Register(string UserName, string Password) { BaseDatabaseWarpper.CheckParamter("userName", UserName); BaseDatabaseWarpper.CheckParamter("password", Password); using (var Warpper = this.CreateDatabaseWarpper()) { var trans = Warpper.Connection.BeginTransaction(); try { if (Warpper.ContainsUserNameWorkProc(UserName, trans)) { throw new RegisterUserSameNameException(); } Warpper.ExcuteCommand(CreateRegisterUserInsertSql(UserName, Password), trans); } catch (RegisterUserSameNameException ex) { trans.Rollback(); LogUtil.Error(ex.Message, ex); throw ex; } catch (Exception ex) { trans.Rollback(); LogUtil.Error(ex.Message, ex); throw ex; } trans.Commit(); return(0); } }
public static string CreateRegisterUserInsertSql(string userName, string Password) { BaseDatabaseWarpper.CheckParamter("userName", userName); BaseDatabaseWarpper.CheckParamter("Password", Password); return(string.Format("INSERT INTO USER_TABLE (USERID,PASSWORD) VALUES ({0},{1})", BaseDatabaseWarpper.GetSafeString(userName), BaseDatabaseWarpper.GetSafeString(getSafePassword(Password)))); }
public static string CreateCheckLogonSql(string userName, string Password) { return(string.Format("SELECT COUNT(*) FROM USER_TABLE WHERE USERID={0} AND PASSWORD={1}", BaseDatabaseWarpper.GetSafeString(userName), BaseDatabaseWarpper.GetSafeString(Password))); }