private void BindRequest(Object c)
{
try
{
Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext;
SheetView spread_request_sheet = new SheetView();
spread_request_sheet.Columns.Count = 11;
spread_request_sheet.Columns[0].Width = 80;
spread_request_sheet.Columns[1].Width = 100;
spread_request_sheet.Columns[2].Width = 200;
spread_request_sheet.Columns[3].Width = 150;
spread_request_sheet.Columns[4].Width = 240;
spread_request_sheet.Columns[5].Width = 80;
spread_request_sheet.Columns[6].Width = 130;
spread_request_sheet.Columns[7].Width = 120;
spread_request_sheet.Columns[8].Width = 300;
spread_request_sheet.Columns[9].Width = 300;
spread_request_sheet.Columns[0, spread_request_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
TextCellType text = new TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_request_sheet.Columns[0, 2].CellType = text;
DataTable Data = DocumentHelperClient.GetUnPreocessedRequestList();
spread_request_sheet.Rows.Count = 0;
if (Data != null)
{
//spread_request.ShowRow(spread_request.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_request_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Height = 20;
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Locked = true;
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_request_sheet.Columns[i - 3].VerticalAlignment = CellVerticalAlignment.Center;
spread_request_sheet.Columns[i - 3].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_request_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_request_sheet.Cells[j, i - 3].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_request_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModuleID"].ToString();
}
}
AddViewDelegate avd = new AddViewDelegate(AddView);
spread_request.Invoke(avd, spread_request, spread_request_sheet);
ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle);
tabPage3.Invoke(cttd, tabPage3, "待审批用户申请【" + spread_request.Sheets[0].RowCount + "】");
}
catch
{
}
}
private void BindInvalid(Object c)
{
try
{
Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext;
SheetView spread_invalide_sheet = new SheetView();
spread_invalide_sheet.Rows.Count = 0;
spread_invalide_sheet.Columns.Count = 12;
spread_invalide_sheet.ColumnHeader.Cells[0, 0].Text = "标段";
spread_invalide_sheet.ColumnHeader.Cells[0, 1].Text = "单位";
spread_invalide_sheet.ColumnHeader.Cells[0, 2].Text = "试验室";
spread_invalide_sheet.ColumnHeader.Cells[0, 3].Text = "试验报告";
spread_invalide_sheet.ColumnHeader.Cells[0, 4].Text = "报告编号";
spread_invalide_sheet.ColumnHeader.Cells[0, 5].Text = "报告日期";
spread_invalide_sheet.ColumnHeader.Cells[0, 6].Text = "试验项目";
spread_invalide_sheet.ColumnHeader.Cells[0, 7].Text = "标准值";
spread_invalide_sheet.ColumnHeader.Cells[0, 8].Text = "实测值";
spread_invalide_sheet.ColumnHeader.Cells[0, 9].Text = "原因分析";
spread_invalide_sheet.ColumnHeader.Cells[0, 10].Text = "监理意见";
spread_invalide_sheet.ColumnHeader.Cells[0, 11].Text = "处理结果";
spread_invalide_sheet.Columns[0].Width = 80;
spread_invalide_sheet.Columns[1].Width = 100;
spread_invalide_sheet.Columns[2].Width = 100;
spread_invalide_sheet.Columns[3].Width = 190;
spread_invalide_sheet.Columns[4].Width = 200;
spread_invalide_sheet.Columns[5].Width = 90;
spread_invalide_sheet.Columns[6].Width = 110;
spread_invalide_sheet.Columns[7, 8].Width = 90;
spread_invalide_sheet.Columns[9].Width = 200;
spread_invalide_sheet.Columns[10].Width = 200;
spread_invalide_sheet.Columns[11].Width = 200;
FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
spread_invalide_sheet.Columns[5].CellType = datetime;
Boolean isSG = false;
if (userType.IndexOf("施工") > 0)
{
isSG = true;
}
DataTable Data = DocumentHelperClient.GetUndoInvalidDocumentList(isSG);
if (Data != null)
{
//spread_invalide.ShowRow(spread_invalide.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_invalide_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_invalide_sheet.Columns[0, 2].CellType = text;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Height = 25;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Locked = true;
spread_invalide_sheet.Columns[0, spread_invalide_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_invalide_sheet.Columns[i - 2].VerticalAlignment = CellVerticalAlignment.Center;
spread_invalide_sheet.Columns[i - 2].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_invalide_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_invalide_sheet.Cells[j, i - 2].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_invalide_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString();
}
}
}
AddViewDelegate avd = new AddViewDelegate(AddView);
spread_invalide.Invoke(avd, spread_invalide, spread_invalide_sheet);
ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle);
tabPage2.Invoke(cttd, tabPage2, "待处理不合格报告【" + spread_invalide.Sheets[0].RowCount + "】");
}
catch
{
}
}
