110,534
社区成员
发帖
与我相关
我的任务
分享
public static int WriteOneLineToOracle(string MycommandStr,int IndexNum)// 写一行数据到数据库 sunjie
{
int EffectLineNum = 0;
OracleConnection conn = null;
OracleTransaction objTran = null;
OracleCommand cmd = new OracleCommand();
try
{
string GB_ConnectionStr = OracleHelper.OracleConnString( common.MyServerInfo[0].ServerIp,
common.MyServerInfo[0].ServerPort,
common.MyServerInfo[0].ConnName,
common.MyServerInfo[0].DBServerID,
common.MyServerInfo[0].DBServerPWD);
conn = new OracleConnection(GB_ConnectionStr);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
objTran = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.CommandText = "INSERT into tbd_score ( TEST_ID,TEST_LEVEL ) values ( '201712280041','Level-2');";
cmd.Transaction = objTran;
EffectLineNum = cmd.ExecuteNonQuery();
objTran.Commit();
cmd.Parameters.Clear();
}
catch (Exception ex)
{
objTran.Rollback();
MessageBox.Show(ex.ToString());
}
finally
{
objTran.Dispose();
objTran = null;
cmd.Dispose();
cmd = null;
conn.Close();
conn.Dispose();
conn = null;
}
return EffectLineNum;
}
public static int WriteOneLineToTB_Score(int WriteLineNum)
{
string sqlStr = string.Empty;
int EffectLineNum = 0;
OracleConnection conn = null;
OracleTransaction objTran = null;
OracleCommand cmd = new OracleCommand();
try
{
string GB_ConnectionStr = OracleHelper.OracleConnString(common.MyServerInfo[0].ServerIp,
common.MyServerInfo[0].ServerPort,
common.MyServerInfo[0].ConnName,
common.MyServerInfo[0].DBServerID,
common.MyServerInfo[0].DBServerPWD);
conn = new OracleConnection(GB_ConnectionStr);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
objTran = conn.BeginTransaction();
cmd = conn.CreateCommand();
cmd.Transaction = objTran;
cmd.CommandText = @"INSERT into tbd_bi_exam_score(FCT_CODE,PLANT_CODE,TEST_ID) values(:FCT_CODE,:PLANT_CODE,:TEST_ID);";
OracleParameter[] commandParameters = new OracleParameter[] {
new OracleParameter(":FCT_CODE", OracleType.NVarChar,30),
new OracleParameter(":PLANT_CODE", OracleType.NVarChar,20),
new OracleParameter(":TEST_ID", OracleType.NVarChar,50),
};
commandParameters[0].Value = "C660A";
commandParameters[1].Value = "P631";
commandParameters[2].Value = TestScore.TeacherSetNowScore[WriteLineNum].Test_id;
cmd.Parameters.AddRange(commandParameters);
cmd.ExecuteNonQuery();//==================异常在这句执行后出现
cmd.Parameters.Clear();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
objTran.Rollback();
}
finally
{
objTran.Dispose();
objTran = null;
cmd.Dispose();
cmd = null;
conn.Close();
conn.Dispose();
conn = null;
}
return EffectLineNum;
}
public static System.Data.DataTable GetUserFromOracle_TB_SCORE(string emp_id)// 从数据库中获取用户信息数据
{
DataSet myDataSet = new DataSet();
System.Data.DataTable MyDatatable = new System.Data.DataTable();
OracleCommand cmd = null;
OracleConnection connection = null;//select distinct JDUTY_CODE from tbm_bi_worker
string sqlStr = @"select " + "FCT_CODE,PLANT_CODE,TEST_ID,TEST_LEVEL,EM_NUM,SUM_SCORE,TEST_TIME" + " from " + " tbd_bi_exam_score " + " where EM_NUM = :EM_NUM";
try
{
OracleParameter[] param = new OracleParameter[]{
new OracleParameter(":EM_NUM",OracleType.NVarChar,50),
};
param[0].Value = emp_id;
connection = new OracleConnection(OracleHelper.OracleConnString( common.MyServerInfo[0].ServerIp,
common.MyServerInfo[0].ServerPort,
common.MyServerInfo[0].ConnName,
common.MyServerInfo[0].DBServerID,
common.MyServerInfo[0].DBServerPWD));
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
cmd = new OracleCommand(sqlStr, connection);
cmd.Parameters.AddRange(param);
OracleDataAdapter myDataAdapter = new OracleDataAdapter(cmd);
myDataAdapter.Fill(myDataSet);
connection.Close();
//if (myDataSet.Tables[0].Rows.Count == 1)
{
MyDatatable = myDataSet.Tables[0];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cmd.Dispose();
cmd = null;
connection.Close();
connection.Dispose();
connection = null;
}
return MyDatatable;
}