public void Execute(IJobExecutionContext context) { //获得当前用户名称和单位类型 String Project = context.Scheduler.Context.GetString("project"); String CompanyIndex = context.Scheduler.Context.GetString("currentCompanyIndex"); String CompanyType = context.Scheduler.Context.GetString("currentCompanyType"); Boolean IsAdmin = context.Scheduler.Context.GetBoolean("isAdmin"); if (!string.IsNullOrEmpty(Project) && !string.IsNullOrEmpty(CompanyType) && CompanyType != "@unit_施工单位") { List <String> RoomCodes = DepositoryEvaluateDataList.GetTestRoomList(IsAdmin, CompanyIndex, CompanyType); logger.Info(string.Format("[{0}]获得监管的试验室编码完成,编码列表为:{1}", Project, string.Join(",", RoomCodes.ToArray()))); //DataTable Data = DepositoryDataModificationInfo.InitDataModificationList(RoomCodes.ToArray()); //if (Data != null) //{ // logger.Info(string.Format("[{0}]获取审批修改信息成功,共{1}条信息。", Project, Data.Rows.Count)); // if (Data.Rows.Count > 0) // { // logger.Info(string.Format("[{0}]正在初始化审批修改信息...", Project)); //DataModificationView Dialog = new DataModificationView(); //QuerySponsorModifyDialog Dialog = new QuerySponsorModifyDialog(); //FpSpread FpSpread = Dialog.FpSpread; //SheetView FpSpread_Info = Dialog.FpSpread_Info; //FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); //FpSpread_Info.Columns.Count = 7; //FpSpread_Info.Columns[0].Width = 200; //FpSpread_Info.Columns[1].Width = 150; //FpSpread_Info.Columns[2].Width = 240; //FpSpread_Info.Columns[3].Width = 80; //FpSpread_Info.Columns[4].Width = 130; //FpSpread_Info.Columns[5].Width = 120; //FpSpread_Info.Columns[6].Width = 250; //FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //text.Multiline = true; //text.WordWrap = true; //FpSpread_Info.Columns[0, 2].CellType = text; //FpSpread_Info.Rows.Count = Data.Rows.Count; //FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 35; //FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true; //FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; //FpSpread_Info.Rows[0, FpSpread_Info.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 == "ModelCode" || Column.ColumnName == "ModelIndex") // continue; // i = Data.Columns.IndexOf(Column); // FpSpread_Info.Columns[i - 4].VerticalAlignment = CellVerticalAlignment.Center; // FpSpread_Info.Columns[i - 4].Label = Column.ColumnName; // foreach (DataRow Row in Data.Rows) // { // j = Data.Rows.IndexOf(Row); // FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; // FpSpread_Info.Cells[j, i - 4].Value = Row[Column.ColumnName].ToString(); // } //} //foreach (DataRow Row in Data.Rows) //{ // j = Data.Rows.IndexOf(Row); // FpSpread_Info.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModelCode"].ToString() + "," + Row["ModelIndex"].ToString(); //} // logger.Info(string.Format("[{0}]正在显示审批修改窗口...", Project)); // Dialog.ShowDialog(); //} //} } }
public void Execute(IJobExecutionContext context) { //获得当前用户名称和单位类型 String Project = context.Scheduler.Context.GetString("project"); String CompanyIndex = context.Scheduler.Context.GetString("currentCompanyIndex"); String CompanyType = context.Scheduler.Context.GetString("currentCompanyType"); Boolean IsAdmin = context.Scheduler.Context.GetBoolean("isAdmin"); if (!string.IsNullOrEmpty(Project) && !string.IsNullOrEmpty(CompanyType) && CompanyType != "@unit_施工单位") { List <String> RoomCodes = DepositoryEvaluateDataList.GetTestRoomList(IsAdmin, CompanyIndex, CompanyType); logger.Info(string.Format("[{0}]获得监管的试验室编码完成,编码列表为:{1}", Project, string.Join(",", RoomCodes.ToArray()))); DataTable Data = DepositoryEvaluateDataList.GetReminderInfos(RoomCodes.ToArray(), DateTime.Now, DateTime.Now); if (Data != null) { logger.Info(string.Format("[{0}]获取不合格报告信息成功,共{1}条信息。", Project, Data.Rows.Count)); if (Data.Rows.Count > 0) { logger.Info(string.Format("[{0}]正在初始化不合格报告信息...", Project)); ReportEvaluateDialog Dialog = new ReportEvaluateDialog(Project); FpSpread FpSpread = Dialog.FpSpread; SheetView FpSpread_Info = Dialog.FpSpread_Info; FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top); FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); text.Multiline = true; text.WordWrap = true; FpSpread_Info.Columns[0, 2].CellType = text; FpSpread_Info.Rows.Count = Data.Rows.Count; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 25; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true; FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center; FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center; int i, j; foreach (System.Data.DataColumn Column in Data.Columns) { if (Column.ColumnName == "ID" || Column.ColumnName == "DataIndex" || Column.ColumnName == "ModelCode" || Column.ColumnName == "ModelIndex") { continue; } i = Data.Columns.IndexOf(Column); FpSpread_Info.Columns[i - 4].VerticalAlignment = CellVerticalAlignment.Center; FpSpread_Info.Columns[i - 4].Label = Column.ColumnName; foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center; FpSpread_Info.Cells[j, i - 4].Value = Row[Column.ColumnName].ToString(); } } foreach (DataRow Row in Data.Rows) { j = Data.Rows.IndexOf(Row); FpSpread_Info.Rows[j].Tag = Row["DataIndex"].ToString() + "," + Row["ModelCode"].ToString() + "," + Row["ModelIndex"].ToString() + "," + Row["ID"].ToString(); } logger.Info(string.Format("[{0}]正在显示提醒窗口...", Project)); Dialog.ShowDialog(); } } else { logger.Info(string.Format("[{0}]获取不合格报告信息失败。", Project)); } logger.Info(string.Format("[{0}]不合格报告提醒完毕", Project)); } }