public AddDbUserForm(DbConnect dbc) { InitializeComponent(); for (int i =access_level_start_index;i<=dbc.CurrUser.AccessLevel;i++) { this.comboBox1.Items.Add(i); } if(comboBox1.Items.Count>0) comboBox1.SelectedIndex=0; if (comboBoxWithInputCheck1.Items.Count > 0) comboBoxWithInputCheck1.SelectedIndex = 0; dbc.SelectFrom("*", "employee_customer_selection", dt); comboBoxWithInputCheck1.DataSource = dt; comboBoxWithInputCheck1.ValueMember = "id"; comboBoxWithInputCheck1.DisplayMember = "data"; this.postgreConnection = dbc; }
public void DrawData(int oper, double number, DbConnect pgc, string from,string formName =null) { if (formName != null) { this.Text = formName; button3.Enabled = true; } bool compRes = false; chart1.Series.Clear(); Series sIncome = new Series(), sExpenses = new Series(); sIncome.ChartType = sExpenses.ChartType = SeriesChartType.Line; DataTable dt = new DataTable(); DataPoint dp = new DataPoint(); DataTable ordersTable = new DataTable(); pgc.SelectFrom("*", from, ordersTable); sIncome.LegendText = "Доход"; sIncome.Color = Color.Blue; sExpenses.Color = Color.Red; sExpenses.LegendText = "Расход"; foreach (DataRow dr in ordersTable.Rows) { dp = new DataPoint(); dp.Color = Color.Blue; dp.MarkerSize = 5; dp.MarkerColor = Color.Blue; dp.MarkerStyle = MarkerStyle.Circle; dp.IsEmpty = false; pgc.SelectFromFunc("*", "order_expenses_income", dr.ItemArray[0].ToString(), dt); if (oper != -1 && number > 0) if (Compare(oper, number, dt.Rows[0].ItemArray[0]) && Compare(oper, number, dt.Rows[0].ItemArray[1])) compRes = true; else compRes = false; if ((compRes) || (oper == -1 && number ==-1)) { try { dp.SetValueXY(DateTime.Parse(dr.ItemArray[6].ToString()), dt.Rows[0].ItemArray[0]); dp.Label = DateTime.Parse(dr.ItemArray[6].ToString()).ToShortDateString() + " " + dr.ItemArray[9].ToString(); sIncome.Points.Add(dp); } catch { } dp = new DataPoint(); dp.Color = Color.Red; dp.MarkerSize = 5; dp.MarkerColor = Color.Red; dp.MarkerStyle = MarkerStyle.Circle; dp.IsEmpty = false; dp.SetValueXY(DateTime.Parse(dr.ItemArray[6].ToString()), dt.Rows[0].ItemArray[1]); dp.Label = DateTime.Parse(dr.ItemArray[6].ToString()).ToShortDateString() + " " + dr.ItemArray[9].ToString(); sExpenses.Points.Add(dp); } dt.Clear(); } sExpenses.XValueType = ChartValueType.Date; sIncome.XValueType = ChartValueType.Date; //chart1.ChartAreas[0].AxisX.ScaleView.Zoom(0, 10); chart1.Series.Add(sExpenses); chart1.Series.Add(sIncome); chart1.ChartAreas[0].RecalculateAxesScale(); }