public Dictionary <string, SystemICS_SJJH_DownloadLog> GetSJJHState(string _yhm)
{
Dictionary <string, SystemICS_SJJH_DownloadLog> _ret = new Dictionary <string, SystemICS_SJJH_DownloadLog>();
OraMetaDataQueryFactroy _odf = new OraMetaDataQueryFactroy();
List <MDQuery_GuideLineParameter> _param = new List <MDQuery_GuideLineParameter>();
_param.Add(new MDQuery_GuideLineParameter(new MD_GuideLineParameter("&strYHM", "", "字符型", 0, 0, "", true, ""), _yhm));
DataTable _dt = _odf.QueryGuideLine("911000001681", _param);
foreach (DataRow _dr in _dt.Rows)
{
string _s = _dr["更新对象分类"].ToString();
if (!_ret.ContainsKey(_s))
{
SystemICS_SJJH_DownloadLog _item = new SystemICS_SJJH_DownloadLog(
_dr.IsNull("系统名称") ? "" : _dr["系统名称"].ToString(),
"",
(DateTime)_dr["下载时间"],
Convert.ToInt32(_dr["下载进度"]),
_dr.IsNull("更新对象分类") ? "" : _dr["更新对象分类"].ToString()
);
_ret.Add(_s, _item);
}
}
return(_ret);
}
public List <SystemICS_SJJH_DownloadLog> GetSJJHProcessList(string _yhm, DateTime _start, DateTime _end)
{
List <SystemICS_SJJH_DownloadLog> _ret = new List <SystemICS_SJJH_DownloadLog>();
OraMetaDataQueryFactroy _odf = new OraMetaDataQueryFactroy();
List <MDQuery_GuideLineParameter> _param = new List <MDQuery_GuideLineParameter>();
_param.Add(new MDQuery_GuideLineParameter(new MD_GuideLineParameter("&strYHM", "", "字符型", 0, 0, "", true, ""), _yhm));
_param.Add(new MDQuery_GuideLineParameter(new MD_GuideLineParameter("&dtBegin", "", "日期型", 0, 0, "", true, ""), _start.ToString("yyyy-MM-dd") + " 00:00:00"));
_param.Add(new MDQuery_GuideLineParameter(new MD_GuideLineParameter("&dtEnd", "", "日期型", 0, 0, "", true, ""), _end.ToString("yyyy-MM-dd") + " 23:59:59"));
DataTable _dt = _odf.QueryGuideLine("911000001682", _param);
foreach (DataRow _dr in _dt.Rows)
{
SystemICS_SJJH_DownloadLog _item = new SystemICS_SJJH_DownloadLog(
_dr.IsNull("系统名称") ? "" : _dr["系统名称"].ToString(),
_dr.IsNull("下载对象名称") ? "" : _dr["下载对象名称"].ToString(),
(DateTime)_dr["下载时间"],
Convert.ToInt32(_dr["下载进度"]),
_dr.IsNull("更新对象分类") ? "" : _dr["更新对象分类"].ToString()
);
_ret.Add(_item);
}
return(_ret);
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (_toBeQuery != null)
{
QueryData();
}
else
{
this.gridView1.BeginUpdate();
this.sinoCommonGrid1.DataSource = LogList;
this.gridView1.EndUpdate();
if (MainInfo.ContainsKey("新增修改进度"))
{
SystemICS_SJJH_DownloadLog _log = MainInfo["新增修改进度"];
lb_xz_time.Text = _log.DownloadTime.ToString("yyyy年MM月dd日 HH:mm:ss");
lb_xz_bs.Text = _log.ODS_ID.ToString();
}
else
{
lb_xz_time.Text = "";
lb_xz_bs.Text = "";
}
if (MainInfo.ContainsKey("代码表更新进度"))
{
SystemICS_SJJH_DownloadLog _log = MainInfo["代码表更新进度"];
this.lb_dmbgx_time.Text = _log.DownloadTime.ToString("yyyy年MM月dd日 HH:mm:ss");
this.lb_dmbgx_bs.Text = _log.ODS_ID.ToString();
}
else
{
this.lb_dmbgx_time.Text = "";
this.lb_dmbgx_bs.Text = "";
}
if (MainInfo.ContainsKey("删除数据更新进度"))
{
SystemICS_SJJH_DownloadLog _log = MainInfo["删除数据更新进度"];
this.lb_scsj_time.Text = _log.DownloadTime.ToString("yyyy年MM月dd日 HH:mm:ss");
this.lb_scsj_bs.Text = _log.ODS_ID.ToString();
}
else
{
this.lb_scsj_time.Text = "";
this.lb_scsj_bs.Text = "";
}
this.bt_Refresh.Enabled = true;
this.panelWait.Visible = false;
}
}
