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