private void rb_yl_CheckedChanged(object sender, EventArgs e)
{
String testRoomCode = Yqun.Common.ContextCache.ApplicationContext.Current.InTestRoom.Code;
if (Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator)
{
testRoomCode = "0001000100010001";
}
Int32 deviceType = 1;
if (rb_yl.Checked)
{
deviceType = 1;
}
else if (rb_wn.Checked)
{
deviceType = 2;
}
list_Statum.Items.Clear();
dt = ModuleHelperClient.GetStadiumList("", "", testRoomCode, deviceType);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
string ModuleID = row["ModuleID"].ToString();
if (ModuleID.ToUpper() == "05D0D71B-DEF3-42EE-A16A-79B34DE97E9B" || ModuleID.ToUpper() == "68F05EBC-5D34-49C5-9B57-49B688DF24F7")
{
list_Statum.Items.Add(row["委托编号"].ToString());
}
}
}
}
private void BindStadium()
{
DataTable Data = null;
Data = ModuleHelperClient.GetStadiumList("", "", TestRoomCode, -1);
if (Data != null)
{
spread_stadium.ShowRow(spread_stadium.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_stadium_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count == 0)
{
return;
}
int HiddenColumnCount = 4;
spread_stadium_sheet.Columns.Count = Data.Columns.Count - HiddenColumnCount;
if (spread_stadium_sheet.Columns.Count > 0)
{
spread_stadium_sheet.Columns[0].Width = 60;
spread_stadium_sheet.Columns[1].Width = 80;
spread_stadium_sheet.Columns[2].Width = 100;
spread_stadium_sheet.Columns[3].Width = 120;
spread_stadium_sheet.Columns[4].Width = 60;
spread_stadium_sheet.Columns[5].Width = 70;
spread_stadium_sheet.Columns[6].Width = 90;
spread_stadium_sheet.Columns[7].Width = 60;
spread_stadium_sheet.Columns[8].Width = 120;
spread_stadium_sheet.Columns[9].Width = 120;
spread_stadium_sheet.Columns[10].Width = 60;
spread_stadium_sheet.Columns[11].Width = 120;
spread_stadium_sheet.Columns[12].Width = 120;
//spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
//spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
DateTimeCellType datetime = new DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_stadium_sheet.Columns[5].CellType = datetime;
spread_stadium_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Height = 35;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Locked = true;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID" || Column.ColumnName == "DateSpan")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_stadium_sheet.Columns[i - HiddenColumnCount].VerticalAlignment = CellVerticalAlignment.Center;
spread_stadium_sheet.Columns[i - HiddenColumnCount].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
if ((i - HiddenColumnCount) == 10)
{
spread_stadium_sheet.Cells[j, i - HiddenColumnCount].Value = Row[Column.ColumnName].ToString().TrimEnd('0').TrimEnd('.');
}
else
{
spread_stadium_sheet.Cells[j, i - HiddenColumnCount].Value = Row[Column.ColumnName].ToString();
}
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_sheet.Rows[j].Tag = Row["DataID"].ToString() + "," + Row["ModuleID"].ToString();
}
spread_stadium.CellDoubleClick -= new CellClickEventHandler(spread_stadium_CellDoubleClick);
spread_stadium.CellDoubleClick += new CellClickEventHandler(spread_stadium_CellDoubleClick);
}
}
