private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
{
backgroundWorker2.ReportProgress(10); //这里让进度条显示进度
bikeList = bikeReturnBLL.BikeReturnSelectByDpIdAndTime(bikeTemp, startTime, endTime);
backgroundWorker2.ReportProgress(60); //这里让进度条显示进度
bikeTemp.IsVip = false;
bikeNoList = bikeReturnBLL.BikeReturnSelectByDpIdAndTime(bikeTemp, startTime, endTime);
backgroundWorker2.ReportProgress(90);//这里让进度条显示进度
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
lvMsg.BeginUpdate();
lvMsg.Groups.Clear();
lvMsg.Items.Clear();
#region 新办会员收入
ListViewItem addVipSum = new ListViewItem();
ListViewGroup newGroup = new ListViewGroup();
newGroup.Header = "新办会员收入";
newGroup.HeaderAlignment = HorizontalAlignment.Center;
lvMsg.Groups.Add(newGroup);
if (vipList != null)
{
for (int i = 0; i < vipList.Count; i++)
{
UserInfo user = new UserInfo();
user.UserId = vipList[i].UserId;
user = userBLL.SelectUserById(user);
ListViewItem vi = new ListViewItem();
vi.SubItems[0].Text = vipList[i].VipName;
vi.SubItems.Add("10");
vi.SubItems.Add("新会员");
vi.SubItems.Add(vipList[i].AddDate.ToString());
vi.SubItems.Add(user.UserName);
newGroup.Items.Add(vi);
lvMsg.Items.Add(vi);
}
addVipSum.SubItems[0].Text = "新办会员总计:";
addVipSum.SubItems.Add((vipList.Count * 10).ToString());
addVipSum.ForeColor = Color.Red;
}
else
{
addVipSum.SubItems[0].Text = "新办会员总计:";
addVipSum.SubItems.Add("0");
addVipSum.ForeColor = Color.Red;
}
#endregion
#region 充值收入
ListViewItem vipChargeSum = new ListViewItem();
ListViewGroup chargeGroup = new ListViewGroup();
chargeGroup.Header = "充值收入";
chargeGroup.HeaderAlignment = HorizontalAlignment.Center;
RechargeInfo rechargeInfo = new RechargeInfo();
rechargeInfo.DepartId = departId;
List <RechargeInfo> rechargeList = vipMoneyBLL.RechargeInfoSelect(beginTime, endTime, rechargeInfo);
if (rechargeList != null)
{
double money = 0;
for (int i = 0; i < rechargeList.Count; i++)
{
UserInfo user = new UserInfo();
user.UserId = rechargeList[i].UserId;
user = userBLL.SelectUserById(user);
ListViewItem vi = new ListViewItem();
if (rechargeList[i].IsVip)
{
VIPInfo vip = new VIPInfo();
vip.VipId = rechargeList[i].VipId;
vip = vipBLL.VipSelectById(vip);
vi.SubItems[0].Text = vip.VipName;
}
else
{
VipNoInfo vipNo = new VipNoInfo();
vipNo.VipId = rechargeList[i].VipId;
vipNo = new VipNoBLL().VipNoSelectByVIPNoId(vipNo);
vi.SubItems[0].Text = vipNo.VipName;
}
money += rechargeList[i].ChargeMoney;
vi.SubItems.Add(rechargeList[i].ChargeMoney.ToString());
if (rechargeList[i].ChargeMoney < 0)
{
vi.SubItems.Add("扣费");
}
else
{
vi.SubItems.Add("充值");
}
vi.SubItems.Add(rechargeList[i].RechargeTime.ToString());
vi.SubItems.Add(user.UserName);
chargeGroup.Items.Add(vi);
lvMsg.Items.Add(vi);
}
vipChargeSum.SubItems[0].Text = "充值总计:";
vipChargeSum.SubItems.Add(money.ToString());
vipChargeSum.ForeColor = Color.Red;
// lvMsg.Items[rechargeList.Count].ForeColor = Color.Red;
}
else
{
vipChargeSum.SubItems[0].Text = "充值总计:";
vipChargeSum.SubItems.Add("0");
vipChargeSum.ForeColor = Color.Red;
}
lvMsg.Groups.Add(chargeGroup);
#endregion
#region 会员租车收入
/////会员租车收入
ListViewItem vipBorrowSum = new ListViewItem();
ListViewGroup vipGroup = new ListViewGroup();
vipGroup.Header = "会员租车收入";
vipGroup.HeaderAlignment = HorizontalAlignment.Center;
BikeReturn brTemp = new BikeReturn();
brTemp.DpId = departId;
brTemp.IsVip = true;
List <BikeReturn> bikeReturnList = brBLL.BikeReturnSelectByDpIdAndTime(brTemp, beginTime, endTime);
if (bikeReturnList != null)
{
double money = 0;
for (int i = 0; i < bikeReturnList.Count; i++)
{
ListViewItem vi = new ListViewItem();
VIPInfo vip = new VIPInfo();
UserInfo user = new UserInfo();
user.UserId = bikeReturnList[i].BBUserId;
user = userBLL.SelectUserById(user);
vip.VipId = bikeReturnList[i].VipId;
vip = vipBLL.VipSelectById(vip);
vi.SubItems[0].Text = vip.VipName;
vi.SubItems.Add(bikeReturnList[i].BuCost.ToString());
vi.SubItems.Add("会员租车");
vi.SubItems.Add(bikeReturnList[i].BBTime.ToString());
vi.SubItems.Add(user.UserName);
money += bikeReturnList[i].BuCost;
vipGroup.Items.Add(vi);
lvMsg.Items.Add(vi);
}
vipBorrowSum.SubItems[0].Text = "会员租车总计:";
vipBorrowSum.SubItems.Add(money.ToString());
vipBorrowSum.ForeColor = Color.Red;
}
else
{
vipBorrowSum.SubItems[0].Text = "会员租车总计:";
vipBorrowSum.SubItems.Add("0");
vipBorrowSum.ForeColor = Color.Red;
}
lvMsg.Groups.Add(vipGroup);
lvMsg.ShowGroups = true;
#endregion
#region 非会员租车
ListViewItem vipNoBorrowSum = new ListViewItem();
ListViewGroup vipNoGroup = new ListViewGroup();
vipNoGroup.Header = "非会员租车收入";
vipNoGroup.HeaderAlignment = HorizontalAlignment.Center;
brTemp.IsVip = false;
bikeReturnList = brBLL.BikeReturnSelectByDpIdAndTime(brTemp, beginTime, endTime);
if (bikeReturnList != null)
{
double money = 0;
for (int i = 0; i < bikeReturnList.Count; i++)
{
ListViewItem vi = new ListViewItem();
VipNoInfo vipNo = new VipNoInfo();
UserInfo user = new UserInfo();
user.UserId = bikeReturnList[i].BBUserId;
user = userBLL.SelectUserById(user);
vipNo.VipId = bikeReturnList[i].VipId;
vipNo = new VipNoBLL().VipNoSelectByVIPNoId(vipNo);
vi.SubItems[0].Text = vipNo.VipName;
vi.SubItems.Add(bikeReturnList[i].BuCost.ToString());
vi.SubItems.Add("非会员租车");
vi.SubItems.Add(bikeReturnList[i].BBTime.ToString());
try
{
vi.SubItems.Add(user.UserName);
}
catch (Exception)
{
}
money += bikeReturnList[i].BuCost;
vipNoGroup.Items.Add(vi);
lvMsg.Items.Add(vi);
}
vipNoBorrowSum.SubItems[0].Text = "非会员租车总计:";
vipNoBorrowSum.SubItems.Add(money.ToString());
vipNoBorrowSum.ForeColor = Color.Red;
}
else
{
vipNoBorrowSum.SubItems[0].Text = "非会员租车总计:";
vipNoBorrowSum.SubItems.Add("0");
vipNoBorrowSum.ForeColor = Color.Red;
}
lvMsg.Groups.Add(vipNoGroup);
lvMsg.ShowGroups = true;
#endregion
#region 会员租车余额
/////会员租车余额
ListViewItem vipp = new ListViewItem();
vipp.SubItems[0].Text = "会员余额";
string DpId = cmbDepart.SelectedValue.ToString();
string s = vipMoneyBLL.vipSumMoneyBalanceByDpId(DpId).ToString();
vipp.SubItems.Add(s);
vipp.ForeColor = Color.Red;
#endregion
#region 非会员租车余额
/////非会员租车余额
ListViewItem vippNot = new ListViewItem();
vippNot.SubItems[0].Text = "非会员余额";
vippNot.SubItems.Add(vipMoneyBLL.vipNoSumMoneyBalanceByDpId(DpId).ToString());
vippNot.ForeColor = Color.Red;
#endregion
#region 总计
ListViewGroup AllMoney = new ListViewGroup();
AllMoney.Header = "各项总计";
AllMoney.HeaderAlignment = HorizontalAlignment.Center;
AllMoney.Items.Add(addVipSum);
lvMsg.Items.Add(addVipSum);
AllMoney.Items.Add(vipChargeSum);
lvMsg.Items.Add(vipChargeSum);
AllMoney.Items.Add(vipBorrowSum);
lvMsg.Items.Add(vipBorrowSum);
AllMoney.Items.Add(vipNoBorrowSum);
lvMsg.Items.Add(vipNoBorrowSum);
AllMoney.Items.Add(vipp);
lvMsg.Items.Add(vipp);
AllMoney.Items.Add(vippNot);
lvMsg.Items.Add(vippNot);
lvMsg.Groups.Add(AllMoney);
lvMsg.ShowGroups = true;
#endregion
lvMsg.EndUpdate();
btnOk.Enabled = true;
progressBar1.Visible = false;
}
