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