protected override void OnPrimaryKeyChangedAsync()
{
AccessHelper access = new AccessHelper();
List<School> schools = access.Select<School>(string.Format("uid='{0}'", PrimaryKey));
if (schools.Count > 0)
SchoolData = schools[0];
else
SchoolData = null;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
School s = new School();
s.Title = txtTitle.Text;
s.DSNS = txtDSNS.Text;
s.Group = cboGroup.Text;
s.Save();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
DialogResult = DialogResult.None;
}
}
private void ReadSchoolRecordFromExcel(string fileName, Dictionary<string, School> schools)
{
try
{
Dictionary<string, int> column_map = new Dictionary<string, int>(StringComparer.CurrentCultureIgnoreCase);
Workbook book = new Workbook();
book.Open(fileName, FileFormatType.Excel2007Xlsx);
Worksheet sheet = book.Worksheets[0];
ReadColumnName(column_map, sheet);
for (int i = 1; i <= sheet.Cells.MaxDataRow; i++)
{
string name = sheet.Cells[i, column_map["Name".ToLower()]].StringValue;
School school = new School();
if (schools.ContainsKey(name))
school = schools[name];
else
schools.Add(name, school);
school.DSNS = sheet.Cells[i, column_map["Name".ToLower()]].StringValue;
school.Title = sheet.Cells[i, column_map["Title".ToLower()]].StringValue;
if (column_map.ContainsKey("Group"))
school.Group = sheet.Cells[i, column_map["Group".ToLower()]].StringValue;
if (column_map.ContainsKey("Memo"))
school.Comment = sheet.Cells[i, column_map["Memo".ToLower()]].StringValue;
}
}
catch (Exception ex)
{
ErrorBox.Show("讀取 Excel 錯誤！", ex);
}
}
protected override void OnPrimaryKeyChangedAsync()
{
AccessHelper access = new AccessHelper();
List<School> schools = access.Select<School>(string.Format("uid='{0}'", PrimaryKey));
if (schools.Count > 0)
SchoolData = schools[0];
else
throw new Exception("查不到學校資料：" + PrimaryKey);
HashSet<string> tables = GetTables();
// Chart mc = new Chart();
// mc.ChartArea.AxisY2.IsMajorGridVisible = false;
// mc.ChartArea.AxisY.IsMajorGridVisible = false;
// mc.ChartArea.AxisX.IsMajorGridVisible = false;
// mc.ChartArea.AxisX2.IsMajorGridVisible = false;
// mc.ChartArea.AxisX.DefaultLabel.Format = "dd";
// mc.ChartArea.AxisY2.AxisLabels.IsDataPointNameVisible = false;
// Series serCount = new Series() { ChartType = ChartType.Line };
// serCount.Name = "取樣數";
// serCount.DefaultDataPoint.IsLabelVisible = true;
// serCount.IsPrimaryAxisY = false;
// Series serTraffic = new Series() { ChartType = ChartType.Bar };
// serTraffic.Name = "流量(MB)";
// serTraffic.IsPrimaryAxisY = true;
// List<DateTime> times = new List<DateTime>();
// for (int i = 8; i >= 0; i--)
// {
// times.Add(DateTime.Now.AddDays(-i));
// }
// foreach (DateTime dt in times)
// {
// string tableName = string.Format("log_client_{0:0000}_{1:00}_{2:00}", dt.Year, dt.Month, dt.Day);
// if (!tables.Contains(tableName))
// continue;
// string cmd = @"select count(*) count,sum(bts+btr) traffic,trunc(stddev(spend)) spend,trunc(stddev(server_spend)) sspend,trunc(stddev(spend-server_spend)) network_spend
// from {0}
// where app in ('{1}')
// group by app";
// cmd = string.Format(cmd, tableName, SchoolData.DSNS);
// XElement records = Query(cmd);
// foreach (XElement record in records.Elements("Record"))
// {
// int count = record.ElementInt("count", -1);
// int totalSpend = record.ElementInt("spend", -1);
// int serverSpend = record.ElementInt("sspend", -1);
// int networkSpend = record.ElementInt("network_spend", -1);
// int traffic = record.ElementInt("traffic", -1);
// serTraffic.DataPoints.Add(new DataPoint(dt, traffic / 1024 / 1024));
// serCount.DataPoints.Add(new DataPoint(dt, count));
// }
// }
// mc.SeriesCollection.Add(serTraffic);
// mc.SeriesCollection.Add(serCount);
// //Series s0 = new Series();
// //s0.IsPrimaryAxisY = true;
// ////mc.ChartArea.AxisY.DefaultLabel.Color = s0.DefaultDataPoint.Color = s0.DefaultDataPoint.BorderColor = Color.Green;
// //s0.ChartType = ChartType.Line;
// //for (int i = 1; i < 8; i++)
// // s0.DataPoints.Add(new DataPoint(i, i * i));
// //mc.SeriesCollection.Add(s0);
// //Series s1 = new Series();
// //s1.IsPrimaryAxisY = false;
// ////mc.ChartArea.AxisY2.DefaultLabel.Color = s1.DefaultDataPoint.Color = Color.Blue;
// //s1.ChartType = ChartType.Bar;
// //for (int i = 1; i < 8; i++)
// // s1.DataPoints.Add(new DataPoint(i, i * i * i));
// //mc.SeriesCollection.Add(s1);
// MainChart = mc;
}
private void frmSpecial_Load(object sender, EventArgs e)
{
AccessHelper helper = new AccessHelper();
List<School> Schools = helper.Select<School>();
School vSchool = new School();
vSchool.DSNS = "dev.jh_kh";
vSchool.Title = "高雄測試國中(內部)";
Schools.Add(vSchool);
cmbSchool.DataSource = Schools;
cmbSchool.DisplayMember = "Title";
cmbSchool.ValueMember = "DSNS";
}
protected override void OnPrimaryKeyChangedAsync()
{
AccessHelper access = new AccessHelper();
List <School> schools = access.Select <School>(string.Format("uid='{0}'", PrimaryKey));
if (schools.Count > 0)
{
SchoolData = schools[0];
}
else
{
throw new Exception("查不到學校資料：" + PrimaryKey);
}
HashSet <string> tables = GetTables();
// Chart mc = new Chart();
// mc.ChartArea.AxisY2.IsMajorGridVisible = false;
// mc.ChartArea.AxisY.IsMajorGridVisible = false;
// mc.ChartArea.AxisX.IsMajorGridVisible = false;
// mc.ChartArea.AxisX2.IsMajorGridVisible = false;
// mc.ChartArea.AxisX.DefaultLabel.Format = "dd";
// mc.ChartArea.AxisY2.AxisLabels.IsDataPointNameVisible = false;
// Series serCount = new Series() { ChartType = ChartType.Line };
// serCount.Name = "取樣數";
// serCount.DefaultDataPoint.IsLabelVisible = true;
// serCount.IsPrimaryAxisY = false;
// Series serTraffic = new Series() { ChartType = ChartType.Bar };
// serTraffic.Name = "流量(MB)";
// serTraffic.IsPrimaryAxisY = true;
// List<DateTime> times = new List<DateTime>();
// for (int i = 8; i >= 0; i--)
// {
// times.Add(DateTime.Now.AddDays(-i));
// }
// foreach (DateTime dt in times)
// {
// string tableName = string.Format("log_client_{0:0000}_{1:00}_{2:00}", dt.Year, dt.Month, dt.Day);
// if (!tables.Contains(tableName))
// continue;
// string cmd = @"select count(*) count,sum(bts+btr) traffic,trunc(stddev(spend)) spend,trunc(stddev(server_spend)) sspend,trunc(stddev(spend-server_spend)) network_spend
// from {0}
// where app in ('{1}')
// group by app";
// cmd = string.Format(cmd, tableName, SchoolData.DSNS);
// XElement records = Query(cmd);
// foreach (XElement record in records.Elements("Record"))
// {
// int count = record.ElementInt("count", -1);
// int totalSpend = record.ElementInt("spend", -1);
// int serverSpend = record.ElementInt("sspend", -1);
// int networkSpend = record.ElementInt("network_spend", -1);
// int traffic = record.ElementInt("traffic", -1);
// serTraffic.DataPoints.Add(new DataPoint(dt, traffic / 1024 / 1024));
// serCount.DataPoints.Add(new DataPoint(dt, count));
// }
// }
// mc.SeriesCollection.Add(serTraffic);
// mc.SeriesCollection.Add(serCount);
// //Series s0 = new Series();
// //s0.IsPrimaryAxisY = true;
// ////mc.ChartArea.AxisY.DefaultLabel.Color = s0.DefaultDataPoint.Color = s0.DefaultDataPoint.BorderColor = Color.Green;
// //s0.ChartType = ChartType.Line;
// //for (int i = 1; i < 8; i++)
// // s0.DataPoints.Add(new DataPoint(i, i * i));
// //mc.SeriesCollection.Add(s0);
// //Series s1 = new Series();
// //s1.IsPrimaryAxisY = false;
// ////mc.ChartArea.AxisY2.DefaultLabel.Color = s1.DefaultDataPoint.Color = Color.Blue;
// //s1.ChartType = ChartType.Bar;
// //for (int i = 1; i < 8; i++)
// // s1.DataPoints.Add(new DataPoint(i, i * i * i));
// //mc.SeriesCollection.Add(s1);
// MainChart = mc;
}
