攒了半年的分都在这了,如果得不到答案,从此就不在上csdn了,来者有份
sqlHelper.ExecNonQuery( sql,QueryCondition condition);怎么编写这个方法呢
entity是实体,例如设置实体的属性后,进行插入操作,调用这个方法。执行Sql语句,怎么编写这个执行Sql的语句的方法呢
public void Insert(Engine entity)
{
string sql = @"
INSERT INTO Engine (Id, Code, Name)
VALUES (@Id, @Code, @Name)";
sqlHelper.ExecNonQuery(sql, Entity2Condition(entity));
}
private QueryCondition Entity2Condition(Engine entity)
{
QueryCondition condition = new QueryCondition();
condition.Parameters.Add(new Parameter("Id", DbType.Guid, entity.Id));
condition.Parameters.Add(new Parameter("Code", DbType.AnsiString, entity.Code));
condition.Parameters.Add(new Parameter("Name", DbType.String, entity.Name));
}
sqlHelper.ExecNonQuery( sql,QueryCondition condition){};求这个方法怎么写