private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { lvMsg.BeginUpdate(); lvMsg.Items.Clear(); if (rechargeList.Count == 0) { MessageBox.Show("无充值记录"); lvMsg.EndUpdate(); progressBar1.Visible = false; btnOk.Enabled = true; return; } if (rechargeList.Count != 0) { for (int i = 0; i < rechargeList.Count; i++) { UserInfo user = new UserInfo(); user.UserId = rechargeList[i].UserId; user = userBLL.SelectUserById(user); DepartInfo depart = new DepartInfo(); depart.DpId = rechargeList[i].DepartId; depart = departBLL.DepartSelectById(depart); lvMsg.Items.Add(""); if (rechargeList[i].IsVip) { VIPInfo vip = new VIPInfo(); vip.VipId = rechargeList[i].VipId; lvMsg.Items[i].SubItems[0].Text = vipBLL.VipSelectById(vip).VipName; } else { VipNoInfo vip = new VipNoInfo(); vip.VipId = rechargeList[i].VipId; lvMsg.Items[i].SubItems[0].Text = vipNoBLL.VipNoSelectByVIPNoId(vip).VipName; } lvMsg.Items[i].SubItems.Add(rechargeList[i].ChargeMoney.ToString()); lvMsg.Items[i].SubItems.Add(user.UserName); lvMsg.Items[i].SubItems.Add(rechargeList[i].RechargeTime.ToString()); lvMsg.Items[i].SubItems.Add(depart.DpName); } } lvMsg.EndUpdate(); progressBar1.Visible = false; btnOk.Enabled = true; }
private void GetVipInfoById(object vip) { VIPInfo vipTemp = vipBLL.VipSelectById((VIPInfo)vip); this.Invoke(new Action(() => { txtVipNumber.Text = vipTemp.VipNumber; cmbVipLevel.SelectedValue = vipTemp.VipLevelId; txtVipName.Text = vipTemp.VipName; cmbDPID.SelectedValue = vipTemp.DpId; if (vipTemp.VipSex) { rbtnSex1.Checked = true; } else { rbtnSex2.Checked = true; } txtVipPWD.Text = vipTemp.VipPWD; txtVipPWD2.Text = vipTemp.VipPWD; txtVipPhone.Text = vipTemp.VipPhone; txtVipCard.Text = vipTemp.VipCard; txtVipAddress.Text = vipTemp.VipAddress; image = vipTemp.VipPhoto; txtMark.Text = vipTemp.Mark; try { if (vipTemp.VipPhoto == new Byte[0]) { picUser.Image = null; return; } MemoryStream stream = new MemoryStream(vipTemp.VipPhoto, true); stream.Write(vipTemp.VipPhoto, 0, vipTemp.VipPhoto.Length); picUser.Image = new Bitmap(stream); picUser.SizeMode = PictureBoxSizeMode.StretchImage; } catch (Exception ex) { picUser.Image = null; } cmbDPID.SelectedValue = vipTemp.DpId; })); }
private void FillVipMessage() { VIPInfo vipTemp = new VIPInfo(); VipMoney moneyTemp = new VipMoney(); moneyTemp.VipId = vipInfo.VipId; moneyTemp.IsVip = true; try { moneyTemp = vipMoneyBLL.VipMoneySelectByVipId(moneyTemp); if (moneyTemp != null) { txtInte.Text = moneyTemp.Integral.ToString(); txtBalance.Text = moneyTemp.VmBalance.ToString(); } vipTemp = vipBLL.VipSelectById(vipInfo); txtAddress.Text = vipTemp.VipAddress; txtBirthday.Text = vipTemp.VipBirthDay.ToShortDateString(); txtCard.Text = vipTemp.VipNumber; txtVIPNum.Text = vipTemp.VipId.ToString(); txtPhone.Text = vipTemp.VipPhone; txtVipName.Text = vipTemp.VipName; txtVipCard.Text = vipTemp.VipCard; int vipLV = vipTemp.VipLevelId; VipLevelInfo levelInfo = new VipLevelInfo(); levelInfo.LvId = vipLV; levelInfo = vipLVBLL.VipLevelSelectById(levelInfo); txtVipLv.Text = levelInfo.LvName; int dpid = vipTemp.DpId; DepartInfo dpInfo = new DepartInfo(); dpInfo.DpId = dpid; dpInfo = dpBLL.DepartSelectById(dpInfo); txtDp.Text = dpInfo.DpName; } catch (Exception) { MessageBox.Show("网络不稳定,请刷新!"); } }
private void FillVipMessage() { int id = Int32.Parse(cmbVipId.SelectedValue.ToString()); VIPInfo vipTemp = new VIPInfo(); vipInfo.VipId = id; vipTemp = vipBLL.VipSelectById(vipInfo); txtAddress.Text = vipTemp.VipAddress; txtBirthday.Text = vipTemp.VipBirthDay.ToShortDateString(); txtCard.Text = vipTemp.VipNumber; txtPhone.Text = vipTemp.VipPhone; txtVipName.Text = vipTemp.VipName; txtVipCard.Text = vipTemp.VipCard; int vipLV = vipTemp.VipLevelId; VipLevelInfo levelInfo = new VipLevelInfo(); levelInfo.LvId = vipLV; levelInfo = vipLVBLL.VipLevelSelectById(levelInfo); txtVipLv.Text = levelInfo.LvName; int dpid = vipTemp.DpId; DepartInfo dpInfo = new DepartInfo(); dpInfo.DpId = dpid; dpInfo = dpBLL.DepartSelectById(dpInfo); try { MemoryStream stream = new MemoryStream(vipTemp.VipPhoto, true); stream.Write(vipTemp.VipPhoto, 0, vipTemp.VipPhoto.Length); pbVip.Image = new Bitmap(stream); pbVip.SizeMode = PictureBoxSizeMode.StretchImage; } catch (Exception ex) { pbVip.Image = null; } }
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; }
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { VipNoInfo vipNoTemp = new VipNoInfo(); VIPInfo vipTemp = new VIPInfo(); VipLevelInfo vipLvInfo = new VipLevelInfo(); if (vipBorrowList == null || vipBorrowList.Count == 0) { MessageBox.Show("未查询到相应租车信息!"); lvBorrowMessage.Items.Clear(); btnOK.Enabled = true; progressBar1.Visible = false; return; } int length = vipBorrowList.Count; lvBorrowMessage.BeginUpdate(); lvBorrowMessage.Items.Clear(); for (int i = 0; i < vipBorrowList.Count; i++) { lvBorrowMessage.Items.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); lvBorrowMessage.Items[i].SubItems.Add(""); vipTemp.VipId = vipBorrowList[i].VipId; vipTemp = vipBLL.VipSelectById(vipTemp); vipLvInfo.LvId = vipTemp.VipLevelId; vipLvInfo = vipLvBLL.VipLevelSelectById(vipLvInfo); lvBorrowMessage.Items[i].SubItems[0].Text = vipTemp.VipNumber; lvBorrowMessage.Items[i].SubItems[1].Text = vipTemp.VipName; lvBorrowMessage.Items[i].SubItems[2].Text = vipTemp.VipPhone; lvBorrowMessage.Items[i].SubItems[3].Text = vipLvInfo.LvName; lvBorrowMessage.Items[i].SubItems[4].Text = vipBorrowList[i].BbkTime.ToString(); lvBorrowMessage.Items[i].SubItems[5].Text = vipBorrowList[i].BbkNumber.ToString(); lvBorrowMessage.Items[i].SubItems[6].Text = kind[vipBorrowList[i].RkrId]; lvBorrowMessage.Items[i].SubItems[7].Text = vipBorrowList[i].IsReturn == true ? "已还" : "未还"; lvBorrowMessage.Items[i].SubItems[8].Text = vipBorrowList[i].LeftNum.ToString(); } if (vipNoBorrowList == null) { return; } for (int i = 0; i < vipNoBorrowList.Count; i++) { lvBorrowMessage.Items.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); lvBorrowMessage.Items[i + length].SubItems.Add(""); vipNoTemp.VipId = vipNoBorrowList[i].VipId; vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId(vipNoTemp); vipLvInfo.LvId = vipNoTemp.LvId; vipLvInfo = vipLvBLL.VipLevelSelectById(vipLvInfo); lvBorrowMessage.Items[i + length].SubItems[0].Text = vipNoTemp.VipNumber; lvBorrowMessage.Items[i + length].SubItems[1].Text = vipNoBorrowList[i].VnName; lvBorrowMessage.Items[i + length].SubItems[2].Text = vipNoBorrowList[i].VnPhone; lvBorrowMessage.Items[i + length].SubItems[3].Text = vipLvInfo.LvName; lvBorrowMessage.Items[i + length].SubItems[4].Text = vipNoBorrowList[i].BbkTime.ToString(); lvBorrowMessage.Items[i + length].SubItems[5].Text = vipNoBorrowList[i].VnNumber.ToString(); lvBorrowMessage.Items[i + length].SubItems[6].Text = kind[vipNoBorrowList[i].RkrId]; lvBorrowMessage.Items[i + length].SubItems[7].Text = vipNoBorrowList[i].IsReturn == true ? "已还" : "未还"; lvBorrowMessage.Items[i + length].SubItems[8].Text = vipNoBorrowList[i].LeftNum.ToString(); } lvBorrowMessage.EndUpdate(); btnOK.Enabled = true; progressBar1.Visible = false; }
//private void Bingding() //{ // this.Invoke(new Action(() => // { // FillVipMessage(); // FillVipBorrowMessage(); // })); //} private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { vipTemp = vipBLL.VipSelectById(vipInfo); borrowList = borrowBLL.VipBorrowUnReturnByVipId(vipInfo.VipId); vipMoneyTemp = moneyBLL.VipMoneySelectByVipId(vipMoneyTemp); }