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