private void PersonalInfo_Load(object sender, EventArgs e)
 {
     treeView1.ExpandAll();
     InitTree(this.treeView1.Nodes, "0");
     treeView1.ExpandAll();
     toolStrip_save.Enabled   = false;
     toolStripButton2.Enabled = false;
     MySQLConnection1.OpenConn();
 }
        void ca_updatePic(bool topmost)
        {
            DataView  dv = new DataView();
            DataTable dt = MySQLConnection1.GetDataTableValue("select * from staff_info where id = '" + currentID + "'");

            dt.TableName = "staff_info";
            dv.Table     = dt;
            DataRowView drv = dv[0];

            Byte[]       Files = (Byte[])drv["pic"];
            MemoryStream mysm  = new MemoryStream((byte[])drv["pic"]);
            Image        ims   = Image.FromStream(mysm);

            this.pictureBox1.Image = ims;
        }
        private void btn_search_Click(object sender, EventArgs e)
        {
            string sql;
            string type;

            if (!IsNumberic(txt_id.Text) && txt_id.Text != "")
            {
                MessageBox.Show("ID must be a number");
            }
            else
            {
                if (comboB_type.Text == "All")
                {
                    type = "";
                }
                else
                {
                    type = comboB_type.Text;
                }
                if (txt_id.Text == "")
                {
                    sql = "select * from stock where itemID like '%" + txt_id.Text + "%' and itemName like '%" + txt_name.Text + "%' and type like '%" + type + "%'";
                }

                else
                {
                    sql = "select * from stock where itemID = '" + txt_id.Text + "' and itemName like '%" + txt_name.Text + "%' and type like '%" + type + "%'";
                }
                if (local)
                {
                    DataSet ds = GetDataSet(sql);

                    this.dataGridView1.DataSource = ds;
                    this.dataGridView1.DataMember = "tb";
                    ColumnOrder();
                }
                else
                {
                    DataSet ds = MySQLConnection1.GetDataSetValue(sql, "tb");

                    this.dataGridView1.DataSource = ds;
                    this.dataGridView1.DataMember = "tb";
                    ColumnOrder();
                }
            }
            isSearchOrAddIsClick = true;
        }
        private void btn_savpic_Click(object sender, EventArgs e)
        {
            string strPath = txt_pic.Text.Trim();

            FileStream fs = new FileStream(strPath, FileMode.Open, FileAccess.Read);

            byte[] byteFile = new byte[fs.Length];

            fs.Read(byteFile, 0, (int)fs.Length);

            fs.Close();
            using (MySqlConnection conn = new MySqlConnection(MySQLConnection1.SqlCon))
            {
                string UpdateSql = "update staff_info" +
                                   " set pic = @ImgData" +
                                   " where id = '" + currentID + "'";
                //   string sql = "Insert Into picTest Values (@ImgData) ";

                using (MySqlCommand cmd = new MySqlCommand(UpdateSql))
                {
                    MySqlParameter param = new MySqlParameter("ImgData", MySqlDbType.VarBinary, byteFile.Length);
                    param.Value = byteFile;
                    cmd.Parameters.Add(param);
                    cmd.Connection = conn;
                    conn.Open();
                    int i = cmd.ExecuteNonQuery();
                    MessageBox.Show("success!");
                }
            }

            DataView  dv = new DataView();
            DataTable dt = MySQLConnection1.GetDataTableValue("select * from staff_info where id = '" + currentID + "'");

            dt.TableName = "staff_info";
            dv.Table     = dt;


            DataRowView drv = dv[0];

            Byte[]       Files = (Byte[])drv["pic"];
            MemoryStream mysm  = new MemoryStream((byte[])drv["pic"]);
            Image        ims   = Image.FromStream(mysm);

            this.pictureBox1.Image = ims;
        }
        private void InitialGrid()
        {
            DataSet ds;

            if (local)
            {
                ds = GetDataSet("select * from stock");
            }
            else
            {
                ds = MySQLConnection1.GetDataSetValue("select * from stock", "tb");
            }
            this.dataGridView1.DataSource = ds;
            this.dataGridView1.DataMember = "tb";
            ColumnOrder();

            style();
        }
 private void deleteData(int id)
 {
     try
     {
         string DeleteSql = "Delete from stock where itemID = '" + id + "'";
         if (local)
         {
             SqlConnection sqlcon = new SqlConnection(strcon);
             sqlcon.Open();
             SqlCommand com = new SqlCommand(DeleteSql, sqlcon);
             com.ExecuteNonQuery();
             SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
             DataSet        ds  = new DataSet();
             ada.Fill(ds, "stock");
             sqlcon.Close();
         }
         else
         {
             MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
             MySqlCon.Open();
             MySqlCommand com = new MySqlCommand(DeleteSql, MySqlCon);
             com.ExecuteNonQuery();
             MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
             DataSet          ds  = new DataSet();
             ada.Fill(ds, "stock");
             MySQLConnection1.CloseConn();
         }
         MySqlConnection MySqlCon1 = new MySqlConnection(MySQLConnection1.SqlCon);
         MySqlCon1.Open();
         MySqlCommand com1 = new MySqlCommand("ALTER TABLE stock AUTO_INCREMENT = 1;", MySqlCon1);
         com1.ExecuteNonQuery();
         MySqlDataAdapter ada1 = new MySqlDataAdapter("select * from stock", MySqlCon1);
         DataSet          ds1  = new DataSet();
         ada1.Fill(ds1, "stock");
         MySQLConnection1.CloseConn();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
        private void InitTree(TreeNodeCollection Nds, string parentId)
        {
            DataView dv = new DataView();
            TreeNode tmpNd;
            string   intId;

            if (local)
            {
                DataSet ds = GetDataSet("select * from staff_info");
                dv.Table = ds.Tables[0];
            }
            else
            {
                DataTable dt = MySQLConnection1.GetDataTableValue("select * from staff_info");
                dt.TableName = "staff_info";
                dv.Table     = dt;
            }

            dv.RowFilter = "parent_id='" + parentId + "'";

            foreach (DataRowView drv in dv)
            {
                tmpNd      = new TreeNode();
                tmpNd.Tag  = drv["id"].ToString();
                tmpNd.Text = drv["last_name"].ToString();
                if (drv["parent_id"].ToString() == "1")  //10 means admin
                {
                    tmpNd.ImageIndex = tmpNd.SelectedImageIndex = 0;
                }
                else
                {
                    tmpNd.ImageIndex = tmpNd.SelectedImageIndex = 1;
                }
                this.treeView1.BeginUpdate();
                Nds.Add(tmpNd);
                this.treeView1.EndUpdate();
                intId = drv["parent_id"].ToString();
                InitTree(tmpNd.Nodes, tmpNd.Tag.ToString());
            }
        }
 private void updateData(int id, string name, int safe, int qty)
 {
     try
     {
         string UpdateSql = "update stock" +
                            " set itemName = '" + name + "'," +
                            "itemSafeStock = '" + safe + "'," +
                            "quantity = '" + qty + "'" +
                            "where itemID = '" + id + "'";
         if (local)
         {
             SqlConnection sqlcon = new SqlConnection(strcon);
             sqlcon.Open();
             SqlCommand com = new SqlCommand(UpdateSql, sqlcon);
             com.ExecuteNonQuery();
             SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
             DataSet        ds  = new DataSet();
             ada.Fill(ds, "stock");
             sqlcon.Close();
         }
         else
         {
             MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
             MySqlCon.Open();
             MySqlCommand com = new MySqlCommand(UpdateSql, MySqlCon);
             com.ExecuteNonQuery();
             MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
             DataSet          ds  = new DataSet();
             ada.Fill(ds, "stock");
             MySQLConnection1.CloseConn();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 private void deleteData()
 {
     try
     {
         string DeleteSql = "Delete from staff_info where id = '" + treeView1.SelectedNode.Tag + "'";
         if (local)
         {
             SqlConnection sqlcon = new SqlConnection(strcon);
             sqlcon.Open();
             SqlCommand com = new SqlCommand(DeleteSql, sqlcon);
             com.ExecuteNonQuery();
             SqlDataAdapter ada = new SqlDataAdapter("select * from staff_info", sqlcon);
             DataSet        ds  = new DataSet();
             ada.Fill(ds, "staff_info");
             sqlcon.Close();
         }
         else
         {
             MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
             MySqlCon.Open();
             MySqlCommand com = new MySqlCommand(DeleteSql, MySqlCon);
             com.ExecuteNonQuery();
             MySqlDataAdapter ada = new MySqlDataAdapter("select * from staff_info", MySqlCon);
             DataSet          ds  = new DataSet();
             ada.Fill(ds, "staff_info");
             MySQLConnection1.CloseConn();
         }
         treeView1.Nodes.Clear();
         InitTree(this.treeView1.Nodes, "0");
         treeView1.ExpandAll();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Exemple #10
0
        void initialChart(string type, Boolean showAll)
        {
            string sql;

            chart1.Series.Clear();//清理掉默认的图表   然后重新添加

            DataTable ds = new DataTable();

            if (showAll)
            {
                sql = "select * from statistics";
            }
            else
            {
                sql = "SELECT * FROM statistics WHERE DATE BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' AND '" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "'";
            }

            MySqlConnection  MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
            MySqlDataAdapter sda      = new MySqlDataAdapter(sql, MySqlCon);

            MySQLConnection1.OpenConn();
            sda.Fill(ds);
            if (type == "line")
            {
                Series ss = new Series("income");        //这里 dt1 ,dt2 任意取名称,但要唯一
                ss.Points.DataBind(ds.AsEnumerable(), "date", "income", "");
                ss.XValueType = ChartValueType.DateTime; //设置X轴
                ss.ChartType  = SeriesChartType.Spline;  //设置Y轴为折线
                chart1.Series.Add(ss);

                if (checkBox_cost.Checked)
                {
                    Series ss1 = new Series("cost");          //这里 dt1 ,dt2 任意取名称,但要唯一
                    ss1.Points.DataBind(ds.AsEnumerable(), "date", "cost", "");
                    ss1.XValueType = ChartValueType.DateTime; //设置X轴
                    ss1.ChartType  = SeriesChartType.Spline;  //设置Y轴为折线
                    chart1.Series.Add(ss1);
                }
            }
            else if (type == "pie")
            {
                Series s = chart1.Series.Add("饼图");
                //
                //设置图标名称
                //s.ChartArea = "ChartArea" + j;
                //图表类型   折线  柱状 圆形
                s.ChartType           = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
                s.BorderWidth         = 3;
                s.ShadowOffset        = 1;
                s.IsValueShownAsLabel = true;               //是否在图表上显示数据的值
                s.XValueType          = ChartValueType.Int32;
                s.MarkerStyle         = MarkerStyle.Circle; //数据点样式
                List <string> xData1 = new List <string>(); //声明两个集合将数据先放在集合中
                List <string> yData1 = new List <string>();
                for (int i = 0; i < ds.Rows.Count; i++)     //
                {
                    //将数据先放在集合中
                    xData1.Add(ds.Rows[i]["date"].ToString());
                    yData1.Add(ds.Rows[i]["income"].ToString());
                }
                //循环结束后,绑定数据源
                chart1.Series[0].Points.DataBindXY(xData1, yData1);
            }
            //  chart2.Series.Add(ss);

            //第二条数据



            ////第三条数据
            //string sql2 = "SELECT * FROM APiece WHERE APiece.Piece_PId=3";
            //DataTable ds2 = new DataTable();
            //SqlDataAdapter sda2 = new SqlDataAdapter(sql2, con);
            //sda2.Fill(ds2);
            //Chart1.DataSource = ds2;
            //Series ss3 = new Series("产品3");
            //ss3.Points.DataBind(ds2.AsEnumerable(), "Piece_Time", "Piece_Level", "");
            //ss3.XValueType = ChartValueType.DateTime; //设置X轴
            //ss3.ChartType = SeriesChartType.Spline;   //设置Y轴为折线
            //Chart1.Series.Add(ss3);
        }
Exemple #11
0
        private void insertData()
        {
            try
            {
                if (!IsNumberic(txt_safe.Text))
                {
                    MessageBox.Show("Safe stock must be a number");
                    return;
                }
                if (!IsNumberic(txt_qty.Text))
                {
                    MessageBox.Show("Qty must be be a number");
                    return;
                }
                if (comboB_type1.Text == "")
                {
                    MessageBox.Show("Must select the type of item");
                    return;
                }
                else
                {
                    string InsertSql = "insert into stock(itemName,itemSafeStock,quantity,type) " +
                                       "values ('" + txt_name1.Text + "'" +
                                       ",'" + txt_safe.Text + "'" +
                                       ",'" + txt_qty.Text + "'" +
                                       ",'" + comboB_type1.Text + "')";

                    if (local)
                    {
                        SqlConnection sqlcon = new SqlConnection(strcon);
                        sqlcon.Open();
                        SqlCommand com = new SqlCommand(InsertSql, sqlcon);
                        com.ExecuteNonQuery();
                        SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
                        DataSet        ds  = new DataSet();
                        ada.Fill(ds, "stock");
                        sqlcon.Close();
                    }
                    else
                    {
                        MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
                        MySqlCon.Open();
                        MySqlCommand com = new MySqlCommand(InsertSql, MySqlCon);
                        com.ExecuteNonQuery();
                        MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
                        DataSet          ds  = new DataSet();
                        ada.Fill(ds, "stock");
                        MySQLConnection1.CloseConn();
                    }
                    MessageBox.Show("successful");
                    txt_name1.Text    = "";
                    txt_safe.Text     = "";
                    txt_qty.Text      = "";
                    comboB_type1.Text = "";
                    InitialGrid();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void updateData()
        {
            int parentID = 0;

            if (cmb_position.SelectedIndex == 0)
            {
                parentID = 1;
            }
            if (cmb_position.SelectedIndex == 1)
            {
                parentID = 2;
            }
            if (cmb_position.SelectedIndex == 2)
            {
                parentID = 3;
            }
            if (cmb_position.SelectedIndex == 3)
            {
                parentID = 4;
            }
            if (!IsEmail(txt_Email.Text))
            {
                MessageBox.Show("the email address is invalid");
                return;
            }
            else
            {
                string UpdateSql = "update staff_info" +
                                   " set last_name = '" + txt_name.Text + "'," +
                                   "address_id = '" + txt_Address.Text + "'," +
                                   "phone = '" + txt_Phone.Text + "'," +
                                   "parent_id = '" + parentID + "'," +
                                   "gender = '" + comBox_gender.Text + "'," +
                                   "birthday = '" + dateTimePicker1.Value.Date.ToString("yyyy-MM-dd HH:mm") + "'," +
                                   "ssn = '" + txt_SSN.Text + "'," +
                                   "email = '" + txt_Email.Text + "' " +
                                   "where id = '" + treeView1.SelectedNode.Tag + "'";


                try
                {
                    if (local)
                    {
                        SqlConnection sqlcon = new SqlConnection(strcon);
                        sqlcon.Open();
                        SqlCommand com = new SqlCommand(UpdateSql, sqlcon);
                        com.ExecuteNonQuery();
                        SqlDataAdapter ada = new SqlDataAdapter("select * from staff_info", sqlcon);
                        DataSet        ds  = new DataSet();
                        ada.Fill(ds, "staff_info");
                        sqlcon.Close();
                    }
                    else
                    {
                        MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
                        MySqlCon.Open();
                        MySqlCommand com = new MySqlCommand(UpdateSql, MySqlCon);
                        com.ExecuteNonQuery();
                        MySqlDataAdapter ada = new MySqlDataAdapter("select * from staff_info", MySqlCon);
                        DataSet          ds  = new DataSet();
                        ada.Fill(ds, "staff_info");
                        MySQLConnection1.CloseConn();
                    }

                    MessageBox.Show("successful");
                    treeView1.Nodes.Clear();
                    InitTree(this.treeView1.Nodes, "0");
                    treeView1.ExpandAll();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                toolStripButton1.Text    = "Add";
                toolStripButton1.Image   = imageList1.Images[2];
                toolStripButton1.Enabled = true;

                initial();
            }
        }
        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            currentID = int.Parse(e.Node.Tag.ToString());
            if (e.Action == TreeViewAction.ByMouse)
            {
                DataView dv = new DataView();
                if (local)
                {
                    DataSet ds = GetDataSet("select * from staff_info where id = '" + e.Node.Tag + "'");
                    dv.Table = ds.Tables[0];
                }
                else
                {
                    DataTable dt = MySQLConnection1.GetDataTableValue("select * from staff_info where id = '" + e.Node.Tag + "'");
                    dt.TableName = "staff_info";
                    dv.Table     = dt;
                }


                DataRowView drv = dv[0];
                if (e.Node.Parent != null)
                {
                    txt_name.Text = drv["last_name"].ToString();
                    if (drv["gender"].ToString() == "Male")
                    {
                        comBox_gender.SelectedIndex = 0;
                    }
                    else
                    {
                        comBox_gender.SelectedIndex = 1;
                    }
                    txt_SSN.Text = drv["ssn"].ToString();
                    if (drv["parent_id"].ToString() == "1")
                    {
                        cmb_position.SelectedIndex = 0;
                    }
                    if (drv["parent_id"].ToString() == "2")
                    {
                        cmb_position.SelectedIndex = 1;
                    }
                    if (drv["parent_id"].ToString() == "3")
                    {
                        cmb_position.SelectedIndex = 2;
                    }
                    if (drv["parent_id"].ToString() == "4")
                    {
                        cmb_position.SelectedIndex = 3;
                    }
                    txt_Phone.Text   = drv["phone"].ToString();
                    txt_Address.Text = drv["address_id"].ToString();

                    if (!drv["birthday"].Equals(System.DBNull.Value))
                    {
                        dateTimePicker1.Value = Convert.ToDateTime(drv["Birthday"]);
                    }
                    else
                    {
                        dateTimePicker1.Value = System.DateTime.Today;
                    }
                    if (!drv["pic"].Equals(System.DBNull.Value))
                    {
                        Byte[]       Files = (Byte[])drv["pic"];
                        MemoryStream mysm  = new MemoryStream((byte[])drv["pic"]);
                        Image        ims   = Image.FromStream(mysm);
                        this.pictureBox1.Image = ims;
                    }
                    else
                    {
                        this.pictureBox1.Image = null;
                    }



                    txt_Email.Text = drv["email"].ToString();


                    toolStripButton2.Enabled = true;
                    btn_del.Enabled          = true;
                }
                else
                {
                    toolStripButton2.Enabled = false;
                    btn_del.Enabled          = false;
                }
            }
        }