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