ordernewspaper.cs

订阅报刊的企业员工用户希望通过企业的系统更方便、快捷地订阅报刊

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using 报刊管理.类;     //添加引用
using System.Data.SqlClient;


namespace 报刊管理.报刊处理
{
    public partial class OrderNewspaper : Form
    {
        public OrderNewspaper()
        {
            InitializeComponent();
        }

        SqlBaseClass SqlClass = new SqlBaseClass();

        private void ListInfo(string SQL)
        {
            try
            {
                this.listView1.Items.Clear();
                SqlDataAdapter da = new SqlDataAdapter(SQL, SqlClass.GetCon());
                DataTable dt = new DataTable();
                da.Fill(dt);
                foreach (DataRow dr in dt.Rows)
                {
                    ListViewItem lv;
                    lv = new ListViewItem(dr[0].ToString());
                    lv.SubItems.Add(dr[1].ToString());
                    lv.SubItems.Add(dr[2].ToString());
                    lv.SubItems.Add(dr[3].ToString());
                    lv.SubItems.Add(dr[4].ToString());
                    lv.SubItems.Add(dr[5].ToString());
                    lv.SubItems.Add(dr[6].ToString());
                    lv.SubItems.Add(dr[7].ToString());

                    this.listView1.Items.Add(lv);
                }
            }
            catch { }

        }

        private void ListInfo1(string SQL)
        {
            try
            {
                this.listView2.Items.Clear();
                SqlDataAdapter da = new SqlDataAdapter(SQL, SqlClass.GetCon());
                DataTable dt = new DataTable();
                da.Fill(dt);
                foreach (DataRow dr in dt.Rows)
                {
                    ListViewItem lv;
                    lv = new ListViewItem(dr[0].ToString());
                    lv.SubItems.Add(dr[1].ToString());
                    lv.SubItems.Add(dr[2].ToString());
                    lv.SubItems.Add(dr[3].ToString());
                    lv.SubItems.Add(dr[4].ToString());
                    lv.SubItems.Add(dr[5].ToString());
                    lv.SubItems.Add(dr[6].ToString());
                    lv.SubItems.Add(dr[7].ToString());

                    this.listView2.Items.Add(lv);
                }
            }
            catch { }

        }

        private void OrderNewspaper_Load(object sender, EventArgs e)
        {
            
            this.label10.Text = DateTime.Now.ToString();
            SqlDataReader dk = SqlClass.GetReader("SELECT * FROM N_Dish");
            dk.Read();
            if (dk.HasRows)
            {
                string str_select = "select max(DishID) from N_Dish";
                SqlDataReader dr = SqlClass.GetReader(str_select);
                dr.Read();
                this.label11.Text = Convert.ToString(Convert.ToInt16(dr[0].ToString()) + 1);
                dr.Close();
            }
            else
            {
                this.label11.Text = "100";
            }
            string Str_cmd = "INSERT INTO N_Dish(DishID,UserID,DishTime)  VALUES ('" + this.label11.Text + "','" + PropertyClass.SendNameValue + "','" + this.label10.Text + "')";
            SqlClass.GetExecute(Str_cmd);
            string Str_select = "SELECT NewspaperID,NewspaperName,NewspaperCompany,NewspaperTime,NewspaperPrice*1,NewspaperPrice*3*(a.PeriodOff),NewspaperPrice*6*(b.PeriodOff),NewspaperPrice*12*(c.PeriodOff) FROM N_Newspaper,N_Period as a,N_Period as b,N_Period as c where a.PeriodID='3' and b.PeriodID='6' and c.PeriodID='12'";
            ListInfo(Str_select.ToString());

        }

        private void button3_Click(object sender, EventArgs e)
        {
            int M = Convert.ToInt16(this.dateTimePicker1.Value.Day.ToString());
            int N = Convert.ToInt16(DateTime.Now.Day.ToString());
            int K = Convert.ToInt16(this.dateTimePicker1.Value.Month.ToString());
            int Q = Convert.ToInt16(DateTime.Now.Month.ToString());
            if (K ==Q)
            {
                if(M<=N)
                {
                MessageBox.Show("输入日期错误！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
                }
            }
            if (K < Q)
            {
                MessageBox.Show("输入日期错误！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            SqlDataReader dk = SqlClass.GetReader("select NewspaperID from N_Newspaper where NewspaperID='"+this.textBox1.Text+"'");
            dk.Read();
            if (!dk.HasRows)
            {
                MessageBox.Show("输入报刊号错误！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (this.textBox1.Text == "")
            {
                MessageBox.Show("报刊号不能为空！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            else if (this.textBox2.Text == "")
            {
                MessageBox.Show("订阅数量不能为空！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            else if (this.textBox3.Text == "")
            {
                MessageBox.Show(" 订阅时间不能为空！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            string Str_cmd = "INSERT INTO N_Order VALUES ('" + this.label11.Text + "','" + this.textBox1.Text + "','" + this.textBox2.Text + "','" + this.dateTimePicker1.Value.ToString() + "','" + this.textBox3.Text + "')";
            SqlClass.GetExecute(Str_cmd);
            this.textBox1.Text = "";
            this.textBox2.Text = "";
            this.textBox3.Text = "";
            string Str_select = "SELECT NewspaperID,NewspaperName,NewspaperCompany,NewspaperTime,OrderNO,OrderNO*NewspaperPrice*PeriodOff*PeriodID,PeriodName,OrderTime FROM UserPeriod where DishID='"+this.label11.Text+"'";
            ListInfo1(Str_select.ToString());
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string cmd = "delete from N_Dish where DishID=" + this.label11.Text + "";
            string cmd1 = "delete from N_Order where DishID=" + this.label11.Text + "";
            if (SqlClass.GetExecute(cmd1))
            {
                if (SqlClass.GetExecute(cmd))
                {
                    MessageBox.Show("订单已取消！");
                    this.Close();
                }
                else
                {
                    MessageBox.Show("订单取消失败！");
                }
            }
            else
            {
                MessageBox.Show("订单取消失败！");
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string Str_select = "SELECT sum(OrderNO*NewspaperPrice*PeriodOff*PeriodID) as Price FROM UserPeriod where DishID='" + this.label11.Text + "'";
            SqlDataReader dk = SqlClass.GetReader(Str_select);
            dk.Read();
            if (dk.HasRows) 
            {
                this.label12.Text = dk["Price"].ToString().Trim();
            }
            dk.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }


    }
}