/// <summary> /// 定时器 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private static void TaskTimer_Elapsed(object sender, ElapsedEventArgs e) { //作者:林添喜 2006-01-25 说明:任务调用 string _log2 = string.Format("任务调用开始!"); if (WriteTaskInfo) { OralceLogWriter.WriteSystemLog(_log2, "INFO"); } //获取任务列表 DataTable _rwdata = SQL_TaskCommon.GetTaskList(); if (_rwdata != null) { foreach (DataRow _dr in _rwdata.Rows) { try { string _rwid = _dr["RWID"].ToString(); string _lb = _dr["RZLB"].ToString(); string _ml = _dr["RWML"].ToString(); TaskController.RunTask(_rwid, _lb, _ml); } catch (Exception ex) { string _log = string.Format("任务调用时出现错误:{0}", ex.Message); OralceLogWriter.WriteSystemLog(_log, "ERROR"); } } } }
/// <summary> /// 报生成的报表ID /// </summary> /// <param name="_reportName"></param> /// <param name="_sDate"></param> /// <param name="_eDate"></param> /// <param name="_dwdm"></param> /// <returns></returns> private static string GetReportID(string _reportName, DateTime _sDate, DateTime _eDate, string _dwdm) { using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "select ID from TJ_ZDYBBFJXXB where BBMC=:BBMC AND TJDW=:TJDW AND KSRQ=:KSRQ and JZRQ=:JZRQ "; _cmd.CommandType = CommandType.Text; _cmd.Parameters.Add(":BBMC", _reportName); _cmd.Parameters.Add(":TJDW", _dwdm); _cmd.Parameters.Add(":KSRQ", _sDate); _cmd.Parameters.Add(":JZRQ", _eDate); object _obj = _cmd.ExecuteScalar(); cn.Close(); return((_obj == null) ? "" : _obj.ToString()); } catch (Exception e) { string _emsg = string.Format("生成统计报表(报生成的报表ID)时发生错误!reportName={0} _dwdm={1} DATE={2} - {3} ", _reportName, _dwdm, _sDate, _eDate); _emsg += string.Format(" \n 错误信息:{0}", e.Message); OralceLogWriter.WriteSystemLog(_emsg, "ERROR"); return(""); } } }
private bool Save_ZHTJ_CS(string CSNAME, string CSDATA, string Des) { using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); try { OracleCommand _cmd = new OracleCommand(SQL_DelZHTJ_CS, cn); _cmd.Parameters.Add(":CSNAME", CSNAME); _cmd.ExecuteNonQuery(); OracleCommand _cmd2 = new OracleCommand(SQL_InsZHTJ_CS, cn); _cmd2.Parameters.Add(":CSNAME", CSNAME); _cmd2.Parameters.Add(":CSDATA", CSDATA); _cmd2.Parameters.Add(":CSDESC", Des); _cmd2.ExecuteNonQuery(); _txn.Commit(); return(true); } catch (Exception ex) { string _err = string.Format("写入参数{0}时发生错误:{1}", CSNAME, ex.Message); OralceLogWriter.WriteSystemLog(_err, "ERROR"); _txn.Rollback(); return(false); } } }
public static void WriteTaskLog(string _Rwid, int state, string _msg) { OracleCommand cmd; using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction txn = cn.BeginTransaction(); try { string _newmsg = (_msg.Length > 2000) ? _msg.Substring(0, 2000) : _msg; cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into gzrw_rz (rzid,rwid,rwmc,runtime,runflag,runresult) values (SEQ_YW.NEXTVAL,:RWID,'',sysdate,:STATE,:RUNRESULT)"; cmd.Parameters.Add(new OracleParameter(":RWID", decimal.Parse(_Rwid))); cmd.Parameters.Add(new OracleParameter(":STATE", Convert.ToDecimal(state))); cmd.Parameters.Add(new OracleParameter(":RUNRESULT", _newmsg)); cmd.ExecuteScalar(); txn.Commit(); } catch (Exception e) { string _log = string.Format("写入任务{1}日志表时出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); txn.Rollback(); } cn.Close(); } }
private static Application GetExcelApplication() { int times = 0; while (isBusy && times < 6000) { Thread.Sleep(100); times++; } ; isBusy = true; if (times > 5999) { OralceLogWriter.WriteSystemLog("Excel 程序忙!", "ERROR"); return(null); } if (UseCount > 10) { ClearExcelApp(); KillExcelThread(); UseCount = 0; } UseCount++; if (pExcelApp == null) { beforeTime = DateTime.Now; pExcelApp = new Application(); pExcelApp.Visible = false; pExcelApp.DisplayAlerts = false; afterTime = DateTime.Now; } return(pExcelApp); }
public static void ClearExcelApp() { int _ret = -1; try { if (pExcelApp != null) { pExcelApp.Quit(); ReleaseAllRef(pExcelApp); //_ret = System.Runtime.InteropServices.Marshal.ReleaseComObject(m_oExcelApp); OralceLogWriter.WriteSystemLog(string.Format("执行关闭m_oExcelApp!ret = {0}", _ret), "INFO"); int generation = System.GC.GetGeneration(pExcelApp); } pExcelApp = null; OralceLogWriter.WriteSystemLog("完成关闭EXCEL进程!", "INFO"); GC.Collect(); // GC.WaitForPendingFinalizers(); // GC.Collect(); // GC.WaitForPendingFinalizers(); } catch (Exception e) { OralceLogWriter.WriteSystemLog(string.Format("关闭EXCEL进程时出错!{0}", e.Message), "ERROR"); } finally { GC.Collect(); // GC.WaitForPendingFinalizers(); // GC.Collect(); // GC.WaitForPendingFinalizers(); } }
public bool SaveDataInfo(WC_DataInfo DataInfo) { using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); try { OracleCommand _cmd = new OracleCommand(SQL_DelDataInfo, cn); _cmd.Parameters.Add(":GZDATE", DataInfo.GZ_Date.ToString("yyyyMMdd")); _cmd.ExecuteNonQuery(); OracleCommand _cmd2 = new OracleCommand(SQL_InsDataInfo, cn); _cmd2.Parameters.Add(":GZDATA", DataInfo.GZ_Date.ToString("yyyyMMdd")); _cmd2.Parameters.Add(":GZ_META", DataInfo.Meta); _cmd2.Parameters.Add(":GZ_YEAR", Convert.ToDecimal(DataInfo.GZ_Date.Year)); _cmd2.Parameters.Add(":GZ_MONTH", Convert.ToDecimal(DataInfo.GZ_Date.Month)); _cmd2.Parameters.Add(":GZ_DAY", Convert.ToDecimal(DataInfo.GZ_Date.Day)); _cmd2.Parameters.Add(":GZ_LX", DataInfo.IsTJSBR ? (decimal)1 : (decimal)0); _cmd2.Parameters.Add(":GZ_SFGZR", DataInfo.IsWorkDay ? (decimal)0 : (decimal)1); _cmd2.Parameters.Add(":GZ_FXSB", DataInfo.IsFXSBR ? (decimal)1 : (decimal)0); _cmd2.ExecuteNonQuery(); _txn.Commit(); return(true); } catch (Exception ex) { string _err = string.Format("写入GZRL日期:{0}时发生错误:{1}", DataInfo.GZ_Date, ex.Message); OralceLogWriter.WriteSystemLog(_err, "ERROR"); _txn.Rollback(); return(false); } } }
private bool SaveNewNotifyInfo(NotifyInfo _info) { using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); try { OracleCommand _cmd = new OracleCommand(SQL_SaveNewNotifyInfo, cn); _cmd.Parameters.Add(":FBDW", SinoUserCtx.CurUser.CurrentPost.PostDWDM); _cmd.Parameters.Add(":FBR", SinoUserCtx.CurUser.UserName); _cmd.Parameters.Add(":LXDH", _info.TelNum); _cmd.Parameters.Add(":DZYJ", _info.Email); _cmd.Parameters.Add(":XXBT", _info.Title); _cmd.Parameters.Add(":XXNR", _info.Context); _cmd.ExecuteNonQuery(); } catch (Exception e) { string _errmsg = string.Format("删除ID={1}的通知通告信息时出错,错误信息为:{0}!", e.Message, _info.ID); OralceLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(false); } _txn.Commit(); cn.Close(); } return(true); }
public bool DeleteNotifyInfo(NotifyInfo CurrentInfo) { string _sql = " delete from XT_GGXX where ID=:ID AND FBDW=:FBDWDM "; using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); try { OracleCommand _cmd = new OracleCommand(_sql, cn); _cmd.Parameters.Add(":ID", decimal.Parse(CurrentInfo.ID)); _cmd.Parameters.Add(":FBDWDM", SinoUserCtx.CurUser.CurrentPost.PostDWDM); _cmd.ExecuteNonQuery(); } catch (Exception e) { string _errmsg = string.Format("删除ID={1}的通知通告信息时出错,错误信息为:{0}!", e.Message, CurrentInfo.ID); OralceLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(false); } _txn.Commit(); cn.Close(); } return(true); }
/// <summary> /// 验证口令 /// </summary> /// <param name="_name"></param> /// <param name="_pass"></param> /// <returns></returns> override public bool Check(string _name, string _pass, string CheckType) { //1.通过三统一接口验证密码 try { if (CUPPAPassportConfig.DebugMode) { return(_name == _pass); } else { using (OguReaderClient _orc = new OguReaderClient()) { bool _ret = _orc.CheckPwd(_name, CheckType, _pass); if (CUPPAPassportConfig.CUPPA_Check_WriteLog) { CUPPAPassportConfig.WriteCUPPALog(string.Format("采用三统一平台验证口令返回{0},! name={1}, CUPPA_Check_Type={2}, pass={3}", _ret, _name, CheckType, _pass)); } return(true); } } } catch (Exception e1) { string _error = string.Format("采用三统一平台验证口令出错:{0}\n Name={1} Pass={2}", e1.Message, _name, _pass); OralceLogWriter.WriteSystemLog(_error, "ERROR"); if (CUPPAPassportConfig.CUPPA_Check_WriteLog) { CUPPAPassportConfig.WriteCUPPALog(_error); } return(false); } }
/// <summary> /// 生成报表统计数据 /// </summary> /// <param name="_reportName"></param> /// <param name="_sDate"></param> /// <param name="_eDate"></param> /// <param name="_dwdm"></param> /// <returns></returns> private static bool CreateReportData(string _reportName, DateTime _sDate, DateTime _eDate, string _dwdm) { int _ret = 0; using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(); _cmd.CommandText = "zhtj_zdybb.bb"; _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.Add("strtjdw", _dwdm); _cmd.Parameters.Add("dtbegin_p", _sDate); _cmd.Parameters.Add("dtend_p", _eDate); _cmd.Parameters.Add("strbbmc", _reportName); OracleParameter _p1 = _cmd.Parameters.Add("recret", OracleDbType.Decimal); _p1.Direction = ParameterDirection.Output; _cmd.Connection = cn; _cmd.ExecuteNonQuery(); _ret = int.Parse(_p1.Value.ToString()); cn.Close(); return(_ret == 0); } catch (Exception e) { string _emsg = string.Format("生成统计报表(生成报表统计数据)时发生错误!reportName={0} _dwdm={1} DATE={2} - {3} ", _reportName, _dwdm, _sDate, _eDate); _emsg += string.Format(" \n 错误信息:{0}", e.Message); OralceLogWriter.WriteSystemLog(_emsg, "ERROR"); return(false); } } }
/// <summary> /// 取统计报表特殊行/特殊列结果数据 /// </summary> /// <param name="_reportName"></param> /// <param name="_sDate"></param> /// <param name="_eDate"></param> /// <param name="_dwdm"></param> /// <param name="_cellData"></param> /// <returns></returns> private static bool GetReportSpecialData(string _reportName, DateTime _sDate, DateTime _eDate, string _dwdm, out DataTable _dt) { _dt = new DataTable(); using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "ZHTJ_ZDYBB.GetBB_DYG"; _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.Add("strtjdw", _dwdm); _cmd.Parameters.Add("dtbegin_p", _sDate); _cmd.Parameters.Add("dtend_p", _eDate); _cmd.Parameters.Add("strbbmc", _reportName); _cmd.Parameters.Add("recret", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output); OracleDataAdapter _adapter = new OracleDataAdapter(_cmd); _adapter.Fill(_dt); cn.Close(); return(true); } catch (Exception e) { string _emsg = string.Format("生成统计报表(取报表统计结果特殊行、列数据)时发生错误!reportName={0} _dwdm={1} DATE={2} - {3} ", _reportName, _dwdm, _sDate, _eDate); _emsg += string.Format(" \n 错误信息:{0}", e.Message); OralceLogWriter.WriteSystemLog(_emsg, "ERROR"); return(false); } } }
/// <summary> /// 取报表明细数据 /// </summary> /// <param name="_reportName"></param> /// <param name="_sDate"></param> /// <param name="_eDate"></param> /// <param name="_dwdm"></param> /// <param name="_mxData"></param> /// <returns></returns> private static bool GetReportMXData(string _reportName, DateTime _sDate, DateTime _eDate, string _dwdm, out DataTable _dt) { _dt = new DataTable(); using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "select hx,lx from TJ_ZDYBBJLB_MX where BBMC=:BBMC AND TJDW=:TJDW AND KSRQ=:KSRQ and JZRQ=:JZRQ and MX is not null"; _cmd.CommandType = CommandType.Text; _cmd.Parameters.Add(":BBMC", _reportName); _cmd.Parameters.Add(":TJDW", _dwdm); _cmd.Parameters.Add(":KSRQ", _sDate); _cmd.Parameters.Add(":JZRQ", _eDate); OracleDataAdapter _adapter = new OracleDataAdapter(_cmd); _adapter.Fill(_dt); cn.Close(); return(true); } catch (Exception e) { string _emsg = string.Format("生成统计报表(取报表明细数据)时发生错误!reportName={0} _dwdm={1} DATE={2} - {3} ", _reportName, _dwdm, _sDate, _eDate); _emsg += string.Format(" \n 错误信息:{0}", e.Message); OralceLogWriter.WriteSystemLog(_emsg, "ERROR"); return(false); } } }
public DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM) { DataTable _ret = new DataTable(); _ret.TableName = "RESULT"; string _zbsf = ReportGuideLineDefine.DetialMethod.Trim(); try { using (OracleConnection cn = OracleHelper.OpenConnection()) { _zbsf = _zbsf.Replace("dtBegin", string.Format("to_date('{0}01','YYYYMMDD')", StartDate.ToString("yyyMM"))); _zbsf = _zbsf.Replace("dtEnd", string.Format("to_date('{0}235959','YYYYMMDDhh24miss')", EndDate.ToString("yyyMMdd"))); _zbsf = _zbsf.Replace("strTJDW", string.Format("'{0}'", DWDM)); _ret = OracleHelper.FillDataTable(cn, CommandType.Text, _zbsf); cn.Close(); } return(_ret); } catch (Exception e) { string _errmsg = string.Format("执行报表指标{2}[{3}]的详细记录查询出错,错误信息为:{0}!\n查询语句为:{1}\n", e.Message, _zbsf, ReportGuideLineDefine.DisplayName, ReportGuideLineDefine.ID); OralceLogWriter.WriteSystemLog(_errmsg, "ERROR"); return(_ret); } }
public void WriteExportLog(int _exportRowCount, string ExportDataMsg) { using (OracleConnection cn = OracleHelper.OpenConnection()) { try { string _ipaddr = WCFClientInfo.IPAddr; string _hostName = _ipaddr; if (ExportDataMsg == null || ExportDataMsg.Trim() == "") { OralceLogWriter.WriteUserLog(decimal.Parse(SinoUserCtx.CurUser.UserID), "导出数据", string.Format("导了数据成功! 导出记录数:{0}", _exportRowCount), 1, _ipaddr, _hostName, ConfigFile.SystemID); } else { OralceLogWriter.WriteUserLog(decimal.Parse(SinoUserCtx.CurUser.UserID), "导出数据", string.Format("导了数据成功! 导出记录数:{0} 导出数据说明:{1}", _exportRowCount, ExportDataMsg), 1, _ipaddr, _hostName, ConfigFile.SystemID); } } catch (Exception ex) { OralceLogWriter.WriteSystemLog(string.Format("写入导出日志失败!导出内容:{0} 导出行数:{1} 错误信息:{2}", ExportDataMsg, _exportRowCount, ex.Message), "ERROR"); } } }
/// <summary> /// 取报表定义数据 /// </summary> /// <param name="_reportName"></param> /// <param name="_sDate"></param> /// <param name="_eDate"></param> /// <param name="_dwdm"></param> /// <param name="_hmcData"></param> /// <returns></returns> private static bool GetReportDefine(string _reportName, DateTime _sDate, DateTime _eDate, string _dwdm, out DataSet _ds) { _ds = new DataSet(); try { using (OracleConnection cn = OracleHelper.OpenConnection()) { //取表定义 DataTable _dt = new DataTable("REPORT_DEFINE"); OracleCommand _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "select * from TJ_ZDYBBMCB a where a.BBMC =:BBMC"; _cmd.CommandType = CommandType.Text; _cmd.Parameters.Add(":BBMC", _reportName); OracleDataAdapter _adapter = new OracleDataAdapter(_cmd); _adapter.Fill(_dt); _ds.Tables.Add(_dt); //取列定义 DataTable _coldt = new DataTable("COL_DEFINE"); _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "select * from TJ_ZDYBBDYB_DTLJL a where a.bbmc =:BBMC and TJDW = :TJDW and KSRQ = :KSRQ and JZRQ = :JZRQ order by LX"; _cmd.CommandType = CommandType.Text; _cmd.Parameters.Add(":BBMC", _reportName); _cmd.Parameters.Add(":TJDW", _dwdm); _cmd.Parameters.Add(":KSRQ", _sDate); _cmd.Parameters.Add(":JZRQ", _eDate); _adapter = new OracleDataAdapter(_cmd); _adapter.Fill(_coldt); _ds.Tables.Add(_coldt); //取行定义 DataTable _rowdt = new DataTable("ROW_DEFINE"); _cmd = new OracleCommand(); _cmd.Connection = cn; _cmd.CommandText = "select * from TJ_ZDYBBDYB_DTHJL a where a.bbmc =:BBMC and TJDW = :TJDW and KSRQ = :KSRQ and JZRQ = :JZRQ order by HX"; _cmd.CommandType = CommandType.Text; _cmd.Parameters.Add(":BBMC", _reportName); _cmd.Parameters.Add(":TJDW", _dwdm); _cmd.Parameters.Add(":KSRQ", _sDate); _cmd.Parameters.Add(":JZRQ", _eDate); _adapter = new OracleDataAdapter(_cmd); _adapter.Fill(_rowdt); _ds.Tables.Add(_rowdt); cn.Close(); } return(true); } catch (Exception e) { string _emsg = string.Format("生成统计报表(取报表定义数据)时发生错误!reportName={0} _dwdm={1} DATE={2} - {3} ", _reportName, _dwdm, _sDate, _eDate); _emsg += string.Format(" \n 错误信息:{0}", e.Message); OralceLogWriter.WriteSystemLog(_emsg, "ERROR"); return(false); } }
private byte[] GetRsReport_OLD(MD_ReportItem _reportItem, string Format) { ReportingService rs = new ReportingService(); rs.Credentials = new System.Net.NetworkCredential(RsConfig.Name, RsConfig.Pass); //rs.Credentials = new System.Net.NetworkCredential(Config.Rs_UserName, Config.Rs_UserPass); // Assign the URL of the Web service rs.Url = RsConfig.RsURL; string ReportPath = "/海关总署缉私局/" + _reportItem.ReportName.ReportName; // Prepare Render arguments string historyID = null; string deviceInfo = null; ParameterValue[] param = new ParameterValue[3]; param[0] = new ParameterValue(); param[0].Name = "Report_Parameter_Year"; param[0].Value = _reportItem.StartDate.Year.ToString(); param[1] = new ParameterValue(); param[1].Name = "Report_Parameter_month"; param[1].Value = _reportItem.StartDate.Month.ToString("D2"); param[2] = new ParameterValue(); param[2].Name = "Report_Parameter_Dw"; param[2].Value = _reportItem.ReportDWID; string showHide = null; DataSourceCredentials[] credentials = null; Byte[] results; string encoding; string mimeType; Warning[] warnings = null; ParameterValue[] reportHistoryParameters = null; string[] streamIDs = null; //Exectute the report and save it into a file. try { results = rs.Render(ReportPath, Format, historyID, deviceInfo, param, credentials, showHide, out encoding, out mimeType, out reportHistoryParameters, out warnings, out streamIDs); return(results); } catch (Exception e) { Exception e1 = e; string _eStr = string.Format(" 系统在生成报表时发出错误!\n Report Name:{0} \n Report Date:{1} \n Report Dw:{2} \n Report Error:{3}", _reportItem.ReportName, _reportItem.StartDate.Year.ToString() + _reportItem.StartDate.Month.ToString("D2"), string.Format("{0}[{1}]", _reportItem.ReportDWID, _reportItem.ReportDWName), e.Message); // Write an informational entry to the event log. OralceLogWriter.WriteSystemLog(_eStr, "ERROR"); return(null); } }
public static bool WriteErrorResultSetRunFlag(string _Rwid, DateTime _startTime, DateTime _nextTime, string ErrorMsg, int flag) { //清除执行状态,并写入执行错误结果,设置下次执行时间 OracleCommand cmd; string _newmsg = (ErrorMsg.Length > 2000) ? ErrorMsg.Substring(0, 2000) : ErrorMsg; using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); try { cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Update GZRW SET NEXTTIME=:NEXTTIME,LASTTIME =:LASTTIME,RUNFLAG=9,RWZT=:FLAG,RUNRESULT=:MSG where RWID=:RWID"; cmd.Parameters.Add(new OracleParameter(":NEXTTIME", _nextTime)); cmd.Parameters.Add(new OracleParameter(":LASTTIME", _startTime)); cmd.Parameters.Add(new OracleParameter(":FLAG", Convert.ToDecimal(flag))); cmd.Parameters.Add(new OracleParameter(":MSG", "任务执行失败!")); cmd.Parameters.Add(new OracleParameter(":RWID", decimal.Parse(_Rwid))); cmd.ExecuteScalar(); } catch (Exception e) { string _log = string.Format("写入任务{1}结果时出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); _txn.Rollback(); return(false); } try { cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into gzrw_rz (rzid,rwid,rwmc,runtime,runflag,runresult) values (SEQ_YW.NEXTVAL,:RWID,'',sysdate,9,:RUNRESULT)"; cmd.Parameters.Add(new OracleParameter(":RWID", decimal.Parse(_Rwid))); cmd.Parameters.Add(new OracleParameter(":RUNRESULT", _newmsg)); cmd.ExecuteScalar(); } catch (Exception e) { string _log = string.Format("写入任务{1}日志表时出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); _txn.Rollback(); return(false); } _txn.Commit(); cn.Close(); } return(true); }
/// <summary> /// 将所有任务状态置为空闲 /// </summary> public static void InitAllTaskState() { string _rwql = string.Format("update GZRW set RWZT = 0 where RWZT =1"); try { OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringProfile, CommandType.Text, _rwql); } catch (Exception ex) { string _log = string.Format("清除未执行完毕任务时出错:{0}", ex.Message); OralceLogWriter.WriteSystemLog(_log, "ERROR"); } }
public static bool WriteResultSetRunFlag(string _Rwid, DateTime _startTime, DateTime _nextTime, int flag) { //清除执行状态,并写入执行结果,设置下次执行时间 OracleCommand cmd; using (OracleConnection cn = OracleHelper.OpenConnection()) { try { cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Update GZRW SET NEXTTIME=:NEXTTIME,LASTTIME =:LASTTIME,RUNFLAG=0,RWZT=:RWZT,RUNRESULT=:MSG where RWID=:RWID"; cmd.Parameters.Add(new OracleParameter(":NEXTTIME", _nextTime)); cmd.Parameters.Add(new OracleParameter(":LASTTIME", _startTime)); cmd.Parameters.Add(new OracleParameter(":RWZT", Convert.ToDecimal(flag))); cmd.Parameters.Add(new OracleParameter(":MSG", "任务正常执行完毕!")); cmd.Parameters.Add(new OracleParameter(":RWID", decimal.Parse(_Rwid))); cmd.ExecuteScalar(); } catch (Exception e) { string _log = string.Format("写入任务{1}结果时出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); return(false); } try { cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into gzrw_rz (rzid,rwid,rwmc,runtime,runflag,runresult) values (SEQ_YW.NEXTVAL,:RWID,'',sysdate,0,:RUNRESULT)"; cmd.Parameters.Add(new OracleParameter(":RWID", decimal.Parse(_Rwid))); cmd.Parameters.Add(new OracleParameter(":RUNRESULT", "任务正常执行完毕!")); cmd.ExecuteScalar(); } catch (Exception e) { string _log = string.Format("写入任务{1}日志表时出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); return(false); } cn.Close(); } return(true); }
public void WriteClientUserLog(string Message, string LogType) { using (OracleConnection cn = OracleHelper.OpenConnection()) { try { string _ipaddr = WCFClientInfo.IPAddr; OralceLogWriter.WriteUserLog(decimal.Parse(SinoUserCtx.CurUser.UserID), "客户端日志", Message, 1, _ipaddr, _ipaddr, ConfigFile.SystemID); } catch (Exception ex) { OralceLogWriter.WriteSystemLog(string.Format("写入客户端日志失败!日志内容:{0} 类型:{1} 错误信息:{2}", Message, LogType, ex.Message), "ERROR"); } } }
public bool WriteLog(string _log, System.Diagnostics.EventLogEntryType _logType) { string _typeStr = "INFO"; switch (_logType) { case System.Diagnostics.EventLogEntryType.Error: _typeStr = "ERROR"; break; default: _typeStr = "INFO"; break; } OralceLogWriter.WriteSystemLog(_log, _typeStr); return(true); }
/// <summary> /// 写任务开始状态 /// </summary> /// <param name="_Rwid"></param> /// <returns></returns> public static bool WriteRWState(string _Rwid) { string _cmd = "Update GZRW SET RWZT = 1 where RWID=:RWID"; OracleParameter[] _param = { new OracleParameter(":RWID", OracleDbType.Decimal) }; _param[0].Value = decimal.Parse(_Rwid); try { OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringProfile, CommandType.Text, _cmd, _param); } catch (Exception e) { string _log = string.Format("设置任务{1}状态为正在执行时,出现错误:{0}", e.Message, _Rwid); OralceLogWriter.WriteSystemLog(_log, "ERROR"); return(false); } return(true); }
/// <summary> /// 通过用户名称和口令取用户ID /// </summary> /// <param name="_name">用户名称</param> /// <param name="_pass">用户口令</param> /// <returns></returns> public static string GetYHIDByName(string _name, string _pass) { string _select = string.Format("SELECT a.YHID FROM qx2_yhxx a where a.yhm = '{0}' or a.hggh ='{1}'", _name, ((_name.Length < 7) ? _name.PadRight(7, '0') : _name)); DataTable _dt = OracleHelper.Get_Data(_select, "TABLE"); if (_dt == null || _dt.Rows.Count == 0) { OralceLogWriter.WriteSystemLog(string.Format("取未注册用户[{0}]的YHID信息", _name), "INFO"); return("-1"); } if (_dt.Rows.Count != 1) { throw new Exception(string.Format("系统中存在{1}个相同的用户名:{0},请与管理员联系!", _name, _dt.Rows.Count)); } return(_dt.Rows[0]["YHID"].ToString()); }
private static string GetUserGuidByJS(string _name) { using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(SQL_GetUserGuidByJS, cn); _cmd.Parameters.Add(":YHM", _name); string ret = _cmd.ExecuteScalar().ToString(); return(ret); } catch (Exception ex) { OralceLogWriter.WriteSystemLog(string.Format("通过登录名称从数据库中取用户GUID失败!{0} {1}", ex.Message, _name), "ERROR"); throw ex; } } }
public bool SaveOrgExtList(List <OrgExtInfo> BeSavedDataList, List <OrgExtFieldDefine> PropertieDefines) { StringBuilder _sb = new StringBuilder(); _sb.Append(" update QX2_JGFJXX set JGXSMC=:JGXSMC,ISDISPLAY=:ISDISPLAY,DISPLAYORDER=:DISPLAYORDER"); foreach (OrgExtFieldDefine _field in PropertieDefines) { _sb.Append(string.Format(",{0}=:{0}", _field.FieldName)); } _sb.Append(" where ZZJGID=:ZZJGID "); using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleTransaction _txn = cn.BeginTransaction(); foreach (OrgExtInfo _item in BeSavedDataList) { try { List <OracleParameter> _plist = new List <OracleParameter>(); _plist.Add(new OracleParameter(":JGXSMC", _item.GetValue("JGXSMC"))); _plist.Add(new OracleParameter(":ISDISPLAY", _item.GetValue("ISDISPLAY"))); _plist.Add(new OracleParameter(":DISPLAYORDER", _item.GetValue("DISPLAYORDER"))); foreach (OrgExtFieldDefine _field in PropertieDefines) { _plist.Add(new OracleParameter(string.Format(":{0}", _field.FieldName), _item.GetValue(_field.FieldName))); } _plist.Add(new OracleParameter(":ZZJGID", Convert.ToDecimal(_item.GetValue("ZZJGID")))); OracleParameter[] _ps = _plist.ToArray(); OracleHelper.ExecuteNonQuery(cn, CommandType.Text, _sb.ToString(), _ps); } catch (Exception e) { string _errmsg = string.Format("写入{1}的组织机构扩展信息时出错,错误信息为:{0}!", e.Message, _item.GetValue("ZZJGID")); OralceLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(false); } } _txn.Commit(); cn.Close(); } return(true); }
/// <summary> /// 取所有的达到执行时间的任务列表 /// </summary> /// <returns></returns> public static DataTable GetTaskList() { DataTable detailData = null; StringBuilder _sb = new StringBuilder(); _sb.Append("select RWID,RZLB,RWML from GZRW where RWZT = 0 and NEXTTIME<sysdate"); try { detailData = OracleHelper.FillDataTable(OracleHelper.ConnectionStringProfile, CommandType.Text, _sb.ToString()); detailData.TableName = "TASKLIST"; return(detailData); } catch (Exception ex) { string _log = string.Format("取所有的达到执行时间的任务列表出错:{0}", ex.Message); OralceLogWriter.WriteSystemLog(_log, "ERROR"); return(null); } }
/// <summary> /// 任务管理器 /// </summary> /// <param name="application"></param> /// <param name="_rwid">任务ID</param> /// <param name="_lb">任务类别</param> /// <param name="_ml">任务命令</param> public static void RunTask(string _rwid, string _lb, string _ml) { string _pluginName = _lb.Trim(); ITaskPlugin _plugin = TaskLib.GetService(_pluginName); if (_plugin == null) { throw new Exception(string.Format("任务{0}接口未注册!", _pluginName)); } try { Task_Base _task = _plugin.GetTaskObject(_rwid, _ml) as Task_Base; Thread t = new Thread(new ThreadStart(_task.ThreadProc)); t.Start(); } catch (Exception ex) { OralceLogWriter.WriteSystemLog(ex.Message, "ERROR"); } }
private void CloseReportTemplate() { int _ret = -1; try { if (m_oBook != null) { m_oBook.Close(true, m_sReportTemplate, m_oMissing); } if (m_oExcelApp != null) { OralceLogWriter.WriteSystemLog(string.Format("执行关闭m_oExcelApp!ret = {0}", _ret), "INFO"); } m_oExcelApp = null; m_oBooks = null; m_oBook = null; oSheets = null; m_oSheet = null; oCells = null; OralceLogWriter.WriteSystemLog("完成关闭EXCEL进程!", "INFO"); GC.Collect(); isBusy = false; // GC.WaitForPendingFinalizers(); // GC.Collect(); // GC.WaitForPendingFinalizers(); } catch (Exception e) { OralceLogWriter.WriteSystemLog(string.Format("关闭EXCEL进程时出错!{0}", e.Message), "ERROR"); } finally { GC.Collect(); // GC.WaitForPendingFinalizers(); // GC.Collect(); // GC.WaitForPendingFinalizers(); } }
public List <MD_ReportGuideLineItem> GetReportGuideLines(MD_ReportName _reportName) { List <MD_ReportGuideLineItem> _ret = new List <MD_ReportGuideLineItem>(); using (OracleConnection cn = OracleHelper.OpenConnection()) { try { OracleCommand _cmd = new OracleCommand(SQL_GetReportGuideLines, cn); _cmd.Parameters.Add(":ZTMC", _reportName.ReportName); OracleDataReader _dr = _cmd.ExecuteReader(); while (_dr.Read()) { MD_ReportGuideLineItem _item = new MD_ReportGuideLineItem( "1", "", _dr.IsDBNull(2) ? "" : _dr.GetString(2), _dr.IsDBNull(0) ? "" : _dr.GetString(0), Enum_ReportGuideLineItemType.Report ); _item.Children = GetChildGuideLine(_item, cn); _ret.Add(_item); } _dr.Close(); cn.Close(); } catch (Exception ex) { string _err = string.Format("取报表指标项时出错,错误信息:{0} SQL语句:{1}", ex.Message, SQL_GetReportGuideLines); OralceLogWriter.WriteSystemLog(_err, "ERROR"); throw ex; } } return(_ret); }