HYTOS

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "POSCO_Report", "POSCO_Report\POSCO_Report.csproj", "{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}"

EndProject

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|x64.ActiveCfg = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|x64.Build.0 = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|x86.ActiveCfg = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Debug|x86.Build.0 = Debug|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|Any CPU.Build.0 = Release|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|x64.ActiveCfg = Release|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|x64.Build.0 = Release|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|x86.ActiveCfg = Release|Any CPU

		{0B9ACE24-227C-42FF-ADAD-A7847CB91F01}.Release|x86.Build.0 = Release|Any CPU

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections>

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

      <section name="POSCO_Report.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />

    </sectionGroup>

  </configSections>

  <startup>

    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" />

  </startup>

  <entityFramework>

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />

    </providers>

  </entityFramework>

  <system.data>

    <DbProviderFactories>

      <remove invariant="System.Data.SQLite.EF6" />

      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />

    <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>

  </system.data>

  <userSettings>

    <POSCO_Report.Properties.Settings>

      <setting name="SYMBOLSETTING" serializeAs="String">

        <value />

      </setting>

      <setting name="STREAMNOATTR" serializeAs="String">

        <value />

      </setting>

      <setting name="ITEMATTR" serializeAs="String">

        <value />

      </setting>

      <setting name="TEMPLATESETTING" serializeAs="String">

        <value />

      </setting>

    </POSCO_Report.Properties.Settings>

  </userSettings>

</configuration>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SQLite;

using System.Globalization;

using System.Data;

using System.Windows.Forms;

namespace POSCO_Report

{

	public static class DB

	{

		const string HMB_From_To = "HMB_From_To";

		const string HMB_LIST = "HMB_LIST";

		const string HMB_VALUE = "HMB_VALUE";

		const string Stream_No = "Stream_No";

		const string Components = "Components";

		const string Attributes = "Attributes";

		const string Symbol = "Symbol";

		const string SymbolType = "SymbolType";

		const string SymbolAttribute = "SymbolAttribute";

		public static bool CheckConnection()

		{

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			bool result = false;

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

                            using (SQLiteCommand cmd = connection.CreateCommand())

                            {

                                cmd.CommandText = "SELECT NAME FROM sqlite_master WHERE type='table'";

                                using (SQLiteDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

                                    if (dt.Select(string.Format("NAME = '{0}'", HMB_From_To)).Length.Equals(1) &&

										dt.Select(string.Format("NAME = '{0}'", HMB_LIST)).Length.Equals(1) &&

										dt.Select(string.Format("NAME = '{0}'", HMB_VALUE)).Length.Equals(1) &&

										dt.Select(string.Format("NAME = '{0}'", Stream_No)).Length.Equals(1) &&

										dt.Select(string.Format("NAME = '{0}'", Components)).Length.Equals(1) &&

										dt.Select(string.Format("NAME = '{0}'", Attributes)).Length.Equals(1))

                                    {

										result = true;

									}

                                }

                            }

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return result;

		}

		public static DataTable GetSymbolTable()

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format("SELECT s.UID, s.Name, st.Type, s.BaseSymbol FROM {0} s LEFT JOIN {1} st on s.SymbolType_UID = st.UID", Symbol, SymbolType);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static DataTable GetSymbolAttributeTable()

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format("SELECT DISTINCT Attribute FROM {0}", SymbolAttribute);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static DataTable GetHMBCaseDataTable()

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format(@"

								SELECT hv.UID, hv.Value, hv.[Case], hv.HMB_LIST_UID, hl.Name, hl.Unit, hl.Type, st.Stream_No

								FROM {0} hv 

								LEFT JOIN {1} hl 

								ON hv.HMB_LIST_UID = hl.UID

								LEFT JOIN {2} st

								ON hv.Stream_No_UID = st.UID", HMB_VALUE, HMB_LIST, Stream_No);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static DataTable GetHMBListDataTable()

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format(@"

								SELECT *

								FROM {0}", HMB_LIST);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static DataTable GetSymbolStreamData(string streamNoAttrName)

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format(@"

								SELECT c.UID, c.SYMBOL_UID, a.[VALUE], sa.ATTRIBUTE 

								FROM COMPONENTS c, Attributes a, SymbolAttribute sa

								WHERE c.UID = a.COMPONENTS_UID AND a.SymbolAttribute_UID = sa.UID AND sa.Attribute = '{0}'", streamNoAttrName);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static DataTable GetSymbolItemData(string itemAttrName)

		{

			DataTable dt = new DataTable();

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								cmd.CommandText = string.Format(@"

								SELECT c.UID, c.SYMBOL_UID, a.[VALUE], sa.ATTRIBUTE 

								FROM COMPONENTS c, Attributes a, SymbolAttribute sa

								WHERE c.UID = a.COMPONENTS_UID AND a.SymbolAttribute_UID = sa.UID AND sa.Attribute = '{0}'", itemAttrName);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return dt;

		}

		public static string GetAttributeValue(string componentUID, string attrName)

		{

			string result = string.Empty;

			ProjectInformation projectInformation = ProjectInformation.GetInstance();

			try

			{

				if (projectInformation.DBType.Equals(DBType.SQLite))

				{

					using (SQLiteConnection connection = new SQLiteConnection(projectInformation.ConnString, true))

					{

						connection.Open();

						if (connection.State.Equals(ConnectionState.Open))

						{

							using (SQLiteCommand cmd = connection.CreateCommand())

							{

								DataTable dt = new DataTable();

								cmd.CommandText = string.Format(@"

								SELECT c.UID, c.SYMBOL_UID, a.[VALUE], sa.ATTRIBUTE 

								FROM COMPONENTS c, Attributes a, SymbolAttribute sa

								WHERE c.UID = a.COMPONENTS_UID AND a.SymbolAttribute_UID = sa.UID AND sa.Attribute = '{0}' AND c.UID = '{1}'", attrName, componentUID);

								using (SQLiteDataReader dr = cmd.ExecuteReader())

									dt.Load(dr);

								if (dt.Rows.Count.Equals(1))

									result = dt.Rows[0]["VALUE"].ToString();

							}

						}

						connection.Close();

					}

				}

				else if (projectInformation.DBType.Equals(DBType.MSSQL))

				{

					throw new Exception("mssql");

				}

			}

			catch (Exception ex)

			{

				MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);

			}

			return result;

		}

	}

}

namespace POSCO_Report

{

	partial class MainForm

	{

		/// <summary>

		/// 필수 디자이너 변수입니다.

		/// </summary>

		private System.ComponentModel.IContainer components = null;

		/// <summary>

		/// 사용 중인 모든 리소스를 정리합니다.

		/// </summary>

		/// <param name="disposing">관리되는 리소스를 삭제해야 하면 true이고, 그렇지 않으면 false입니다.</param>

		protected override void Dispose(bool disposing)

		{

			if (disposing && (components != null))

			{

				components.Dispose();

			}

			base.Dispose(disposing);

		}

		#region Windows Form 디자이너에서 생성한 코드

		/// <summary>

		/// 디자이너 지원에 필요한 메서드입니다. 

		/// 이 메서드의 내용을 코드 편집기로 수정하지 마세요.

		/// </summary>

		private void InitializeComponent()

		{

			this.components = new System.ComponentModel.Container();

			System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MainForm));

			this.ribbonControl = new DevExpress.XtraBars.Ribbon.RibbonControl();

			this.defaultLookAndFeel = new DevExpress.LookAndFeel.DefaultLookAndFeel(this.components);

			this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();

			this.spinEditColumn = new DevExpress.XtraEditors.SpinEdit();

			this.spinEditRow = new DevExpress.XtraEditors.SpinEdit();

			this.btnGroup = new DevExpress.XtraEditors.SimpleButton();

			this.gridLookUpEditItemAttribute = new DevExpress.XtraEditors.GridLookUpEdit();

			this.gridLookUpEdit1View = new DevExpress.XtraGrid.Views.Grid.GridView();

			this.btnSymbolSetting = new DevExpress.XtraEditors.SimpleButton();

			this.btnExportExcel = new DevExpress.XtraEditors.SimpleButton();

			this.spreadsheetControl = new DevExpress.XtraSpreadsheet.SpreadsheetControl();

			this.btnLoadData = new DevExpress.XtraEditors.SimpleButton();

			this.gridLookUpEditStreamNo = new DevExpress.XtraEditors.GridLookUpEdit();

			this.gridLookUpEdit2View = new DevExpress.XtraGrid.Views.Grid.GridView();

			this.Root = new DevExpress.XtraLayout.LayoutControlGroup();

			this.layoutControlItem6 = new DevExpress.XtraLayout.LayoutControlItem();

			this.emptySpaceItem2 = new DevExpress.XtraLayout.EmptySpaceItem();

			this.layoutControlItem7 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem5 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem8 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem10 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup();

			this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem3 = new DevExpress.XtraLayout.LayoutControlItem();

			this.layoutControlItem9 = new DevExpress.XtraLayout.LayoutControlItem();

			this.emptySpaceItem1 = new DevExpress.XtraLayout.EmptySpaceItem();

			((System.ComponentModel.ISupportInitialize)(this.ribbonControl)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();

			this.layoutControl1.SuspendLayout();

			((System.ComponentModel.ISupportInitialize)(this.spinEditColumn.Properties)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.spinEditRow.Properties)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEditItemAttribute.Properties)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit1View)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEditStreamNo.Properties)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit2View)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.Root)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem6)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem7)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem5)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem8)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem10)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem3)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem9)).BeginInit();

			((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).BeginInit();

			this.SuspendLayout();

			// 

			// ribbonControl

			// 

			this.ribbonControl.ExpandCollapseItem.Id = 0;

			this.ribbonControl.Items.AddRange(new DevExpress.XtraBars.BarItem[] {

            this.ribbonControl.ExpandCollapseItem});

			this.ribbonControl.Location = new System.Drawing.Point(0, 0);

			this.ribbonControl.MaxItemId = 1;

			this.ribbonControl.Name = "ribbonControl";

			this.ribbonControl.ShowApplicationButton = DevExpress.Utils.DefaultBoolean.False;

			this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

			this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

			this.ribbonControl.ShowToolbarCustomizeItem = false;

			this.ribbonControl.Size = new System.Drawing.Size(1471, 32);

			this.ribbonControl.Toolbar.ShowCustomizeItem = false;

			// 

			// defaultLookAndFeel

			// 

			this.defaultLookAndFeel.LookAndFeel.SkinName = "Office 2016 Colorful";

			// 

			// layoutControl1

			// 

			this.layoutControl1.Controls.Add(this.spinEditColumn);

			this.layoutControl1.Controls.Add(this.spinEditRow);

			this.layoutControl1.Controls.Add(this.btnGroup);

			this.layoutControl1.Controls.Add(this.gridLookUpEditItemAttribute);

			this.layoutControl1.Controls.Add(this.btnSymbolSetting);

			this.layoutControl1.Controls.Add(this.btnExportExcel);

			this.layoutControl1.Controls.Add(this.spreadsheetControl);

			this.layoutControl1.Controls.Add(this.btnLoadData);

			this.layoutControl1.Controls.Add(this.gridLookUpEditStreamNo);

			this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;

			this.layoutControl1.Location = new System.Drawing.Point(0, 32);

			this.layoutControl1.Name = "layoutControl1";

			this.layoutControl1.Root = this.Root;

			this.layoutControl1.Size = new System.Drawing.Size(1471, 808);

			this.layoutControl1.TabIndex = 1;

			this.layoutControl1.Text = "layoutControl1";

			// 

			// spinEditColumn

			// 

			this.spinEditColumn.EditValue = new decimal(new int[] {

            1,

            0,

            0,

            0});

			this.spinEditColumn.Location = new System.Drawing.Point(113, 195);

			this.spinEditColumn.MenuManager = this.ribbonControl;

			this.spinEditColumn.Name = "spinEditColumn";

			this.spinEditColumn.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

			this.spinEditColumn.Properties.Mask.EditMask = "f0";

			this.spinEditColumn.Properties.MaxValue = new decimal(new int[] {

            100,

            0,

            0,

            0});

			this.spinEditColumn.Properties.MinValue = new decimal(new int[] {

            1,

            0,

            0,

            0});

			this.spinEditColumn.Size = new System.Drawing.Size(147, 20);

			this.spinEditColumn.StyleController = this.layoutControl1;

			this.spinEditColumn.TabIndex = 19;

			// 

			// spinEditRow

			// 

			this.spinEditRow.EditValue = new decimal(new int[] {

            1,

            0,

            0,

            0});

			this.spinEditRow.Location = new System.Drawing.Point(113, 171);

			this.spinEditRow.MenuManager = this.ribbonControl;

			this.spinEditRow.Name = "spinEditRow";

			this.spinEditRow.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

			this.spinEditRow.Properties.Mask.EditMask = "f0";

			this.spinEditRow.Properties.MaxValue = new decimal(new int[] {

            100,

            0,

            0,

            0});

			this.spinEditRow.Properties.MinValue = new decimal(new int[] {

            1,

            0,

            0,

            0});

			this.spinEditRow.Size = new System.Drawing.Size(147, 20);

			this.spinEditRow.StyleController = this.layoutControl1;

			this.spinEditRow.TabIndex = 17;

			// 

			// btnGroup

			// 

			this.btnGroup.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnGroup.ImageOptions.Image")));

			this.btnGroup.Location = new System.Drawing.Point(12, 52);

			this.btnGroup.Name = "btnGroup";

			this.btnGroup.Size = new System.Drawing.Size(260, 36);

			this.btnGroup.StyleController = this.layoutControl1;

			this.btnGroup.TabIndex = 16;

			this.btnGroup.Text = "Template Setting";

			this.btnGroup.Click += new System.EventHandler(this.btnGroup_Click);

			// 

			// gridLookUpEditItemAttribute

			// 

			this.gridLookUpEditItemAttribute.Location = new System.Drawing.Point(113, 147);

			this.gridLookUpEditItemAttribute.MenuManager = this.ribbonControl;

			this.gridLookUpEditItemAttribute.Name = "gridLookUpEditItemAttribute";

			this.gridLookUpEditItemAttribute.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

			this.gridLookUpEditItemAttribute.Properties.PopupView = this.gridLookUpEdit1View;

			this.gridLookUpEditItemAttribute.Size = new System.Drawing.Size(147, 20);

			this.gridLookUpEditItemAttribute.StyleController = this.layoutControl1;

			this.gridLookUpEditItemAttribute.TabIndex = 12;

			// 

			// gridLookUpEdit1View

			// 

			this.gridLookUpEdit1View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;

			this.gridLookUpEdit1View.Name = "gridLookUpEdit1View";

			this.gridLookUpEdit1View.OptionsSelection.EnableAppearanceFocusedCell = false;

			this.gridLookUpEdit1View.OptionsView.ShowGroupPanel = false;

			// 

			// btnSymbolSetting

			// 

			this.btnSymbolSetting.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnSymbolSetting.ImageOptions.Image")));

			this.btnSymbolSetting.Location = new System.Drawing.Point(12, 12);

			this.btnSymbolSetting.Name = "btnSymbolSetting";

			this.btnSymbolSetting.Size = new System.Drawing.Size(260, 36);

			this.btnSymbolSetting.StyleController = this.layoutControl1;

			this.btnSymbolSetting.TabIndex = 11;

			this.btnSymbolSetting.Text = "Symbol Setting";

			this.btnSymbolSetting.Click += new System.EventHandler(this.btnSymbolSetting_Click);

			// 

			// btnExportExcel

			// 

			this.btnExportExcel.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnExportExcel.ImageOptions.Image")));

			this.btnExportExcel.Location = new System.Drawing.Point(1374, 760);

			this.btnExportExcel.Name = "btnExportExcel";

			this.btnExportExcel.Size = new System.Drawing.Size(85, 36);

			this.btnExportExcel.StyleController = this.layoutControl1;

			this.btnExportExcel.TabIndex = 10;

			this.btnExportExcel.Text = "Export";

			this.btnExportExcel.Click += new System.EventHandler(this.btnExportExcel_Click);

			// 

			// spreadsheetControl

			// 

			this.spreadsheetControl.Location = new System.Drawing.Point(276, 12);

			this.spreadsheetControl.MenuManager = this.ribbonControl;

			this.spreadsheetControl.Name = "spreadsheetControl";

			this.spreadsheetControl.Options.Import.Csv.Encoding = ((System.Text.Encoding)(resources.GetObject("spreadsheetControl.Options.Import.Csv.Encoding")));

			this.spreadsheetControl.Options.Import.Txt.Encoding = ((System.Text.Encoding)(resources.GetObject("spreadsheetControl.Options.Import.Txt.Encoding")));

			this.spreadsheetControl.Size = new System.Drawing.Size(1183, 744);

			this.spreadsheetControl.TabIndex = 9;

			this.spreadsheetControl.Text = "spreadsheetControl1";

			// 

			// btnLoadData

			// 

			this.btnLoadData.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnLoadData.ImageOptions.Image")));

			this.btnLoadData.Location = new System.Drawing.Point(12, 231);

			this.btnLoadData.Name = "btnLoadData";

			this.btnLoadData.Size = new System.Drawing.Size(260, 36);

			this.btnLoadData.StyleController = this.layoutControl1;

			this.btnLoadData.TabIndex = 8;

			this.btnLoadData.Text = "Load Data";

			this.btnLoadData.Click += new System.EventHandler(this.btnLoadData_Click);

			// 

			// gridLookUpEditStreamNo

			// 

			this.gridLookUpEditStreamNo.Location = new System.Drawing.Point(113, 123);

			this.gridLookUpEditStreamNo.MenuManager = this.ribbonControl;

			this.gridLookUpEditStreamNo.Name = "gridLookUpEditStreamNo";

			this.gridLookUpEditStreamNo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

			this.gridLookUpEditStreamNo.Properties.PopupView = this.gridLookUpEdit2View;

			this.gridLookUpEditStreamNo.Size = new System.Drawing.Size(147, 20);

			this.gridLookUpEditStreamNo.StyleController = this.layoutControl1;

			this.gridLookUpEditStreamNo.TabIndex = 5;

			// 

			// gridLookUpEdit2View

			// 

			this.gridLookUpEdit2View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;

			this.gridLookUpEdit2View.Name = "gridLookUpEdit2View";

			this.gridLookUpEdit2View.OptionsSelection.EnableAppearanceFocusedCell = false;

			this.gridLookUpEdit2View.OptionsView.ShowGroupPanel = false;

			// 

			// Root

			// 

			this.Root.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;

			this.Root.GroupBordersVisible = false;

			this.Root.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.layoutControlItem6,

            this.emptySpaceItem2,

            this.layoutControlItem7,

            this.layoutControlItem5,

            this.layoutControlItem8,

            this.layoutControlItem10,

            this.layoutControlGroup2,

            this.emptySpaceItem1});

			this.Root.Name = "Root";

			this.Root.Size = new System.Drawing.Size(1471, 808);

			this.Root.TextVisible = false;

			// 

			// layoutControlItem6

			// 

			this.layoutControlItem6.Control = this.spreadsheetControl;

			this.layoutControlItem6.Location = new System.Drawing.Point(264, 0);

			this.layoutControlItem6.Name = "layoutControlItem6";

			this.layoutControlItem6.Size = new System.Drawing.Size(1187, 748);

			this.layoutControlItem6.TextSize = new System.Drawing.Size(0, 0);

			this.layoutControlItem6.TextVisible = false;

			// 

			// emptySpaceItem2

			// 

			this.emptySpaceItem2.AllowHotTrack = false;

			this.emptySpaceItem2.Location = new System.Drawing.Point(0, 748);

			this.emptySpaceItem2.Name = "emptySpaceItem2";

			this.emptySpaceItem2.Size = new System.Drawing.Size(1362, 40);

			this.emptySpaceItem2.TextSize = new System.Drawing.Size(0, 0);

			// 

			// layoutControlItem7

			// 

			this.layoutControlItem7.Control = this.btnExportExcel;

			this.layoutControlItem7.Location = new System.Drawing.Point(1362, 748);

			this.layoutControlItem7.Name = "layoutControlItem7";

			this.layoutControlItem7.Size = new System.Drawing.Size(89, 40);

			this.layoutControlItem7.TextSize = new System.Drawing.Size(0, 0);

			this.layoutControlItem7.TextVisible = false;

			// 

			// layoutControlItem5

			// 

			this.layoutControlItem5.Control = this.btnLoadData;

			this.layoutControlItem5.Location = new System.Drawing.Point(0, 219);

			this.layoutControlItem5.Name = "layoutControlItem5";

			this.layoutControlItem5.Size = new System.Drawing.Size(264, 40);

			this.layoutControlItem5.TextSize = new System.Drawing.Size(0, 0);

			this.layoutControlItem5.TextVisible = false;

			// 

			// layoutControlItem8

			// 

			this.layoutControlItem8.Control = this.btnSymbolSetting;

			this.layoutControlItem8.Location = new System.Drawing.Point(0, 0);

			this.layoutControlItem8.Name = "layoutControlItem8";

			this.layoutControlItem8.Size = new System.Drawing.Size(264, 40);

			this.layoutControlItem8.TextSize = new System.Drawing.Size(0, 0);

			this.layoutControlItem8.TextVisible = false;

			// 

			// layoutControlItem10

			// 

			this.layoutControlItem10.Control = this.btnGroup;

			this.layoutControlItem10.Location = new System.Drawing.Point(0, 40);

			this.layoutControlItem10.Name = "layoutControlItem10";

			this.layoutControlItem10.Size = new System.Drawing.Size(264, 40);

			this.layoutControlItem10.TextSize = new System.Drawing.Size(0, 0);

			this.layoutControlItem10.TextVisible = false;

			// 

			// layoutControlGroup2

			// 

			this.layoutControlGroup2.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.layoutControlItem2,

            this.layoutControlItem1,

            this.layoutControlItem3,

            this.layoutControlItem9});

			this.layoutControlGroup2.Location = new System.Drawing.Point(0, 80);

			this.layoutControlGroup2.Name = "layoutControlGroup2";

			this.layoutControlGroup2.Size = new System.Drawing.Size(264, 139);

			this.layoutControlGroup2.Text = "Attribute Mapping";

			// 

			// layoutControlItem2

			// 

			this.layoutControlItem2.Control = this.gridLookUpEditStreamNo;

			this.layoutControlItem2.Location = new System.Drawing.Point(0, 0);

			this.layoutControlItem2.Name = "layoutControlItem2";

			this.layoutControlItem2.Size = new System.Drawing.Size(240, 24);

			this.layoutControlItem2.Text = "Stream Number";

			this.layoutControlItem2.TextSize = new System.Drawing.Size(86, 14);

			// 

			// layoutControlItem1

			// 

			this.layoutControlItem1.Control = this.gridLookUpEditItemAttribute;

			this.layoutControlItem1.Location = new System.Drawing.Point(0, 24);

			this.layoutControlItem1.Name = "layoutControlItem1";

			this.layoutControlItem1.Size = new System.Drawing.Size(240, 24);

			this.layoutControlItem1.Text = "Attribute";

			this.layoutControlItem1.TextSize = new System.Drawing.Size(86, 14);

			// 

			// layoutControlItem3

			// 

			this.layoutControlItem3.Control = this.spinEditRow;

			this.layoutControlItem3.Location = new System.Drawing.Point(0, 48);

			this.layoutControlItem3.Name = "layoutControlItem3";

			this.layoutControlItem3.Size = new System.Drawing.Size(240, 24);

			this.layoutControlItem3.Text = "Start Row";

			this.layoutControlItem3.TextSize = new System.Drawing.Size(86, 14);

			// 

			// layoutControlItem9

			// 

			this.layoutControlItem9.Control = this.spinEditColumn;

			this.layoutControlItem9.Location = new System.Drawing.Point(0, 72);

			this.layoutControlItem9.Name = "layoutControlItem9";

			this.layoutControlItem9.Size = new System.Drawing.Size(240, 24);

			this.layoutControlItem9.Text = "Start Column";

			this.layoutControlItem9.TextSize = new System.Drawing.Size(86, 14);

			// 

			// emptySpaceItem1

			// 

			this.emptySpaceItem1.AllowHotTrack = false;

			this.emptySpaceItem1.Location = new System.Drawing.Point(0, 259);

			this.emptySpaceItem1.Name = "emptySpaceItem1";

			this.emptySpaceItem1.Size = new System.Drawing.Size(264, 489);

			this.emptySpaceItem1.TextSize = new System.Drawing.Size(0, 0);

			// 

			// MainForm

			// 

			this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 14F);

			this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

			this.ClientSize = new System.Drawing.Size(1471, 840);

			this.Controls.Add(this.layoutControl1);

			this.Controls.Add(this.ribbonControl);

			this.Name = "MainForm";

			this.Ribbon = this.ribbonControl;

			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

			this.Text = "Report";

			this.Load += new System.EventHandler(this.Report_Load);

			((System.ComponentModel.ISupportInitialize)(this.ribbonControl)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();

			this.layoutControl1.ResumeLayout(false);

			((System.ComponentModel.ISupportInitialize)(this.spinEditColumn.Properties)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.spinEditRow.Properties)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEditItemAttribute.Properties)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit1View)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEditStreamNo.Properties)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit2View)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.Root)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem6)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem7)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem5)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem8)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem10)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem3)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.layoutControlItem9)).EndInit();

			((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).EndInit();

			this.ResumeLayout(false);

			this.PerformLayout();

		}

		#endregion

		private DevExpress.XtraBars.Ribbon.RibbonControl ribbonControl;

		private DevExpress.LookAndFeel.DefaultLookAndFeel defaultLookAndFeel;

		private DevExpress.XtraLayout.LayoutControl layoutControl1;

		private DevExpress.XtraLayout.LayoutControlGroup Root;

		private DevExpress.XtraSpreadsheet.SpreadsheetControl spreadsheetControl;

		private DevExpress.XtraEditors.SimpleButton btnLoadData;

		private DevExpress.XtraEditors.GridLookUpEdit gridLookUpEditStreamNo;

		private DevExpress.XtraGrid.Views.Grid.GridView gridLookUpEdit2View;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem2;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem5;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem6;

		private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem2;

		private DevExpress.XtraEditors.SimpleButton btnExportExcel;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

		private DevExpress.XtraEditors.SimpleButton btnSymbolSetting;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem8;

		private DevExpress.XtraEditors.GridLookUpEdit gridLookUpEditItemAttribute;

		private DevExpress.XtraGrid.Views.Grid.GridView gridLookUpEdit1View;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem1;

		private DevExpress.XtraEditors.SimpleButton btnGroup;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem10;

		private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup2;

		private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem1;

		private DevExpress.XtraEditors.SpinEdit spinEditColumn;

		private DevExpress.XtraEditors.SpinEdit spinEditRow;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem3;

		private DevExpress.XtraLayout.LayoutControlItem layoutControlItem9;

	}

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using DevExpress.Spreadsheet;

using DevExpress.XtraEditors;

using Newtonsoft.Json;

using POSCO_Report.Properties;

namespace POSCO_Report

{

	public partial class MainForm : DevExpress.XtraBars.Ribbon.RibbonForm

	{

		ProjectInformation projectInformation = ProjectInformation.GetInstance();

		public MainForm()

		{

			InitializeComponent();

		}

		private void Report_Load(object sender, EventArgs e)

		{

			string[] strArg = Environment.GetCommandLineArgs();

			strArg = new string[] { "SQLite", @"Data Source = C:\Users\gaqhf\Desktop\macro\POSCO_S" };

			bool bContinue = false;

			if (strArg.Length.Equals(2))

			{

				string dbType = strArg[0];

				projectInformation.ProjectDirectory = strArg[1];

				DBType type = DBType.None;

				if (Enum.TryParse(dbType, out type))

				{

					projectInformation.DBType = type;

					if (DB.CheckConnection())

						bContinue = true;

				}

			}

			if (!bContinue)

			{

				MessageBox.Show("Check ID2 DB information!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

				Close();

			}

			else

			{

				InitLookUpEdit();

			}

		}

		private void InitLookUpEdit()

		{

			DataTable dt = DB.GetSymbolAttributeTable();

			SetLookUpEditProperties(gridLookUpEditStreamNo, dt);

			SetLookUpEditProperties(gridLookUpEditItemAttribute, dt);

			#region Set Mapping Data

			string streamAttr = Settings.Default.STREAMNOATTR;

			string itemAttr = Settings.Default.ITEMATTR;

			if (!string.IsNullOrEmpty(streamAttr))

				for (int i = 0; i < dt.Rows.Count; i++)

				{

					DataRow row = dt.Rows[i];

					if (row["Attribute"].ToString().Equals(streamAttr))

					{

						DataRowView view = dt.DefaultView[i];

						gridLookUpEditStreamNo.EditValue = view;

						break;

					}

				}

			if (!string.IsNullOrEmpty(itemAttr))

				for (int i = 0; i < dt.Rows.Count; i++)

				{

					DataRow row = dt.Rows[i];

					if (row["Attribute"].ToString().Equals(itemAttr))

					{

						DataRowView view = dt.DefaultView[i];

						gridLookUpEditItemAttribute.EditValue = view;

						break;

					}

				}

			#endregion

			gridLookUpEditStreamNo.EditValueChanged += LookUpEdit_EditValueChanged;

			gridLookUpEditItemAttribute.EditValueChanged += LookUpEdit_EditValueChanged;

		}

		private void btnSymbolSetting_Click(object sender, EventArgs e)

		{

			SymbolForm symbolForm = new SymbolForm();

			symbolForm.ShowDialog();

		}

		private void SetLookUpEditProperties(GridLookUpEdit lookUpEdit, DataTable dt)

		{

			lookUpEdit.KeyUp += lookUpEdit_KeyUp;

			lookUpEdit.Properties.DataSource = dt;

			lookUpEdit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;

			lookUpEdit.Properties.DisplayMember = "Attribute";

			lookUpEdit.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

			lookUpEdit.Properties.NullText = "";

			lookUpEdit.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;

		}

		private void LookUpEdit_EditValueChanged(object sender, EventArgs e)

		{

			LookUpEditBase lookupEditor = sender as LookUpEditBase;

			if (lookupEditor == null || lookupEditor.EditValue == null) return;

			DataRowView streamNoRow = gridLookUpEditStreamNo.EditValue as DataRowView;

			string streamNoAttr = streamNoRow != null ? streamNoRow["Attribute"].ToString() : string.Empty;

			DataRowView itemRow = gridLookUpEditItemAttribute.EditValue as DataRowView;

			string itemAttr = itemRow != null ? itemRow["Attribute"].ToString() : string.Empty;

			Settings.Default.STREAMNOATTR = streamNoAttr;

			Settings.Default.ITEMATTR = itemAttr;

			Settings.Default.Save();

		}

		private void lookUpEdit_KeyUp(object sender, KeyEventArgs e)

		{

			GridLookUpEdit edit = sender as GridLookUpEdit;

			if (e.KeyCode == Keys.Delete)

			{

				edit.ClosePopup();

				edit.EditValue = null;

			}

			else if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Escape)

			{

				if (edit.IsPopupOpen)

					edit.ClosePopup();

			}

			else if (!edit.IsPopupOpen)

				edit.ShowPopup();

			e.Handled = true;

		}

		private void btnLoadData_Click(object sender, EventArgs e)

		{

			if (spreadsheetControl.CreateNewDocument())

			{

				spreadsheetControl.BeginUpdate();

				IWorkbook workbook = spreadsheetControl.Document;

				List<TemplateItem> templateItems = JsonConvert.DeserializeObject<List<TemplateItem>>(Settings.Default.TEMPLATESETTING);

				DataTable HMBDataTable = DB.GetHMBCaseDataTable();

				List<string> symbolLists = new List<string>();

				string streamNoAttrName = Settings.Default.STREAMNOATTR;

				string templateItemAttribute = Settings.Default.ITEMATTR;

				string symbolSettingValue = Settings.Default.SYMBOLSETTING;

				if (!string.IsNullOrEmpty(symbolSettingValue))

				{

					string[] split = symbolSettingValue.Split(new string[] { "*|*" }, StringSplitOptions.None);

					symbolLists = split.ToList();

				}

				DataTable symbolStreamTable = DB.GetSymbolStreamData(streamNoAttrName);

				DataTable symbolItemTable = DB.GetSymbolItemData(templateItemAttribute);

				foreach (TemplateItem template in templateItems)

				{

					string templateName = template.Name;

					List<string> itemAttr = template.ItemList;

					List<DataRow> itemRows = new List<DataRow>();

					foreach (var attrName in itemAttr)

						itemRows.AddRange(symbolItemTable.Select(string.Format("VALUE = '{0}'", attrName)));

					List<DataRow> streamRows = new List<DataRow>();

					foreach (var row in itemRows)

						if (row["SYMBOL_UID"] != null && row["SYMBOL_UID"] != DBNull.Value && symbolLists.Contains(row["SYMBOL_UID"].ToString()))

							streamRows.AddRange(symbolStreamTable.Select(string.Format("UID = '{0}'", row["UID"])));

					List<DataRow> endRows = new List<DataRow>();

					foreach (var row in streamRows)

					{

						if (row["VALUE"] != null && row["VALUE"] != DBNull.Value && !string.IsNullOrEmpty(row["VALUE"].ToString()))

						{

							string streamNo = row["VALUE"].ToString();

							if (HMBDataTable.Select(string.Format("STREAM_NO = '{0}'", streamNo)).Length > 0)

								endRows.Add(row);

						}

					}

					if (endRows.Count > 0)

					{

						Worksheet worksheet = workbook.Worksheets.Add(template.Name);

						bool bFirst = true;

						int startRowIndex = Convert.ToInt32(spinEditRow.EditValue) - 1;

						int startColIndex = Convert.ToInt32(spinEditColumn.EditValue) - 1;

						int dataRowIndex = startRowIndex + 3;

						int colIndex = 0;

						foreach (var row in endRows)

						{

							string streamNo = row["VALUE"].ToString();

							DataRow[] streamDataRows = HMBDataTable.Select(string.Format("STREAM_NO = '{0}'", streamNo));

							if (bFirst)

							{

								Range range = worksheet.Range.FromLTRB(startColIndex, startRowIndex, startColIndex, startRowIndex + 2);

								range.Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

								range.SetValue("NO.");

								range.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

								range.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

							}

							worksheet[dataRowIndex, startColIndex].SetValue((endRows.IndexOf(row) + 1).ToString());

							worksheet[dataRowIndex, startColIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

							colIndex = startColIndex + 1;

							// 추가 Attribute Before

							foreach (var attrName in template.CustomAttributeBefore)

							{

								string sCustomAttr = DB.GetAttributeValue(row["UID"].ToString(), attrName);

								worksheet[dataRowIndex, colIndex].SetValue(sCustomAttr);

								worksheet[dataRowIndex, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

								if (bFirst)

								{

									Range range = worksheet.Range.FromLTRB(colIndex, startRowIndex, colIndex, startRowIndex + 2);

									range.SetValue(attrName);

									range.Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

									range.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

									range.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

								}

								colIndex++;

							}

							for (int i = 0; i < streamDataRows.Length; i++)

							{

								DataRow dataRow = streamDataRows[i];

								if (!template.Case.Contains(dataRow["HMB_LIST_UID"].ToString()))

									continue;

								if (bFirst)

								{

									string sCase = dataRow["CASE"].ToString();

									string sType = dataRow["TYPE"].ToString();

									string sName = dataRow["NAME"].ToString();

									worksheet[startRowIndex, colIndex].SetValue(sCase);

									worksheet[startRowIndex + 1, colIndex].SetValue(!string.IsNullOrEmpty(sType) ? sType : sName);

									worksheet[startRowIndex + 2, colIndex].SetValue(sName);

									worksheet[startRowIndex, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

									worksheet[startRowIndex + 1, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

									worksheet[startRowIndex + 2, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

									worksheet[startRowIndex, colIndex].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

									worksheet[startRowIndex + 1, colIndex].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

									worksheet[startRowIndex + 2, colIndex].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

									worksheet[startRowIndex, colIndex].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

									worksheet[startRowIndex + 1, colIndex].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

									worksheet[startRowIndex + 2, colIndex].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

								}

								string sValue = dataRow["VALUE"].ToString();

								string sUnit = dataRow["UNIT"].ToString();

								if (!string.IsNullOrEmpty(sValue))

								{

									if (sUnit.Equals("-"))

										worksheet[dataRowIndex, colIndex].SetValue(sValue);

									else

										worksheet[dataRowIndex, colIndex].SetValue(sValue + " " + sUnit);

								}

								worksheet[dataRowIndex, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

								colIndex++;

							}

							// 추가 Attribute after

							foreach (var attrName in template.CustomAttributeAfter)

							{

								string sCustomAttr = DB.GetAttributeValue(row["UID"].ToString(), attrName);

								worksheet[dataRowIndex, colIndex].SetValue(sCustomAttr);

								worksheet[dataRowIndex, colIndex].Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

								if (bFirst)

								{

									Range range = worksheet.Range.FromLTRB(colIndex, startRowIndex, colIndex, startRowIndex + 2);

									range.SetValue(attrName);

									range.Borders.SetAllBorders(Color.Black, BorderLineStyle.Thin);

									range.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

									range.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

								}

								colIndex++;

							}

							bFirst = false;

							dataRowIndex++;

						}

						#region 정리

						// 세로

						for (int i = startColIndex; i < int.MaxValue; i++)

						{

							Cell cell1 = worksheet[startRowIndex, i];

							Cell cell2 = worksheet[startRowIndex + 1, i];

							Cell cell3 = worksheet[startRowIndex + 2, i];

							CellValue value1 = worksheet[startRowIndex, i].Value;

							CellValue value2 = worksheet[startRowIndex + 1, i].Value;

							CellValue value3 = worksheet[startRowIndex + 2, i].Value;

							if (string.IsNullOrEmpty(value1.TextValue))

								break;

							if (value1.TextValue.Equals(value2.TextValue) && value2.TextValue.Equals(value3.TextValue))

							{

								Range range = worksheet.Range.FromLTRB(i, startRowIndex, i, startRowIndex + 2);

								worksheet.MergeCells(range);

							}

							else if (value2.TextValue.Equals(value3.TextValue))

							{

								Range range = worksheet.Range.FromLTRB(i, startRowIndex + 1, i, startRowIndex + 2);

								worksheet.MergeCells(range);

							}

							cell1.FillColor = Color.LightGray;

							cell2.FillColor = Color.LightGray;

							cell3.FillColor = Color.LightGray;

						}

						// 가로 행 1

						for (int i = startColIndex; i < int.MaxValue; i++)

						{

							Cell cell = worksheet[startRowIndex, i];

							Cell nextCell = worksheet[startRowIndex, i + 1];

							if (nextCell.IsMerged)

								continue;

							if (nextCell.Value == null || string.IsNullOrEmpty(nextCell.Value.TextValue))

								break;

							string value = string.Empty;

							string nextValue = nextCell.Value.TextValue;

							Range range = null;

							if (cell.IsMerged)

							{

								range = cell.GetMergedRanges().ToList().First();

								if (range.LeftColumnIndex.Equals(range.RightColumnIndex))

									continue;

								value = range.Value.TextValue;

							}

							else

								value = cell.Value.TextValue;

							if (value.Equals(nextValue))

							{

								int leftCol = 0;

								int rightCol = i + 1;

								if (range == null)

									leftCol = i;

								else

								{

									leftCol = range.LeftColumnIndex;

									range.UnMerge();

								}

								Range newRange = worksheet.Range.FromLTRB(leftCol, startRowIndex, rightCol, startRowIndex);

								newRange.Merge();

							}

						}

						// 가로 행 2

						for (int i = startColIndex; i < int.MaxValue; i++)

						{

							Cell cell = worksheet[startRowIndex + 1, i];

							Cell nextCell = worksheet[startRowIndex + 1, i + 1];

							if (nextCell.IsMerged)

								continue;

							if (nextCell.Value == null || string.IsNullOrEmpty(nextCell.Value.TextValue))

								break;

							string value = string.Empty;

							string nextValue = nextCell.Value.TextValue;

							Range range = null;

							if (cell.IsMerged)

							{

								range = cell.GetMergedRanges().ToList().First();

								if (range.LeftColumnIndex.Equals(range.RightColumnIndex))

									continue;

								value = range.Value.TextValue;

							}

							else

								value = cell.Value.TextValue;

							if (value.Equals(nextValue))

							{

								int leftCol = 0;

								int rightCol = i + 1;

								if (range == null)

									leftCol = i;

								else

								{

									leftCol = range.LeftColumnIndex;

									range.UnMerge();

								}

								Range newRange = worksheet.Range.FromLTRB(leftCol, startRowIndex + 1, rightCol, startRowIndex + 1);

								newRange.Merge();

							}

						}

						#endregion

						worksheet.Columns.AutoFit(startColIndex, colIndex - 1);

					}

				}

				spreadsheetControl.Document.Worksheets.Remove(spreadsheetControl.Document.Worksheets[0]);

				spreadsheetControl.EndUpdate();

			}

		}

		private void btnGroup_Click(object sender, EventArgs e)

		{

			TemplateForm groupForm = new TemplateForm();

			groupForm.ShowDialog();

		}

		private void btnExportExcel_Click(object sender, EventArgs e)

		{

			SaveFileDialog dialog = new SaveFileDialog();

			dialog.Filter = "Excel File(*.xlsx)|*.xlsx";

			if (dialog.ShowDialog() == DialogResult.OK)

				spreadsheetControl.Document.SaveDocument(dialog.FileName, DocumentFormat.Xlsx);

		}

	}

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <metadata name="defaultLookAndFeel.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

    <value>17, 17</value>

  </metadata>

  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

  <data name="btnGroup.ImageOptions.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAABGdBTUEAALGPC/xhBQAAACt0RVh0VGl0

        bGUAU2V0dXA7Q3VzdG9taXo7RGVzaWduO1NldHRpbmc7UHJvcGVydDgftSEAAApzSURBVFhHnVdnVFVX

        Fr7WkGKmJJkxa7ISgyODiUQdUSMKFkSUGAU1gqBA4mCJDQyg+FAJxRIBUVZQo6CoCKigFJH+6B0UEKQL

        0rsIdlx7vn3ee6iz5sdM9lof5917zznf7ucg/Q4ZBowARgNqSrwFjASGA/+/HDgW/N/hw7gkeQDuRy/x

        VEFuv+/4DDevi+TqdZ5cPc+Ti2cgLV258Wt8YyWG7Tt8Vtp7CDgYIDkf9JdkHmekPR6nBZzcf5N2u52S

        drue5P0UwmQvBl++AQiTCbz2ji0cJTtw2is1q4SePR8USMm8TassbI/iG3uD5wytVT6Ld719j6TevgGp

        +8GA5ODih1dKeV0BiGoRu5kt4lG1CT+/s/ewf1ljSxf1PnxM7d0Pqba+hVavsy/HtzEAh4bnMV4P0yhg

        eBfIu3r7pZ/2+uJRKe4+QW+QG3675l2XI+eigXg7mbcO3ok4r7NxmLDb1c/D0+8yPX32QpA3t/cSLKPN

        tu60xMTmkLGpzUTMZUXGWG3cvXCn87EkO5nPzfEaWh/iHSs0vLOnX7KVHcNPpbh5Xxxy8SKQu3kHxpRV

        1lNFzX06GRhJzh6nb+xxOxV22DdkMDo+m1rauql/4Kkgb2ztofsAzz8VcJXcPAMHbZ28o2z3+CR7nwyl

        wuIqyi4oJzvZ0YRx47/4CBysxLAdu72ZTyE/e13gga0fse+wf3RZZYOwsP/RU3r85DkVl9VSTmE5DYjn