//显示信息
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);
}
