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