/// <summary>
/// 上班
/// </summary>
public static void StartWork(SimulatorBase sender, CheckpointArgs args)
{
((Staff)sender).IsWorking = true;
StaffSQLController.CheckSql((Staff)sender, true);
Debug.WriteLine(((Staff)sender).StaffName + "上班！");
SimulatorTimer.SpeedSetNormal();
}
public Loader(LoginController loginController)
{
if (loginController.IsCorrespond)
{
StaffList = StaffSQLController.GenerateStaffList();
StudioList = StudioSQLController.GenerateStudioList(this);
PlayerTarget = PlayerSqlController.ReadPlayerInfoSql(loginController.PlayerNumber, true, this);
// 资源加载完毕
IsLoaded = true;
}
}
/// <summary>
/// 下班
/// </summary>
public static void QuitWork(SimulatorBase sender, CheckpointArgs args)
{
var staff = (Staff)sender;
staff.IsWorking = false;
StaffSQLController.CheckSql(staff, false);
Debug.WriteLine(((Staff)sender).StaffName + "下班！");
if (staff.StaffStudioObject.FindWorkingStaffs().Count == 0)
{
SimulatorTimer.SpeedSetQuick();
}
}
/// <summary>
/// 从数据库中读取游戏数据并生成实例，员工信息从工作室中抓取
/// </summary>
/// <param name="gameNumber"></param>
/// <returns></returns>
public static Models.Game.Game ReadGameInfoFromStudioSql(string gameNumber, Models.Studio.Studio studio, Loader loader)
{
Models.Game.Game game = null;
using (var sqlConnection = new SqlConnection(ConString))
{
// 使用了Target占位符表示目标ID
var sqlCommand = new SqlCommand("SELECT * FROM GameInfo WHERE GameNumber = @Target", sqlConnection);
// 构造Parameter对象
var targetSqlParameter = new SqlParameter("@Target", SqlDbType.VarChar, 255);
targetSqlParameter.Value = gameNumber;
sqlCommand.Parameters.Add(targetSqlParameter);
sqlConnection.Open();
var result = sqlCommand.ExecuteReader();
if (result.HasRows)
{
result.Read();
game = new Models.Game.Game(result["GameNumber"].ToString(),
result["GameName"].ToString(),
int.Parse(result["GamePrice"].ToString()),
int.Parse(result["GameFun"].ToString()),
int.Parse(result["GameArt"].ToString()),
int.Parse(result["GameMusic"].ToString()),
int.Parse(result["GameSales"].ToString()),
result["GameStudio"].ToString(),
(Genres)int.Parse(result["GameGenres"].ToString()),
Convert.ToBoolean(int.Parse(result["GameIsDeveloping"].ToString()))
);
game.GameStartDevelopTime = DateTime.Parse(result["GameStartDevelopTime"].ToString());
game.GameFinishDevelopTime = DateTime.Parse(result["GameFinishDevelopTime"].ToString());
game.Developers = StaffSQLController.GetDevelopersListFromStudioSql(game.GameNumber, studio, loader);
game.GameStudioObject = studio;
}
result.Close();
}
return(game);
}
private void Show()
{
var staff = StaffSQLController.ReadStaffInfoSql("1");
// Response.Write("<script>alert('" + staff.ToString() + "')</script>");
}
public static int[] GetStaffCheckArray(bool isWork) => _talkStaff == null ? new int[24] : StaffSQLController.GetStaffCheckTimesArray(_talkStaff, isWork);
public static int GetStaffCheck(int hour, bool isWork) => _talkStaff == null ? 0 : StaffSQLController.GetStaffCheckTimes(_talkStaff, hour, isWork);
