/// <summary> /// 查询称重单列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsb_query_Click(object sender, EventArgs e) { Expression <Func <WeighingSettlementModel, bool> > expr = n => GetCondition(n, cmb_custName.SelectedValue.ToString(), Convert.ToInt32(cmbVoucherState.SelectedValue), dtp_DateStart.Value.Date, dtp_DateEnd.Value.Date ); try { WeightListService w = new WeightListService(); var q = w.GetWeighingList(expr); lbl_money.Text = q.ToList().Sum(s => s.settleAmount).ToString("C", CultureInfo.CreateSpecificCulture("ZH-HANS")); #region add amount WeighingViewModel m = new WeighingViewModel(); m.WeighingDate = "合计"; m.netWeight = q.Sum(x => x.netWeight); m.settleAmount = q.Sum(x => x.settleAmount); q.Add(m); dgv_content.DataSource = q; #endregion #region apperance this.FontBond(); this.BlankCell(); this.ThoundSeparate(); #endregion } catch (Exception ex) { MessageBox.Show("数据查询错误:" + ex.Message + ex.InnerException, "数据查询提示"); return; } //处理数据为空示和时的数据转换错误,可先转成泛型再求和 //ToString("C",CultureInfo.CreateSpecificCulture("ZH-HANS"),如果只选择参数“C”, //则只显示千分符与默认文化区域为货币符号,如是区域选择美国,则货币符号则显示为“$” if (dgv_content.RowCount > 0) { tsb_delete.Enabled = true; } }
public List <WeighingViewModel> GetWeighingList(Expression <Func <WeighingSettlementModel, bool> > expr) { List <WeighingViewModel> list = new List <WeighingViewModel>(); using (var db = new ScrapSettleContext()) { var query = from d in new EnumService().GetVoucherState() join q in db.WeighingSettlement.Where(expr.Compile()) on d.Key equals q.auditFlag join c in db.Customers on q.CustmerCode equals c.CusCode.ToString() join p in db.Peple on q.personCode equals p.Code.ToString() join s in db.Scraps on q.scrapCode equals s.ScrapCode.ToString() select new { q.WeighingDate, q.vocherNO, c.CusName, s.ScrapName, q.proportion, q.webUnitPrice, q.settleUnitPrice, q.netWeight, q.settleAmount, voucherState = d.Value, note = q.note }; foreach (var item in query) { WeighingViewModel m = new WeighingViewModel(); m.WeighingDate = item.WeighingDate.ToString(); m.vocherNO = item.vocherNO; m.CusName = item.CusName; m.ScrapName = item.ScrapName; m.proportion = item.proportion; m.webUnitPrice = item.webUnitPrice; m.settleUnitPrice = item.settleUnitPrice; m.netWeight = item.netWeight; m.settleAmount = item.settleAmount; m.voucherState = item.voucherState; m.note = item.note; list.Add(m); } return(list); } }