/// <summary>
/// 向Studio中填充游戏
/// </summary>
/// <param name="studio"></param>
public static void FillStudioGameSql(Models.Studio.Studio studio, Loader loader)
{
using (var sqlConnection = new SqlConnection(ConString))
{
// 使用了Target占位符表示目标ID
var sqlCommand = new SqlCommand("SELECT GameNumber FROM GameInfo WHERE GameStudio = @Target", sqlConnection);
// 构造Parameter对象
var targetSqlParameter = new SqlParameter("@Target", SqlDbType.VarChar, 255);
targetSqlParameter.Value = studio.StudioNumber;
sqlCommand.Parameters.Add(targetSqlParameter);
sqlConnection.Open();
var result = sqlCommand.ExecuteReader();
while (result.Read())
{
Models.Game.Game game = GameSQLController.ReadGameInfoFromStudioSql(result["GameNumber"].ToString(), studio, loader);
if (game.GameIsDeveloping)
{
studio.AddDevelopingGame(game);
}
else
{
studio.AddDevelopedGame(game);
// game.StartSales();
}
}
result.Close();
}
}
/// <summary> /// 向SQL更新实例 /// </summary> public void UpdateSql() => GameSQLController.UpdateGameInfoSql(GameSQLController.ReadGameInfoSql(this.GameNumber), this);
