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