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); }