{"id":42624,"date":"2024-11-11T03:11:02","date_gmt":"2024-11-11T03:11:02","guid":{"rendered":"https:\/\/atmokpo.com\/w\/?p=42624"},"modified":"2024-11-26T06:34:54","modified_gmt":"2024-11-26T06:34:54","slug":"19-%ec%98%a4%eb%9d%bc%ed%81%b4-%ed%94%84%eb%a1%9c%ec%8b%9c%ec%a0%80%ec%99%80-c%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-%eb%8c%80%ec%8b%9c%eb%b3%b4%eb%93%9c-%ec%95%a0%ed%94%8c%eb%a6%ac%ec%bc%80%ec%9d%b4","status":"publish","type":"post","link":"https:\/\/atmokpo.com\/w\/42624\/","title":{"rendered":"[C# PL\/SQL] 19.\uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc640 C#\uc744 \uc774\uc6a9\ud55c \ub300\uc2dc\ubcf4\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c, \ub370\uc774\ud130 \uc9d1\uacc4 \ud504\ub85c\uc2dc\uc800, C# WPF WinForms \uc5f0\ub3d9, \uadf8\ub798\ud504 \ubc0f \ucc28\ud2b8 \uad6c\ud604."},"content":{"rendered":"

<\/p>\n

\ud604\ub300 \uae30\uc5c5 \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\uc758 \uc591\uc740 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud558\uace0 \uc788\uc73c\uba70, \uc774\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \uc2dc\uac01\ud654\ud558\ub294 \uac83\uc774 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud504\ub85c\uc2dc\uc800\uc640 C# \uc5b8\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec \ub300\uc2dc\ubcf4\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \ub370\uc774\ud130 \uc9d1\uacc4 \ud504\ub85c\uc2dc\uc800, C# WPF \ubc0f WinForms \uc5f0\ub3d9, \uadf8\ub9ac\uace0 \uadf8\ub798\ud504\uc640 \ucc28\ud2b8 \uad6c\ud604\uc5d0 \ud3ec\ucee4\uc2a4\ub97c \ub450\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

1. \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub780?<\/h2>\n

\uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub294 PL\/SQL \uc5b8\uc5b4\ub85c \uc791\uc131\ub41c \ud558\ub098\uc758 \uc800\uc7a5\ud615 \ube14\ub85d\uc785\ub2c8\ub2e4. \ud504\ub85c\uc2dc\uc800\ub97c \ud1b5\ud574 \ubcf5\uc7a1\ud55c \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\ubd80\uc5d0\uc11c \ucc98\ub9ac\ud560 \uc218 \uc788\uc5b4 \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d\uc744 \uc904\uc774\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

1.1. \ud504\ub85c\uc2dc\uc800\uc758 \uae30\ubcf8 \uad6c\uc870<\/h3>\n
CREATE OR REPLACE PROCEDURE \ud504\ub85c\uc2dc\uc800\uba85 IS\n    -- \ubcc0\uc218 \uc120\uc5b8\nBEGIN\n    -- \ud504\ub85c\uc2dc\uc800 \ucf54\ub4dc\nEND;<\/code><\/pre>\n
1.2. \ub370\uc774\ud130 \uc9d1\uacc4 \ud504\ub85c\uc2dc\uc800 \uc608\uc81c<\/h3>\n
\ub370\uc774\ud130 \uc9d1\uacc4\ub97c \uc704\ud55c \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \ud310\ub9e4 \ub370\uc774\ud130\uc5d0\uc11c \ucd1d \ub9e4\ucd9c\uc744 \uc9d1\uacc4\ud569\ub2c8\ub2e4.<\/p>\n
CREATE OR REPLACE PROCEDURE GetTotalSales(p_start_date IN DATE, p_end_date IN DATE, o_total_sales OUT NUMBER) IS\nBEGIN\n    SELECT SUM(sales_amount)\n    INTO o_total_sales\n    FROM sales\n    WHERE sale_date BETWEEN p_start_date AND p_end_date;\nEND;<\/code><\/pre>\n
2. C#\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\ub3d9<\/h2>\n
C#\uc5d0\uc11c\ub294 Oracle.DataAccess.Client \ub610\ub294 Oracle.ManagedDataAccess.Client\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 Oracle.ManagedDataAccess.Client\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
2.1. NuGet \ud328\ud0a4\uc9c0 \uc124\uce58<\/h3>\n
Visual Studio\uc5d0\uc11c \ud504\ub85c\uc81d\ud2b8\ub97c \uc0dd\uc131\ud55c \ud6c4, Package Manager Console\uc5d0\uc11c \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc5ec NuGet \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud569\ub2c8\ub2e4.<\/p>\n
Install-Package Oracle.ManagedDataAccess<\/code><\/pre>\n
2.2. \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c \uc608\uc81c<\/h3>\n
\ub2e4\uc74c\uc740 C#\uc5d0\uc11c \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n
using Oracle.ManagedDataAccess.Client;\n\nstring connString = \"User Id=myUsername;Password=myPassword;Data Source=myDataSource;\";\n\nusing (OracleConnection conn = new OracleConnection(connString))\n{\n    conn.Open();\n    using (OracleCommand cmd = new OracleCommand(\"GetTotalSales\", conn))\n    {\n        cmd.CommandType = CommandType.StoredProcedure;\n        cmd.Parameters.Add(\"p_start_date\", OracleDbType.Date).Value = new DateTime(2023, 1, 1);\n        cmd.Parameters.Add(\"p_end_date\", OracleDbType.Date).Value = new DateTime(2023, 12, 31);\n        cmd.Parameters.Add(\"o_total_sales\", OracleDbType.Decimal).Direction = ParameterDirection.Output;\n\n        cmd.ExecuteNonQuery();\n        \n        decimal totalSales = (decimal)cmd.Parameters[\"o_total_sales\"].Value;\n        Console.WriteLine($\"\ucd1d \ub9e4\ucd9c: {totalSales}\");\n    }\n}<\/code><\/pre>\n
3. C# WPF\/WinForms \ub300\uc2dc\ubcf4\ub4dc UI \uad6c\ud604<\/h2>\n
\ub300\uc2dc\ubcf4\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc885\uc885 \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \uc774\ud574\ud558\uace0 \uc989\uc2dc \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \ub3c4\uc640\uc8fc\ub294 GUI\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 WPF\uc640 WinForms\uc5d0\uc11c \ub370\uc774\ud130 \uc9d1\uacc4 \uacb0\uacfc\ub97c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
3.1. WPF \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c<\/h3>\n
WPF\uc5d0\uc11c\ub294 XAML\uc744 \uc0ac\uc6a9\ud558\uc5ec UI\ub97c \uc124\uacc4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc778 \ubc84\ud2bc\uacfc \ud14d\uc2a4\ud2b8 \ubc15\uc2a4\ub97c \ud3ec\ud568\ud55c \uc608\uc81c XAML \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
<Window x:Class=\"Dashboard.MainWindow\"\n            xmlns=\"http:\/\/schemas.microsoft.com\/winfx\/2006\/xaml\/presentation\"\n            xmlns:x=\"http:\/\/schemas.microsoft.com\/winfx\/2006\/xaml\"\n            Title=\"\ub300\uc2dc\ubcf4\ub4dc\" Height=\"350\" Width=\"525\">\n    <Grid>\n        <Button Name=\"btnGetSales\" Content=\"\ub9e4\ucd9c \uc870\ud68c\" Click=\"btnGetSales_Click\" Width=\"100\" Height=\"30\" \/>\n        <TextBlock Name=\"txtTotalSales\" Text=\"\ucd1d \ub9e4\ucd9c: \" FontSize=\"16\" Margin=\"10,50,0,0\"\/>\n    <\/Grid>\n    <\/Window><\/code><\/pre>\n
3.2. WPF \uc774\ubca4\ud2b8 \ud578\ub4e4\ub7ec<\/h3>\n
\ubc84\ud2bc \ud074\ub9ad \uc2dc \ucd1d \ub9e4\ucd9c\uc744 \uac00\uc838\uc624\ub294 \uc774\ubca4\ud2b8 \ud578\ub4e4\ub7ec\ub97c \uc791\uc131\ud569\ub2c8\ub2e4:<\/p>\n
private void btnGetSales_Click(object sender, RoutedEventArgs e)\n{\n    decimal totalSales = GetTotalSales(new DateTime(2023, 1, 1), new DateTime(2023, 12, 31));\n    txtTotalSales.Text = $\"\ucd1d \ub9e4\ucd9c: {totalSales}\";\n}<\/code><\/pre>\n
3.3. WinForms \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c<\/h3>\n
WinForms\uc5d0\uc11c\ub294 Tools\uc5d0\uc11c Button\uacfc Label \ucee8\ud2b8\ub864\uc744 \ucd94\uac00\ud558\uc5ec \uc544\ub798\uc640 \uac19\uc774 \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\/\/ WinForms Form1.cs\nprivate void btnGetSales_Click(object sender, EventArgs e)\n{\n    decimal totalSales = GetTotalSales(new DateTime(2023, 1, 1), new DateTime(2023, 12, 31));\n    lblTotalSales.Text = $\"\ucd1d \ub9e4\ucd9c: {totalSales}\";\n}<\/code><\/pre>\n
4. \uadf8\ub798\ud504 \ubc0f \ucc28\ud2b8 \uad6c\ud604<\/h2>\n
\ub300\uc2dc\ubcf4\ub4dc\uc758 \uc911\uc694\ud55c \uc694\uc18c \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130 \uc2dc\uac01\ud654\uc785\ub2c8\ub2e4. WPF\uc640 WinForms\ub294 \ub2e4\uc591\ud55c \ucc28\ud2b8 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 LiveCharts\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc2dc\uac01\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4.1. LiveCharts \uc124\uce58<\/h3>\n
\uccab \ubc88\uc9f8 \ub2e8\uacc4\ub294 NuGet\uc744 \ud1b5\ud574 LiveCharts \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\ub294 \uac83\uc785\ub2c8\ub2e4:<\/p>\n
Install-Package LiveCharts.WinForms<\/code><\/pre>\n
4.2. \ub370\uc774\ud130 \uc2dc\uac01\ud654 \uc608\uc81c (WPF)<\/h3>\n
XAML\uc5d0\uc11c \ucc28\ud2b8 \ucee8\ud2b8\ub864\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4:<\/p>\n
<lvc:CartesianChart Name=\"cartesianChart\">\n        <lvc:CartesianChart.Series>\n            <lvc:LineSeries Values=\"{Binding TotalSales}\" \/>\n        <\/lvc:CartesianChart.Series>\n    <\/lvc:CartesianChart><\/code><\/pre>\n
\ucc28\ud2b8 \ub370\uc774\ud130\ub294 ViewModel\uc744 \ud1b5\ud574 \ubc14\uc778\ub529\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4.3. \ub370\uc774\ud130 \uc2dc\uac01\ud654 \uc608\uc81c (WinForms)<\/h3>\n
WinForms\uc5d0\uc11c\ub294 Chart \ucee8\ud2b8\ub864\uc744 \ucd94\uac00\ud558\uace0 \ub370\uc774\ud130 \uc2dc\ub9ac\uc988\ub97c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
chart1.Series[0].Points.AddXY(\"2023-01\", totalSales);<\/code><\/pre>\n
5. \uacb0\ub860<\/h2>\n
\uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc640 C#\uc744 \ud1b5\ud574 \ub300\uc2dc\ubcf4\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\ub294 \uac83\uc740 \ube44\uc988\ub2c8\uc2a4 \uc778\uc0ac\uc774\ud2b8\ub97c \uc81c\uacf5\ud558\ub294 \uac15\ub825\ud55c \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uc9d1\uacc4, UI \uad6c\ud604 \ubc0f \ub370\uc774\ud130 \uc2dc\uac01\ud654\uc758 \uacb0\ud569\uc740 \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \ubcf4\ub2e4 \uc27d\uac8c \uc774\ud574\ud558\uace0 \ubd84\uc11d\ud558\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc90d\ub2c8\ub2e4. \ud5a5\ud6c4 \uc774 \uae00\uc5d0\uc11c\ub294 \uc131\ub2a5 \ucd5c\uc801\ud654, \ubcf4\uc548 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uad00\ub9ac \ub4f1\uc758 \ucd94\uac00\uc801\uc778 \uc8fc\uc81c\ub97c \ub2e4\ub8f0 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n
\ucc38\uace0 \ubb38\ud5cc<\/h2>\n