public static IList <HospitalProductEntity> GetByUnit(string unitId)
        {
            var sql = string.Format(@"SELECT {0} FROM hospital_products WHERE unit_id = @p_unit_id", COLUMN_SQL);

            var db = DatabaseFactory.CreateDatabase();

            var dc = db.GetSqlStringCommand(sql);

            db.AddInParameter(dc, "p_unit_id", DbType.String, unitId);

            var list = new List <HospitalProductEntity>();

            using (var reader = db.ExecuteReader(dc))
            {
                while (reader.Read())
                {
                    var product = new HospitalProductEntity();
                    product.Init(reader);

                    list.Add(product);
                }
            }

            return(list);
        }
        internal static HospitalProductEntity GetOneProduct(string productId, string hospitalId)
        {
            var sql = string.Format(@"SELECT top 1 {0} FROM hospital_products 
WHERE hospital_id = @p_hospital_id and product_id = @p_product_id", COLUMN_SQL);

            var db = DatabaseFactory.CreateDatabase();

            var dc = db.GetSqlStringCommand(sql);

            db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId);
            db.AddInParameter(dc, "p_product_id", DbType.String, productId);

            HospitalProductEntity entity = null;

            using (var reader = db.ExecuteReader(dc))
            {
                while (reader.Read())
                {
                    entity = new HospitalProductEntity();
                    entity.Init(reader);

                    break;
                }
            }

            return(entity);
        }