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