Пример #1
0
 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();
 }
Пример #2
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);
        }
Пример #3
0
        private void insertData()
        {
            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");
            }
            else
            {
                string InsertSql = "insert into staff_info(last_name,address_id,phone,parent_id,gender,birthday,ssn,email) " +
                                   "values ('" + txt_name.Text + "','" + txt_Address.Text + "','" + txt_Phone.Text + "','" + parentID + "','" + comBox_gender.Text + "','" + dateTimePicker1.Value.Date.ToString("yyyy-MM-dd HH:mm") + "','" + txt_SSN.Text + "','" + txt_Email.Text + "')";

                try
                {
                    if (local)
                    {
                        SqlConnection sqlcon = new SqlConnection(strcon);
                        sqlcon.Open();
                        SqlCommand com = new SqlCommand(InsertSql, 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();
                        MySQLConnection1.OpenConn();
                        MySqlCommand com = new MySqlCommand(InsertSql, 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();
            }
        }