C# 진행과정

저는 결제창에 대한 과정을 맡았습니다.

 

현재 진행중이며, 수정과 추가를 하고 있습니다.

 

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Reflection.Emit;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using static System.Windows.Forms.VisualStyles.VisualStyleElement;
using MySql.Data.MySqlClient;

namespace foslast
{
public partial class Form1 : Form
{
    String Connection = "datasource=192.168.0.38;port=3306;Database=BurgerKing;Uid=pmh;Pwd=1234";
        public Form1()
    {
        InitializeComponent();
        addlist();
        cashadd();
        cardadd();
    }
    //private void button1_Click(object sender, EventArgs e)
    //{
    //
    //private void button2_Click(object sender, EventArgs e)
    //{  
    //private void button3_Click(object sender, EventArgs e)
    //{
    //}


    private void addlist()
    {
        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand("select * from payment ", conn);
        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            ListViewItem item = new ListViewItem(reader["payment_id"].ToString());
            item.SubItems.Add(reader["order_id"].ToString());
            item.SubItems.Add(reader["payment_method"].ToString());
            item.SubItems.Add(reader["payment_amount"].ToString());
            item.SubItems.Add(reader["payment_time"].ToString());

            listView1.Items.Add(item);

        }
        int totalPrice = 0;

        foreach (ListViewItem item in listView1.Items)
        {

            int price = (int)double.Parse(item.SubItems[3].Text);
            totalPrice += price;
        }

        label1.Text = "총" + totalPrice.ToString() + "원";

        reader.Close();
        conn.Close();
    }

    private void cashadd()
    {

        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select sum(payment_amount) from payment where payment_method = '현금'";
        cmd.Connection = conn;

        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {

            listView2.Items.Add(reader["sum(payment_amount)"].ToString() + "원"

            );
        }
        reader.Close();
        conn.Close();
    }


    private void cardadd()
    {

        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select sum(payment_amount) from payment where payment_method = '카드'";
        cmd.Connection = conn;

        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {

            listView3.Items.Add(reader["sum(payment_amount)"].ToString() + "원"

            );
        }
        reader.Close();
        conn.Close();
    }

    private void button1_Click_1(object sender, EventArgs e)
    {
        listView1.Items.Clear();
        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand("select * from payment where date(payment_time) = curdate()", conn);
        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            ListViewItem item = new ListViewItem(reader["payment_id"].ToString());
            item.SubItems.Add(reader["order_id"].ToString());
            item.SubItems.Add(reader["payment_method"].ToString());
            item.SubItems.Add(reader["payment_amount"].ToString());
            item.SubItems.Add(reader["payment_time"].ToString());

            listView1.Items.Add(item);

        }


        int totalPrice = 0;

        foreach (ListViewItem item in listView1.Items)
        {

            int price = (int)double.Parse(item.SubItems[3].Text);
            totalPrice += price;
        }

        label1.Text = "총" + totalPrice.ToString() + "원";




        reader.Close();
        conn.Close();
    }

    private void button2_Click_1(object sender, EventArgs e)
    {
        listView2.Items.Clear();
        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "SELECT  SUM(payment_amount) FROM payment WHERE DATE(payment_time) = CURDATE() AND payment_method = '현금';";
        cmd.Connection = conn;

        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {

            listView2.Items.Add(reader["sum(payment_amount)"].ToString() + "원"

            );
        }
        reader.Close();
        conn.Close();
    }

    private void button3_Click_1(object sender, EventArgs e)
    {
        listView3.Items.Clear();
        MySqlConnection conn = new MySqlConnection(Connection);
        conn.Open();
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select sum(payment_amount) from payment where payment_method = '카드'";
        cmd.Connection = conn;

        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {

            listView3.Items.Add(reader["sum(payment_amount)"].ToString() + "원"

            );
        }
        reader.Close();
        conn.Close();
    }
}
    }

 

DB로 C#과 연결해준다 (여기서 DB는 oracle과 heidi sql 둘다 사용해봤습니다.)

 

버튼에 대한 이번트를 넣어줍니다.

버튼을 눌렀을때 sql 구문을 통해 select 와 sum 값 을 나타나게 해봤습니다.