private void miUnlock_Click(object sender, EventArgs e)
{
int RowCount = 0;
if (neuSpread1_Sheet1.Rows.Count > 0)
{
RowCount = neuSpread1_Sheet1.Rows.Count;
int ActiveRow = neuSpread1_Sheet1.ActiveRowIndex;
string sid = neuSpread1_Sheet1.Cells[ActiveRow, 2].Text;
string session = neuSpread1_Sheet1.Cells[ActiveRow, 3].Text;
Neusoft.HISFC.BizLogic.Manager.AllObjects obj = new Neusoft.HISFC.BizLogic.Manager.AllObjects();
//执行
if (obj.AlterSessionState(sid, session) == -1)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("解锁失败"));
}
//执行成功 刷新
this.QueryLockSession();
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("解锁成功"));
}
}
/// <summary>
/// 刷新界面
/// </summary>
private void RefreshfpSpread()
{
Neusoft.HISFC.BizLogic.Manager.AllObjects obj = new Neusoft.HISFC.BizLogic.Manager.AllObjects();
ds = obj.GetAllObject(this.owner);
if (this.ds != null && this.ds.Tables.Count > 0)
{
this.dv = new System.Data.DataView(this.ds.Tables[0]);
neuSpread1_Sheet1.DataSource = this.dv;
}
SetfpSpread1();
}
/// <summary>
/// 编译失效的程序
/// </summary>
private void AlterSql()
{
int RowCount = 0;
if (neuSpread1_Sheet1.Rows.Count > 0)
{
RowCount = neuSpread1_Sheet1.Rows.Count;
int ActiveRow = neuSpread1_Sheet1.ActiveRowIndex;
//拥有者
string Own = neuSpread1_Sheet1.Cells[ActiveRow, 0].Text;
//程序名称
string ObjectName = neuSpread1_Sheet1.Cells[ActiveRow, 1].Text;
//程序类型
string ObjectType = neuSpread1_Sheet1.Cells[ActiveRow, 2].Text;
ObjectType = GetName(ObjectType);
//组合要传递的参数
string ParameterString = ObjectType + " " + Own + "." + ObjectName;
Neusoft.HISFC.BizLogic.Manager.AllObjects obj = new Neusoft.HISFC.BizLogic.Manager.AllObjects();
//执行
obj.AlterSql(ParameterString);
//执行成功 刷新
RefreshfpSpread();
if (RowCount == neuSpread1_Sheet1.Rows.Count)
{
//执行失败
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("编译失败"));
}
else
{
//执行成功
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("编译成功"));
}
}
}
public int Init()
{
try
{
Neusoft.HISFC.BizLogic.Manager.AllObjects obj = new Neusoft.HISFC.BizLogic.Manager.AllObjects();
this.ds = obj.GetAllObject(this.owner);
if (ds != null && ds.Tables.Count > 0)
{
this.dv = new System.Data.DataView(ds.Tables[0]);
neuSpread1_Sheet1.DataSource = dv;
}
else
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg(obj.Err));
}
SetfpSpread1();
}
catch (Exception ee)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg(ee.Message));
}
return(1);
}
public ucKillSession()
{
this.manager = new Neusoft.HISFC.BizLogic.Manager.AllObjects();
InitializeComponent();
}
