110,533
社区成员
发帖
与我相关
我的任务
分享
string sqlshenhe = "INSERT INTO ClassLog ( DiQu,ZhuangTai,ShenheId,ShenheShiJian) (select DiQu,ZhuangTai,4,'2012-2-18 10:00:00' FROM ClassLogLuRu WHERE ClassLogLuRu_id =" + id + ") ";
if (Convert.ToInt32(SqlHelper.ExecuteScalar(DBConn.ConnectionString, CommandType.Text, sqlshenhe)) > 0)
{
string sql = "delete from [ClassLogLuRu] where ClassLogLuRu_id =" + id;
...................................
}
INSERT INTO ClassLog
(DiQu, ZhuangTai, ShenheId, ShenheShiJian) (SELECT DiQu, ZhuangTai, 4, '2012-2-18 10:00:00'
FROM ClassLogLuRu
WHERE ClassLogLuRu_id = 701)
string sqlshenhe = @"INSERT INTO ClassLog ( DiQu,ZhuangTai,ShenheId,ShenheShiJian) select DiQu,ZhuangTai,4,'2012-2-18 10:00:00' FROM ClassLogLuRu WHERE ClassLogLuRu_id ="+id +";
//把你的代码改成这样试试
INSERT INTO ClassLog ( DiQu,ZhuangTai,ShenheId,ShenheShiJian)
(select DiQu,ZhuangTai,4,'2012-2-18 10:00:00' FROM ClassLogLuRu WHERE ClassLogLuRu_id =" + id + ")