// Use this for initialization void Start() { CO = GetComponent<ClickObject>(); MD = (GameObject.Find("/Main")).GetComponent<MainData>(); tog = false; dt = 0f; }
// Use this for initialization void Awake() { if (dataCenter == null) { dataCenter = gameObject.GetComponent<DataCenter>(); ins = this; GameObject.DontDestroyOnLoad (gameObject); } else if (dataCenter != gameObject.GetComponent<DataCenter>() ) { Destroy(gameObject); //Debug.Log ("hello"); //Debug.Log ("ins:"+ins.GetInstanceID()+" dataCenter:"+dataCenter.GetInstanceID() ); } }
static void Main() { #if !DEBUG Application.ThreadException += new System.Threading.ThreadExceptionEventHandler(Program.OnThreadException); #endif Program.DataPath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\IssueTimeTracker\\Data\\"; if (File.Exists(Path.Combine(Program.DataPath, "CurrentVersion.xml")) && !File.Exists(Path.Combine(Program.DataPath, "CurrentVersion.json"))) { Serializer <Update> .WriteToJSONFile(Serializer <Update> .LoadFromXMLFile(Path.Combine(Program.DataPath, "CurrentVersion.xml")), Path.Combine(Program.DataPath, "CurrentVersion.json")); } if (File.Exists(Path.Combine(Program.DataPath, "Settings.xml"))) { Setting.Load("xml"); NeedsConversiontoJSON = true; } else { Setting.Load(); } AdminControl.Load(); MainData.Init(); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); if (!NeedsConversiontoJSON) { if (!File.Exists(Path.Combine(Program.DataPath, "CurrentVersion.json")) || Setting.Value.General_CurrentVersion == null || isNewer(Setting.Value.General_CurrentVersion, Program.GetUpdateFile(Path.Combine(Program.DataPath, "CurrentVersion.json")).Version)) { Setting.Value.General_FirstTimeAfterUpdate = true; if (File.Exists(Path.Combine(Program.DataPath, "CurrentVersion.json"))) { Setting.Value.General_CurrentVersion = Program.GetUpdateFile(Path.Combine(Program.DataPath, "CurrentVersion.json")).Version; } else { Setting.Value.General_CurrentVersion = FileVersionInfo.GetVersionInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).FileVersion; } } else { Setting.Value.General_FirstTimeAfterUpdate = false; } } else { UpdateToOnePointSeven(); return; } if (Setting.Value.General_FirstTimeAfterUpdate) { if (Directory.Exists(Path.Combine(DataPath, "ErrorLog"))) { foreach (string s in Directory.GetFiles(Path.Combine(DataPath, "ErrorLog"))) { File.Delete(s); } } } try { if (!Directory.Exists(Program.DataPath)) { Directory.CreateDirectory(Program.DataPath); } if (!Directory.Exists(Program.DataPath + "\\TaskData\\")) { Directory.CreateDirectory(Program.DataPath + "\\TaskData\\"); } if (!Directory.Exists(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Tasks\\")) { Directory.CreateDirectory(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Tasks\\"); } } catch { MessageBox.Show("Please run as Administrator for setup"); } WebClient wc = new WebClient(); if (CheckForInternetConnection() && File.Exists(Path.Combine(DataPath, "CurrentVersion.json")) && isNewer(GetUpdateFile(Path.Combine(DataPath, "CurrentVersion.json")).Version, getLatestVersion(wc))) { string updater = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\IssueTimeTracker\\IssueTimeTrackerUpdater.exe"; try { if (File.Exists(updater)) { File.Delete(updater); } wc.DownloadFile(MainData.Instance.Domain + "IssueTimeTracker/IssueTimeTrackerUpdater.exe", updater); } catch { } if (File.Exists(updater)) { Process.Start(updater); } } if (Setting.Value.General_FirstTime) { Application.Run(new FirstTimeSetup()); } Setting.Value.General_FirstTimeAfterUpdate = false; Setting.Save(); /*if (Properties.Settings.Default.Timer_TestStyle) * Application.Run(new TestIssueTimeTracker()); * else*/ //if (Setting.Value.Timer_Themes) Application.Run(new ThemedMain()); //else // Application.Run(new Main()); }
void OnDestroy() { instance = null; }
private void subManualLPM_Load(object sender, EventArgs e) { _Main = MainData.Instance; }
/// <summary> /// 多次关联主表和分表的数据 /// </summary> /// <typeparam name="M">主表类</typeparam> /// <typeparam name="C">关联值</typeparam> /// <param name="mainList">主表数据集合</param> /// <param name="mainData">主表主键委托</param> /// <returns>返回多次关联管理对象</returns> public static MultiRelation <M, C> RelationList <M, C>(List <M> mainList, MainData <M, C> mainData) { return(new MultiRelation <M, C>(mainList, mainData)); }
// Use this for initialization void Start() { MD = (GameObject.Find("/Main")).GetComponent<MainData>(); }
// Use this for initialization void Start() { /* 注册请求 */ mGameHandle = new GameHandle(); NetCore.Instance.registHandle(mGameHandle); mGameControler = GetComponent <GameControler>(); mGameControler.mGameHandle = mGameHandle; mButtonControler = GetComponent <ButtonControler>(); mButtonControler.mGameHandle = mGameHandle; mChatControler = GetComponent <ChatControler>(); mChatControler.mGameHandle = mGameHandle; // 初始化房间信息 InitRoomInfo(); // 通知更新牌桌(换桌的时候会通知一次) NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_get_table_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_get_table_ack, (roomGetTableAck) => { NetProto.RoomGetTableAck roomGetTableAction = (NetProto.RoomGetTableAck)roomGetTableAck; MainData.Instance().tableInfo = roomGetTableAction.Table; foreach (var playerInfo in roomGetTableAction.Table.Players) { if (UserManager.Instance().authModel.user_id == playerInfo.Id) { MainData.Instance().selfInfo = playerInfo; break; } } // 重置UI mGameControler.ResetUIAfterChangeTable(); // 初始化房间信息 InitRoomInfo(); // 隐藏换桌加载组件 mGameControler.SetChangeTableLoadingActive(false); }); // 玩家加入游戏 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_join_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_join_ack, (roomPlayerJoinAck) => { RoomPlayerJoinAck roomPlayerJoinAction = (RoomPlayerJoinAck)roomPlayerJoinAck; // 更新玩家信息 mGameControler.UpdateAfterPlayerJoin(roomPlayerJoinAction.Player); }); // 玩家离开游戏 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_gone_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_gone_ack, (roomPlayerGoneAck) => { RoomPlayerGoneAck roomPlayerGoneAction = (RoomPlayerGoneAck)roomPlayerGoneAck; // 更新玩家信息 mGameControler.UpdateAfterPlayerGone(roomPlayerGoneAction.Player); }); // 通报庄家 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_button_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_button_ack, (roomButtonAck) => { RoomButtonAck roomButtonAction = (RoomButtonAck)roomButtonAck; // 设置庄家 mGameControler.SetDealer(roomButtonAction.ButtonPos); }); // 发牌 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_deal_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_deal_ack, (roomDealAck) => { RoomDealAck roomDealAction = (RoomDealAck)roomDealAck; string cardType = CardInfoUtil.GetCardType(roomDealAction.HandLevel); switch (roomDealAction.Action) { case CardInfoUtil.ACTION_PREFLOP: mGameControler.DealHandCard(roomDealAction.Cards, cardType); break; case CardInfoUtil.ACTION_FLOP: mGameControler.DealPublicCard(roomDealAction.Cards, cardType); break; case CardInfoUtil.ACTION_TURN: mGameControler.DealPublicCard(roomDealAction.Cards, cardType); break; case CardInfoUtil.ACTION_RIVER: mGameControler.DealPublicCard(roomDealAction.Cards, cardType); break; default: break; } }); // 通报当前下注玩家 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_action_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_action_ack, (roomActionAck) => { RoomActionAck roomActionAction = (RoomActionAck)roomActionAck; mGameControler.TurnNext(roomActionAction.Pos, roomActionAction.BaseBet); }); // 玩家押注 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_bet_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_bet_ack, (roomPlayerBetAck) => { RoomPlayerBetAck roomPlayerBetAction = (RoomPlayerBetAck)roomPlayerBetAck; if (roomPlayerBetAction.Action.Equals(PlayerInfoUtil.ACTION_FLOD)) { mGameControler.Discard(roomPlayerBetAction.Pos); } else { mGameControler.PlayerBetting(roomPlayerBetAction); } }); // 通报底池 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_pot_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_pot_ack, (roomPotAck) => { roomPotAckAction = (RoomPotAck)roomPotAck; Invoke("RoomPot", 0.5f); }); // 摊牌比牌 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_showdown_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_showdown_ack, (roomShowdownAck) => { RoomShowdownAck roomShowdownAction = (RoomShowdownAck)roomShowdownAck; mGameControler.GameOver(roomShowdownAction); }); // 通报玩家站起 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_standup_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_standup_ack, (roomPlayerStandupAck) => { RoomPlayerStandupAck roomPlayerStandupAction = (RoomPlayerStandupAck)roomPlayerStandupAck; // 更新玩家信息 mGameControler.UpdateAfterPlayerStandUp(roomPlayerStandupAction); }); // 通报玩家坐下 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_sitdown_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_sitdown_ack, (roomPlayerSitdownAck) => { RoomPlayerSitdownAck roomPlayerSitdownAction = (RoomPlayerSitdownAck)roomPlayerSitdownAck; // 更新玩家信息 mGameControler.UpdateAfterPlayerSitDown(roomPlayerSitdownAction.Player); }); // 自动坐下等待玩家数通报 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_player_auto_sitdown_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_player_auto_sitdown_ack, (roomPlayerAutoSitdownAck) => { RoomPlayerAutoSitdownAck roomPlayerAutoSitdownAction = (RoomPlayerAutoSitdownAck)roomPlayerAutoSitdownAck; mButtonControler.UpdateWaitCount(roomPlayerAutoSitdownAction.Num); }); // 踢出玩家 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_kicked_outAck); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_kicked_outAck, (kickedOutAck) => { KickedOutAck kickedOutAction = (KickedOutAck)kickedOutAck; }); // 关闭牌桌,服务进行维护时通报 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_shutdown_table_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_shutdown_table_ack, (roomShutdownTableAck) => { Application.LoadLevel("main"); }); // 牌桌聊天消息回复 NetCore.Instance.setActionForever(NetProto.Api.ENetMsgId.room_table_chat_ack); NetCore.Instance.RegisterAction(NetProto.Api.ENetMsgId.room_table_chat_ack, (roomTableChatAck) => { RoomTableChatAck roomTableChatAction = (RoomTableChatAck)roomTableChatAck; mChatControler.AddMessage(roomTableChatAction.Body.ToByteArray()); }); }
public void ChangePlayer(string inPlayer) { MainData.GetInstance().ChangeMainPlayer(inPlayer); UpdateHUD(); }
private void btnSalvar_Click(object sender, EventArgs e) { bool isOperationOK = true; SqlCommand comm; errorProvider1.Clear(); if (txtNome.Text.Length == 0) { errorProvider1.SetError(txtNome, "O campo deve estar preenchido!"); return; } if (txtEndereco.Text.Length == 0) { errorProvider1.SetError(txtEndereco, "O campo deve estar preenchido!"); return; } if (msktxtTelefone.Text.Length > 0 && !msktxtTelefone.MaskCompleted) { errorProvider1.SetError(msktxtTelefone, "O campo deve estar completamente preenchido!"); return; } if (msktxtCPF.Text.Length > 0 && (!msktxtCPF.MaskFull || !MainData.isCPF(msktxtCPF.Text.Substring(0, 3) + "." + msktxtCPF.Text.Substring(3, 3) + "." + msktxtCPF.Text.Substring(6, 3) + "-" + msktxtCPF.Text.Substring(9, 2)))) { errorProvider1.SetError(msktxtCPF, "O campo deve estar completamente preenchido e válido!"); return; } if (clienteID == 0) { SqlDataReader reader; SqlCommand qrySearch = new SqlCommand("SELECT count(*) Cont FROM Cliente WHERE Nome = @Nome", conn); qrySearch.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); qrySearch.Parameters["@Nome"].Value = txtNome.Text; try { try { conn.Open(); } catch (Exception error) { MessageBox.Show(error.Message, "Erro ao abrir conexão com o BD!", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { reader = qrySearch.ExecuteReader(); if (reader.Read()) { if (Convert.ToInt32(reader["Cont"].ToString()) > 0) { MessageBox.Show("Este cliente já existe!", "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } reader.Close(); } catch (Exception error) { MessageBox.Show(error.Message, "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { } finally { conn.Close(); } comm = new SqlCommand("INSERT INTO Cliente (Nome, Endereco, Cidade_ID, DataNascimento, Email, Telefone, Cpf) " + "VALUES (@Nome, @Endereco, @Cidade_ID, @DataNascimento, @Email, @Telefone, @Cpf)", conn); } else { comm = new SqlCommand("UPDATE Cliente SET Nome = @Nome, Endereco = @Endereco, Cidade_ID = @Cidade_ID, DataNascimento = @DataNascimento, " + "Email = @Email, Telefone = @Telefone, Cpf = @Cpf WHERE cliente_id = @Codigo", conn); comm.Parameters.Add("@Codigo", System.Data.SqlDbType.Int); comm.Parameters["@Codigo"].Value = clienteID; } comm.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); comm.Parameters["@Nome"].Value = txtNome.Text; comm.Parameters.Add("@Endereco", System.Data.SqlDbType.NVarChar); comm.Parameters["@Endereco"].Value = txtEndereco.Text; comm.Parameters.Add("@Cidade_ID", System.Data.SqlDbType.Int); comm.Parameters["@Cidade_ID"].Value = cbxCidade.SelectedValue; comm.Parameters.Add("@DataNascimento", System.Data.SqlDbType.Date); comm.Parameters["@DataNascimento"].Value = dtpNascimento.Text; comm.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar); comm.Parameters["@Email"].Value = txtEmail.Text; comm.Parameters.Add("@Telefone", System.Data.SqlDbType.NVarChar); if (msktxtTelefone.MaskCompleted) { comm.Parameters["@Telefone"].Value = "(" + msktxtTelefone.Text.Substring(0, 3) + ")" + msktxtTelefone.Text.Substring(3, 4) + "-" + msktxtTelefone.Text.Substring(7, 4); } else { comm.Parameters["@Telefone"].Value = ""; } comm.Parameters.Add("@Cpf", System.Data.SqlDbType.NVarChar); if (msktxtCPF.MaskCompleted) { comm.Parameters["@Cpf"].Value = msktxtCPF.Text.Substring(0, 3) + "." + msktxtCPF.Text.Substring(3, 3) + "." + msktxtCPF.Text.Substring(6, 3) + "-" + msktxtCPF.Text.Substring(9, 2); } else { comm.Parameters["@Cpf"].Value = ""; } try { try { conn.Open(); } catch (Exception error) { isOperationOK = false; MessageBox.Show(error.Message, "Erro ao abrir conexão com o BD!", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { comm.ExecuteNonQuery(); } catch (Exception error) { isOperationOK = false; MessageBox.Show(error.Message, "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { } finally { conn.Close(); if (isOperationOK) { if (clienteID == 0) { MessageBox.Show("Registro Criado com sucesso!", "Banco de Dados", MessageBoxButtons.OK, MessageBoxIcon.None); } else { MessageBox.Show("Registro Alterado com sucesso!", "Banco de Dados", MessageBoxButtons.OK, MessageBoxIcon.None); } btnLimpar_Click(sender, e); ClienteEntry_Load(sender, e); } } }
public MotionLaminator() { _Main = MainData.Instance; }
private void Awake() { MainData.LoadData(); }
// Use this for initialization void Start() { CO = GetComponent <ClickObject>(); Main = (GameObject.Find("/Main")).GetComponent <main>(); MD = (GameObject.Find("/Main")).GetComponent <MainData>(); }
void OnDestory() { m_Instance = null; }
void Awake() { m_Instance = this; DontDestroyOnLoad(gameObject); InitData(); }
private void btnSalvar_Click(object sender, EventArgs e) { bool isOperationOK = true; SqlCommand comm, comm2; SqlDataReader reader; errorProvider1.Clear(); if (txtNome.Text.Length == 0) { errorProvider1.SetError(txtNome, "O campo deve estar preenchido!"); return; } if (txtEndereco.Text.Length == 0) { errorProvider1.SetError(txtEndereco, "O campo deve estar preenchido!"); return; } if (msktxtTelefone.Text.Length > 0 && !msktxtTelefone.MaskFull) { errorProvider1.SetError(msktxtTelefone, "O campo deve estar completamente preenchido!"); return; } if (msktxtCPF.Text.Length > 0 && (!msktxtCPF.MaskFull || !MainData.isCPF(msktxtCPF.Text.Substring(0, 3) + "." + msktxtCPF.Text.Substring(3, 3) + "." + msktxtCPF.Text.Substring(6, 3) + "-" + msktxtCPF.Text.Substring(9, 2)))) { errorProvider1.SetError(msktxtCPF, "O campo deve estar completamente preenchido e válido!"); return; } decimal i; if (txtSalario.Text.Trim().Length == 0 || !Decimal.TryParse(txtSalario.Text, out i) || txtSalario.Text.Contains(".")) { errorProvider1.SetError(txtSalario, "O campo deve estar preenchido por dígitos e separado por vírgula!"); return; } if (cbxCargo.SelectedIndex == -1) { errorProvider1.SetError(cbxCargo, "Um cargo deve ser selecionado!"); return; } if (txtConta.Text.Length == 0) { errorProvider1.SetError(txtConta, "O campo deve estar preenchido!"); return; } if (cbxNivelAcesso.SelectedIndex == -1) { errorProvider1.SetError(cbxNivelAcesso, "Um nível de acesso deve ser selecionado!"); return; } if (funcionarioID == 0 && txtSenha.Text.Trim().Length == 0) { errorProvider1.SetError(txtSenha, "O campo deve estar preenchido!"); return; } if (funcionarioID == 0) { SqlCommand qrySearch = new SqlCommand("SELECT count(*) Cont FROM Funcionario WHERE Nome = @Nome", conn); qrySearch.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); qrySearch.Parameters["@Nome"].Value = txtNome.Text; SqlCommand qrySearch2 = new SqlCommand("SELECT count(*) Cont FROM Usuario WHERE Nome = @Nome", conn); qrySearch2.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); qrySearch2.Parameters["@Nome"].Value = txtConta.Text; try { try { conn.Open(); } catch (Exception error) { MessageBox.Show(error.Message, "Erro ao abrir conexão com o BD!", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { reader = qrySearch.ExecuteReader(); if (reader.Read()) { if (Convert.ToInt32(reader["Cont"].ToString()) > 0) { MessageBox.Show("Este funcionário já existe!", "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } reader.Close(); reader = qrySearch2.ExecuteReader(); if (reader.Read()) { if (Convert.ToInt32(reader["Cont"].ToString()) > 0) { MessageBox.Show("Esta conta já existe!", "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } reader.Close(); } catch (Exception error) { MessageBox.Show(error.Message, "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { } finally { conn.Close(); } comm = new SqlCommand("INSERT INTO Funcionario (Nome, Endereco, Cidade_ID, DataNascimento, Email, Telefone, Cpf, Salario, Cargo) " + "VALUES (@Nome, @Endereco, @Cidade_ID, @DataNascimento, @Email, @Telefone, @Cpf, @Salario, @Cargo)", conn); comm2 = new SqlCommand("INSERT INTO Usuario (Nome, Senha, Funcionario_ID, NivelAcesso) " + "VALUES (@Nome, @Senha, @Funcionario_ID, @NivelAcesso)", conn); comm2.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); comm2.Parameters["@Nome"].Value = txtConta.Text; comm2.Parameters.Add("@Senha", System.Data.SqlDbType.NVarChar); comm2.Parameters["@Senha"].Value = txtSenha.Text; String nivel = ""; switch (cbxNivelAcesso.SelectedIndex) { case 0: nivel = "A"; break; case 1: nivel = "F"; break; } comm2.Parameters.Add("@NivelAcesso", System.Data.SqlDbType.NVarChar); comm2.Parameters["@NivelAcesso"].Value = nivel; } else { comm = new SqlCommand("UPDATE Funcionario SET Nome = @Nome, Endereco = @Endereco, Cidade_ID = @Cidade_ID, DataNascimento = @DataNascimento, " + "Email = @Email, Telefone = @Telefone, Cpf = @Cpf, Salario = @Salario, Cargo = @Cargo WHERE funcionario_ID = @Codigo", conn); comm.Parameters.Add("@Codigo", System.Data.SqlDbType.Int); comm.Parameters["@Codigo"].Value = funcionarioID; if (txtSenha.Text.Trim().Length > 0) { comm2 = new SqlCommand("UPDATE Usuario SET Nome = @Nome, Senha = @Senha, NivelAcesso = @NivelAcesso WHERE Funcionario_ID = @Funcionario_ID", conn); comm2.Parameters.Add("@Senha", System.Data.SqlDbType.NVarChar); comm2.Parameters["@Senha"].Value = txtSenha.Text; } else { comm2 = new SqlCommand("UPDATE Usuario SET Nome = @Nome, NivelAcesso = @NivelAcesso WHERE Funcionario_ID = @Funcionario_ID", conn); } comm2.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); comm2.Parameters["@Nome"].Value = txtConta.Text; String nivel = ""; switch (cbxNivelAcesso.SelectedIndex) { case 0: nivel = "A"; break; case 1: nivel = "F"; break; } comm2.Parameters.Add("@NivelAcesso", System.Data.SqlDbType.NVarChar); comm2.Parameters["@NivelAcesso"].Value = nivel; } comm.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); comm.Parameters["@Nome"].Value = txtNome.Text; comm.Parameters.Add("@Endereco", System.Data.SqlDbType.NVarChar); comm.Parameters["@Endereco"].Value = txtEndereco.Text; comm.Parameters.Add("@Cidade_ID", System.Data.SqlDbType.Int); comm.Parameters["@Cidade_ID"].Value = cbxCidade.SelectedValue; comm.Parameters.Add("@DataNascimento", System.Data.SqlDbType.Date); comm.Parameters["@DataNascimento"].Value = dtpNascimento.Text; comm.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar); comm.Parameters["@Email"].Value = txtEmail.Text; comm.Parameters.Add("@Telefone", System.Data.SqlDbType.NVarChar); if (msktxtTelefone.MaskCompleted) { comm.Parameters["@Telefone"].Value = "(" + msktxtTelefone.Text.Substring(0, 3) + ")" + msktxtTelefone.Text.Substring(3, 4) + "-" + msktxtTelefone.Text.Substring(7, 4); } else { comm.Parameters["@Telefone"].Value = ""; } comm.Parameters.Add("@Cpf", System.Data.SqlDbType.NVarChar); if (msktxtCPF.MaskCompleted) { comm.Parameters["@Cpf"].Value = msktxtCPF.Text.Substring(0, 3) + "." + msktxtCPF.Text.Substring(3, 3) + "." + msktxtCPF.Text.Substring(6, 3) + "-" + msktxtCPF.Text.Substring(9, 2); } else { comm.Parameters["@Cpf"].Value = ""; } comm.Parameters.Add("@Salario", System.Data.SqlDbType.Decimal); comm.Parameters["@Salario"].Value = Convert.ToDecimal(txtSalario.Text); comm.Parameters.Add("@Cargo", System.Data.SqlDbType.NVarChar); comm.Parameters["@Cargo"].Value = cbxCargo.Text; try { try { conn.Open(); } catch (Exception error) { isOperationOK = false; MessageBox.Show(error.Message, "Erro ao abrir conexão com o BD!", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { comm.ExecuteNonQuery(); if (funcionarioID == 0) { SqlCommand comm3 = new SqlCommand("SELECT Funcionario_ID FROM Funcionario WHERE Nome = @Nome", conn); comm3.Parameters.Add("@Nome", System.Data.SqlDbType.NVarChar); comm3.Parameters["@Nome"].Value = txtNome.Text; reader = comm3.ExecuteReader(); if (reader.Read()) { funcionarioID = Convert.ToInt32(reader["Funcionario_ID"].ToString()); } reader.Close(); } if (funcionarioID > 0) { comm2.Parameters.Add("@Funcionario_ID", SqlDbType.Int); comm2.Parameters["@Funcionario_ID"].Value = funcionarioID; comm2.ExecuteNonQuery(); } else { isOperationOK = false; MessageBox.Show("Não foi possível inserir o usuário!", "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception error) { isOperationOK = false; MessageBox.Show(error.Message, "Erro ao executar comando SQL!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { } finally { conn.Close(); if (isOperationOK) { if (funcionarioID == 0) { MessageBox.Show("Registro Criado com sucesso!", "Banco de Dados", MessageBoxButtons.OK, MessageBoxIcon.None); } else { MessageBox.Show("Registro Alterado com sucesso!", "Banco de Dados", MessageBoxButtons.OK, MessageBoxIcon.None); } btnLimpar_Click(sender, e); FuncionarioEntry_Load(sender, e); } } }
public void Test1500() { // 拆分单位 = 1500 没单位. DefaultMainSubDataManager manager = new DefaultMainSubDataManager() { MaxSubValue = 1500 }; // 初始金额= 8K. MainData mainData = new MainData() { MainInitValue = 8000 }; // 拆分. manager.InsertNewMainData(mainData); // 拆分后子数据列表不为 NULL Assert.IsNotNull(mainData.SubDataList); // 子数据列表长度应为 6个 其中, 前5个是满的 1500, 最后一个是 500 Assert.AreEqual(6, mainData.SubDataList.Count); for (int i = 0; i < 5; i++) { Assert.AreEqual(1500, mainData.SubDataList[i].SubInitValue); Assert.AreEqual(1500, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(500, mainData.SubDataList[5].SubInitValue); Assert.AreEqual(500, mainData.SubDataList[5].SubBalanceValue); // 测试消耗一次. bool updateResult = manager.UpdateMainData(mainData, -500); // 成功. Assert.IsTrue(updateResult); // 首行消耗 500, 其它保持不变. Assert.AreEqual(1000, mainData.SubDataList[0].SubBalanceValue); for (int i = 1; i < 5; i++) { Assert.AreEqual(1500, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(500, mainData.SubDataList[5].SubBalanceValue); updateResult = manager.UpdateMainData(mainData, -3000); // 成功. Assert.IsTrue(updateResult); // 前2行余额0, 第3行消耗 500, 其它保持不变. for (int i = 0; i < 2; i++) { Assert.AreEqual(0, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(1000, mainData.SubDataList[2].SubBalanceValue); for (int i = 3; i < 5; i++) { Assert.AreEqual(1500, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(500, mainData.SubDataList[5].SubBalanceValue); updateResult = manager.UpdateMainData(mainData, -1500); // 成功. Assert.IsTrue(updateResult); // 前3行余额0, 第4行消耗 500, 其它保持不变. for (int i = 0; i < 3; i++) { Assert.AreEqual(0, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(1000, mainData.SubDataList[3].SubBalanceValue); for (int i = 4; i < 5; i++) { Assert.AreEqual(1500, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(500, mainData.SubDataList[5].SubBalanceValue); updateResult = manager.UpdateMainData(mainData, 3000); // 成功. Assert.IsTrue(updateResult); // 前1行余额0, 第2行消耗 500, 其它保持不变. for (int i = 0; i < 1; i++) { Assert.AreEqual(0, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(1000, mainData.SubDataList[1].SubBalanceValue); for (int i = 2; i < 5; i++) { Assert.AreEqual(1500, mainData.SubDataList[i].SubBalanceValue); } Assert.AreEqual(500, mainData.SubDataList[5].SubBalanceValue); }
public void DeletePlayer(string inPlayer) { MainData.GetInstance().DeletePlayer(inPlayer); UpdateHUD(); }
// Use this for initialization void Start() { CO = GetComponent<ClickObject>(); Main = (GameObject.Find("/Main")).GetComponent<main>(); MD = (GameObject.Find("/Main")).GetComponent<MainData>(); }
public MotionLoadlock() { _Main = MainData.Instance; }
// Use this for initialization void Start() { MD = GetComponent<MainData>(); TS = MD.TS; LL = GetComponent<LottoLogic> (); }
public MotionLpm() { _Main = MainData.Instance; }
public void ResetProgress() { MainData.ResetLevels(); }
/// <summary> /// 首页数据 /// </summary> /// <param name="days"></param> /// <param name="pagination"></param> /// <returns></returns> public MainData GetMainData(int days, Pagination pagination) { var currentTime = DateTime.Now.ToCstTime().ToString("yyyy-MM-dd"); var yesterdayTime = DateTime.Now.ToCstTime().AddDays(-1).ToString("yyyy-MM-dd"); var data = new MainData(); var listPays = new payBusiness().GetIQueryable().Where(x => x.status == 1).ToList(); //支付记录 var listProduct = new ProductBusiness().GetIQueryable().ToList(); //产品清单 var listMembers = new membersBusiness().GetIQueryable().ToList(); //用户记录 var listOrders = new orderBusiness().GetIQueryable().Where(x => x.status == 1).ToList().Where(x => listPays.Find(a => a.order_id == x.Id) != null).ToList(); //订单 -支付完成的订单 //浏览数 data.T_VisitsNum = 0; data.Y_VisitsNum = 0; data.A_VisitsNum = 0; //注册用户数 data.T_RegisteredUsers = listMembers.Where(x => x.registration_time?.ToString("yyyy-MM-dd") == currentTime).Count(); data.Y_RegisteredUsers = listMembers.Where(x => x.registration_time?.ToString("yyyy-MM-dd") == yesterdayTime).Count(); data.A_RegisteredUsers = listMembers.Where(x => x.registration_time != null).Count(); //团长新增数 data.T_NewHead = listMembers.Where(x => x.header_time?.ToString("yyyy-MM-dd") == currentTime).Count(); data.Y_NewHead = listMembers.Where(x => x.header_time?.ToString("yyyy-MM-dd") == yesterdayTime).Count(); data.A_NewHead = listMembers.Where(x => x.header_time != null).Count(); //参团数 data.T_Participants = listOrders.Where(x => x.create_time.ToString("yyyy-MM-dd") == currentTime).Sum(x => x.num); data.Y_Participants = listOrders.Where(x => x.create_time.ToString("yyyy-MM-dd") == yesterdayTime).Sum(x => x.num); data.A_Participants = listOrders.Where(x => x.create_time != null).Sum(x => x.num); //交易额 data.T_TradingVolume = listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == currentTime).Sum(x => x.money); data.Y_TradingVolume = listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == yesterdayTime).Sum(x => x.money); data.A_TradingVolume = listPays.Where(x => x.pay_time != null).Sum(x => x.money); decimal value = 0; for (int i = days - 1; i >= 0; i--) { value += listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == DateTime.Now.ToCstTime().AddDays(-i).ToString("yyyy-MM-dd")).Sum(x => x.money); data.xAxisData.Add(DateTime.Now.ToCstTime().AddDays(-i).ToString("MM/dd")); data.yAxisData.Add(value); } List <SaleRank> ProductSaleRank = new List <SaleRank>(); var listProductSaleRank = listOrders.GroupBy(x => x.product_id); foreach (var item in listProductSaleRank) { ProductSaleRank.Add(new SaleRank() { name = listProduct.Find(x => x.Id == int.Parse(item.Key))?.title, num = item.Sum(x => x.num) }); } data.ProductSaleRank = pagination.BuildTableResult_DataGrid(ProductSaleRank.GetPagination(pagination).ToList()); List <SaleRank> TeamSaleRank = new List <SaleRank>(); var listTeamSaleRank = listOrders.Where(x => x.share_id != null).GroupBy(x => x.share_id); foreach (var item in listTeamSaleRank) { TeamSaleRank.Add(new SaleRank() { name = listMembers.Find(x => x.oppen_id == item.Key)?.nick_name, num = item.Sum(x => x.num) }); } data.TeamSaleRank = pagination.BuildTableResult_DataGrid(TeamSaleRank.GetPagination(pagination).ToList()); return(data); }