/// <summary>
/// 把DataRow转换成Model
/// </summary>
public UserWebBookmarkImportLog ToModel(MySqlDataReader dr)
{
UserWebBookmarkImportLog userWebBookmarkImportLog = new UserWebBookmarkImportLog();
userWebBookmarkImportLog.UserWebBookmarkImportLogID = (long)ToModelValue(dr, "UserWebBookmarkImportLogID");
userWebBookmarkImportLog.UserInfoID = (long)ToModelValue(dr, "UserInfoID");
userWebBookmarkImportLog.Path = (string)ToModelValue(dr, "Path");
userWebBookmarkImportLog.FileName = (string)ToModelValue(dr, "FileName");
userWebBookmarkImportLog.CreateTime = (DateTime)ToModelValue(dr, "CreateTime");
return(userWebBookmarkImportLog);
}
public BizUserWebBookmarkImportLog(UserWebBookmarkImportLog dataInfo)
{
if (dataInfo == null)
{
return;
}
UserInfoID = dataInfo.UserInfoID;
UserWebBookmarkImportLogID = dataInfo.UserWebBookmarkImportLogID;
Path = dataInfo.Path;
FileName = dataInfo.FileName;
CreateTime = dataInfo.CreateTime;
}
/// <summary>
/// 根据传入Model，并返回Model
/// </summary>
public bool Add(UserWebBookmarkImportLog userWebBookmarkImportLog)
{
string sql = "INSERT INTO tblUserWebBookmarkImportLog (UserInfoID, Path, FileName, CreateTime) VALUES (@UserInfoID, @Path, @FileName, @CreateTime)";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@UserInfoID", ToDBValue(userWebBookmarkImportLog.UserInfoID)),
new MySqlParameter("@Path", ToDBValue(userWebBookmarkImportLog.Path)),
new MySqlParameter("@FileName", ToDBValue(userWebBookmarkImportLog.FileName)),
new MySqlParameter("@CreateTime", ToDBValue(userWebBookmarkImportLog.CreateTime)),
};
int AddId = (int)MyDBHelper.ExecuteScalar(sql, para);
if (AddId == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据传入Model更新数据并返回更新后的Model
/// </summary>
public int Update(UserWebBookmarkImportLog userWebBookmarkImportLog)
{
string sql =
"UPDATE tblUserWebBookmarkImportLog " +
"SET " +
" UserInfoID = @UserInfoID"
+ ", Path = @Path"
+ ", FileName = @FileName"
+ ", CreateTime = @CreateTime"
+ " WHERE UserWebBookmarkImportLogID = @UserWebBookmarkImportLogID";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@UserWebBookmarkImportLogID", userWebBookmarkImportLog.UserWebBookmarkImportLogID)
, new MySqlParameter("@UserInfoID", ToDBValue(userWebBookmarkImportLog.UserInfoID))
, new MySqlParameter("@Path", ToDBValue(userWebBookmarkImportLog.Path))
, new MySqlParameter("@FileName", ToDBValue(userWebBookmarkImportLog.FileName))
, new MySqlParameter("@CreateTime", ToDBValue(userWebBookmarkImportLog.CreateTime))
};
return(MyDBHelper.ExecuteNonQuery(sql, para));
}
public int Update(UserWebBookmarkImportLog userWebBookmarkImportLog)
{
return(new UserWebBookmarkImportLogDAL().Update(userWebBookmarkImportLog));
}
public bool UserWebBookmarkImportLogAdd(UserWebBookmarkImportLog userWebBookmarkImportLog)
{
return(new UserWebBookmarkImportLogDAL().Add(userWebBookmarkImportLog));
}
