//按日期查询 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); } }