static int TestLogin()
{
SoundBlog_NEW.Model.SB_User model = new SoundBlog_NEW.Model.SB_User();
model.User_OriginPsw = "12344456";
model.User_Email = "*****@*****.**";
return SoundBlog_NEW.Factory.BLLFactory.CreateSB_UserBLL().Login(model);
}
public SoundBlog_NEW.Model.SB_User GetByID(Int32 ID)
{
String SQLCmd = "select * from User where " +
"User_ID = @User_ID";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_ID",MySqlDbType.Int32)
};
parameters[0].Value = ID;
MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters);
SoundBlog_NEW.Model.SB_User model = new SoundBlog_NEW.Model.SB_User(); ;
while (reader.Read())
{
model.User_ID = (Int32)reader["User_ID"];
model.User_BlogName = (String)reader["User_BlogName"];
model.User_Datetime = (DateTime)reader["User_Datetime"];
model.User_Email = (String)reader["User_Email"];
model.User_HeadPhoto = (String)reader["User_HeadPhoto"];
model.User_NickName = (String)reader["User_NickName"];
model.User_OriginPsw = (String)reader["User_OriginPsw"];
model.User_Passwd = (String)reader["User_Passwd"];
model.User_Remark = (String)reader["User_Remark"];
model.User_UpDatetime = (DateTime)reader["User_UpDatetime"];
}
return model;
}
static int TestRegister()
{
SoundBlog_NEW.Model.SB_User model = new SoundBlog_NEW.Model.SB_User();
model.User_BlogName = "Wangxu";
//model.User_NickName = "NickName";
//model.User_Passwd = "1234";
model.User_OriginPsw = "12344456";
//model.User_Datetime = DateTime.Now;
//model.User_UpDatetime = DateTime.Now;
model.User_Email = "*****@*****.**";
//model.User_HeadPhoto = "";
//model.User_Remark = "";
return SoundBlog_NEW.Factory.BLLFactory.CreateSB_UserBLL().Register(model);
}
private IList<SoundBlog_NEW.Model.SB_User> _GetListHelper(String SQLCmd, MySqlParameter[] parameters)
{
MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters);
IList<SoundBlog_NEW.Model.SB_User> models = new List<SoundBlog_NEW.Model.SB_User>();
while (reader.Read())
{
SoundBlog_NEW.Model.SB_User model = new SoundBlog_NEW.Model.SB_User(); ;
model.User_ID = (Int32)reader["User_ID"];
model.User_BlogName = (String)reader["User_BlogName"];
model.User_Datetime = (DateTime)reader["User_Datetime"];
model.User_Email = (String)reader["User_Email"];
model.User_HeadPhoto = (String)reader["User_HeadPhoto"];
model.User_NickName = (String)reader["User_NickName"];
model.User_OriginPsw = (String)reader["User_OriginPsw"];
model.User_Passwd = (String)reader["User_Passwd"];
model.User_Remark = (String)reader["User_Remark"];
model.User_UpDatetime = (DateTime)reader["User_UpDatetime"];
models.Add(model);
}
return models;
}
