private static ListedAccount ReadAccount(System.Data.Common.DbDataReader reader)
{
return(new ListedAccount()
{
ProtectionId = reader.GetInt64("protection"),
AccountName = reader.GetString("account"),
Reason = reader.GetString("reason")
});
}
public static long?GetReaderValueInt64(System.Data.Common.DbDataReader reader, string name)
{
var ordinal = reader.GetOrdinal(name);
if (reader.IsDBNull(ordinal))
{
return(null);
}
try
{
return(reader.GetInt64(ordinal));
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
protected override void BeforeStarting()
{
MySqlHelper db = DbHelper.CreateMySqlHelper("host=localhost;database=liba_user;uid=root;pwd=123456;charset=utf8") as MySqlHelper;
using (System.Data.Common.DbDataReader reader = db.ExecuteReader("SELECT uid,uname from users where email='' order by uid asc", System.Data.CommandBehavior.CloseConnection))
{
//and uname REGEXP('^[0-9a-z_-]+$')
while (reader.Read())
{
string uid = reader.GetInt64(0).ToString();
string uname = reader.GetString(1).Trim();
FinalUrl url = Url.CreateFinalUrl(String.Format("http://bbs.sh.libaclub.com/sendpass.php?action=sendme&username1={0}&id={1}", System.Web.HttpUtility.UrlEncode(Encoding.Default.GetBytes(uname)), uid), null) as FinalUrl;
url.UriEscape = false;
if (null != url)
{
url.ContentHandlers.Add(new Libahander2());
this.ManualQueue(url, false);
}
}
}
}
/// <summary>
/// Gets an int64 column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static Int64?GetNInt64(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (long?)null : reader.GetInt64(ordinal));
}
/// <summary>
/// Gets an int64 column. Slower then GetOrdinal + GetInt64
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Int64?GetNInt64(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (long?)null : reader.GetInt64(ordinal));
}