/// <summary> /// 通过房号查询账单 /// </summary> private void Bind() { List <Model.goods_account> list = bllga.GetListOut("ga_occuid='" + roomnum + "'"); //List<Model.goods_account> listmode = bllga.GetModelList("ga_occuid='" + roomnum + "' and ga_Type=6"); List <Model.goods_account> listmode = list.Where(d => d.ga_Type == 6).ToList(); if (listmode.Count > 0) { tuikuan = listmode[0].ga_price.ToString(); } if (list != null) { foreach (Model.goods_account model in list) { if (model.ga_zffs_id == null) { sbtext.Append("<tr class=\"trs\"><td>" + model.ga_roomNumber + "</td><td>" + model.ga_name + "</td><td class=\"ff\">" + model.ga_price + "</td><td class=\"fy\">" + model.ga_sum_price + "</td><td></td></tr>"); } else { sbtext.Append("<tr class=\"trs\"><td>" + model.ga_roomNumber + "</td><td>" + model.ga_name + "</td><td class=\"ff\">" + model.ga_price + "</td><td class=\"fy\">" + model.ga_sum_price + "</td><td>" + model.Meth_pay_model.meth_pay_name + "</td></tr>"); } } } }