public void CreateThread(string threadname, int seconds, string pythonscripts) { if (_threadDictionary.Keys.Contains(threadname)) { throw new Exception("线程[" + threadname + "]已经存在!禁止重复创建。"); } ParameterManager pm = new ParameterManager(); pm.Add("threadname", threadname); pm.Add("pythonscripts", pythonscripts); pm.Add("seconds", seconds); //System.Threading.Thread thread = new Thread(new ParameterizedThreadStart(EnableButton)); //thread.Start(null); System.Threading.Thread thread = new System.Threading.Thread(new System.Threading.ParameterizedThreadStart(ThreadRunning)); thread.IsBackground = true; thread.Name = threadname; thread.Start(pm);//线程开始。。。 // _threadDictionary.Add(threadname, thread); _threadStopFlagDictionary.Add(threadname, true); }
private void ThreadRunning(object pm) { if (!(pm is ParameterManager)) { return; } try { ParameterManager parameterManager = (ParameterManager)pm; int seconds = (int)parameterManager.Get("seconds"); string threadname = parameterManager.Get("threadname").ToString(); if (seconds == -1) { //只执行一次; //执行脚本; this.ExecScript(parameterManager.Get("pythonscripts").ToString()); } else { //获取 while (_threadStopFlagDictionary[threadname]) { //如果数据库网络连接中断;不执行; //if (Common.DBHelper.SqlConn.bConnIsAceess) { //执行脚本; this.ExecScript(parameterManager.Get("pythonscripts").ToString()); } //间隔; System.Threading.Thread.Sleep(seconds * 1000); } } } catch (Exception exp) { //AddLogValue("错误:" + exp.Message); } }
public void SetParameterValue(string key, object value) { if (this._pageParamterManager == null) { this._pageParamterManager = new ParameterManager(); } if (this._pageParamterManager._dic.ContainsKey(key)) { Parameter p = _pageParamterManager._dic[key]; //= value.ToString(); p.value = value; } else { // this._pageParamterManager.Add(key, value); } }
public DataTable SQLGetDataTable(string connstring, string sqltxt, ParameterManager pars) { try { List <SqlParameter> sqlPars = new List <SqlParameter>(); foreach (KeyValuePair <string, Parameter> kv in pars._dic) { sqlPars.Add(new SqlParameter("@" + kv.Value.parname, kv.Value.value.ToString())); } return(EohiDataCenter.Helper.SqlCmdExec.getDataTable( connstring, sqltxt, sqlPars.ToArray())); } catch (SqlException exp) { Common.Util.NocsMessageBox.Message(exp.Message); //throw; } return(null); }
/// <summary> /// 执行语句,返回受影响的行数; /// select 行数不返回; /// </summary> /// <param name="sqltxt"></param> /// <param name="pars"></param> /// <returns></returns> public int SQLExecuteNonQuery(string connstring, string sqltxt, ParameterManager pars) { try { List <SqlParameter> sqlPars = new List <SqlParameter>(); foreach (KeyValuePair <string, Parameter> kv in pars._dic) { sqlPars.Add(new SqlParameter("@" + kv.Value.parname, kv.Value.value.ToString())); } var abc = EohiDataCenter.Helper.SqlCmdExec.ExecuteNonQuery( connstring, sqltxt, sqlPars.ToArray()); return(abc); } catch (SqlException exp) { Common.Util.NocsMessageBox.Message(exp.Message); //throw; } return(-1); }
/// <summary> /// 返回第一行第一列的值,如果无返回值,则返回-1; /// </summary> /// <param name="sqltxt"></param> /// <param name="pars"></param> /// <returns></returns> public object SQLExecuteScalar(string connstring, string sqltxt, ParameterManager pars) { try { List <SqlParameter> sqlPars = new List <SqlParameter>(); foreach (KeyValuePair <string, Parameter> kv in pars._dic) { sqlPars.Add(new SqlParameter("@" + kv.Value.parname, kv.Value.value.ToString())); } object obj = Helper.SqlCmdExec.ExecuteScalar( connstring, sqltxt, sqlPars.ToArray()); return(obj); } catch (SqlException exp) { Common.Util.NocsMessageBox.Message(exp.Message); //throw; } return(null); }
public ParameterManager NewPars() { ParameterManager pm = new ParameterManager(); return(pm); }