public bool Update(BillModel model)
{
if (model == null) throw new Exception("model不能为null");
if (model.Bill == null) throw new Exception("bill不能为null");
if (string.IsNullOrEmpty(model.Bill.ID)) throw new Exception("Bill.ID不能为空");
ISqlMapper mapper = MapperHelper.GetMapper();
BillDao billdao = new BillDao(mapper);
OtherFeeBillDao ofbdao = new OtherFeeBillDao(mapper);
billdao.Update(new BillUpdateForm
{
Entity = new Bill
{
ShouldPay = model.Bill.ShouldPay,
Payed = model.Bill.Payed,
},
BillQueryForm = new BillQueryForm { ID = model.Bill.ID },
});
if (model.OtherFeeBill != null)
{
foreach (var ofb in model.OtherFeeBill)
{
if (ofb.OtherFeeBill == null || string.IsNullOrEmpty(ofb.OtherFeeBill.ID)) continue;
ofbdao.Update(new OtherFeeBillUpdateForm
{
Entity = new OtherFeeBill
{
StartValue = ofb.OtherFeeBill.StartValue,
EndValue = ofb.OtherFeeBill.EndValue,
Fee = ofb.OtherFeeBill.Fee,
},
OtherFeeBillQueryForm = new OtherFeeBillQueryForm { ID = ofb.OtherFeeBill.ID },
});
}
}
return true;
}
public bool Update(BillModel Bill)
{
return bll.Update(Bill);
}
public BillModel QuerySingle(string BillID)
{
ISqlMapper mapper = MapperHelper.GetMapper();
BillDao dao = new BillDao(mapper);
OtherFeeDao ofdao = new OtherFeeDao(mapper);
House_OtherFeeDao hodao = new House_OtherFeeDao(mapper);
OtherFeeBillDao ofbdao = new OtherFeeBillDao(mapper);
var bill = dao.QueryFullBill(new QueryFullBillServiceForm { ID = BillID }).FirstOrDefault();
BillModel model = new BillModel
{
Bill = bill,
};
if (bill == null) return model;
var house_otherfees = hodao.Query(new House_OtherFeeQueryForm { HouseOrRoomID = bill.HouseOrRoomID });
var otherfeeids = (from ho in house_otherfees select ho.OtherFeeID).ToList();
var otherfeebills = ofbdao.Query(new OtherFeeBillQueryForm { BillID = bill.ID, });
var otherfees = ofdao.Query(new OtherFeeQueryForm { IDs = otherfeeids });
var fullotherfeebills = new List<FullOtherFeeBill>();
foreach (var ho in house_otherfees)
{
FullOtherFeeBill ofb = new FullOtherFeeBill
{
House_OtherFee = ho,
OtherFee = otherfees.Find(t => t.ID.Equals(ho.OtherFeeID)),
OtherFeeBill = otherfeebills.Find(t => t.OtherFeeID.Equals(ho.OtherFeeID)),
};
fullotherfeebills.Add(ofb);
}
model.OtherFeeBill = fullotherfeebills;
return model;
}
