public MainWindow()
{
InitializeComponent();
#region call service to test connectivity
//// Create a Proxy Object to communicate with the wcf service.
//NorthwindServiceContractClient proxy = new NorthwindServiceContractClient();
//// Call the Select Employeee Method of the service and handle the return.
//NorthwindEmployee[] employees = proxy.SelectEmployees();
//// always close the proxy object
//proxy.Close();
////Display the Lastname of th First Employee in a messagebox
//// MessageBox.Show("Last Name {0}", employees[0].LastName);
//MessageBox.Show(employees[0].LastName);
#endregion
string[] titles = DataGateway.SelectEmployeeTitles();
foreach (string tl in titles)
{
combobox1.Items.Add(tl);
}
}
/// <summary>
/// 判断表是否已存在
/// </summary>
/// <param name="connString">普通用户</param>
/// <param name="table"></param>
/// <returns></returns>
public static bool IsExists(ConnectString connString, string tableName)
{
string sql = $"select 1 from dba_tables where table_name = '{tableName}'";
object result = new DataGateway(OracleProvider.ManagedDataAccess).ExecuteScalar(connString, sql);
return(result != null && Convert.ToInt16(result) == 1);
}
/// <summary>
/// 获取表的约束信息
/// </summary>
/// <param name="connString"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static IEnumerable <Constraint> GetConstraints(ConnectString connString, string tableName)
{
DataGateway gateway = new DataGateway(OracleProvider.ManagedDataAccess);
string sql = "select owner, constraint_name, constraint_type, TABLE_NAME, r_constraint_name, delete_rule, "
+ "case when (status='ENABLED') then 1 else 0 end as enabled, "
+ "case when (index_name is not null) then 1 else 0 end as using_index "
+ $"from user_constraints where constraint_type!='C' and table_name='{tableName}'";
IEnumerable <Constraint> result = gateway.Query <Constraint>(connString, sql);
sql = $"select * from USER_CONS_COLUMNS where table_name='{tableName}' order by column_name,position";
IEnumerable <ConstraintColumns> cols = gateway.Query <ConstraintColumns>(connString, sql);
foreach (var con in result)
{
con.Columns = string.Join(",", cols.Where(item => item.Name == con.Name).OrderBy(item => item.Position).Select(item => item.ColumnName));
if (con.Type == "R")
{
con.RefConstraint = gateway.Query <ConstraintColumns>(connString, $"select * from USER_CONS_COLUMNS where constraint_name='{con.RefName}'").FirstOrDefault();
}
}
return(result);
}
/// <summary>
/// 用户是否存在
/// </summary>
/// <param name="connString"></param>
/// <param name="userName"></param>
/// <returns></returns>
public static bool IsExists(ConnectString connString, string userName)
{
string sql = $"select 1 from all_users where username='******'";
object result = new DataGateway(OracleProvider.ManagedDataAccess).ExecuteScalar(connString, sql);
return(result != null && Convert.ToInt16(result) == 1);
}
private void buttonEmployees_Click_1(object sender, RoutedEventArgs e)
{
EmployeeViewModel[] employees = DataGateway.SelectEmployees();
foreach (EmployeeViewModel emp in employees)
{
listboxEmployeData.Items.Add(emp.FullName);
}
}
public void SubmitBenefitInquiry(int employerId, int cchId)
{
DataGateway.ExecuteCommand(
"270_CallConsoleApp", new {
EmployerId = employerId,
CCHID = cchId
},
DataSource.Platform,
employerId);
}
public EVMInterpreter(byte[] byteCode)
{
m_byteCode = byteCode;
m_pc = 0;
m_memory = new List <byte>();
m_stack = new List <uint256>();
m_log = new List <EVMLog>();
m_storage = new Dictionary <uint256, uint256>();
edg = new EtherscanDataGateway();
}
private void ButtonInsertEmployee_Click_1(object sender, RoutedEventArgs e)
{
EmployeeViewModel emp = new EmployeeViewModel();
emp.FirstName = txtFirstName.Text;
emp.LastName = txtLastName.Text;
emp.Title = txtTitle.Text;
emp.HomePhone = txtHomePhone.Text;
DataGateway.InsertEmployee(emp);
}
public async Task <HealthPlanSummary> GetHealthPlanSummaryAsync(int employerId, int cchId)
{
return(await DataGateway.QueryScalarAsync <HealthPlanSummary>(
"p_GetHealthPlanSummary",
new {
CCHID = cchId
},
DataSource.Employer,
employerId
));
}
private void combobox1_SelectionChanged_1(object sender, SelectionChangedEventArgs e)
{
listboxEmployeData.Items.Clear();
string title;
title = combobox1.SelectedValue.ToString();
EmployeeViewModel[] employees = DataGateway.SelectEmployeesByTitle(title);
foreach (EmployeeViewModel emp in employees)
{
listboxEmployeData.Items.Add(emp.FullName);
}
}
public GameConsole()
{
gameState = new GameState
{
Running = true
};
var rewardsRepo = new RewardRepository(@".\Resources\Dat\rewards.csv");
var achievementsRepo = new AchievementRepository(@".\Resources\Dat\achievements.csv", gameState);
var gameItemsRepo = new GameItemRepository(@".\Resources\Dat\gameItems.csv");
var storeInventoryRepo = new StoryInventoryRepository(@".\Resources\Dat\storeInventory.csv");
gateway = new DataGateway(rewardsRepo, gameItemsRepo, achievementsRepo, storeInventoryRepo);
commandsGroup = new TopCommandGroupFactory().Build();
gameState.Lobby = new LobbyRoom(gameState, new[] { "Welcome to the Lobby" }, GameMode.Lobby, commandsGroup);
gameState.Store = gameState.Store ?? new MinerStoreFactory(gameState, commandsGroup, gateway).Build();
gameState.ControlRoom = new ControlRoomFactory(gameState, commandsGroup).Build();
gameState.ClaimsOffice = new ClaimsOfficeRoomFactory(gameState, commandsGroup, gateway).Build();
gameState.SaveDirectory = @"c:\chipMiner\saves";
gameState.GameTime.Start();
IsVisible = true;
IsFocused = true;
StartGame();
hud = new HudConsole(gameState)
{
Position = new Point(0, 0)
};
input = new InputConsole(this, gameState)
{
Position = new Point(1, 34)
};
output = new OutputConsole(this, 83)
{
Position = new Point(1, 1)
};
events = new GameEventsConsole(this, 83)
{
Position = new Point(85, 1)
};
Children.Add(hud);
Children.Add(input);
Children.Add(output);
Children.Add(events);
Global.FocusedConsoles.Set(input);
}
public MemberDetail GetKeyEmployeeInfo(int employerId, int cchId)
{
//var keyEmployeeInfo = DataGateway.Query(
// "GetKeyEmployeeInfoByCchId",
// new
// {
// CCHID = cchId
// },
// DataSource.Employer,
// employerId
//);
//return keyEmployeeInfo;
MemberDetail keyEmployeeInfo = null;
using (var connection = ConnectionFactory.Get(DataSource.Employer, employerId))
{
try
{
connection.Open();
var multiple = connection.QueryMultiple(
"GetKeyEmployeeInfoByCchId",
new
{
CCHID = cchId
},
commandType: CommandType.StoredProcedure);
keyEmployeeInfo = multiple.Read <MemberDetail>().AsList().ToArray()[0];
keyEmployeeInfo.Dependents.AddRange(multiple.Read <DependentDetail>());
}
catch (Exception ex)
{
DataGateway.LogError(ex);
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
}
}
return(keyEmployeeInfo);
}
/// <summary>
/// 获取表的详细信息（包括字段）
/// </summary>
/// <param name="connString">普通用户</param>
/// <param name="tableName"></param>
/// <returns></returns>
public static Table GetTableDetails(ConnectString connString, string tableName)
{
string sql = "select t.object_id, t.OBJECT_NAME, p.tablespace_name, c.comments, t.created "
+ "from user_objects t, user_all_tables p, user_tab_comments c "
+ "where t.object_name= p.table_name and t.object_name= c.table_name "
+ $"and t.object_type = 'TABLE' and t.OBJECT_NAME = '{tableName}'";
Debug.WriteLine(sql);
Table result = new DataGateway(OracleProvider.ManagedDataAccess).Query <Table>(connString, sql).FirstOrDefault();
if (result != null)
{
result.Columns = GetColumns(connString, tableName);
}
return(result);
}
public ClaimsOfficeRoomFactory(GameState gameState, CommandsGroup baseCommandsGroup, DataGateway gateway)
{
_gateway = gateway;
_gameState = gameState;
_baseCommandsGroup = baseCommandsGroup;
}
public GeneralController(ExploreCaliforniaContext context)
{
db = context;
dataGateway = new DataGateway <T>(context);
}
protected override void EstablishContext()
{
string connectionString = ConfigurationManager.ConnectionStrings["TestDb"].ConnectionString;
_gateway = new DataGateway(connectionString);
using (var dc = new TestDataRepositoryDataContext())
dc.spTruncate();
}
public LoanController()
{
DataGateway = new LoanGateway();
}
public BookController()
{
DataGateway = new BookGateway();
}
public MinerStoreFactory(GameState gameState, CommandsGroup baseCommandsGroup, DataGateway gateway)
{
_gateway = gateway;
_gameState = gameState;
_baseCommandsGroup = baseCommandsGroup;
}
public DataController(IRedisCacheClient cacheClient)
{
rediscacheClient = cacheClient;
dataGateway = new DataGateway();
}
