private IDBServer getDBManager()
{
IDBServer manager = null;
switch (Neusoft.FrameWork.Management.Connection.DBType)
{
case Neusoft.FrameWork.Management.Connection.EnumDBType.ORACLE:
manager = new DBOracle();
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.DB2:
manager = new DB2Access();
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.SQLSERVER:
manager = new DBSqlServer();
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.OTHER:
manager = new DBOle();
break;
default:
manager = new DBOracle();
break;
}
return(manager);
}
public byte[] OutputBlob(string strSql)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
byte[] i = manager.OutputBlob(strSql);
Pooling.CloseDB(this.applicationID);
return(i);
}
public DateTime GetDateTimeFromSysDateTime()
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
DateTime i = manager.GetDateTimeFromSysDateTime();
Pooling.CloseDB(this.applicationID);
return(i);
}
public int ExecEvent(string strSql, ref string Return)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
int i = manager.ExecEvent(strSql, ref Return);
Pooling.CloseDB(this.applicationID);
return(i);
}
public int InputBlob(string strSql, byte[] ImageData)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
int i = manager.InputBlob(strSql, ImageData);
Pooling.CloseDB(this.applicationID);
return(i);
}
public System.Data.DataTable ExecQuery(string strSql)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
System.Data.DataTable i = manager.ExecQuery(strSql);
Pooling.CloseDB(this.applicationID);
return(i);
}
public int ExecNoQuery(string strSql)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
int i = manager.ExecNoQuery(strSql);
Pooling.CloseDB(this.applicationID);
return(i);
}
public int InputLong(string strSql, string data)
{
IDBServer manager = this.getDBManager();
this.setDB(manager as IDBServer);
Pooling.OpenDB(this.applicationID);
int i = manager.InputLong(strSql, data);
Pooling.CloseDB(this.applicationID);
return(i);
}
private void setDB(IDBServer db)
{
this.db = db;
this.db.SetConnection(ConnectionPool.GetConnection(this.applicationID), TransactionPool.GetTransaction(this.applicationID));
}
protected override void OnLoad(EventArgs e)
{
if (!DesignMode)
{
myServer = ServerFactory.GetServer();
ICSharpCode.Core.Properties pro = ICSharpCode.Core.PropertyService.Get("DataGridOption", new ICSharpCode.Core.Properties());
dataGrid = new EditGrid();
dataGrid.Dock = DockStyle.Fill;
dataGrid.OnValidatingEditor += new BaseContainerValidateEditorEventHandler(dataGrid_OnValidatingEditor);
dataGrid.OnCreateColumning += new OnCreateColumnsHadle(dataGrid_OnCreateColumning);
dataGrid.SetCaption(ViewName);
dataGrid.OnCreateContextMenu += new OnCreateContextMenuHadle(dataGrid_OnCreateContextMenu);
this.panel2.Controls.Add(dataGrid);
//dataGrid.ShowEditor();
LoadData();
}
}
