private static InspectionFormEntity Get(string id, Database db, DbTransaction trans)
{
var sql = string.Format("select {0} from inspection_form where id=@p_id", COLUMN_SQL);
if (db == null)
{
db = DatabaseFactory.CreateDatabase();
}
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
InspectionFormEntity entity = null;
using (var reader = (trans == null ? db.ExecuteReader(dc) : db.ExecuteReader(dc, trans)))
{
while (reader.Read())
{
entity = new InspectionFormEntity();
entity.Init(reader);
break;
}
}
return(entity);
}
public static IList <InspectionFormEntity> QueryConfirm(string hospitalId)
{
var sql = string.Format(@"select {0} from inspection_form where scan_over = 0 and hospital_id=@p_hospital_id
order by order_form_no", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId);
var list = new List <InspectionFormEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new InspectionFormEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
