/// <summary> /// 连接检查 /// </summary> /// <returns></returns> private static bool ConnCheck(string RemotingSqlAddress) { try { string strSql = @"select getdate()"; Hashtable parames = new Hashtable(); EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingSqlAddress); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { return(false); } else { return(true); } } catch (Exception exp) { MessageBox.Show(exp.Message); return(false); } }
private void ReadInfo() { try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } string strSql = @"select * from api_links where id=@id"; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@id", this.id.ToString()); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { //this.gridControl_report.DataSource = result.DataTable; DataTable dt = result.DataTable; if (dt != null && dt.Rows.Count > 0) { this.textEdit_id.Text = dt.Rows[0]["id"].ToString(); this.textEdit_linktype.Text = dt.Rows[0]["linktype"].ToString(); this.textEdit_linkname.Text = dt.Rows[0]["linkname"].ToString(); this.memoEdit_linkstring.Text = dt.Rows[0]["linkstring"].ToString(); } else { Common.Util.NocsMessageBox.Message("信息获取失败!"); } } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void toolStripButton_Delete_Click(object sender, EventArgs e) { if (this.gridView_report.FocusedRowHandle < 0) { MessageBox.Show("请选择需要删除的数据!"); return; } if (MessageBox.Show("是否删除当前选择的数据[" + this.gridView_report.GetFocusedRowCellValue("apiname").ToString() + "]?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } try { string strSql = "delete from api_iems where id=@id"; Hashtable parames = new Hashtable(); parames.Add("@id", this.gridView_report.GetFocusedRowCellValue("id").ToString()); EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { Common.Util.NocsMessageBox.Message("删除成功!"); this.gridView_report.DeleteRow(this.gridView_report.FocusedRowHandle); } } catch (Exception exp) { Common.Util.NocsMessageBox.Message(exp.Message); } }
private void GetList() { string strSql = @"select api_items_on.*, api_items.apipars, api_items.apinote, api_items.apiscript from api_items_on left join api_items on (api_items.apiname =api_items_on.apiname) order by api_items_on.apiname asc"; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { // this.apiItemList.Clear(); // for (int i = 0; i < result.DataTable.Rows.Count; i++) { ApiItem apiItem = new ApiItem(); apiItem.apiname = result.DataTable.Rows[i]["apiname"].ToString(); apiItem.apiscript = result.DataTable.Rows[i]["apiscript"].ToString(); this.apiItemList.Add(apiItem); } } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void GetList() { //string strSql = @"select * from api_links where (linkname like '%'+@keyword+'%') order by id asc"; //SqlParameter[] pars = new SqlParameter[] //{ // new SqlParameter("@keyword","%"+this.textEdit_keyword.Text+"%") //}; //DataTable dt = Common.DBHelper.SqlCmd.getDataTable(strSql, pars); //this.gridControl_report.DataSource = dt; try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } string strSql = @"select * from api_links where (linkname like '%'+@keyword+'%') order by id asc"; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@keyword", this.textEdit_keyword.Text); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { this.gridControl_report.DataSource = result.DataTable; } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
public string GetDataLinkString(string linkname) { try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { return(""); } string strSql = @"select top 1 * from api_links where linkname =@linkname "; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@linkname", linkname); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { return(""); } else { DataTable dt = result.DataTable; if (dt != null && dt.Rows.Count > 0) { return(dt.Rows[0]["linkstring"].ToString()); } else { return(""); } } } catch (Exception exp) { return(""); } return(""); }
private void GetList() { string strSql = @"select * from api_websocket"; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { for (int i = 0; i < result.DataTable.Rows.Count; i++) { pythonScriptTxt = result.DataTable.Rows[i]["scripttxt"].ToString(); pythonLoopScriptTxt = result.DataTable.Rows[i]["loopscripttxt"].ToString(); } } } catch (Exception exp) { MessageBox.Show(exp.Message); } for (int i = 0; i < sessionList.Count; i++) { sessionList[i].loopScripTxt = this.pythonLoopScriptTxt; } }
private void btn_Save_Click(object sender, EventArgs e) { if (this.id > 0) { string strSql = @"update api_websocket set scripttxt=@scripttxt, loopscripttxt=@loopscripttxt where id=@id"; EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } Hashtable parames = new Hashtable(); parames.Add("@id", this.id); parames.Add("@scripttxt", this.textEditorControl.Text); parames.Add("@loopscripttxt", this.textEditorControl_loop.Text); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { Common.Util.NocsMessageBox.Message("修改成功!"); } } else { string strSql = @"insert into api_websocket (scripttxt,loopscripttxt) values (@scripttxt,@loopscripttxt)"; EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } Hashtable parames = new Hashtable(); parames.Add("@scripttxt", this.textEditorControl.Text); parames.Add("@loopscripttxt", this.textEditorControl_loop.Text); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { Common.Util.NocsMessageBox.Message("添加成功!"); } } }
private void GetList() { string strSql = @"select api_items_on.*, api_items.apipars, api_items.apinote, api_items.apiscript from api_items_on left join api_items on (api_items.apiname =api_items_on.apiname) order by api_items_on.apiname asc"; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@keyword", "%" + this.textEdit_apiexec_port.Text + "%") }; //string strSql = @"select * from u3d_project order by id asc"; //SqlParameter[] pars = new SqlParameter[] //{ // new SqlParameter("@keyword","%"+this.textEdit_keyword.Text+"%") //}; //DataTable dt = Common.DBHelper.SqlCmd.getDataTable(strSql, pars); //this.gridControl_report.DataSource = dt; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@keyword", this.textEdit_apiexec_port.Text); try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.getDataTable(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { this.gridControl_report.DataSource = result.DataTable; // this.apiItemList.Clear(); // for (int i = 0; i < result.DataTable.Rows.Count; i++) { ApiItem apiItem = new ApiItem(); apiItem.apiname = result.DataTable.Rows[i]["apiname"].ToString(); apiItem.apiscript = result.DataTable.Rows[i]["apiscript"].ToString(); this.apiItemList.Add(apiItem); } } } catch (Exception exp) { MessageBox.Show(exp.Message); } }