List <Classification> SetOfClassification()
{
OracleConnection conn = new OracleConnection();
List <Classification> temp_lCla = new List <Classification>();
try
{
//conn.ConnectionString = ConfigurationManager.ConnectionStrings["oradb"].ConnectionString;
conn.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=59.110.237.142)(PORT=1521)))(CONNECT_DATA=(sid =lwhy)));User Id=lwhy;Password=123";
conn.Open();
string sql = " select * from CLASSIFICATION";
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataReader dr = cmd.ExecuteReader(); // C#
if (dr.HasRows)
{
while (dr.Read())
{
Classification temp_cla = new Classification();
temp_cla.cId = (int)dr[""];
temp_cla.Cla[0] = dr[""].ToString();
temp_cla.Cla[1] = dr[""].ToString();
temp_cla.Cla[2] = dr[""].ToString();
temp_cla.Cla[3] = dr[""].ToString();
temp_cla.Cla[4] = dr[""].ToString();
temp_lCla.Add(temp_cla);
}
}
else
{
throw new Exception("未能读取到相应的问题");
}
}
catch (Exception ex)
{
}
finally
{
conn.Clone();
}
return(temp_lCla);
}
List <Classification> IDataPumpSearchQueManager.SetOfClassification()
{
OracleConnection conn = new OracleConnection();
List <Classification> ClaSet = new List <Classification>();
try
{
//conn.ConnectionString = ConfigurationManager.ConnectionStrings["oradb"].ConnectionString;
conn.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=59.110.237.142)(PORT=1521)))(CONNECT_DATA=(sid =lwhy)));User Id=lwhy;Password=123";
conn.Open();
string sql = "select * from CLASSFICATION ";// C# !!!!!!!!!!!!!!!!!!!!!!!
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataReader dr = cmd.ExecuteReader(); // C#
if (dr.HasRows)
{
while (dr.Read())
{
Classification temp_Classification = new Classification();
temp_Classification.cId = (int)dr["cid"];
temp_Classification.Cla[0] = dr["topclassfication"].ToString();
temp_Classification.Cla[1] = dr["secondclassfication"].ToString();//这句之后要进行思考。
ClaSet.Add(temp_Classification);
}
}
else
{
throw new Exception("未能读取到相应的问题");
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
finally
{
conn.Clone();
}
return(ClaSet);
}
public Classification(Classification _Cla)
{
iCId = _Cla.cId;
iClassification = _Cla.Cla;
}
bool IDataPumpAddquesManager.AddNewquestion(Question _que, Classification where)//添加一个新题gie!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
{
OracleConnection conn = new OracleConnection();
bool success = false;
try
{
conn.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=59.110.237.142)(PORT=1521)))(CONNECT_DATA=(sid =lwhy)));User Id=lwhy;Password=123";
conn.Open();
Console.Write("Success open \n ");
String sql = "insert into TEMPQUESTION(ttitle,tbody,tanswer,tstatue,ttype)values(:ttitle,:tbody,:tanswer,:tstatue,:ttype)";
OracleCommand cmd = new OracleCommand(sql, conn);
OracleParameter pari = new OracleParameter(":ttitle", _que.title);
OracleParameter parn = new OracleParameter(":tbody", _que.body);
OracleParameter parp = new OracleParameter(":answer", _que.answer);
OracleParameter pars = new OracleParameter(":tstatue", 'n');
OracleParameter party = new OracleParameter(":ttype", _que.type);
cmd.Parameters.Add(pari);
cmd.Parameters.Add(parn);
cmd.Parameters.Add(parp);
cmd.Parameters.Add(pars);
cmd.Parameters.Add(party);
int result = cmd.ExecuteNonQuery();
if (result != 1)
{
throw new Exception("写入tempquesion失败");
}
Console.Write("success for temp" + result);
int temp_tqid = 0;
String gettqid = "select tqid from TEMPQUESTION where tqid in (select max(tqid) as tqid from TEMPQUESTION)";
OracleCommand cmd1 = new OracleCommand(gettqid, conn);
OracleDataReader dr1 = cmd1.ExecuteReader(); // C#
if (dr1.HasRows)
{
while (dr1.Read())
{
temp_tqid = (int)dr1["tqid"];
}
}
else
{
throw new Exception("未能读取到相应的tqid");
}
Console.Write(temp_tqid);
String getcid = "select cid from CLASSFICATION where TOPCLASSFICATION ='" + where.Cla[0] + "' and SECONDCLASSFICATION='" + where.Cla[1] + "'";
OracleCommand cmd2 = new OracleCommand(getcid, conn);
OracleDataReader dr2 = cmd2.ExecuteReader(); // C#
int temp_cid = 0;
if (dr2.HasRows)
{
while (dr2.Read())
{
temp_cid = (int)dr2["cid"];
}
}
else
{
throw new Exception("未能读取到相应的cid");
}
if (temp_cid != 0)
{
String ISql = "insert into TCLASSIFICATIONMAP(tqid,cid) values(:tqid,:cid)";
OracleCommand cmd3 = new OracleCommand(ISql, conn);
OracleParameter tqidpar = new OracleParameter(":tqid", temp_tqid);
OracleParameter cidpar = new OracleParameter(":cid", temp_cid);
cmd3.Parameters.Add(tqidpar);
cmd3.Parameters.Add(cidpar);
int result2 = cmd3.ExecuteNonQuery();
if (result2 != 1)
{
throw new Exception("写入tempquesion失败");
}
Console.Write("success for temp" + result2);
}
else
{
throw new Exception("没有这个分类");
}
ManagerAssign ma = new ManagerAssign();
int temp_managerid = ma.giveAssign(temp_tqid, 'a');
if (temp_managerid != 0)
{
success = true;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
finally
{
conn.Clone();
}
return(success);
}
