//显示信息 private void dgv_show() { var dc = new BathDBDataContext(LogIn.connectionString); var cc = dc.CardCharge.Where(x => x.CC_InputDate >= startTime.Value && x.CC_InputDate <= endTime.Value); if (card.Text != "") { cc = cc.Where(x => x.CC_CardNo == card.Text); } cc = cc.OrderBy(x => x.CC_InputDate); foreach (var x in cc) { string t = ""; var ci = dc.CardInfo.FirstOrDefault(y => y.CI_CardNo == x.CC_CardNo); if (ci != null) { var mt = dc.MemberType.FirstOrDefault(z => z.id == ci.CI_CardTypeNo); if (mt != null) { t = mt.name; } } string[] row = { x.CC_CardNo, t, x.CC_ItemExplain, BathClass.get_member_balance(dc,x.CC_CardNo).ToString(), ToString(x.expense), x.CC_AccountNo, x.CC_InputOperator, x.CC_InputDate.ToString() }; this.Invoke(new delegate_add_row(add_row), (Object)row); } this.Invoke(new delegate_set_dgv_fit(BathClass.set_dgv_fit), (Object)dgv); }