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