コード例 #1
0
 public string SyncPatient()
 {
     try
     {
         Process p = new Process();
         //设置要启动的应用程序
         var appSettingsJson = AppSettingsJson.GetAppSettings();
         var processpath     = appSettingsJson["syncpatientapppath"];//admin12345
         p.StartInfo.FileName = processpath;
         //是否使用操作系统shell启动
         p.StartInfo.UseShellExecute = false;
         // 接受来自调用程序的输入信息
         p.StartInfo.RedirectStandardInput = true;
         //输出信息
         p.StartInfo.RedirectStandardOutput = true;
         // 输出错误
         p.StartInfo.RedirectStandardError = true;
         //不显示程序窗口
         p.StartInfo.CreateNoWindow = false;
         //启动程序
         p.Start();
         p.StandardInput.AutoFlush = true;
         //等待程序执行完退出进程
         p.WaitForExit();
         p.Close();
         return("同步成功");
     }
     catch (Exception)
     {
         return("同步失败");
     }
 }
コード例 #2
0
ファイル: OMContext.cs プロジェクト: bahadir147/Tygre
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            var appSettingsJson  = AppSettingsJson.GetAppSettings();
            var connectionString = appSettingsJson["ConnectionStrings:DefaultConnection"];

            optionsBuilder.UseSqlServer(connectionString);
        }
コード例 #3
0
        public IActionResult Index()
        {
            var appSettingsJson  = AppSettingsJson.GetAppSettings();
            var connectionString = appSettingsJson["MssqlConnectionString"];

            return(View());
        }
コード例 #4
0
        public IActionResult Index(string username, string pwd, bool logout = false)
        {
            //user admin12345
            if (logout || string.IsNullOrEmpty(username))
            {
                HttpContext.Session.SetString("user", "");
            }
            else
            {
                MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
                byte[]        data     = md5Hasher.ComputeHash(Encoding.Default.GetBytes(username + '-' + pwd));
                StringBuilder sBuilder = new StringBuilder();
                for (int i = 0; i < data.Length; i++)
                {
                    sBuilder.Append(data[i].ToString("x2"));
                }
                var appSettingsJson = AppSettingsJson.GetAppSettings();
                var userpwd         = appSettingsJson["userpwd"];//admin12345

                if (userpwd == sBuilder.ToString())
                {
                    HttpContext.Session.SetString("user", "admin");
                    ViewBag.Username = "******";
                }
                else
                {
                    ViewBag.ErrorMsg = "用户名密码错误";
                }
            }

            return(View());
        }
コード例 #5
0
        public UserController()
        {
            Microsoft.Extensions.Configuration.IConfigurationRoot appSettingsJson = AppSettingsJson.GetAppSettings();
            string connectionString = appSettingsJson["DefaultConnection"];

            ConnectionString = connectionString;
        }
コード例 #6
0
ファイル: tools.cs プロジェクト: maoxianmmd/Note-net
        //连接数据库
        public SqlConnection Sqlconnect()
        {
            var           asp  = AppSettingsJson.GetAppSettings()["ConnectionStrings"];
            SqlConnection conn = new SqlConnection(asp);

            conn.Open();
            return(conn);
        }
コード例 #7
0
        public DataAccess(string connectionStringName = "GoodBooks", string Database = "GoodBooks")
        {
            //Get connection string from appsettings
            var appSettingsJson = AppSettingsJson.GetAppSettings();

            connString = appSettingsJson["Data:ConnectionStrings:" + connectionStringName];

            //colnnect to cluster and select db
            _client = new MongoClient(connString);
            _db     = _client.GetDatabase(Database);
        }
コード例 #8
0
        public QueueSender()
        {
            var appSettings = AppSettingsJson.GetAppSettings();

            _settings = new QueueSettings(
                appSettings["SBusAzure:SBusConnectionString"],
                appSettings["SBusAzure:SBusQueueName"]);

            _queueClient = new QueueClient(
                _settings.ConnectionString, _settings.QueueName);
        }
コード例 #9
0
        public QueueReceiver(IProcess processData, ILogger <QueueReceiver <T> > logger)
        {
            var appSettings = AppSettingsJson.GetAppSettings();

            _settings = new QueueSettings(
                appSettings["SBusAzure:SBusConnectionString"],
                appSettings["SBusAzure:SBusQueueName"]);

            _processData = processData;
            _logger      = logger;
            _queueClient = new QueueClient(
                _settings.ConnectionString, _settings.QueueName);
        }
コード例 #10
0
        public ApplicationDbContext CreateDbContext(string[] args)
        {
            // To prep each database uncomment the corresponding line below.
            var appSettingsJson = AppSettingsJson.GetAppSettings();
            var con             = appSettingsJson["Finbuckle:MultiTenant:Stores:ConfigurationStore:Defaults:ConnectionString"];
            var tenantInfo      = new TenantInfo {
                ConnectionString = con
            };

            var optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>();

            return(new ApplicationDbContext(tenantInfo, optionsBuilder.Options));
        }
コード例 #11
0
ファイル: EPSContext.cs プロジェクト: Csands-Aecom/EPS3
 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
 {
     try
     {
         var appSettingsJson   = AppSettingsJson.GetAppSettings();
         var connectionStrings = appSettingsJson["ConnectionStrings"];
         var connectionString  = appSettingsJson["EPSContext"];
         connectionString = "Data Source=USTLH1LT1506\\TurnpikeTest;Initial Catalog=EPSNew;Integrated Security=True";
     }
     catch (Exception e)
     {
         Console.Write(e.StackTrace.ToString());
     }
 }
コード例 #12
0
        public JobContainer(IJobExecutionContext _Context)
        {
            var config = AppSettingsJson.GetAppSettings();

            SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder(config.GetSection("ConnectionStrings:BaseDBContext").Value);

            sqlConnectionStringBuilder.Password = Encryption.Decrypt(sqlConnectionStringBuilder.Password);
            ConnString = sqlConnectionStringBuilder.ConnectionString;

            stopwatch.Start();
            Context = _Context;

            JobName = JobGroup = MethodName = MethodParams = JobMessage = ExceptionInfo = "";
            JobName = Context.JobDetail.Key.Name;
            InitContainer();
        }
コード例 #13
0
        // This method gets called by the runtime. Use this method to add services to the container.
        // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940
        public void ConfigureServices(IServiceCollection services)
        {
            var appSettingsJson = AppSettingsJson.GetAppSettings();

            services.AddDbContext <DataContext>(opts => opts.UseSqlServer(appSettingsJson["ConnectionString:ReceiptsDBAzure"]));
            services.AddScoped <IDataRepository <Receipt>, ReceiptManager>();
            services.AddScoped <IDataRepository <User>, UserManager>();

            services.BuildServiceProvider().GetService <DataContext>().Database.Migrate();
            services.AddOpenApiDocument(config => config.Title = "API");
            services.AddControllers();

            services.AddApiVersioning(config =>
            {
                config.DefaultApiVersion = new ApiVersion(1, 0);
                config.AssumeDefaultVersionWhenUnspecified = true;
                config.ReportApiVersions = true;
            });
        }
コード例 #14
0
        public static async Task Main(string[] args)
        {
            var host = CreateHostBuilder(args).Build();

            // Set up the databases for the sample if needed.
            var env = host.Services.GetService <IWebHostEnvironment>();

            if (env.EnvironmentName == "Development")
            {
                var appSettingsJson = AppSettingsJson.GetAppSettings();
                var con             = appSettingsJson["Finbuckle:MultiTenant:Stores:ConfigurationStore:Defaults:ConnectionString"];
                using (var db = new ApplicationDbContext(new TenantInfo {
                    ConnectionString = con
                }))
                {
                    await db.Database.MigrateAsync();
                }
            }

            await host.RunAsync();
        }
コード例 #15
0
        public IActionResult PatientDetails()
        {
            List <string> OutPut = new List <string>();
            //Dictionary<string, string> dict = new Dictionary<string, string>();

            // string connectionString = "Server = demosql001.cc4mi4fhf4fo.ap-southeast-2.rds.amazonaws.com; Database = WHADemo; User Id = whadevfe; Password = 4MeW3%T7JxMA; ";
            //string connectionString = "SELECT TOP (1000) [PersonID],[LastName],[FirstName],[Address],[City] FROM [testdatabase].[dbo].[Persons]";
            //string connectionString = "Data Source=DESKTOP-SK0EJ1N;Initial Catalog=testdatabase;Integrated Security=True";
            //var xxx = ConfigurationManager.ConnectionStrings["DefaultConnectString"];
            //string myDb1ConnectionString = _configuration.GetConnectionString("myDb1");
            var appSettingsJson  = AppSettingsJson.GetAppSettings();
            var connectionString = appSettingsJson["DefaultConnectString"];
            //string connectionString = "dfa";
            SqlConnection conn = new SqlConnection(connectionString);

            conn.Open();
            //SqlCommand com = new SqlCommand("select * from dbo.POBPatient where POBPatientID = 1;", conn);
            SqlCommand com      = new SqlCommand("select * from dbo.Persons;", conn);
            var        Returned = com.ExecuteReader();

            while (Returned.Read())
            {
                for (int i = 0; i < Returned.FieldCount; i++)
                {
                    OutPut.Add(Returned.GetName(i));

                    // columns.Add(Returned.GetName(i));
                }

                //OutPut.Add(Returned.GetString(3));
            }
            conn.Close();

            var column = new PatientEmpolymentHistory();

            //column.ColumnNames = OutPut;

            return(Ok(OutPut));
        }
コード例 #16
0
ファイル: ApiRequest.cs プロジェクト: Edchen29/SanyMES-master
        public ApiRequest(string System, bool LoginFlag = false)
        {
            Stopwatch = new Stopwatch();
            Stopwatch.Start();

            _System    = System;
            _LoginFlag = LoginFlag;
            try
            {
                var config = AppSettingsJson.GetAppSettings();
                ConnString = config.GetSection("ConnectionStrings:BaseDBContext").Value;

                SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder(ConnString);
                sqlConnectionStringBuilder.Password = Encryption.Decrypt(sqlConnectionStringBuilder.Password);
                ConnString = sqlConnectionStringBuilder.ConnectionString;

                Server   = config.GetSection(System + "Setting:Server").Value;
                LoginUrl = config.GetSection(System + "Setting:LoginUrl").Value;
                Uid      = config.GetSection(System + "Setting:Uid").Value;
                Pwd      = config.GetSection(System + "Setting:Pwd").Value;
            }
            catch (Exception) { }
        }
コード例 #17
0
        public UserRepository()
        {
            var appSettings = AppSettingsJson.GetAppSettings();

            _connectionString = appSettings["ConnectionString"];
        }