private void btn_addapi_on_Click(object sender, EventArgs e) { From_ApiList_Selector frm = new From_ApiList_Selector(); if (frm.ShowDialog() == DialogResult.OK) { //select_apiname string apiname = frm.select_apiname; string strSql = "insert into api_items_on (apiname) values(@apiname)"; //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@apiname", apiname); try { EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.ExecuteNonQuery(strSql, parames); if (result.Code > 0) { MessageBox.Show(result.Msg); } else { //刷新; GetList(); } } 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("linkname").ToString() + "]?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } string strSql = "delete from api_links 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.gridView_report.GetFocusedRowCellValue("id").ToString()); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.ExecuteNonQuery(strSql, parames); if (result.Code > 0) { Common.Util.NocsMessageBox.Message(result.Msg); } GetList(); }
private void btn_Save_Click(object sender, EventArgs e) { if (this.textEdit_linkname.Text.Trim().Length <= 0) { Common.Util.NocsMessageBox.Message("请输入模型名称!"); return; } if (this.id.Length > 0) { string strSql = @"update api_links set linkname=@linkname, linktype=@linktype, linkstring=@linkstring 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("@linkname", this.textEdit_linkname.Text.Trim()); parames.Add("@linktype", this.textEdit_linktype.Text.Trim()); parames.Add("@linkstring", this.memoEdit_linkstring.Text.Trim()); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.ExecuteNonQuery(strSql, parames); if (result.Code > 0) { Common.Util.NocsMessageBox.Message(result.Msg); return; } else { } } else { string strSql = @"insert into api_links (linkname,linktype,linkstring) values (@linkname,@linktype,@linkstring)"; EohiDataRemoteObject.RemotingSQLHelper remotingSQLHelper = (EohiDataRemoteObject.RemotingSQLHelper)Activator.GetObject( typeof(EohiDataRemoteObject.RemotingSQLHelper), RemotingConfig.RetmotingSqlAddress); if (remotingSQLHelper == null) { MessageBox.Show("连接创建失败!"); return; } //构建一个哈希表,把参数依次压入 Hashtable parames = new Hashtable(); parames.Add("@linkname", this.textEdit_linkname.Text.Trim()); parames.Add("@linktype", this.textEdit_linktype.Text.Trim()); parames.Add("@linkstring", this.memoEdit_linkstring.Text.Trim()); EohiDataRemoteObject.RemotingSQLResult result = remotingSQLHelper.ExecuteNonQuery(strSql, parames); if (result.Code > 0) { Common.Util.NocsMessageBox.Message(result.Msg); return; } else { } } this.DialogResult = DialogResult.OK; this.Close(); }