public Int32 Add(SoundBlog_NEW.Model.SB_Text model)
{
String SQLCmd = "insert into Text" +
"(Text_UserID,Text_Category,Text_Title,Text_Keyword,Text_Content,Text_Datetime,Text_CommentCount,Text_ReadCount)" +
" values " +
"(@Text_UserID,@Text_Category,@Text_Title,@Text_Keyword,@Text_Content,@Text_Datetime,@Text_CommentCount,@Text_ReadCount)";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@Text_UserID", MySqlDbType.Int32),
new MySqlParameter("@Text_Category", MySqlDbType.Int32),
new MySqlParameter("@Text_Title", MySqlDbType.String),
new MySqlParameter("@Text_Keyword", MySqlDbType.String),
new MySqlParameter("@Text_Content", MySqlDbType.String),
new MySqlParameter("@Text_Datetime", MySqlDbType.DateTime),
new MySqlParameter("@Text_CommentCount", MySqlDbType.Int32),
new MySqlParameter("@Text_ReadCount", MySqlDbType.Int32)
};
parameters[0].Value = model.Text_UserID;
parameters[1].Value = model.Text_Category;
parameters[2].Value = model.Text_Title;
parameters[3].Value = model.Text_Keyword;
parameters[4].Value = model.Text_Content;
parameters[5].Value = model.Text_Datetime;
parameters[6].Value = model.Text_CommentCount;
parameters[7].Value = model.Text_ReadCount;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Boolean IsExsit(SoundBlog_NEW.Model.SB_User model)
{
String SQLCmd = "select * from User where User_Email = @User_Email";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_Email", MySqlDbType.VarChar,50)
};
parameters[0].Value = model.User_Email;
MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters);
if (reader.HasRows)
{
return true;
}
return false;
}
public Int32 Add(SoundBlog_NEW.Model.SB_TextCate model)
{
String SQLCmd = "insert into TextCate" +
"(TextCate_ID,TextCate_UserID,TextCate_Name)" +
" values " +
"(@TextCate_ID,@TextCate_UserID,@TextCate_Name)";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@TextCate_ID", MySqlDbType.Int32),
new MySqlParameter("@TextCate_UserID", MySqlDbType.Int32),
new MySqlParameter("@TextCate_Name", MySqlDbType.String)
};
parameters[0].Value = model.TextCate_ID;
parameters[1].Value = model.TextCate_UserID;
parameters[2].Value = model.TextCate_Name;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Int32 GetID(SoundBlog_NEW.Model.SB_User model)
{
// 实现和IsExist基本相同
String SQLCmd = "select * from User where User_Email = @User_Email";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_Email", MySqlDbType.VarChar,50)
};
parameters[0].Value = model.User_Email;
MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters);
if (reader.HasRows)
{
reader.Read();
return reader.GetInt32(0);
}
return -1;
}
public Int32 Add(SoundBlog_NEW.Model.SB_Friend model)
{
String SQLCmd = "insert into Friend" +
"(Friend_MasterID,Friend_SlaveID,Friend_Datetime)" +
" values " +
"(@Friend_MasterID,@Friend_SlaveID,@Friend_Datetime)";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@Friend_MasterID", MySqlDbType.Int32),
new MySqlParameter("@Friend_SlaveID", MySqlDbType.Int32),
new MySqlParameter("@Friend_Datetime", MySqlDbType.DateTime)
};
parameters[0].Value = model.Friend_MasterID;
parameters[1].Value = model.Friend_SlaveID;
parameters[2].Value = model.Friend_Datetime;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Int32 Login(SoundBlog_NEW.Model.SB_User model)
{
model.User_Passwd = Encryptor.MD5Encrypt(model.User_OriginPsw);
String SQLCmd = "select * from User where " +
"User_Email = @User_Email and User_Passwd = @User_Passwd";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_Email", MySqlDbType.VarChar,50),
new MySqlParameter("@User_Passwd", MySqlDbType.VarChar,50)
};
parameters[0].Value = model.User_Email;
parameters[1].Value = model.User_Passwd;
MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters);
if (reader.HasRows)
{
return 1;
}
return 0;
}
public Int32 Add(SoundBlog_NEW.Model.SB_Comment model)
{
String SQLCmd = "insert into Comment" +
"(Comment_TargetTypeID,Comment_TargetID,Comment_UserID,Comment_Content,Comment_Datetime)" +
" values " +
"(@Comment_TargetTypeID,@Comment_TargetID,@Comment_UserID,@Comment_Content,@Comment_Datetime)";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@Comment_TargetTypeID", MySqlDbType.Int32),
new MySqlParameter("@Comment_TargetID", MySqlDbType.Int32),
new MySqlParameter("@Comment_UserID", MySqlDbType.Int32),
new MySqlParameter("@Comment_Content", MySqlDbType.VarChar),
new MySqlParameter("@Comment_Datetime", MySqlDbType.DateTime)
};
parameters[0].Value = model.Comment_TargetTypeID;
parameters[1].Value = model.Comment_TargetID;
parameters[2].Value = model.Comment_UserID;
parameters[3].Value = model.Comment_Content;
parameters[4].Value = model.Comment_Datetime;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Int32 Modify(SoundBlog_NEW.Model.SB_User model)
{
String SQLCmd = "update User set " +
"User_NickName = @User_NickName," +
"User_BlogName = @User_BlogName," +
"User_Email = @User_Email," +
"User_OriginPsw = @User_OriginPsw," +
"User_Passwd = @User_Passwd," +
"User_HeadPhoto = @User_HeadPhoto," +
"User_Remark = @User_Remark " +
"where User_ID = @User_ID";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_NickName", MySqlDbType.String),
new MySqlParameter("@User_BlogName", MySqlDbType.String),
new MySqlParameter("@User_Email", MySqlDbType.String),
new MySqlParameter("@User_OriginPsw", MySqlDbType.String),
new MySqlParameter("@User_Passwd", MySqlDbType.String),
new MySqlParameter("@User_HeadPhoto", MySqlDbType.String),
new MySqlParameter("@User_Remark", MySqlDbType.String),
new MySqlParameter("@User_ID", MySqlDbType.Int32)
};
model.User_Passwd = Encryptor.MD5Encrypt(model.User_OriginPsw);
parameters[0].Value = model.User_NickName;
parameters[1].Value = model.User_BlogName;
parameters[2].Value = model.User_Email;
parameters[3].Value = model.User_OriginPsw;
parameters[4].Value = model.User_Passwd;
parameters[5].Value = model.User_HeadPhoto;
parameters[6].Value = model.User_Remark;
parameters[7].Value = model.User_ID;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Int32 Modify(SoundBlog_NEW.Model.SB_Text model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_TextDAL().Modify(model);
}
public Int32 GetID(SoundBlog_NEW.Model.SB_Text model)
{
return 0;
}
public Int32 Add(SoundBlog_NEW.Model.SB_Friend model)
{
return Factory.DALFactory.CreateSB_FriendDAL().Add(model);
}
public Int32 GetID(SoundBlog_NEW.Model.SB_User model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_UserDAL().GetID(model);
}
public Int32 Add(SoundBlog_NEW.Model.SB_Comment model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_CommentDAL().Add(model);
}
public Int32 Modify(SoundBlog_NEW.Model.SB_Text model)
{
String SQLCmd = "update Text set " +
"Text_Category = @Text_Category,Text_Title = @Text_Title,Text_Content = @Text_Content " +
"where Text_ID = @Text_ID";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@Text_Category", MySqlDbType.Int32),
new MySqlParameter("@Text_Title", MySqlDbType.VarChar),
new MySqlParameter("@Text_Content", MySqlDbType.VarChar),
new MySqlParameter("@Text_ID", MySqlDbType.Int32,4)
};
parameters[0].Value = model.Text_Category;
parameters[1].Value = model.Text_Title;
parameters[2].Value = model.Text_Content;
parameters[3].Value = model.Text_ID;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Int32 Register(SoundBlog_NEW.Model.SB_User model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_UserDAL().Register(model);
}
public Int32 Login(SoundBlog_NEW.Model.SB_User model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_UserDAL().Login(model);
}
public Boolean IsExist(SoundBlog_NEW.Model.SB_User model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_UserDAL().IsExsit(model);
}
public Int32 Register(SoundBlog_NEW.Model.SB_User model)
{
if(IsExsit(model) == true)
{
return 0;
}
model.User_Passwd = Encryptor.MD5Encrypt(model.User_OriginPsw);
String SQLCmd = "insert into User" +
"(User_NickName,User_BlogName,User_Email,User_OriginPsw,User_Passwd,User_HeadPhoto,User_Datetime,User_UpDatetime,User_Remark)" +
" values " +
"(@User_NickName,@User_BlogName,@User_Email,@User_OriginPsw,@User_Passwd,@User_HeadPhoto,@User_Datetime,@User_UpDatetime,@User_Remark)";
MySqlParameter[] parameters = new MySqlParameter[]{
new MySqlParameter("@User_NickName", MySqlDbType.VarChar,50),
new MySqlParameter("@User_BlogName", MySqlDbType.VarChar,50),
new MySqlParameter("@User_Email", MySqlDbType.VarChar,50),
new MySqlParameter("@User_OriginPsw", MySqlDbType.VarChar,50),
new MySqlParameter("@User_Passwd", MySqlDbType.VarChar,50),
new MySqlParameter("@User_HeadPhoto", MySqlDbType.VarChar,50),
new MySqlParameter("@User_Datetime", MySqlDbType.DateTime),
new MySqlParameter("@User_UpDatetime", MySqlDbType.DateTime),
new MySqlParameter("@User_Remark", MySqlDbType.VarChar,200)
};
parameters[0].Value = model.User_NickName;
parameters[1].Value = model.User_BlogName;
parameters[2].Value = model.User_Email;
parameters[3].Value = model.User_OriginPsw;
parameters[4].Value = model.User_Passwd;
parameters[5].Value = model.User_HeadPhoto;
parameters[6].Value = model.User_Datetime;
parameters[7].Value = model.User_UpDatetime;
parameters[8].Value = model.User_Remark;
return MySqlHelper.ExecuteSQLNonQuery(SQLCmd, parameters);
}
public Int32 Add(SoundBlog_NEW.Model.SB_TextCate model)
{
return SoundBlog_NEW.Factory.DALFactory.CreateSB_TextCateDAL().Add(model);
}
