var contracts = from c in db.B_Contract_Out join h in db.B_Hospital on c.HospitalID equals h.ID into ch where c.C4 == "1" && c.ContractDate < DateTime.Now from chs in ch.DefaultIfEmpty() join u in db.sys_User on c.PrincipalUser equals u.UserID into cu from cus in cu.DefaultIfEmpty() orderby c.ContractDate descending join p in db.B_PayRecord on c.ID equals p.ContractID into cp from cps in cp.DefaultIfEmpty() where c.AllMoney != Convert.ToDouble(cps.PayMoney) orderby c.ContractDate descending //select new { c.WinFee, c.C1, c.BankFee, c.PayType,c.C2,c.Contract,c.Remark, c.ID, c.ContractType, ArmNames = GetArmariumName(c.ID), PayMoney = GetPayedMoney(c.ID), c.CreateTime, c.ArriveDate, c.SetupDate, qiankuan = c.AllMoney - double.Parse(GetPayedMoney(c.ID).ToString()), c.ContractDate, c.ContactNum, cus.U_CName, c.AllMoney, chs.HospitalName }; select new { PayMoney = GetPayedMoney(c.ID), ArmNames = GetArmariumName(c.ID), ArmInPrice = GetArmInPrice(c.ID), USInPrice = GetUSInPrice(c.ID), Duty = GetDuty(Convert.ToDouble(c.AllMoney), c.ID), Profit = GetProfit(Convert.ToDouble(c.AllMoney), c.ID, Convert.ToDouble(c.BankFee), Convert.ToDouble(c.WinFee)), c.WinFee, c.C1, c.BankFee, c.PayType, c.C2, c.Contract, c.Remark, c.ID, c.ContractType, c.CreateTime, c.ArriveDate, c.SetupDate, c.ContractDate, c.ContactNum, cus.U_CName, c.AllMoney, chs.HospitalName, qiankuan = (c.AllMoney - Convert.ToDouble(cps.PayMoney)) };
1 回答
- 1 回答
- 0 关注
- 913 浏览
添加回答
举报
0/150
提交
取消