// Helper method: This method establishes a connection to a database
private IBM.Data.DB2.DB2Connection ConnectDb()
{
String server = txtHostName.Text.Trim();
String alias = txtDatabaseName.Text.Trim();
String userId = txtUserId.Text.Trim();
String password = txtPwd.Text.Trim();
String portNumber = txtPortNumber.Text.Trim();
String connectString;
try
{
connectString = "Server=" + server + ":" + portNumber + ";Database=" + alias;
if (userId != "")
{
connectString += ";UID=" + userId + ";PWD=" + password;
}
IBM.Data.DB2.DB2Connection conn = new IBM.Data.DB2.DB2Connection(connectString);
conn.Open();
return(conn);
}
catch (Exception)
{
throw;
}
}
static System.Data.IDbConnection GetNewTempConnection()
{
string connectString = Neusoft.FrameWork.Management.Connection.DataSouceString;
if (connectString.ToLower().Trim().IndexOf("pooling=true") > 0)
{
connectString = connectString.Replace("True", "False");
connectString = connectString.Replace("true", "False");
}
System.Data.IDbConnection conn = null;
switch (Neusoft.FrameWork.Management.Connection.DBType)
{
case Neusoft.FrameWork.Management.Connection.EnumDBType.ORACLE:
conn = new System.Data.OracleClient.OracleConnection(connectString);
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.DB2:
conn = new IBM.Data.DB2.DB2Connection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.SQLSERVER:
conn = new System.Data.SqlClient.SqlConnection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
default:
conn = new System.Data.OleDb.OleDbConnection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
}
return(conn);
}
/// <summary>
/// 设置连接
/// </summary>
/// <param name="strConnectString">连接的字符串</param>
/// <returns>0 success -1 fail</returns>
public int Connect(string strConnectString)
{
try
{
//显示进度
this.ProgressBarValue = 50;
this.ProgressBarText = "正在连接数据库...";
con = new IBM.Data.DB2.DB2Connection(strConnectString);
con.Open();
Neusoft.FrameWork.Management.Connection.Instance = con as IBM.Data.DB2.DB2Connection;//传给全局连接
WriteDebug("连接数据库！" + strConnectString);
this.ProgressBarValue = 0;
return(0);
}
catch (Exception ex)
{
this.ProgressBarValue = 0;
this.Err = "连接数据库产生错误！" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = "-1";
this.WriteErr();
return(-1);
}
}
/// <summary>
/// 执行非查询语句
/// </summary>
/// <param name="strSql">执行sql语句</param>
/// <returns>执行sql语句影响的行数 0执行到零行,-1没有执行有错误，对于update,insert,del外都为-1。>0成功的行数</returns>
public int ExecNoQuery(string strSql)
{
//this.command=new OracleCommand();
a:
CloseRead();
if (Neusoft.FrameWork.Management.PublicTrans.Trans != null)
{
this.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
}
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
this.command.CommandType = CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
int i = 0;
try
{
i = this.command.ExecuteNonQuery();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;//暂时写死,前台用这个做判断,比如先UPDATE如果返1,那么执行INSERT
this.WriteErr();
//if (ex.Number == 3113)
//{
// while (this.Connect(this.con.ConnectionString) == -1)
// {
// }
// goto a;
//}
if (this.con.State != ConnectionState.Open)
{
con.Open();
goto a;
}
return(-1);
}
if (i == 0)
{
this.Err = "没找到相应的行数！";
this.ErrCode = strSql;
this.WriteErr();
}
WriteDebug("执行无返回sql语句！" + strSql);
return(i);
}
public void Open()
{
try
{
_DB2Conn = new IBM.Data.DB2.DB2Connection();
_DB2Conn.ConnectionString = _connectingString;
_DB2Conn.Open();
}
catch (System.Exception ex)
{
_DB2Conn = null;
throw ex;
}
}
/// <summary>
/// 更新数据库的Blob数据类型,需指定sql参数为length=1的参数
/// </summary>
/// <param name="strSql"></param>
/// <param name="ImageData"></param>
/// <returns></returns>
public int InputBlob(string strSql, byte[] ImageData)
{
CloseRead();
if (Neusoft.FrameWork.Management.PublicTrans.Trans != null)
{
this.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
}
// string block="INSERT INTO test_image(id,name, image) VALUES (2,'a', :blobtodb)";
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
command.CommandText = strSql + "";
command.CommandType = System.Data.CommandType.Text;
string strParam = "";
int i = strSql.IndexOf(":", 0);
if (i <= 0)
{
this.Err = "未指定参数！" + strSql;
this.WriteErr();
return(-1);
}
strParam = strSql.Substring(i + 1, 1);
IBM.Data.DB2.DB2Parameter param = command.Parameters.Add(strParam, IBM.Data.DB2.DB2Type.Blob);
param.Direction = System.Data.ParameterDirection.Input;
param.Value = ImageData;
try
{
command.ExecuteNonQuery();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
return(-1);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.WriteErr();
return(-1);
}
return(0);
}
/// <summary>
/// 执行sql，返回DataSet
/// </summary>
/// <param name="strSql"></param>
/// <param name="DataSet"></param>
/// <returns></returns>
public int ExecQuery(string strSql, ref DataSet DataSet)
{
a:
CloseRead();
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
IBM.Data.DB2.DB2DataAdapter adapter = new IBM.Data.DB2.DB2DataAdapter(this.command);
adapter.Fill(DataSet);
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
//[2007/11/28]先不改,下面代码是ORACLE专用的
//if (ex.Number == 3113)
//{
// while (this.Connect(this.con.ConnectionString) == -1)
// {
// }
// goto a;
//}
//end;
if (this.con.State != ConnectionState.Open)
{
this.con.Open();
goto a;
}
return(-1);
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
private void btnDB2Connection_Click(object sender, EventArgs e)
{
string message = string.Empty;
try
{
IBM.Data.DB2.DB2Connection conn = ConnectDb();
message = "DB2 Connection Successful !";
conn.Close();
}
catch (Exception ex)
{
message = ex.Message;
}
MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 输入长字符串
/// 针对>4000长度的字符串
/// </summary>
/// <param name="strSql"></param>
/// <param name="data"></param>
/// <returns></returns>
public int InputLong(string strSql, string data)
{
CloseRead();
if (Neusoft.FrameWork.Management.PublicTrans.Trans != null)
{
this.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
}
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
command.CommandText = strSql + "";
command.CommandType = System.Data.CommandType.Text;
string strParam = "";
int i = strSql.IndexOf(":", 0);
if (i <= 0)
{
this.Err = "未指定参数！" + strSql;
this.WriteErr();
return(-1);
}
strParam = strSql.Substring(i + 1, 1);
IBM.Data.DB2.DB2Parameter param = command.Parameters.Add(strParam, IBM.Data.DB2.DB2Type.LongVarChar);
param.Direction = System.Data.ParameterDirection.Input;
param.Value = data;
try
{
command.ExecuteNonQuery();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
return(-1);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.WriteErr();
return(-1);
}
return(0);
}
private void btnPublishData_Click(object sender, EventArgs e)
{
string sQuery1 = string.Empty;
string sQuery2 = string.Empty;
string sQuery3 = string.Empty;
string message = string.Empty;
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
try
{
conn = ConnectDb();
switch (cmbTransactionType.SelectedIndex)
{
case 0:
sQuery1 = "SELECT * FROM DEPOSIT FETCH FIRST 5 ROWS ONLY";
break;
case 1:
sQuery1 = "SELECT * FROM LOAN FETCH FIRST 5 ROWS ONLY";
break;
}
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(sQuery1, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
if (dt.Rows.Count <= 0)
{
message = "No Record Exist !!!";
}
else
{
SaveData(dt);
message = "Successfully Imported '" + cmbTransactionType.Text + "' Data !!!";
}
}
catch (Exception ex)
{
message = ex.Message;
}
MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void Close()
{
if (_DB2Conn == null)
{
return;
}
try
{
_DB2Conn.Close();
_DB2Conn.Dispose();
_DB2Conn = null;
}
catch (System.Exception ex)
{
_DB2Conn = null;
throw ex;
}
}
/*
* Método que trae todos los datos de la tabla TOOL_SETUP_INFO por toolId
*/
private static DataTable bringResultsForToolId(string toolIdToSearch)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForToolKey =
@"SELECT TS_INFO_KEY, PRODUCT_PN_KEY, TOOL_KEY, ROUTE_STEP_KEY, LAST_CHANGE_TMST, RECIPE_READY, RECIPE_ID, PROGRAM_ID, CARRIER_PN_KEY, DUAL_SIDED, DUAL_LANE, PFC_MODE, LAST_SETUP_TOOL_KEY, LAST_SETUP_TOOL_STAGE
FROM CGSLSC.TOOL_SETUP_INFO
WHERE (TOOL_KEY = " + toolIdToSearch + ") ORDER BY LAST_CHANGE_TMST DESC";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForToolKey, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
/*
* Método que devuelve el nombre del part number ID
*/
private static DataTable bringResultsForProductPN(string _ProductPartNumberId)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForPN =
@" SELECT PART_NUMBER_KEY AS EXPR1, CGS.PART_NUMBER.*
FROM CGS.PART_NUMBER
WHERE (PART_NUMBER_KEY = " + _ProductPartNumberId + ")";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPN, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
/*
* Método que trae las posiciones que dispone cada part number.
*/
private static DataTable bringResultsForPositions(string toolIdToSearch, string _ProductPartNumberId)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForPositions =
@" SELECT CGSLSC.TOOL_SETUP.*, TOOL_KEY AS EXPR1, PRODUCT_PN_KEY AS EXPR2
FROM CGSLSC.TOOL_SETUP
WHERE (TOOL_KEY = " + toolIdToSearch + ") AND (PRODUCT_PN_KEY = " + _ProductPartNumberId + ")";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPositions, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
/// <summary>
/// 加载内存 判断是否debug 非公开
/// </summary>
/// <param name="errLogoFileName">errLogoFileName</param>
private void newDatabase(string errLogoFileName)
{
if (this.con == null)
{
con = new IBM.Data.DB2.DB2Connection();
}
command = new IBM.Data.DB2.DB2Command();
this.command.Connection = con as IBM.Data.DB2.DB2Connection;
Logo = new Neusoft.FrameWork.Models.NeuLog(errLogoFileName);
string debugLogoFileName = "./debugSql.log";
if (System.IO.File.Exists(debugLogoFileName))
{
debugLogo = new Neusoft.FrameWork.Models.NeuLog(debugLogoFileName);
bDebug = true;
}
else
{
bDebug = false;
}
}
/*
* Método que conecta con la base de datos.
*/
private static IBM.Data.DB2.DB2Connection ConnectDb()
{
String userId = "sromero";
String password = "******";
String connectString;
string message = string.Empty;
try
{
connectString = "Database=CGS;Server=ARUS3DB03.nwsn.local:50000;Persist Security Info=True";
string letMeIn = "Database=CGS;Server=ARUS3DB06.nwsn.local:50000;Persist Security Info=True";
if (userId != "")
{
letMeIn += ";UID=" + userId + ";PWD=" + password;
}
IBM.Data.DB2.DB2Connection conn = new IBM.Data.DB2.DB2Connection(letMeIn);
conn.Open();
message = "DB2 Cennexion exitosa !";
return(conn);
}
catch (Exception)
{ throw; }
}
/// <summary>
/// 获得连接
/// </summary>
/// <returns></returns>
static System.Data.IDbConnection GetNewConnection()
{
System.Data.IDbConnection conn = null;
switch (Neusoft.FrameWork.Management.Connection.DBType)
{
case Neusoft.FrameWork.Management.Connection.EnumDBType.ORACLE:
conn = new System.Data.OracleClient.OracleConnection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.DB2:
conn = new IBM.Data.DB2.DB2Connection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
case Neusoft.FrameWork.Management.Connection.EnumDBType.SQLSERVER:
conn = new System.Data.SqlClient.SqlConnection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
default:
conn = new System.Data.OleDb.OleDbConnection(Neusoft.FrameWork.Management.Connection.DataSouceString);
break;
}
return(conn);
}
/// <summary>
/// 执行查询语句,返回Reader
/// </summary>
/// <param name="strSql">执行sql语句</param>
/// <returns>0 success -1 fail</returns>
public int ExecQuery(string strSql, ref IBM.Data.DB2.DB2DataReader Reader)
{
//this.command=new OracleCommand();
a:
CloseRead();
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
//this.command.Connection.Close();
//this.command.Connection.Open();
this.command.CommandType = System.Data.CommandType.Text;
this.command.CommandText = strSql + "";
this.command.Parameters.Clear();
try
{
Reader = this.command.ExecuteReader();
//Reader.FetchSize = this.command.RowSize * 10000;//这行代码先注释掉,可能需要改动[2007/11/28]肿瘤医院
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
//新增[2007/11/29]
//trans.Rollback();
//end;
//下面代码可能是如果断开连接,那么重新连接,下面代码是ORACLE专用的,一会儿再改为DB2的[2007/11/28]
//if (ex.Number == 3113)
//{
// while (this.Connect(this.con.ConnectionString) == -1)
// {
// }
// goto a;
//}
// end;
if (this.con.State != ConnectionState.Open)
{
this.con.Open();
goto a;
}
return(-1);
}
catch (Exception ex)
{
//trans.Rollback();//新增[2007/11/29]
this.Err = "执行产生错误!" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
}
//trans.Commit();//新增[2007/11/29]
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
/// <summary>
/// 执行sql语句 重载
/// </summary>
/// <param name="strSql"></param>
/// <param name="strDataSet">返回DataSet xml</param>
/// <returns></returns>
public int ExecQuery(string strSql, ref string strDataSet)
{
//[2007/12/01]新增
//if (TempReader1 != null)
//{
// if (!TempReader1.IsClosed)
// {
// TempReader1.Close();
// }
//}
// end;
//[2008/03/13]
//if (reader != null)
//{
// if (!reader.IsClosed)
// {
// reader.Close();
// }
//}
//END
CloseRead();
if (Neusoft.FrameWork.Management.PublicTrans.Trans != null)
{
this.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
}
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
TempReader1 = this.command.ExecuteReader();
//TempReader1.FetchSize = this.command.RowSize * 10000;[2007/11/28]
XmlDocument doc = new XmlDocument();
XmlNode root;
XmlNode node, table;
root = doc.CreateElement("DataSet");
doc.AppendChild(root);
while (TempReader1.Read())
{
table = doc.CreateElement("Table");
for (int i = 0; i < TempReader1.FieldCount; i++)
{
node = doc.CreateElement(TempReader1.GetName(i).ToString());
node.InnerText = TempReader1[i].ToString() + "";
table.AppendChild(node);
}
root.AppendChild(table);
}
strDataSet = doc.OuterXml;
TempReader1.Close();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
return(-1);
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
/// <summary>
/// 执行存储过程
/// <example>PRC_HIEBILL_CHARGE_ext,arg_checkopercode,22,1,{0},
/// arg_exec_Sqn,22,1,{1},arg_yearcode,22,1,{2},return_code,30,2,{3},return_result,22,2,{4}</example>
/// </summary>
/// <param name="strSql">存储过程-参数,类型，输入输出,数值<br>22 varchar 30 double 33 int 6 DATETIME </br></param>
/// <param name="Return">存储过程返回值 逗号分割</param>
/// <returns>0 成功 -1 失败</returns>
public int ExecEvent(string strSql, ref string Return)
{
CloseRead();
this.command.CommandType = System.Data.CommandType.StoredProcedure;
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
this.command.Parameters.Clear();
string prcName = "";
string[] prcParams = strSql.Split(',');
try
{
prcName = prcParams[0];
this.command.CommandText = prcName;
//'22 varchar 30 double 33 int 6 DATETIME
for (int i = 1; i < prcParams.GetUpperBound(0); i = i + 4)
{
IBM.Data.DB2.DB2Parameter param = new IBM.Data.DB2.DB2Parameter();
param.ParameterName = prcParams[i].Trim();
switch (int.Parse(prcParams[i + 1]))
{
case 22:
param.DB2Type = IBM.Data.DB2.DB2Type.VarChar;
break;
case 30:
param.DB2Type = IBM.Data.DB2.DB2Type.Double;
break;
case 6:
param.DB2Type = IBM.Data.DB2.DB2Type.Timestamp;
break;
case 33:
param.DB2Type = IBM.Data.DB2.DB2Type.Integer;
break;
case 13:
param.DB2Type = IBM.Data.DB2.DB2Type.BigInt;
break;
case 28:
param.DB2Type = IBM.Data.DB2.DB2Type.BigInt;
break;
default:
param.DB2Type = IBM.Data.DB2.DB2Type.VarChar;
break;
}
param.Direction = (System.Data.ParameterDirection) int.Parse(prcParams[i + 2]);
if (param.Direction == System.Data.ParameterDirection.Input)
{
param.Value = prcParams[i + 3].Trim();
param.Size = 50;
}
else if (param.DB2Type == IBM.Data.DB2.DB2Type.VarChar)
{
param.Size = 50;
}
this.command.Parameters.Add(param);
}
this.command.ExecuteNonQuery();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
return(-1);
}
catch (Exception ex)
{
this.Err = "执行存储过程出错！" + strSql + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.WriteErr();
return(-1);
}
try
{
for (int i = 0; i < this.command.Parameters.Count; i++)
{
if (this.command.Parameters[i].Direction == System.Data.ParameterDirection.Output)
{
Return = Return + "," + this.command.Parameters[i].Value;
}
}
Return = Return.Substring(1);
}
catch (Exception ex)
{
this.Err = "执行存储过程出错！" + strSql + ex.Message;
this.WriteErr();
return(-1);
}
return(0);
}
/// <summary>
/// 执行sql
/// </summary>
/// <param name="strSql"></param>
/// <param name="strDataSet"></param>
/// <returns></returns>
public int ExecQuery(string strSql, ref string strDataSet, string strXSLFileName)
{
//[2007/12/01]新增
CloseRead();
// end;
//[2008/03/13]
//if (reader != null)
//{
// if (!reader.IsClosed)
// {
// reader.Close();
// }
//}
// end;
this.command.Connection = this.con as IBM.Data.DB2.DB2Connection;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
TempReader1 = this.command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode root;
XmlElement node, row;
doc.AppendChild(doc.CreateXmlDeclaration("1.0", "GB2312", ""));
if (strXSLFileName != null && strXSLFileName != "")
{
string PI = "type='text/xsl' href='" + strXSLFileName + "'";
System.Xml.XmlProcessingInstruction xmlProcessingInstruction = doc.CreateProcessingInstruction("xml-stylesheet", PI);
doc.AppendChild(xmlProcessingInstruction);
}
root = doc.CreateElement("Table");
doc.AppendChild(root);
while (TempReader1.Read())
{
row = doc.CreateElement("Row");
for (int i = 0; i < TempReader1.FieldCount; i++)
{
node = doc.CreateElement("Column");
node.SetAttribute("Name", TempReader1.GetName(i).ToString());
node.InnerText = TempReader1[i].ToString() + "";
row.AppendChild(node);
}
root.AppendChild(row);
}
strDataSet = doc.OuterXml;
TempReader1.Close();
}
catch (IBM.Data.DB2.DB2Exception ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = 1;
this.WriteErr();
return(-1);
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
public DB2Command(string commandStr, IBM.Data.DB2.DB2Connection con, IBM.Data.DB2.DB2Transaction trans)
{
}
public DB2Command(string commandStr, IBM.Data.DB2.DB2Connection con)
{
}
public DB2DataAdapter(string selectCommandText, IBM.Data.DB2.DB2Connection selectConnection)
{
}
public static void DB2CheckReturn(short sqlRet, short handleType, System.IntPtr handle, string message, IBM.Data.DB2.DB2Connection connection)
{
}
