private void TemperatureDialog_Load(object sender, EventArgs e) { ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode); FpSpread_Info.Rows.Count = 0; FpSpread_Info.Columns.Count = 12; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "ID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "试验室编码"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "试验日期"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "早晨温度"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "中午温度"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "傍晚温度"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "平均温度"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "备注"; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "LastEditUser"; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "LastEditTime"; FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "IsUpdated"; FpSpread_Info.ColumnHeader.Cells[0, 11].Text = "TemperatureType"; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType(); number.DecimalPlaces = 1; number.FixedPoint = true; FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //number var TemperatureType = Convert.ToInt32(ComboTemperature.SelectedValue); DataTable Data = ModuleHelperClient.GetTemperatureList("000", new DateTime(2014, 1, 2), new DateTime(2014, 1, 1), TemperatureType); FpSpread_Info.DataSource = Data; FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FpSpread_Info.Columns[2].CellType = datetime; FpSpread_Info.Columns[2].Locked = true; FpSpread_Info.Columns[3].CellType = number; FpSpread_Info.Columns[4].CellType = number; FpSpread_Info.Columns[5].CellType = number; FpSpread_Info.Columns[6].CellType = number; FpSpread_Info.Columns[6].Locked = true; FpSpread_Info.Columns[7].CellType = text; FpSpread_Info.Columns[8].Visible = false; FpSpread_Info.Columns[9].Visible = false; FpSpread_Info.Columns[10].Visible = false; FpSpread_Info.Columns[11].Visible = false; FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; DateTimePicker_Start.Value = DateTime.Now.AddMonths(-1); DateTimePicker_End.Value = DateTime.Now; SetDefaultStyle(); }
private void TemperatureDialog_Load(object sender, EventArgs e) { FpSpread_Info.Rows.Count = 0; FpSpread_Info.Columns.Count = 12; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "ID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "项名称"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "项类型"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "权重"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "中午温度"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "傍晚温度"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "平均温度"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "备注"; FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "IsUpdated"; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //number FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FpSpread_Info.Columns[2].CellType = datetime; FpSpread_Info.Columns[2].Locked = true; FpSpread_Info.Columns[3].CellType = number; FpSpread_Info.Columns[4].CellType = number; FpSpread_Info.Columns[5].CellType = number; FpSpread_Info.Columns[6].CellType = number; FpSpread_Info.Columns[6].Locked = true; FpSpread_Info.Columns[7].CellType = text; FpSpread_Info.Columns[8].Visible = false; FpSpread_Info.Columns[9].Visible = false; FpSpread_Info.Columns[10].Visible = false; FpSpread_Info.Columns[11].Visible = false; int TemperatureType = 0; DataTable Data = ModuleHelperClient.GetTemperatureList("000", new DateTime(2014, 1, 2), new DateTime(2014, 1, 1), TemperatureType); FpSpread_Info.DataSource = Data; FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; }
private void BindDayList() { DateTime StartDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_Start.Value.Year, DateTimePicker_Start.Value.Month, DateTimePicker_Start.Value.Day)); DateTime EndDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_End.Value.Year, DateTimePicker_End.Value.Month, DateTimePicker_End.Value.Day)); DateTimePicker_End.Value = EndDate; ProgressScreen.Current.ShowSplashScreen(); ProgressScreen.Current.SetStatus = "正在获取数据..."; String testroom = TestRoomCode;// Yqun.Common.ContextCache.ApplicationContext.Current.InTestRoom.Code; EndDate = EndDate.AddDays(1); var TemperatureType = Convert.ToInt32(ComboTemperature.SelectedValue); DataTable Data = ModuleHelperClient.GetTemperatureList(testroom, StartDate, EndDate, TemperatureType); if (Data != null) { FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); FpSpread_Info.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { i = Data.Columns.IndexOf(Column); FpSpread_Info.Columns[i].Width = 100; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; if ((i == 3 || i == 4 || i == 5 || i == 6) && Row[Column.ColumnName] != null) { bool bIsNumber = false; float fValue = 0; bIsNumber = float.TryParse(Row[Column.ColumnName].ToString(), out fValue); if (bIsNumber == true) { FpSpread_Info.Cells[j, i].Value = fValue.ToString("F1"); } else { FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName]; } } else { FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName]; } } } #region 计算总温度与锁定两天以前添加的温度 double fTemperatureSum = 0; object TemperatureAvg = null; object oLastEditTime = null; DateTime dtLastEditTime = new DateTime(); foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].Tag = Row["ID"] == DBNull.Value ? "" : Row["ID"].ToString(); TemperatureAvg = Row["TemperatureAvg"]; oLastEditTime = Row["LastEditTime"]; if (TemperatureAvg != DBNull.Value) { fTemperatureSum += Convert.ToDouble(TemperatureAvg); } if (oLastEditTime != DBNull.Value) { dtLastEditTime = DateTime.Parse(oLastEditTime.ToString()); if (dtLastEditTime.AddDays(2).CompareTo(DateTime.Now.Date) < 0 && !Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator) { FpSpread_Info.Rows[j].Locked = true; } } } lblTemperatureSum.Text = string.Format("总温度:{0}℃", fTemperatureSum.ToString("f1")); #endregion } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); MessageBox.Show("无数据,请重新选择条件!"); } } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); MessageBox.Show("无数据,请重新选择条件!"); } ProgressScreen.Current.CloseSplashScreen(); this.Activate(); if (Data == null) { TotalCount.Text = string.Format("本次查询共 {0} 条记录", 0); } else { TotalCount.Text = string.Format("本次查询共 {0} 条记录", Data.Rows.Count); } }
private void BindDayList() { ProgressScreen.Current.ShowSplashScreen(); ProgressScreen.Current.SetStatus = "正在获取数据..."; DataTable Data = ModuleHelperClient.GetTemperatureList(testroom, StartDate, EndDate, TemperatureType); if (Data != null) { FpSpread_Info.DataSource = Data; FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); FpSpread_Info.Rows.Count = Data.Rows.Count; if (Data.Rows.Count > 0) { int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { i = Data.Columns.IndexOf(Column); FpSpread_Info.Columns[i].Width = 100; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName]; } } double fTemperatureSum = 0; object TemperatureAvg = null; object oLastEditTime = null; DateTime dtLastEditTime = new DateTime(); foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].Tag = Row["ID"] == DBNull.Value ? "" : Row["ID"].ToString(); TemperatureAvg = Row["TemperatureAvg"]; oLastEditTime = Row["LastEditTime"]; if (TemperatureAvg != DBNull.Value) { fTemperatureSum += Convert.ToDouble(TemperatureAvg); } if (oLastEditTime != DBNull.Value) { dtLastEditTime = DateTime.Parse(oLastEditTime.ToString()); if (dtLastEditTime.AddDays(2).CompareTo(DateTime.Now.Date) < 0 && !Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator) { FpSpread_Info.Rows[j].Locked = true; } } } } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); } } else { ProgressScreen.Current.CloseSplashScreen(); this.Activate(); } ProgressScreen.Current.CloseSplashScreen(); this.Activate(); if (Data == null) { TotalCount.Text = string.Format("本次查询共 {0} 条记录", 0); } else { TotalCount.Text = string.Format("本次查询共 {0} 条记录", Data.Rows.Count); } }