public bool Update(XXZX.Model.TXL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TXL set ");
strSql.Append("KS=:KS,");
strSql.Append("XM=:XM,");
strSql.Append("DWDH=:DWDH,");
strSql.Append("JTDH=:JTDH,");
strSql.Append("SJ=:SJ,");
strSql.Append("JTZZ=:JTZZ,");
strSql.Append("YX=:YX");
strSql.Append("ID=:ID");
strSql.Append("rowid1=:rowid1");
strSql.Append(" where rowid=:rowid1 ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "KS", DbType.String, model.KS);
db.AddInParameter(dbCommand, "XM", DbType.String, model.XM);
db.AddInParameter(dbCommand, "DWDH", DbType.String, model.DWDH);
db.AddInParameter(dbCommand, "JTDH", DbType.String, model.JTDH);
db.AddInParameter(dbCommand, "SJ", DbType.String, model.SJ);
db.AddInParameter(dbCommand, "JTZZ", DbType.String, model.JTZZ);
db.AddInParameter(dbCommand, "YX", DbType.String, model.YX);
db.AddInParameter(dbCommand, "ID", DbType.String, model.ID);
db.AddInParameter(dbCommand, "rowid1", DbType.String, model.Rowid1);
if (db.ExecuteNonQuery(dbCommand) > 0)【这句提示:用户代码未处理oracleException】
{
return true;
}
else
{
return false;
} }
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TXL set ");
strSql.Append("KS=:KS,");
strSql.Append("XM=:XM,");
strSql.Append("DWDH=:DWDH,");
strSql.Append("JTDH=:JTDH,");
strSql.Append("SJ=:SJ,");
strSql.Append("JTZZ=:JTZZ,");
strSql.Append("YX=:YX");
strSql.Append("ID=:ID");
strSql.Append("rowid1=:rowid1");
strSql.Append(" where rowid=:rowid1 ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "KS", DbType.String, model.KS);
db.AddInParameter(dbCommand, "XM", DbType.String, model.XM);
db.AddInParameter(dbCommand, "DWDH", DbType.String, model.DWDH);
db.AddInParameter(dbCommand, "JTDH", DbType.String, model.JTDH);
db.AddInParameter(dbCommand, "SJ", DbType.String, model.SJ);
db.AddInParameter(dbCommand, "JTZZ", DbType.String, model.JTZZ);
db.AddInParameter(dbCommand, "YX", DbType.String, model.YX);
db.AddInParameter(dbCommand, "ID", DbType.String, model.ID);
db.AddInParameter(dbCommand, "rowid1", DbType.String, model.Rowid1);
if (db.ExecuteNonQuery(dbCommand) > 0)【这句提示:用户代码未处理oracleException】
{
return true;
}
else
{
return false;
} }
我在这里就报错了 "用户代码未处理"
strSql.Append("ID=:ID");这两句,加逗号,再试试
strSql.Append("YX=:YX");
strSql.Append("ID=:ID");
真是的,前面都知道加",",这里就不知道加了