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);
}
}
