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);
}
