private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (result > 0)
{
try
{
BikeReturn bikeReturnTemp = new BikeReturn();
bikeReturnTemp.RbkId = result;
bikeReturnTemp = bRetBLL.BikeReturnSelectById(bikeReturnTemp);
txtCost.Text = bikeReturnTemp.BuCost.ToString() + "元";
txtBBKTime.Text = bikeReturnTemp.BuTimeString;
}
catch (Exception ex)
{
}
MessageBox.Show("还车成功!租车消费:" + txtCost.Text);
btnOK.Enabled = true;
this.Close();
}
else
{
MessageBox.Show("还车失败!");
btnOK.Enabled = true;
}
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
progressBar1.Visible = false;
try
{
if ((vipBorrowList == null && vipReturnList == null))
{
MessageBox.Show("没有查询到相应租车记录信息!");
lvVipMessage.Items.Clear();
return;
}
if (vipBorrowList.Count == 0)
{
MessageBox.Show("没有查询到相应租车记录信息!");
lvVipMessage.Items.Clear();
return;
}
lvVipMessage.Items.Clear();
DepartInfo dpTemp = new DepartInfo();
for (int i = 0; i < vipBorrowList.Count; i++)
{
lvVipMessage.Items.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems.Add("");
lvVipMessage.Items[i].SubItems[0].Text = kind[vipBorrowList[i].RkrId];
lvVipMessage.Items[i].SubItems[1].Text = vipBorrowList[i].BbkTime.ToString();
dpTemp.DpId = vipBorrowList[i].DpId;
dpTemp = dpBLL.DepartSelectById(dpTemp);
lvVipMessage.Items[i].SubItems[2].Text = dpTemp.DpName;
lvVipMessage.Items[i].SubItems[3].Text = vipBorrowList[i].IsReturn == true ? "已还" : "未还";
if (vipBorrowList[i].IsReturn)//如果是已经还过
{
if (vipReturnList == null || vipReturnList.Count == 0)
{
return;
}
bikeReturnTemp = vipReturnList.Find(item => item.BbkId == vipBorrowList[i].BbkId);
if (bikeReturnTemp == null)
{
return;
}
dpTemp.DpId = bikeReturnTemp.DpId;
dpTemp = dpBLL.DepartSelectById(dpTemp);
lvVipMessage.Items[i].SubItems[4].Text = dpTemp.DpName;
lvVipMessage.Items[i].SubItems[5].Text = bikeReturnTemp.RbkTime.ToString();
lvVipMessage.Items[i].SubItems[6].Text = bikeReturnTemp.BuTimeString;
lvVipMessage.Items[i].SubItems[7].Text = bikeReturnTemp.BuCost.ToString();
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// 根据RBKID获得还车记录
/// </summary>
/// <returns></returns>
public BikeReturn BikeReturnSelectById(BikeReturn bikeReturn)
{
string sql = "BIKE_RETURN_SELECT_BY_ID";
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RBKID", SqlDbType.Int)
};
para[0].Value = bikeReturn.RbkId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
BikeReturn bikeReturnInfo = new BikeReturn();
bikeReturnInfo.BbkId = Convert.ToInt32(dt.Rows[0]["BBKID"]);
bikeReturnInfo.RbkTime = Convert.ToDateTime(dt.Rows[0]["RBKTIME"]);
bikeReturnInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]);
bikeReturnInfo.DpId = Convert.ToInt32(dt.Rows[0]["DPID"]);
bikeReturnInfo.BuCost = Convert.ToDouble(dt.Rows[0]["BUCOST"]);
bikeReturnInfo.BuTime = Convert.ToDateTime(dt.Rows[0]["BUTIME"]);
bikeReturnInfo.BrNumber = Convert.ToInt32(dt.Rows[0]["BRNUMBER"]);
return(bikeReturnInfo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询还车记录出错：" + ex.Message, "BikeReturnSelectById", DateTime.Now);
return(null);
}
}
public List <BikeReturn> BikeReturnSelectByDpIdAndTime(BikeReturn bikeReturn, DateTime startTime, DateTime endTime)
{
string sql = "BIKE_RETURN_SELECT_BY_DPID_AND_TIME";
DataTable dt = new DataTable();
List <BikeReturn> bikeList = new List <BikeReturn>();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ISVIP", SqlDbType.Bit),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@STARTTIME", SqlDbType.DateTime),
new SqlParameter("@ENDTIME", SqlDbType.DateTime)
};
para[0].Value = bikeReturn.IsVip;
para[1].Value = bikeReturn.DpId;
para[2].Value = startTime;
para[3].Value = endTime;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
BikeReturn bikeTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
bikeTemp = new BikeReturn();
bikeTemp.RbkId = (int)dt.Rows[i]["RBKID"];
bikeTemp.BbkId = (int)dt.Rows[i]["BBKID"];
bikeTemp.RbkTime = (DateTime)dt.Rows[i]["RBKTIME"];
bikeTemp.VipId = (int)dt.Rows[i]["VIPID"];
bikeTemp.DpId = (int)dt.Rows[i]["DPID"];
bikeTemp.BuCost = double.Parse(dt.Rows[i]["BUCOST"].ToString());
bikeTemp.BrNumber = (int)dt.Rows[i]["BRNUMBER"];
bikeTemp.IsVip = (bool)dt.Rows[i]["ISVIP"];
bikeTemp.BuTime = (DateTime)dt.Rows[i]["BUTIME"];
bikeTemp.BBTime = (DateTime)dt.Rows[i]["BBKTIME"];
bikeTemp.BBUserId = (int)dt.Rows[i]["USERID"];
try
{
bikeTemp.Mark = dt.Rows[i]["MARK"].ToString();
}
catch (Exception)
{
bikeTemp.Mark = "";
}
bikeList.Add(bikeTemp);
}
return(bikeList);
}
catch (Exception ex)
{
except.ExceptionInsert("根据租车地查询还车信息出错：" + ex.Message, "BikeReturnSelectByDpId", DateTime.Now);
return(null);
}
}
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
{
backgroundWorker2.ReportProgress(10);//这里让进度条显示进度
BikeReturn bikeTemp = new BikeReturn();
bikeTemp.IsVip = true;
bikeTemp.DpId = DPId;
bikeList = bikeReturnBLL.BikeReturnSelectByDpIdAndTime(bikeTemp, startTime, endTime);
backgroundWorker2.ReportProgress(50);
bikeTemp.IsVip = false;
bikeNoList = bikeReturnBLL.BikeReturnSelectByDpIdAndTime(bikeTemp, startTime, endTime);
backgroundWorker2.ReportProgress(70);
}
void returnBg_DoWork(object sender, DoWorkEventArgs e)
{
resultBg = bRetBLL.BikeReturnInsert(bikeReturn);
if (resultBg > 0)
{
bikeReturnTemp.RbkId = resultBg;
bikeReturnTemp = bRetBLL.BikeReturnSelectById(bikeReturnTemp);
LogInfo logInfo = new LogInfo();
logInfo.UserId = StaticData.userLocal.UserId;
logInfo.Content = "为会员‘" + txtVipName.Text + "'还车" + NMReturnNum.Text.ToString() + "辆";
logInfo.LogTime = DateTime.Now;
logInfo.DpId = StaticData.departLocal.DpId;
bool b = new LogBLL().LogInsert(logInfo);
}
}
public List <BikeReturn> BikeReturnSelectByVipId(BikeReturn bikeReturn)
{
string sql = "BIKE_RETURN_SELECT_BY_VIPID";
DataTable dt = new DataTable();
List <BikeReturn> bikeList = new List <BikeReturn>();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int),
new SqlParameter("@ISVIP", SqlDbType.Bit),
new SqlParameter("@BEGINTIME", SqlDbType.DateTime),
new SqlParameter("@ENDTIME", SqlDbType.DateTime)
};
para[0].Value = bikeReturn.VipId;
para[1].Value = bikeReturn.IsVip;
para[2].Value = new DateTime(1900, 1, 1, 0, 0, 0);
para[3].Value = new DateTime(2110, 12, 1, 0, 0, 0);
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
BikeReturn bikeTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
bikeTemp = new BikeReturn();
bikeTemp.VipId = (int)dt.Rows[i]["VIPID"];
bikeTemp.RbkId = (int)dt.Rows[i]["RBKID"];
bikeTemp.BbkId = (int)dt.Rows[i]["BBKID"];
bikeTemp.RbkTime = (DateTime)dt.Rows[i]["RBKTIME"];
bikeTemp.DpId = (int)dt.Rows[i]["DPID"];
bikeTemp.BuCost = double.Parse(dt.Rows[i]["BUCOST"].ToString());
bikeTemp.BuTime = (DateTime)dt.Rows[i]["BUTIME"];
bikeTemp.BrNumber = (int)dt.Rows[i]["BRNUMBER"];
bikeTemp.IsVip = (bool)dt.Rows[i]["ISVIP"];
bikeList.Add(bikeTemp);
}
return(bikeList);
}
catch (Exception ex)
{
except.ExceptionInsert("根据会员ID获得会员还车信息出错：" + ex.Message, "BikeReturnSelectByVipId", DateTime.Now);
return(null);
}
}
/// <summary>
/// 根据RBKID获得还车记录
/// </summary>
/// <returns></returns>
public BikeReturn BikeReturnSelectById(BikeReturn bikeReturn)
{
BikeReturn bikeReturnTemp = new BikeReturn();
try
{
bikeReturnTemp = bikeReturnDal.BikeReturnSelectById(bikeReturn);
TimeSpan timeSpan = bikeReturnTemp.BuTime - new DateTime(1900, 1, 1, 0, 0, 0);
bikeReturnTemp.BuTimeString = timeSpan.Days.ToString() + "天";
bikeReturnTemp.BuTimeString += timeSpan.Hours.ToString() + "小时";
bikeReturnTemp.BuTimeString += timeSpan.Minutes.ToString() + "分钟";
return(bikeReturnTemp);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 还车基本信息，直接调用数据库根据bikeReturn中的ISVIP字段判定是VIP还车还是非VIP还车
/// </summary>
/// <param name="bikeReturn"></param>
/// <returns></returns>
public int BikeReturnInsert(BikeReturn bikeReturn)
{
int result;
try
{
string sql = "BIKE_RETURN_INSERT";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BBKID", SqlDbType.Int),
new SqlParameter("@RBKTIME", SqlDbType.DateTime),
new SqlParameter("@VIPID", SqlDbType.Int),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@BRNUMBER", SqlDbType.Int),
new SqlParameter("@ISVIP", SqlDbType.Bit),
new SqlParameter("@USERID", SqlDbType.Int),
new SqlParameter("@RBKID", SqlDbType.Int)
};
para[0].Value = bikeReturn.BbkId;
para[1].Value = bikeReturn.RbkTime;
para[2].Value = bikeReturn.VipId;
para[3].Value = bikeReturn.DpId;
para[4].Value = bikeReturn.BrNumber;
para[5].Value = bikeReturn.IsVip;
para[6].Value = bikeReturn.UserId;
para[7].Direction = ParameterDirection.Output;
result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
if (result > 0)
{
result = (int)para[7].Value;
return(result);
}
else
{
return(result);
}
}
catch (Exception ex)
{
except.ExceptionInsert("添加还车记录出错：" + ex.Message, "BikeReturnInsert", DateTime.Now);
return(-1);
}
}
/// <summary>
/// 删除还车记录
/// </summary>
/// <param name="bikeReturn"></param>
/// <returns></returns>
public bool BikeReturnDelete(BikeReturn bikeReturn)
{
string sql = "BIKE_RETRUN_DELETE";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RBKID", SqlDbType.Int)
};
para[0].Value = bikeReturn.RbkId;
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("删除还车记录出错：" + ex.Message, "BikeReturnDelete", DateTime.Now);
return(false);
}
}
public List <BikeReturn> BikeReturnSelectByDpId(BikeReturn bikeReturn)
{
List <BikeReturn> bikeList = new List <BikeReturn>();
try
{
bikeList = bikeReturnDal.BikeReturnSelectByDpId(bikeReturn);
DateTime timeStart = new DateTime(1900, 1, 1, 0, 0, 0);
for (int i = 0; i < bikeList.Count; i++)
{
TimeSpan timeSpan = bikeList[i].BuTime - timeStart;
bikeList[i].BuTimeString = timeSpan.Days.ToString() + "天" + timeSpan.Hours.ToString() + "小时" + timeSpan.Minutes.ToString() + "分钟";
}
return(bikeList);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 获取所有还车记录
/// </summary>
/// <returns></returns>
public List <BikeReturn> BikeReturnSelect(DateTime beginTime, DateTime endTime)
{
string sql = "BIKE_RETURN_SELECT";
List <BikeReturn> listBikeReturn = new List <BikeReturn>();
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BEGINTIME", SqlDbType.DateTime),
new SqlParameter("@ENDTIME", SqlDbType.DateTime)
};
para[0].Value = beginTime;
para[1].Value = endTime;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null))
{
dt.Load(dr);
}
BikeReturn bikeReturnTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
bikeReturnTemp = new BikeReturn();
bikeReturnTemp.BbkId = Convert.ToInt32(dt.Rows[i]["BBKID"]);
bikeReturnTemp.RbkTime = Convert.ToDateTime(dt.Rows[i]["RBKTIME"]);
bikeReturnTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
bikeReturnTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
bikeReturnTemp.BuCost = Convert.ToDouble(dt.Rows[i]["BUCOST"]);
bikeReturnTemp.BuTime = Convert.ToDateTime(dt.Rows[i]["BUTIME"]);
bikeReturnTemp.BrNumber = Convert.ToInt32(dt.Rows[i]["BRNUMBER"]);
listBikeReturn.Add(bikeReturnTemp);
}
return(listBikeReturn);
}
catch (Exception ex)
{
except.ExceptionInsert("查询还车记录出错：" + ex.Message, "BikeReturnSelect", DateTime.Now);
return(null);
}
}
/// <summary>
/// 还车记录更新
/// </summary>
/// <param name="bikeReturn"></param>
/// <returns></returns>
public bool BikeReturnUpdate(BikeReturn bikeReturn)
{
int result;
try
{
string sql = "BORROW_KIND_UPDATE";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RBKID", SqlDbType.Int),
new SqlParameter("@BBKID", SqlDbType.Int),
new SqlParameter("@RBKTIME", SqlDbType.DateTime),
new SqlParameter("@VIPID", SqlDbType.Int),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@BUCOST", SqlDbType.Money),
new SqlParameter("@BUTIME", SqlDbType.DateTime),
new SqlParameter("@BRNUMBER", SqlDbType.Int),
new SqlParameter("@ISDELETE", SqlDbType.Bit)
};
para[0].Value = bikeReturn.RbkId;
para[1].Value = bikeReturn.BbkId;
para[2].Value = bikeReturn.RbkTime;
para[3].Value = bikeReturn.VipId;
para[4].Value = bikeReturn.DpId;
para[5].Value = bikeReturn.BuCost;
para[6].Value = bikeReturn.BuTime;
para[7].Value = bikeReturn.BrNumber;
para[8].Value = bikeReturn.IsDelete;
result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("修改还车记录出错：" + ex.Message, "BikeReturnUpdate", DateTime.Now);
return(false);
}
}
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;
}
/// <summary>
/// 还车记录添加
/// </summary>
/// <param name="bikeReturn">还车记录</param>
/// <returns>若还车数目大于租车数目则返回-2，若还车成功则返回1，若还车不成功则返回-1</returns>
public int BikeReturnInsert(BikeReturn bikeReturn)
{
return(bikeReturnDal.BikeReturnInsert(bikeReturn));
}
/// <summary>
/// 删除还车记录
/// </summary>
/// <param name="bikeReturn"></param>
/// <returns></returns>
public bool BikeReturnDelete(BikeReturn bikeReturn)
{
return(bikeReturnDal.BikeReturnDelete(bikeReturn));
}
/// <summary>
/// 还车记录更新
/// </summary>
/// <param name="bikeReturn"></param>
/// <returns></returns>
public bool BikeReturnUpdate(BikeReturn bikeReturn)
{
return(bikeReturnDal.BikeReturnUpdate(bikeReturn));
}
