private void DgvGrid_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { if (e.RowIndex < 0) { return; } int id = Convert.ToInt32(DgvGrid["ColAction", e.RowIndex].Value.ToString()); // 获取所要修改关联对象的主键。 //用户单击DataGridView“操作”列中的“修改”按钮。 if (DBConfigDataGridViewActionButtonCell.IsModifyButtonClick(sender, e)) { SqlServerConfigInfo dbConfigInfo = SqlServerConfigInfoBLL.CreateInstance().Get(id); FormMain.LoadNewControl(SqlServerConfigEdit.BindJobDetail(dbConfigInfo)); // 载入该模块的修改信息界面至主窗体显示。 } //用户单击DataGridView“操作”列中的“删除”按钮。 if (DBConfigDataGridViewActionButtonCell.IsDeleteButtonClick(sender, e)) { DialogResult dialogResult = FormSysMessage.ShowMessage("确定要删除该项吗?"); if (dialogResult == DialogResult.OK) { SqlServerConfigInfoBLL.CreateInstance().Delete(id); BindDataGrid(); } } }
public JsonResult SyncMsSqlData() { try { Log4NetHelper.WriteInfo("=============同步服务开始=============="); List <SqlServerConfigInfo> listSqlServerConfig = SqlServerConfigInfoBLL.CreateInstance().GetAll(); string jobName = Request["jobName"]; CustomJobDetail jobDetail = CustomJobDetailBLL.CreateInstance().Get(jobName); DateTime startDate = CustomJobDetailBLL.CreateInstance().GetFetchingStartDate(jobDetail.IntervalType, jobDetail.Interval); Parallel.ForEach(listSqlServerConfig, new ParallelOptions { MaxDegreeOfParallelism = 5 }, (sqlServerConfig) => { Monitor.Enter(lockedObj); try { List <EventLogDetail> listEventLogDetail = EventLogDetailBLL.CreateInstance().GetAll(sqlServerConfig.ConnString, startDate); if (listEventLogDetail != null && listEventLogDetail.Count > 0) { int cvsFileCapacity = 1000; if (sqlServerConfig.StoredType == (byte)StoredTypeEnum.PageSize) { cvsFileCapacity = sqlServerConfig.PageSize; } else if (sqlServerConfig.StoredType == (byte)StoredTypeEnum.MaxCapacity) { cvsFileCapacity = sqlServerConfig.MaxCapacity; } ExportCVSFile(listEventLogDetail, sqlServerConfig.EquipmentNum, cvsFileCapacity); } } catch (Exception ex) { Log4NetHelper.WriteExcepetion(ex); } finally { Monitor.Exit(lockedObj); } System.Threading.Thread.Sleep(1000); }); Log4NetHelper.WriteInfo("MsSqlDataSync-SyncMsSqlData 执行成功!"); Log4NetHelper.WriteInfo("=============同步服务结束=============="); return(Json(new { Code = 1, Message = "执行成功!" })); } catch (Exception ex) { Log4NetHelper.WriteExcepetion(ex); return(Json(new { Code = 0, Message = "执行失败!" })); } }
/// <summary> /// 用户单击“保存”按钮时的事件处理方法。 /// </summary> private void BtnSave_Click(object sender, EventArgs e) { BindFormlToObject(); // 进行数据绑定 if (dbConfigInfo.Id > 0) { SqlServerConfigInfoBLL.CreateInstance().Update(dbConfigInfo); } else { SqlServerConfigInfoBLL.CreateInstance().Insert(dbConfigInfo); } FormSysMessage.ShowSuccessMsg("保存成功,单击“确定”按钮返回列表。"); FormMain.LoadNewControl(SqlServerConfigList.Instance); // 载入该模块的信息列表界面至主窗体显示。 }
/// <summary> /// 对DataGridView控件的数据源进行绑定。 /// </summary> public static void BindDataGrid() { instance.PageBar.DataControl = instance.DgvGrid; instance.PageBar.DataSource = SqlServerConfigInfoBLL.CreateInstance().GetPageList(instance.PageBar.PageSize, instance.PageBar.CurPage); instance.PageBar.DataBind(); }