private void button1_Click(object sender, EventArgs e)
{
if (dbHelpFactory != null)
{
for (int i = 0; i < 20; i++)
{
ClearTempDataByProgid();
//ILibDBHelp dbhelp = dbHelpFactory.GetDBHelp();
//object obj = dbhelp.ExecuteScalar("declare @id varchar(10);set @id=1; select AccoutNm,@id from ACCOUT");
}
for (int n = 0; n < 20; n++)
{
ILibDBHelp hel = dbHelpFactory.GetDBHelp("1f4930bb-445d-4b96-b3ac-dcb7d107cbe1");
DataTable t = hel.GetDataTable("select *From Table_1");
}
ILibDBHelp dbhelp2 = dbHelpFactory.GetDBHelp("14f5d469-a774-484e-b467-2f80db09a5d3");
DataTable dt = dbhelp2.GetDataTable("EXEC sp_executesql N'select * from INFO_lanmu where lanmu_ID=@id and lanmu_categorie_ID=@cid',N'@id nchar(3),@cid nchar(3)',@id='001',@cid='001'");
ILibDBHelp dbhelp3 = dbHelpFactory.GetDBHelp("3f2b5957-72dc-4c5a-bfac-35cfcdd5c71f");
DataTable dt2 = dbhelp3.GetDataTable("EXEC sp_executesql N'select * from Course '");
}
if (DALBus != null)
{
//object obj = DALBus.ExecuteDalUpdate("TestFunc");
}
}
/// <summary>
/// 测试连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string ex = string.Empty;
ILibDBHelp help = null;
string connectStr = string.Empty;
switch (this.combDataBaseType.Text.Trim())
{
case "SQL SERVER":
help = new DBHelpFactory().GetDBHelp(LibProviderType.SqlServer);
connectStr = string.Format("server={0};database={1};uid={2};password={3}", this.txtServerAddr.Text, this.txtDataBase.Text, this.txtUserId.Text, this.txtpwd.Text);
break;
case "ORACLE":
help = new DBHelpFactory().GetDBHelp(LibProviderType.Oracle);
ex = string.Empty;
connectStr = string.Format("Provider=OraOLEDB.Oracle.1;User ID={0};Password={1};" +
"Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = {2})(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = {3})))",
this.txtUserId.Text.Trim(), this.txtpwd.Text.Trim(), this.txtServerAddr.Text.Trim(), this.txtDataBase.Text.Trim());
//connectStr = string.Format("User ID={0};Password={1};Data Source={2}",this.txtUserId.Text .Trim (),this.txtpwd .Text .Trim (),this.txtDataBase.Text .Trim ());
break;
}
if (help != null)
{
help.TestConnect(connectStr, out ex);
MessageBox.Show(ex);
}
}
public DataAccess(string guid, LibClientInfo clientInfo)
: this()
{
this._clientInfo = clientInfo;
_dbHelp = _dbFactory.GetDBHelp(guid);
LibEventManager.SubscribeEvent(new LibSqlExceptionEventSource(this, _dbHelp), LibEventType.SqlException);
}
public DataAccess()
{
if (_dbFactory == null)
{
_dbFactory = new DBHelpFactory();
}
_dbHelp = _dbFactory.GetDBHelp();
}
public void Test()
{
ILibDBHelp hel = dbHelpFactory.GetDBHelp("1f4930bb-445d-4b96-b3ac-dcb7d107cbe1");
DataTable t = hel.GetDataTable("select *From Table_1");
}
private string DoGetLogSqlStr(DataRow dr, string tablenm, int action, ILibDBHelp dBHelp)
{
//List<string> sqllist = new List<string>();
StringBuilder sql = new StringBuilder();
try
{
string logid = dr[SysConstManage.Sdp_LogId].ToString();
LibDbParameter[] parameters = new LibDbParameter[4];
parameters[0] = new LibDbParameter {
ParameterNm = "@logid", DbType = DbType.String, Value = logid
};
parameters[1] = new LibDbParameter {
ParameterNm = "@tablenm", DbType = DbType.String, Value = tablenm
};
parameters[2] = new LibDbParameter {
ParameterNm = "@ID", DbType = DbType.Int64, Direction = ParameterDirection.Output, Value = 0
};
parameters[3] = new LibDbParameter {
ParameterNm = "@logtbnm", DbType = DbType.String, Size = 35, Direction = ParameterDirection.Output, Value = string.Empty
};
dBHelp.StoredProcedureReturnValue(action == 1 ? "p_addlogM" : "p_GetlogM", parameters);
ColExtendedProperties colextprop = null;
object fieldvalue = null;
object oldfieldvalue = null;
if (!string.IsNullOrEmpty(parameters[3].Value.ToString()) && (Int64)parameters[2].Value != 0)
{
foreach (DataColumn c in dr.Table.Columns)
{
colextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <ColExtendedProperties>(c.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (!colextprop.IsActive)
{
continue;
}
if (action == 2 && LibSysUtils.Compare(dr[c, DataRowVersion.Original], dr[c, DataRowVersion.Current], false))
{
continue;
}
if (c.DataType == typeof(byte[]))
{
fieldvalue = dr[c] == DBNull.Value?string.Empty : Convert.ToBase64String((byte[])dr[c]);
oldfieldvalue = (action == 1 || dr[c, DataRowVersion.Original] == DBNull.Value)? string.Empty: Convert.ToBase64String((byte[])dr[c, DataRowVersion.Original]);
}
else
{
fieldvalue = dr[c];
oldfieldvalue = action == 1 ? string.Empty : dr[c, DataRowVersion.Original];
}
sql.AppendFormat(" EXEC sp_executesql N'insert into {0}(ID,Action,UserId,IP,DT,FieldNm,FieldValue,OldFieldValue) values(@ID,@Action,@UserId,@IP,@DT,@FieldNm,@FieldValue,@OldFieldValue) '", parameters[3].Value.ToString());
sql.Append(" ,N'@ID bigint,@Action char(1),@UserId nvarchar(30),@IP nvarchar(15),@DT datetime,@FieldNm nvarchar(30),@FieldValue ntext,@OldFieldValue ntext',");
sql.AppendFormat(" @ID={0},@Action='{1}',@UserId='{2}',@IP='{3}',@DT='{4}',@FieldNm='{5}',@FieldValue='{6}',@OldFieldValue='{7}' ",
(Int64)parameters[2].Value, action, this._clientInfo.UserId, this._clientInfo.IP, DateTime.Now, c.ColumnName, fieldvalue, oldfieldvalue);
//sqllist.Add(sql.ToString());
}
}
//dBHelp.ExecuteNonQuery(sql.ToString());
}
catch (Exception ex) {
}
return(sql.ToString());
}
