private void search_history_Click(object sender, EventArgs e)
        {
            purchase             p  = new purchase();
            List <purchaseDanju> ps = new List <purchaseDanju>();

            try
            {
                Console.Write(Convert.ToDateTime(dateTimePicker2.Text));
                if (textBox2.Text == "请输入单据号" || textBox2.Text == "")
                {
                    DataTable dt = new DataTable("teble");
                    dt.Columns.Add("订单日期", typeof(string));
                    dt.Columns.Add("单据编号", typeof(string));
                    dt.Columns.Add("供应商", typeof(String));
                    dt.Columns.Add("总金额", typeof(double));
                    dt.Columns.Add("操作人", typeof(String));
                    dt.Columns.Add("备注", typeof(String));
                    ps = p.selectdate(Convert.ToDateTime(dateTimePicker2.Text), Convert.ToDateTime(dateTimePicker3.Text), 1);
                    foreach (purchaseDanju p1 in ps)
                    {
                        employ      e1   = new employ();
                        employeedao edao = new employeedao();
                        e1 = edao.selectid(p1.Emploee_id);
                        supplier    s1   = new supplier();
                        supplierdao sdao = new supplierdao();
                        s1 = sdao.selectnumber(p1.Supplier_number);
                        dt.Rows.Add(p1.Date, p1.Danju, s1.Supplier_name, p1.Money, e1.Employee_name, p1.Remark);
                    }
                    dataGridView2.DataSource = dt;
                }
                else
                {
                    DataTable dt = new DataTable("teble");
                    dt.Columns.Add("订单日期", typeof(string));
                    dt.Columns.Add("单据编号", typeof(string));
                    dt.Columns.Add("供应商", typeof(String));
                    dt.Columns.Add("总金额", typeof(double));
                    dt.Columns.Add("操作人", typeof(String));
                    dt.Columns.Add("备注", typeof(String));
                    ps = p.selectdateAndNum_Supp(textBox2.Text, 1);
                    foreach (purchaseDanju p1 in ps)
                    {
                        employ      e1   = new employ();
                        employeedao edao = new employeedao();
                        e1 = edao.selectid(p1.Emploee_id);
                        supplier    s1   = new supplier();
                        supplierdao sdao = new supplierdao();
                        s1 = sdao.selectnumber(p1.Supplier_number);
                        dt.Rows.Add(p1.Date, p1.Danju, s1.Supplier_name, p1.Money, e1.Employee_name, p1.Remark);
                    }
                    dataGridView2.DataSource = dt;
                }
            }
            catch (SystemException)
            {
                MessageBox.Show("操作有误");
            }
        }
Example #2
0
        private void search_history_Click(object sender, EventArgs e)
        {
            sale             p  = new sale();
            List <saleDanju> ps = new List <saleDanju>();

            Console.Write(Convert.ToDateTime(dateTimePicker2.Text));
            if (textBox2.Text == "")
            {
                DataTable dt = new DataTable("teble");
                dt.Columns.Add("订单日期", typeof(string));
                dt.Columns.Add("单据编号", typeof(string));
                dt.Columns.Add("客户", typeof(String));
                dt.Columns.Add("总金额", typeof(double));
                dt.Columns.Add("操作人", typeof(String));
                dt.Columns.Add("备注", typeof(String));
                Console.Write("11");
                ps = p.selectdate(Convert.ToDateTime(dateTimePicker2.Text), Convert.ToDateTime(dateTimePicker3.Text));
                Console.Write("12");
                foreach (saleDanju p1 in ps)
                {
                    employ      e1   = new employ();
                    employeedao edao = new employeedao();
                    e1 = edao.selectid(p1.Emploee_id);
                    customer    s1   = new customer();
                    customerdao sdao = new customerdao();
                    s1 = sdao.selectnumber(p1.Customer_number);
                    dt.Rows.Add(p1.Date, p1.Danju, s1.Customer_name, p1.Money, e1.Employee_name, p1.Remark);
                    Console.WriteLine(p1.Customer_number + "谢谢");
                }
                dataGridView2.DataSource = dt;
            }
            else
            {
                DataTable dt = new DataTable("teble");
                dt.Columns.Add("订单日期", typeof(string));
                dt.Columns.Add("单据编号", typeof(string));
                dt.Columns.Add("顾客", typeof(String));
                dt.Columns.Add("总金额", typeof(double));
                dt.Columns.Add("操作人", typeof(String));
                dt.Columns.Add("备注", typeof(String));
                ps = p.selectdateAndNum_Supp(textBox2.Text);
                foreach (saleDanju p1 in ps)
                {
                    employ      e1   = new employ();
                    employeedao edao = new employeedao();
                    e1 = edao.selectid(p1.Emploee_id);
                    customer    s1   = new customer();
                    customerdao sdao = new customerdao();
                    s1 = sdao.selectnumber(p1.Customer_number);
                    dt.Rows.Add(p1.Date, p1.Danju, s1.Customer_name, p1.Money, e1.Employee_name, p1.Remark);
                }
                dataGridView2.DataSource = dt;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox1.Text == "输入工号" || textBox1.Text == "")
                {
                    DataGridView  data = new DataGridView();
                    employeedao   p    = new employeedao();
                    List <employ> rs   = new List <employ>();
                    rs = p.find_all1();
                    Console.Write(rs);
                    int       i  = 0;
                    DataSet   ds = new DataSet();
                    DataTable dt = new DataTable("Table_New");
                    dt.Columns.Add("工号", typeof(string));
                    dt.Columns.Add("姓名", typeof(string));
                    dt.Columns.Add("联系电话", typeof(String));
                    foreach (employ r1 in rs)
                    {
                        dt.Rows.Add(r1.Employee_number, r1.Employee_name, r1.Phone);
                        i++;
                    }
                    dataGridView1.DataSource = dt;
                }
                else
                {
                    DataGridView data = new DataGridView();
                    employeedao  p    = new employeedao();
                    employ       r1   = p.selectid(textBox1.Text);
                    Console.Write(textBox1.Text);

                    if (r1 == null)
                    {
                        MessageBox.Show("不存在此人");
                    }
                    else
                    {
                        DataSet   ds = new DataSet();
                        DataTable dt = new DataTable("Table_New");
                        dt.Columns.Add("工号", typeof(string));
                        dt.Columns.Add("姓名", typeof(string));
                        dt.Columns.Add("联系电话", typeof(String));
                        dt.Rows.Add(r1.Employee_number, r1.Employee_name, r1.Phone);
                        dataGridView1.DataSource = dt;
                    }
                }
            }
            catch (SystemException)
            {
                MessageBox.Show("操作有误");
            }
        }
Example #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            label3.Text = "";
            label4.Text = "";
            if (textBox1.Text == "")
            {
                label4.Text = "用户名不能为空";
            }
            if (textBox2.Text == "")
            {
                label5.Text = "密码不能为空";
            }
            if (textBox2.Text != "" && textBox1.Text != "")
            {
                button1.ForeColor = Color.YellowGreen;

                if (textBox1.Text == "admin" && textBox1.Text == "admin")
                {
                    index x = new index();
                    x.type = "管理员";
                    this.Hide();
                    x.Show();
                    this.Visible = false;
                }
                else
                {
                    employ      ee   = new employ();
                    employeedao edao = new employeedao();
                    ee = edao.selectemployee(textBox1.Text, textBox2.Text);
                    if (ee == null)
                    {
                        MessageBox.Show("用户名或密码错误");
                    }
                    else
                    {
                        index x = new index();
                        x.type = textBox1.Text;
                        this.Hide();
                        x.Show();
                        this.Visible = false;
                    }
                }
            }
        }
        private void employee_purchase_Load(object sender, EventArgs e)
        {
            DataGridView  data = new DataGridView();
            employeedao   p    = new employeedao();
            List <employ> rs   = new List <employ>();

            rs = p.find_all1();
            Console.Write(rs);
            int       i  = 0;
            DataSet   ds = new DataSet();
            DataTable dt = new DataTable("Table_New");

            dt.Columns.Add("工号", typeof(string));
            dt.Columns.Add("姓名", typeof(string));
            dt.Columns.Add("联系电话", typeof(String));
            foreach (employ r1 in rs)
            {
                dt.Rows.Add(r1.Employee_number, r1.Employee_name, r1.Phone);
                i++;
            }
            dataGridView1.DataSource = dt;
        }