Дипломная работа: Автоматизация услуг почтовой связи для Почты России

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
139
Chart1.Series[0]["PieDrawingStyle"] =
"SoftEdge";
dr.Close();
}
else//если выбрано по отделам
{
command = new SqlCommand("SELECT
CONCAT(сумма,' ', Отдел) AS Отдел, Summa AS Сумма FROM
(SELECT ResponsibleDepartment AS Отдел,
Replace(Format(SUM(Sum), 'N'),',',' ') AS Сумма, SUM(Sum) AS
Summa FROM DZ WHERE Month='" +
comboBoxMonthToChart.SelectedValue.ToString() + "' GROUP BY
ResponsibleDepartment) AS th", sqlConnection);
SqlDataReader dr =
command.ExecuteReader();
Chart1.DataBindTable(dr, "Отдел");
Chart1.Series[0].ChartType =
SeriesChartType.Pie;
Chart1.Series[0].IsVisibleInLegend =
false;
Chart1.Series[0]["PieLabelStyle"] =
"Outside";
Chart1.ChartAreas[0].Area3DStyle.Enable3D
= true;
Chart1.Series[0]["PieDrawingStyle"] =
"SoftEdge";
dr.Close();
}
}
private void timer1_Tick(object sender,
System.EventArgs e)
{
if (checkBoxRotate.Checked)
{
angle += 1;
140
if (angle >= 360)
{
angle = 0;
}
Chart1.Series[0]["PieStartAngle"] =
angle.ToString();
}
}
private void graf()
{//задаем стиль для графика
System.Windows.Forms.DataVisualization.Charting.ChartArea
chartArea1 = new
System.Windows.Forms.DataVisualization.Charting.ChartArea();
System.Windows.Forms.DataVisualization.Charting.Series series1
= new
System.Windows.Forms.DataVisualization.Charting.Series();
this.chart3 = new
System.Windows.Forms.DataVisualization.Charting.Chart();
this.SuspendLayout();
chartArea1.AxisX.LineColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(64)))), ((int)(((byte)(64)))),
((int)(((byte)(64)))));
chartArea1.AxisX.MajorGrid.LineColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(64)))), ((int)(((byte)(64)))),
((int)(((byte)(64)))));
chartArea1.AxisY.LabelStyle.Font = new
System.Drawing.Font("Trebuchet MS", 8.25F,
System.Drawing.FontStyle.Bold);
chartArea1.AxisY.LineColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(64)))), ((int)(((byte)(64)))),
((int)(((byte)(64)))));
141
chartArea1.AxisY.MajorGrid.LineColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(64)))), ((int)(((byte)(64)))),
((int)(((byte)(64)))));
chartArea1.BackColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(165)))), ((int)(((byte)(191)))),
((int)(((byte)(228)))));
chartArea1.BackGradientStyle =
System.Windows.Forms.DataVisualization.Charting.GradientStyle.
TopBottom;
chartArea1.BackSecondaryColor =
System.Drawing.Color.White;
chartArea1.BorderColor =
System.Drawing.Color.FromArgb(((int)(((byte)(64)))),
((int)(((byte)(64)))), ((int)(((byte)(64)))),
((int)(((byte)(64)))));
chartArea1.BorderDashStyle =
System.Windows.Forms.DataVisualization.Charting.ChartDashStyle
.Solid;
chartArea1.Name = "Default";
chartArea1.Position.Auto = false;
chartArea1.Position.Height = 94F;
chartArea1.Position.Width = 94F;
chartArea1.Position.X = 2F;
chartArea1.Position.Y = 2F;
chartArea1.ShadowColor =
System.Drawing.Color.Transparent;
this.chart3.ChartAreas.Add(chartArea1);
this.BackColor = System.Drawing.Color.White;
this.ResumeLayout(false);
}
private void UpdateChartSettings()
{
// Loop through all series
142
foreach (Series series in chart3.Series)
{
// Set series chart type
series.ChartType =
(SeriesChartType)Enum.Parse(typeof(SeriesChartType), "Line",
true);
}
}
private void DataForGraf()
{
// Populate series data
SqlCommand command = new SqlCommand("SELECT
right(convert(varchar, Month, 106), 8) AS Месяц, SUM(Sum) AS
Сумма FROM DZ GROUP BY Month ORDER BY Month", sqlConnection);
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
List<string> axisLabel = new List<string>();
string sdf = "";
for (int pointIndex = 0; pointIndex <
ds.Tables[0].Rows.Count; pointIndex++)
{
chart3.Series["Series1"].Points.AddY(ds.Tables[0].Rows[pointIn
dex][1]);
chart3.ChartAreas[0].AxisX.Title =
"Месяц";
chart3.ChartAreas[0].AxisY.Title =
"Сумма";
chart3.Series["Series1"].Points[pointIndex].AxisLabel =
ds.Tables[0].Rows[pointIndex][0].ToString();
}
UpdateChartSettings();
}
143
List<string> listColumns = new List<string>(new
string[] { "Unit AS Почтамт, ", "KAY AS 'Код аналитического
учета', ",
"Client AS Клиент, ", "Contract AS Договор, ",
"NumberOfContract AS 'Номер договора', ",
"ContractDate AS 'Дата договора', ", "INN AS
ИНН, ", "ResponsibleBlock AS 'Ответственный блок', ",
"ResponsibleDepartment AS 'Ответственный
отдел', ", "Comment AS Комментарии, ", "KindOfDZ AS Вид, "});
List<string> listColumnsInDZ = new
List<string>(new string[] { "Unit, ", "KAY, ",
"Client, ", "Contract, ", "NumberOfContract,
", "ContractDate, ", "INN, ", "ResponsibleBlock, ",
"ResponsibleDepartment, ", "Comment, ",
"KindOfDZ, "});
private void
checkedListBox1_SelectedIndexChanged(object sender, EventArgs
e)
{
string namesColumns = null;
string namesColumnsGROUP = null;
columnSelection(0, 1);
columnSelection(1, 2);
columnSelection(2, 3);
columnSelection(3, 4);
columnSelection(4, 5);
columnSelection(5, 6);
columnSelection(6, 8);
columnSelection(7, 9);
columnSelection(8, 10);
columnSelection(9, 12);
columnSelection(10, 13);
foreach (int indexChecked in
checkedListBox1.CheckedIndices)
{
Источник: https://baza.diplomsite.ru/previewfile/2349

Смотрите также:

Изложение содержания дела, по которому приняты судебные постановления
_-___-~1
_1-тема-СтрМетал