private void OverTimeProcessed_Load(object sender, EventArgs e)
{
Datas.MouseDown += new MouseEventHandler(FpSpread_MouseDown);
Go(0);
string UserNodeCode = Yqun.Common.ContextCache.ApplicationContext.Current.UserCode;
if (UserNodeCode.Length > 12)
{
UserNodeCode = UserNodeCode.Substring(0, 12);
}
string userType = DepositoryLabStadiumList.GetUserType(UserNodeCode);
this.除ToolStripMenuItem.Visible = false;
if (Yqun.Common.ContextCache.ApplicationContext.Current.UserCode.Length == 8)
{
填写原因ToolStripMenuItem.Visible = false;
处理ToolStripMenuItem.Visible = true;
}
else if (userType.IndexOf("监理") > 0)
{
填写原因ToolStripMenuItem.Visible = false;
处理ToolStripMenuItem.Visible = true;
}
else
{
填写原因ToolStripMenuItem.Visible = true;
处理ToolStripMenuItem.Visible = false;
}
if (Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator)
{
填写原因ToolStripMenuItem.Visible = true;
处理ToolStripMenuItem.Visible = true;
}
}
public void Execute(IJobExecutionContext context)
{
//获得当前用户所在的试验室编码
String Project = context.Scheduler.Context.GetString("project");
String TestRoomCode = context.Scheduler.Context.GetString("currentLabCode");
if (!string.IsNullOrEmpty(Project) && !string.IsNullOrEmpty(TestRoomCode))
{
DataTable Data = DepositoryLabStadiumList.GetLabStadiumList(TestRoomCode);
if (Data != null)
{
logger.Info(string.Format("[{0}]获取试验龄期提醒信息成功，共{1}条信息。", Project, Data.Rows.Count));
if (Data.Rows.Count > 0)
{
logger.Info(string.Format("[{0}]正在初始化试验龄期提醒信息...", Project));
StadiumReminderDialog Dialog = new StadiumReminderDialog();
Dialog.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
FpSpread FpSpread = Dialog.FpSpread;
SheetView FpSpread_Info = Dialog.FpSpread_Info;
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
int HiddenColumnCount = 4;
FpSpread_Info.Columns.Count = Data.Columns.Count - HiddenColumnCount;
if (FpSpread_Info.Columns.Count > 0)
{
FpSpread_Info.Columns[0].Width = 160;
FpSpread_Info.Columns[1].Width = 110;
FpSpread_Info.Columns[2].Width = 80;
FpSpread_Info.Columns[3].Width = 120;
FpSpread_Info.Columns[4].Width = 100;
FpSpread_Info.Columns[5].Width = 120;
FpSpread_Info.Columns[6].Width = 190;
FpSpread_Info.Columns[7].Width = 190;
FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[0, FpSpread_Info.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;
FpSpread_Info.Columns[2].CellType = datetime;
FpSpread_Info.Columns[5].CellType = text;
FpSpread_Info.Columns[6].CellType = text;
FpSpread_Info.Columns[7].CellType = text;
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 35;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModelCode" || Column.ColumnName == "ModelIndex" || Column.ColumnName == "DateSpan")
{
continue;
}
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i - HiddenColumnCount].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i - HiddenColumnCount].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 - HiddenColumnCount].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].Tag = Row["ModelCode"].ToString() + "," + Row["ModelIndex"].ToString() + "," + Row["ID"].ToString() + "," + Row["DateSpan"].ToString();
}
logger.Info(string.Format("[{0}]正在显示提醒窗口...", Project));
Dialog.ShowDialog();
}
}
else
{
logger.Info(string.Format("[{0}]获取试验龄期提醒信息失败。", Project));
}
logger.Info(string.Format("[{0}]试验龄期提醒完毕，试验室编码：{1}", Project, TestRoomCode));
}
}
