数据通库之间的同步if语句逻辑问题
我现在用数据中心与本地数据库之间的教师数据的同步,用HG(工号)判断在本地数据库中是否已经存在此教师,如果存在,则对数据进行更新,如果没有,则进行insert into插入操作,但是if语句逻辑出现问题,一直执行if之下的语句,并不执行else的下面的语句,也就是说一直没有执行插入新数据的操作,求大神帮忙检查出问题所在,代码如下:
queryString = "SELECT GH,DWH,XM,SFZJH,DQZTM FROM jzgjcsjxx WHERE DWH = '1250000'";
OracleConnection myConnection = new OracleConnection(connectionString);
OracleCommand myORACCommand = new OracleCommand(queryString, myConnection);
myORACCommand.CommandText = queryString;
myConnection.Open();
OracleDataReader HG = myORACCommand.ExecuteReader();
while (HG.Read())
{
myConnection1.Open();
String queryString1 = "SELECT 教师id FROM 教师 WHERE 标准工号 = '"+ HG["GH"] +"'";
SqlCommand mycommand = new SqlCommand(queryString1, myConnection1);
SqlDataReader AB = mycommand.ExecuteReader();
if(AB.Read())
{
AB.Close();
String queryString2 = "update 教师 set 标准工号 = '" + HG["GH"] + "',姓名= '" + HG["XM"] + "',状态 = '" + HG["DQZTM"] + "' where 标准工号 = '" + HG["GH"] + "'";
SqlCommand mycommand2 = new SqlCommand(queryString2, myConnection1);
SqlDataReader CD = mycommand2.ExecuteReader();
Response .Write (HG["XM"] + "<br>");
}
else
{
AB.Close();
String queryString3 = "insert into 教师 (教研室id,身份证号,姓名,密码,职称,状态,标准工号) values ('4','"+HG["SFZJH"]+"', '"+ HG["XM"]+"' , '00000000','讲师', '"+HG["DQZTM"]+"','"+HG["GH"]+"')";
SqlCommand mycommand3 = new SqlCommand(queryString3, myConnection1);
SqlDataReader EF = mycommand3.ExecuteReader();
Response.Write(HG["GH"] + "<br>");
}
myConnection1.Close();
}
myConnection.Close();