From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。
---
HotelPms.SourceFactory/TableToExcel.Designer.cs | 360 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 360 insertions(+), 0 deletions(-)
diff --git a/HotelPms.SourceFactory/TableToExcel.Designer.cs b/HotelPms.SourceFactory/TableToExcel.Designer.cs
new file mode 100644
index 0000000..b1f7110
--- /dev/null
+++ b/HotelPms.SourceFactory/TableToExcel.Designer.cs
@@ -0,0 +1,360 @@
+
+namespace HotelPms.SourceFactory
+{
+ partial class TableToExcel
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Windows Form Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.panel1 = new System.Windows.Forms.Panel();
+ this.txtNewSheet = new System.Windows.Forms.TextBox();
+ this.btnCopySheet = new System.Windows.Forms.Button();
+ this.groupBox1 = new System.Windows.Forms.GroupBox();
+ this.label6 = new System.Windows.Forms.Label();
+ this.lblStatus = new System.Windows.Forms.Label();
+ this.txtTableConditon = new System.Windows.Forms.TextBox();
+ this.button3 = new System.Windows.Forms.Button();
+ this.button2 = new System.Windows.Forms.Button();
+ this.button1 = new System.Windows.Forms.Button();
+ this.btnOpenDB = new System.Windows.Forms.Button();
+ this.label5 = new System.Windows.Forms.Label();
+ this.cmbTable = new System.Windows.Forms.ComboBox();
+ this.txtPassword = new System.Windows.Forms.TextBox();
+ this.label4 = new System.Windows.Forms.Label();
+ this.txtUser = new System.Windows.Forms.TextBox();
+ this.label3 = new System.Windows.Forms.Label();
+ this.txtDB = new System.Windows.Forms.TextBox();
+ this.label2 = new System.Windows.Forms.Label();
+ this.txtHost = new System.Windows.Forms.TextBox();
+ this.label1 = new System.Windows.Forms.Label();
+ this.cmbSheet = new System.Windows.Forms.ComboBox();
+ this.txtExcelPath = new System.Windows.Forms.TextBox();
+ this.OpenExcel = new System.Windows.Forms.Button();
+ this.panel2 = new System.Windows.Forms.Panel();
+ this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
+ this.panel1.SuspendLayout();
+ this.groupBox1.SuspendLayout();
+ this.SuspendLayout();
+ //
+ // panel1
+ //
+ this.panel1.Controls.Add(this.txtNewSheet);
+ this.panel1.Controls.Add(this.btnCopySheet);
+ this.panel1.Controls.Add(this.groupBox1);
+ this.panel1.Controls.Add(this.cmbSheet);
+ this.panel1.Controls.Add(this.txtExcelPath);
+ this.panel1.Controls.Add(this.OpenExcel);
+ this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
+ this.panel1.Location = new System.Drawing.Point(0, 0);
+ this.panel1.Name = "panel1";
+ this.panel1.Size = new System.Drawing.Size(800, 324);
+ this.panel1.TabIndex = 0;
+ //
+ // txtNewSheet
+ //
+ this.txtNewSheet.Location = new System.Drawing.Point(160, 74);
+ this.txtNewSheet.Name = "txtNewSheet";
+ this.txtNewSheet.Size = new System.Drawing.Size(129, 23);
+ this.txtNewSheet.TabIndex = 5;
+ //
+ // btnCopySheet
+ //
+ this.btnCopySheet.Location = new System.Drawing.Point(21, 68);
+ this.btnCopySheet.Name = "btnCopySheet";
+ this.btnCopySheet.Size = new System.Drawing.Size(133, 32);
+ this.btnCopySheet.TabIndex = 4;
+ this.btnCopySheet.Text = "CopySheet To";
+ this.btnCopySheet.UseVisualStyleBackColor = true;
+ this.btnCopySheet.Click += new System.EventHandler(this.btnCopySheet_Click);
+ //
+ // groupBox1
+ //
+ this.groupBox1.Controls.Add(this.label6);
+ this.groupBox1.Controls.Add(this.lblStatus);
+ this.groupBox1.Controls.Add(this.txtTableConditon);
+ this.groupBox1.Controls.Add(this.button3);
+ this.groupBox1.Controls.Add(this.button2);
+ this.groupBox1.Controls.Add(this.button1);
+ this.groupBox1.Controls.Add(this.btnOpenDB);
+ this.groupBox1.Controls.Add(this.label5);
+ this.groupBox1.Controls.Add(this.cmbTable);
+ this.groupBox1.Controls.Add(this.txtPassword);
+ this.groupBox1.Controls.Add(this.label4);
+ this.groupBox1.Controls.Add(this.txtUser);
+ this.groupBox1.Controls.Add(this.label3);
+ this.groupBox1.Controls.Add(this.txtDB);
+ this.groupBox1.Controls.Add(this.label2);
+ this.groupBox1.Controls.Add(this.txtHost);
+ this.groupBox1.Controls.Add(this.label1);
+ this.groupBox1.Location = new System.Drawing.Point(18, 138);
+ this.groupBox1.Name = "groupBox1";
+ this.groupBox1.Size = new System.Drawing.Size(770, 174);
+ this.groupBox1.TabIndex = 3;
+ this.groupBox1.TabStop = false;
+ this.groupBox1.Text = "DB";
+ //
+ // label6
+ //
+ this.label6.AutoSize = true;
+ this.label6.Location = new System.Drawing.Point(21, 95);
+ this.label6.Name = "label6";
+ this.label6.Size = new System.Drawing.Size(153, 15);
+ this.label6.TabIndex = 16;
+ this.label6.Text = "指定シート、テーブルを書き込む";
+ //
+ // lblStatus
+ //
+ this.lblStatus.BackColor = System.Drawing.Color.Red;
+ this.lblStatus.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
+ this.lblStatus.Font = new System.Drawing.Font("メイリオ", 18F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point);
+ this.lblStatus.ForeColor = System.Drawing.Color.White;
+ this.lblStatus.Location = new System.Drawing.Point(639, 95);
+ this.lblStatus.Name = "lblStatus";
+ this.lblStatus.Size = new System.Drawing.Size(125, 62);
+ this.lblStatus.TabIndex = 15;
+ this.lblStatus.Text = "1";
+ this.lblStatus.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
+ //
+ // txtTableConditon
+ //
+ this.txtTableConditon.Location = new System.Drawing.Point(547, 95);
+ this.txtTableConditon.Name = "txtTableConditon";
+ this.txtTableConditon.Size = new System.Drawing.Size(86, 23);
+ this.txtTableConditon.TabIndex = 14;
+ this.txtTableConditon.Text = "M_";
+ //
+ // button3
+ //
+ this.button3.Location = new System.Drawing.Point(408, 125);
+ this.button3.Name = "button3";
+ this.button3.Size = new System.Drawing.Size(133, 32);
+ this.button3.TabIndex = 13;
+ this.button3.Text = "WriteTable";
+ this.button3.UseVisualStyleBackColor = true;
+ this.button3.Click += new System.EventHandler(this.button3_Click);
+ //
+ // button2
+ //
+ this.button2.Location = new System.Drawing.Point(408, 89);
+ this.button2.Name = "button2";
+ this.button2.Size = new System.Drawing.Size(133, 32);
+ this.button2.TabIndex = 12;
+ this.button2.Text = "WriteTo目次";
+ this.button2.UseVisualStyleBackColor = true;
+ this.button2.Click += new System.EventHandler(this.button2_Click);
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(180, 86);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(133, 32);
+ this.button1.TabIndex = 11;
+ this.button1.Text = "WriteToSheet ";
+ this.button1.UseVisualStyleBackColor = true;
+ this.button1.Click += new System.EventHandler(this.button1_Click);
+ //
+ // btnOpenDB
+ //
+ this.btnOpenDB.Location = new System.Drawing.Point(408, 47);
+ this.btnOpenDB.Name = "btnOpenDB";
+ this.btnOpenDB.Size = new System.Drawing.Size(287, 31);
+ this.btnOpenDB.TabIndex = 10;
+ this.btnOpenDB.Text = "OpenDB";
+ this.btnOpenDB.UseVisualStyleBackColor = true;
+ this.btnOpenDB.Click += new System.EventHandler(this.btnOpenDB_Click);
+ //
+ // label5
+ //
+ this.label5.AutoSize = true;
+ this.label5.Location = new System.Drawing.Point(408, 22);
+ this.label5.Name = "label5";
+ this.label5.Size = new System.Drawing.Size(34, 15);
+ this.label5.TabIndex = 9;
+ this.label5.Text = "Table";
+ //
+ // cmbTable
+ //
+ this.cmbTable.FormattingEnabled = true;
+ this.cmbTable.Location = new System.Drawing.Point(449, 19);
+ this.cmbTable.Name = "cmbTable";
+ this.cmbTable.Size = new System.Drawing.Size(246, 23);
+ this.cmbTable.TabIndex = 8;
+ //
+ // txtPassword
+ //
+ this.txtPassword.Location = new System.Drawing.Point(261, 48);
+ this.txtPassword.Name = "txtPassword";
+ this.txtPassword.Size = new System.Drawing.Size(129, 23);
+ this.txtPassword.TabIndex = 7;
+ this.txtPassword.Text = "oatcti";
+ //
+ // label4
+ //
+ this.label4.AutoSize = true;
+ this.label4.Location = new System.Drawing.Point(200, 51);
+ this.label4.Name = "label4";
+ this.label4.Size = new System.Drawing.Size(57, 15);
+ this.label4.TabIndex = 6;
+ this.label4.Text = "Password";
+ //
+ // txtUser
+ //
+ this.txtUser.Location = new System.Drawing.Point(58, 48);
+ this.txtUser.Name = "txtUser";
+ this.txtUser.Size = new System.Drawing.Size(129, 23);
+ this.txtUser.TabIndex = 5;
+ this.txtUser.Text = "sa";
+ //
+ // label3
+ //
+ this.label3.AutoSize = true;
+ this.label3.Location = new System.Drawing.Point(19, 51);
+ this.label3.Name = "label3";
+ this.label3.Size = new System.Drawing.Size(30, 15);
+ this.label3.TabIndex = 4;
+ this.label3.Text = "User";
+ //
+ // txtDB
+ //
+ this.txtDB.Location = new System.Drawing.Point(261, 19);
+ this.txtDB.Name = "txtDB";
+ this.txtDB.Size = new System.Drawing.Size(129, 23);
+ this.txtDB.TabIndex = 3;
+ this.txtDB.Text = "BHotelTR";
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(200, 22);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(22, 15);
+ this.label2.TabIndex = 2;
+ this.label2.Text = "DB";
+ //
+ // txtHost
+ //
+ this.txtHost.Location = new System.Drawing.Point(58, 19);
+ this.txtHost.Name = "txtHost";
+ this.txtHost.Size = new System.Drawing.Size(129, 23);
+ this.txtHost.TabIndex = 1;
+ this.txtHost.Text = "NAVC2-OGI2";
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.Location = new System.Drawing.Point(19, 22);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(32, 15);
+ this.label1.TabIndex = 0;
+ this.label1.Text = "Host";
+ //
+ // cmbSheet
+ //
+ this.cmbSheet.FormattingEnabled = true;
+ this.cmbSheet.Location = new System.Drawing.Point(21, 39);
+ this.cmbSheet.Name = "cmbSheet";
+ this.cmbSheet.Size = new System.Drawing.Size(568, 23);
+ this.cmbSheet.TabIndex = 2;
+ this.cmbSheet.SelectedIndexChanged += new System.EventHandler(this.cmbSheet_SelectedIndexChanged);
+ //
+ // txtExcelPath
+ //
+ this.txtExcelPath.Location = new System.Drawing.Point(21, 10);
+ this.txtExcelPath.Name = "txtExcelPath";
+ this.txtExcelPath.Size = new System.Drawing.Size(568, 23);
+ this.txtExcelPath.TabIndex = 1;
+ this.txtExcelPath.TextChanged += new System.EventHandler(this.txtExcelPath_TextChanged);
+ //
+ // OpenExcel
+ //
+ this.OpenExcel.Location = new System.Drawing.Point(604, 10);
+ this.OpenExcel.Name = "OpenExcel";
+ this.OpenExcel.Size = new System.Drawing.Size(184, 52);
+ this.OpenExcel.TabIndex = 0;
+ this.OpenExcel.Text = "開く";
+ this.OpenExcel.UseVisualStyleBackColor = true;
+ this.OpenExcel.Click += new System.EventHandler(this.OpenExcel_Click);
+ //
+ // panel2
+ //
+ this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
+ this.panel2.Location = new System.Drawing.Point(0, 324);
+ this.panel2.Name = "panel2";
+ this.panel2.Size = new System.Drawing.Size(800, 126);
+ this.panel2.TabIndex = 1;
+ //
+ // openFileDialog1
+ //
+ this.openFileDialog1.FileName = "openFileDialog1";
+ this.openFileDialog1.Filter = "Excel2003以降|*.xlsx|Excel2003以前|*.xls|すべてのファイル|*.*";
+ //
+ // TableToExcel
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 15F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.ClientSize = new System.Drawing.Size(800, 450);
+ this.Controls.Add(this.panel2);
+ this.Controls.Add(this.panel1);
+ this.Name = "TableToExcel";
+ this.Text = "TableToExcel";
+ this.panel1.ResumeLayout(false);
+ this.panel1.PerformLayout();
+ this.groupBox1.ResumeLayout(false);
+ this.groupBox1.PerformLayout();
+ this.ResumeLayout(false);
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.Panel panel1;
+ private System.Windows.Forms.Panel panel2;
+ private System.Windows.Forms.OpenFileDialog openFileDialog1;
+ private System.Windows.Forms.GroupBox groupBox1;
+ private System.Windows.Forms.Button btnOpenDB;
+ private System.Windows.Forms.Label label5;
+ private System.Windows.Forms.ComboBox cmbTable;
+ private System.Windows.Forms.TextBox txtPassword;
+ private System.Windows.Forms.Label label4;
+ private System.Windows.Forms.TextBox txtUser;
+ private System.Windows.Forms.Label label3;
+ private System.Windows.Forms.TextBox txtDB;
+ private System.Windows.Forms.Label label2;
+ private System.Windows.Forms.TextBox txtHost;
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.ComboBox cmbSheet;
+ private System.Windows.Forms.TextBox txtExcelPath;
+ private System.Windows.Forms.Button OpenExcel;
+ private System.Windows.Forms.TextBox txtNewSheet;
+ private System.Windows.Forms.Button btnCopySheet;
+ private System.Windows.Forms.Button button1;
+ private System.Windows.Forms.Button button2;
+ private System.Windows.Forms.Button button3;
+ private System.Windows.Forms.TextBox txtTableConditon;
+ private System.Windows.Forms.Label lblStatus;
+ private System.Windows.Forms.Label label6;
+ }
+}
\ No newline at end of file
--
Gitblit v1.10.0