private static IncomingFormEntity Get(string id, Database db, DbTransaction trans)
{
var sql = string.Format("select {0} from incoming_form {1} where id=@p_id", COLUMN_SQL, TransHelper.UpdateLock(trans));
if (db == null)
{
db = DatabaseFactory.CreateDatabase();
}
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
IncomingFormEntity entity = null;
using (var reader = (trans == null ? db.ExecuteReader(dc) : db.ExecuteReader(dc, trans)))
{
while (reader.Read())
{
entity = new IncomingFormEntity();
entity.Init(reader);
break;
}
}
return(entity);
}
public static IncomingFormEntity GetBySerialId(string serialId, Database db, DbTransaction trans)
{
var sql = string.Format("select {0} from incoming_form where serial_id=@p_serial_id", COLUMN_SQL);
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_serial_id", DbType.String, serialId);
using (var reader = db.ExecuteReader(cmd, trans))
{
if (reader.Read())
{
var entity = new IncomingFormEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}