/// <summary> /// 根据传入Model更新数据并返回更新后的Model /// </summary> public int Update(UserWebFolder userWebFolder) { string sql = "UPDATE tblUserWebFolder " + "SET " + " WebFolderName = @WebFolderName" + ", UserInfoID = @UserInfoID" + ", CreateTime = @CreateTime" + ", Grade = @Grade" + ", ParentWebfolderID = @ParentWebfolderID" + ", IntroContent = @IntroContent" + ", IElementJSON = @IElementJSON" + ", IElementHashcode = @IElementHashcode" + " WHERE UserWebFolderID = @UserWebFolderID"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@UserWebFolderID", userWebFolder.UserWebFolderID) , new MySqlParameter("@WebFolderName", ToDBValue(userWebFolder.WebFolderName)) , new MySqlParameter("@UserInfoID", ToDBValue(userWebFolder.UserInfoID)) , new MySqlParameter("@CreateTime", ToDBValue(userWebFolder.CreateTime)) , new MySqlParameter("@Grade", ToDBValue(userWebFolder.Grade)) , new MySqlParameter("@ParentWebfolderID", ToDBValue(userWebFolder.ParentWebfolderID)) , new MySqlParameter("@IntroContent", ToDBValue(userWebFolder.IntroContent)) , new MySqlParameter("@IElementJSON", ToDBValue(userWebFolder.IElementJSON)) , new MySqlParameter("@IElementHashcode", ToDBValue(userWebFolder.IElementHashcode)) }; return(MyDBHelper.ExecuteNonQuery(sql, para)); }
/// <summary> /// 根据传入Model,并返回Model /// </summary> public bool Add(UserWebFolder userWebFolder) { string sql = "INSERT INTO tblUserWebFolder (WebFolderName, UserInfoID, CreateTime, Grade, ParentWebfolderID, IntroContent, IElementJSON, IElementHashcode) VALUES (@WebFolderName, @UserInfoID, @CreateTime, @Grade, @ParentWebfolderID, @IntroContent, @IElementJSON, @IElementHashcode)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@WebFolderName", ToDBValue(userWebFolder.WebFolderName)), new MySqlParameter("@UserInfoID", ToDBValue(userWebFolder.UserInfoID)), new MySqlParameter("@CreateTime", ToDBValue(userWebFolder.CreateTime)), new MySqlParameter("@Grade", ToDBValue(userWebFolder.Grade)), new MySqlParameter("@ParentWebfolderID", ToDBValue(userWebFolder.ParentWebfolderID)), new MySqlParameter("@IntroContent", ToDBValue(userWebFolder.IntroContent)), new MySqlParameter("@IElementJSON", ToDBValue(userWebFolder.IElementJSON)), new MySqlParameter("@IElementHashcode", ToDBValue(userWebFolder.IElementHashcode)), }; int AddId = (int)MyDBHelper.ExecuteScalar(sql, para); if (AddId == 1) { return(true); } else { return(false); } }
public BizUserWebFolder(UserWebFolder dataInfo) { UserWebFolderID = dataInfo.UserWebFolderID; WebFolderName = dataInfo.WebFolderName; UserInfoID = dataInfo.UserInfoID; CreateTime = dataInfo.CreateTime; Grade = dataInfo.Grade; ParentWebfolderID = dataInfo.ParentWebfolderID; IntroContent = dataInfo.IntroContent; IElementJSON = dataInfo.IElementJSON; IElementHashcode = dataInfo.IElementHashcode; }
/// <summary> /// 把DataRow转换成Model /// </summary> public UserWebFolder ToModel(MySqlDataReader dr) { UserWebFolder userWebFolder = new UserWebFolder(); userWebFolder.UserWebFolderID = (long)ToModelValue(dr, "UserWebFolderID"); userWebFolder.WebFolderName = (string)ToModelValue(dr, "WebFolderName"); userWebFolder.UserInfoID = (long)ToModelValue(dr, "UserInfoID"); userWebFolder.CreateTime = (DateTime)ToModelValue(dr, "CreateTime"); userWebFolder.Grade = (int)ToModelValue(dr, "Grade"); userWebFolder.ParentWebfolderID = (long)ToModelValue(dr, "ParentWebfolderID"); userWebFolder.IntroContent = (string)ToModelValue(dr, "IntroContent"); userWebFolder.IElementJSON = (string)ToModelValue(dr, "IElementJSON"); userWebFolder.IElementHashcode = (int)ToModelValue(dr, "IElementHashcode"); return(userWebFolder); }
public int Update(UserWebFolder userWebFolder) { return(new UserWebFolderDAL().Update(userWebFolder)); }
public bool UserWebFolderAdd(UserWebFolder userWebFolder) { return(new UserWebFolderDAL().Add(userWebFolder)); }