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();
}
