//按日期查询
private void BTDateFind_Click(object sender, EventArgs e)
{
string errorDesc = "";
var shopYeJis = ShopManagement.queryYeJi(LogIn.connectionIP, companyCodes, DPDate.Value.ToString("yyyy-MM-dd"), "D", out errorDesc);
if (shopYeJis == null)
{
BathClass.printErrorMsg(errorDesc);
return;
}
DgvDateStores.Rows.Clear();
DgvDateTotal.Rows.Clear();
DgvDateTotal.Rows.Add(
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountCash), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountbankUnion), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleCash), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleBankUnion), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.totalRevenue), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.creditCard), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.coupon), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.groupBuy), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.server), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.zero), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.wipeZero), 0));
foreach (var shopYeJi in shopYeJis)
{
DgvDateStores.Rows.Add(
shopYeJi.companyName,
shopYeJi.accountCash,
shopYeJi.accountbankUnion,
shopYeJi.cardSaleCash,
shopYeJi.cardSaleBankUnion,
shopYeJi.totalRevenue,
shopYeJi.creditCard,
shopYeJi.coupon,
shopYeJi.groupBuy,
shopYeJi.server,
shopYeJi.zero,
shopYeJi.wipeZero);
}
}
//按照月查询
private void BTMonthFind_Click(object sender, EventArgs e)
{
string errorDesc = "";
var shopYeJis = ShopManagement.queryYeJi(MainForm.ip, companyCodes, CBYear.Text + "-" + CBMonth.Text, "M", out errorDesc);
if (shopYeJis == null)
{
MessageBox.Show(errorDesc);
return;
}
DgvMonthStores.Rows.Clear();
DgvMonthTotal.Rows.Clear();
DgvMonthTotal.Rows.Add(
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountCash), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountbankUnion), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleCash), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleBankUnion), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.totalRevenue), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.creditCard), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.coupon), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.groupBuy), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.server), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.zero), 0),
MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.wipeZero), 0));
foreach (var shopYeJi in shopYeJis)
{
DgvMonthStores.Rows.Add(
shopYeJi.companyName,
shopYeJi.accountCash,
shopYeJi.accountbankUnion,
shopYeJi.cardSaleCash,
shopYeJi.cardSaleBankUnion,
shopYeJi.totalRevenue,
shopYeJi.creditCard,
shopYeJi.coupon,
shopYeJi.groupBuy,
shopYeJi.server,
shopYeJi.zero,
shopYeJi.wipeZero);
}
}
