MCVef/Controllers/BillsController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using System.Web.Http.Description;
using MCVef.Models;

namespace MCVef.Controllers
{
    public class BillsController : ApiController
    {
        private HospitalModel db = new HospitalModel();

        public string Options()
        {
            return null;
        }
        // GET: api/Bills
        public IQueryable<Bill> GetBill()
        {
            return db.Bill;
        }

        // GET: api/Bills/?
        /// <summary>
        /// 遍历算出价格
        /// </summary>
        [ResponseType(typeof(Bill))]
        public IHttpActionResult GetBill(int? billId, int? registId)
        {
            IQueryable<Bill> bills = db.Bill;
            if (billId != null)
            {
                bills = bills.Where(b => b.BillId == billId.Value);
            }
            if(registId != null)
            {
                bills = bills.Where(b => b.RegistId == registId.Value);
            }
            if(bills.Count() == 0)
            {
                return NotFound();
            }
            foreach (var bill in bills)
            {
                bill.BillDetails = db.BillDetail.Where<BillDetail>(b => b.BillId == bill.BillId).ToArray<BillDetail>();
                foreach (var billDetaill in bill.BillDetails)
                {
                    billDetaill.Drug = db.DrugWarehouse.Find(billDetaill.DrugWarehouseId);
                }
                bill.Sum = bill.BillDetails.Sum<BillDetail>(b => b.Drug.DrugPrice * b.DrugUsage).GetValueOrDefault();
            }
            return Ok(bills);
        }