public bool Recharge(VipMoney vipMoney) { string sql = "VIP_MONEY_RECHARGE"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPID", SqlDbType.Int), new SqlParameter("@VMBALANCE", SqlDbType.Money), new SqlParameter("@ISVIP", SqlDbType.Bit), new SqlParameter("@INTEGRAL", SqlDbType.Money) }; para[0].Value = vipMoney.VipId; para[1].Value = vipMoney.VmBalance; para[2].Value = vipMoney.IsVip; para[3].Value = vipMoney.Integral; int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(true); } catch (Exception ex) { except.ExceptionInsert("会员充值出错:" + ex.Message, "Recharge", DateTime.Now); return(false); } }
public VipMoney VipMoneySelectByVipId(VipMoney vipMoney) { string sql = "VIP_MONEY_SELECT_BY_VIPID"; dt = new DataTable(); try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPID", SqlDbType.Int), new SqlParameter("@ISVIP", SqlDbType.Bit) }; para[0].Value = vipMoney.VipId; para[1].Value = vipMoney.IsVip; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { dt.Load(dr); } VipMoney vipMoneyInfo = new VipMoney(); vipMoneyInfo.VmId = Convert.ToInt32(dt.Rows[0]["VMID"]); vipMoneyInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]); vipMoneyInfo.VmBalance = Convert.ToDouble(dt.Rows[0]["VMBALANCE"]); vipMoneyInfo.Integral = Convert.ToDouble(dt.Rows[0]["INTEGRAL"]); return(vipMoneyInfo); } catch (Exception ex) { except.ExceptionInsert("查询会员余额出错:" + ex.Message, "VipMoneySelectByVipId", DateTime.Now); return(null); } }
/// <summary> /// 会员余额更新 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool VipMoneyUpdate(VipMoney vipMoney) { int result; try { string sql = "VIP_MONEY_UPDATE"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPID", SqlDbType.Int), new SqlParameter("@VMBALANCE", SqlDbType.Money), new SqlParameter("@ISVIP", SqlDbType.Bit) }; para[0].Value = vipMoney.VipId; para[1].Value = vipMoney.VmBalance; para[2].Value = vipMoney.IsVip; result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("修改会员余额出错:" + ex.Message, "VipMoneyUpdate", DateTime.Now); return(false); } }
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { lvVip.BeginUpdate(); lvVip.Items.Clear(); VIPInfo vipTemp; labCount.Text = vipList.Count.ToString(); if (vipList.Count <= 0) { lvVip.EndUpdate(); MessageBox.Show("无会员信息"); progressBar1.Visible = false; btnOK.Enabled = true; return; } for (int i = 0; i < vipList.Count; i++) { vipTemp = vipList[i]; levelInfo.LvId = vipTemp.VipLevelId; levelInfo = levelBLL.VipLevelSelectById(levelInfo); moneyTemp.VipId = vipTemp.VipId; moneyTemp.IsVip = true; moneyTemp = moneyBLL.VipMoneySelectByVipId(moneyTemp); lvVip.Items.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].SubItems.Add(""); lvVip.Items[i].Tag = vipTemp; lvVip.Items[i].SubItems[0].Text = vipTemp.VipId.ToString(); lvVip.Items[i].SubItems[1].Text = vipTemp.VipNumber; lvVip.Items[i].SubItems[2].Text = vipTemp.VipName; lvVip.Items[i].SubItems[3].Text = moneyTemp.VmBalance.ToString(); lvVip.Items[i].SubItems[4].Text = moneyTemp.Integral.ToString(); lvVip.Items[i].SubItems[5].Text = levelInfo.LvName; lvVip.Items[i].SubItems[6].Text = vipTemp.VipSex == true ? "男" : "女"; lvVip.Items[i].SubItems[7].Text = vipTemp.VipPhone; lvVip.Items[i].SubItems[8].Text = vipTemp.VipCard; lvVip.Items[i].SubItems[9].Text = vipTemp.VipBirthDay.ToShortDateString(); lvVip.Items[i].SubItems[10].Text = vipTemp.VipAddress; lvVip.Items[i].SubItems[11].Text = vipTemp.AddDate.ToString(); lvVip.Items[i].SubItems[12].Text = vipTemp.Mark; lvVip.Items[i].SubItems.Add(vipTemp.VipPWD); } lvVip.EndUpdate(); progressBar1.Visible = false; btnOK.Enabled = true; }
/// <summary> /// 会员与非会员充值 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool Recharge(RechargeInfo vipMoney, double Integral) { VipMoney money = new VipMoney(); money.IsVip = vipMoney.IsVip; money.VipId = vipMoney.VipId; money.VmBalance = vipMoney.ChargeMoney; money.Integral = Integral; ///先去记录充值信息 vipMoneyDal.RechargeInfoAdd(vipMoney); //这里去充值 return(vipMoneyDal.Recharge(money)); }
public VipManageWindow(bool isAdmin) { InitializeComponent(); bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作,一般去查列表,这个列表在本页面内先声明,然后在这个dowork方法里去取数填充他 bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作,去到数后,这里取用去到的列表绑定到控件 vipModel = new VIPInfo(); vipBLL = new VipBLL(); departBLL = new DepartBLL(); departInfo = new DepartInfo(); levelBLL = new VipLevelBLL(); levelInfo = new VipLevelInfo(); moneyTemp = new VipMoney(); moneyBLL = new VipMoneyBLL(); IsAdmin = isAdmin; }
private void SelectMoneyLeft(int id, bool isVip) { VipMoney vipMoneyTemp = new VipMoney(); vipMoneyTemp.VipId = id; vipMoneyTemp.IsVip = isVip; try { vipMoneyTemp = moneyBLL.VipMoneySelectByVipId(vipMoneyTemp); txtVipNoMoneyLeft.Text = vipMoneyTemp.VmBalance.ToString(); } catch (Exception ex) { txtVipNoMoneyLeft.Text = ""; } }
/// <summary> /// 删除会员余额 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool VipMoneyDelete(VipMoney vipMoney) { string sql = "VIP_MONEY_DELETE"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VMID", SqlDbType.Int) }; para[0].Value = vipMoney.VmId; int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("删除会员余额出错:" + ex.Message, "VipMoneyDelete", DateTime.Now); return(false); } }
public VipReturnWindow(int id) { InitializeComponent(); vipMoneyTemp = new VipMoney(); vipMoneyTemp.VipId = id; vipMoneyTemp.IsVip = true; moneyBLL = new VipMoneyBLL(); vipInfo = new VIPInfo(); vipBLL = new VipBLL(); vipLVBLL = new VipLevelBLL(); dpBLL = new DepartBLL(); borrowBLL = new VipBorrowBLL(); borrowInfo = new VipBorrowInfo(); borrowKindBLL = new BorrowKindBLL(); bRetBLL = new BikeReturnBLL(); borrowInfo.VipId = id; vipInfo.VipId = id; first = true; returnBg.DoWork += new DoWorkEventHandler(returnBg_DoWork); returnBg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(returnBg_RunWorkerCompleted); }
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 FillVipNoMessage() { VipNoInfo vipNoTemp = new VipNoInfo(); vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId(vipNoInfo); txtVipNoNumber.Text = vipNoTemp.VipNumber; txtVipNoId.Text = vipNoTemp.VipId.ToString(); txtVipNoName.Text = vipNoTemp.VipName; txtVipNoPhone.Text = vipNoTemp.VipPhone; txtVipNoCard.Text = vipNoTemp.VipCard; txtVipNoMark.Text = vipNoTemp.Mark; int vipLV = vipNoTemp.LvId; VipLevelInfo levelInfo = new VipLevelInfo(); levelInfo.LvId = vipLV; levelInfo = vipLevelBLL.VipLevelSelectById(levelInfo); txtVipNoLevel.Text = levelInfo.LvName; int dpid = vipNoTemp.DpId; DepartInfo dpInfo = new DepartInfo(); dpInfo.DpId = dpid; dpInfo = dpBLL.DepartSelectById(dpInfo); txtDpId.Text = dpInfo.DpName; VipMoney vipMoney = new VipMoney(); VipMoneyBLL vipMoneyBll = new VipMoneyBLL(); vipMoney.VipId = vipNoTemp.VipId; vipMoney.IsVip = false; vipMoney = vipMoneyBll.VipMoneySelectByVipId(vipMoney); try { txtMoneyLeft.Text = vipMoney.VmBalance.ToString(); } catch (Exception) { } }
/// <summary> /// 获取所有会员余额 /// </summary> /// <returns></returns> public List <VipMoney> VipMoneySelect(bool isVip) { string sql = "VIP_MONEY_SELECT"; List <VipMoney> listVipMoney = new List <VipMoney>(); dt = new DataTable(); try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ISVIP", SqlDbType.Bit) }; para[0].Value = isVip; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { dt.Load(dr); } VipMoney vipMoneyTemp; //VMID,VIPID,VMBALANCE for (int i = 0; i < dt.Rows.Count; i++) { vipMoneyTemp = new VipMoney(); vipMoneyTemp.VmId = Convert.ToInt32(dt.Rows[i]["VMID"]); vipMoneyTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]); vipMoneyTemp.VmBalance = Convert.ToDouble(dt.Rows[i]["VMBALANCE"]); vipMoneyTemp.Integral = Convert.ToDouble(dt.Rows[i]["INTEGRAL"]); listVipMoney.Add(vipMoneyTemp); } return(listVipMoney); } catch (Exception ex) { except.ExceptionInsert("查询会员余额出错:" + ex.Message, "VipMoneySelect", DateTime.Now); return(null); } }
/// <summary> /// 根据LVID获得会员余额 /// </summary> /// <returns></returns> public VipMoney VipMoneySelectById(VipMoney vipMoney) { return(vipMoneyDal.VipMoneySelectById(vipMoney)); }
/// <summary> /// 会员余额添加 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool VipMoneyInsert(VipMoney vipMoney) { return(vipMoneyDal.VipMoneyInsert(vipMoney)); }
/// <summary> /// 会员余额更新 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool VipMoneyUpdate(VipMoney vipMoney) { return(vipMoneyDal.VipMoneyUpdate(vipMoney)); }
/// <summary> /// 删除会员余额 /// </summary> /// <param name="vipMoney"></param> /// <returns></returns> public bool VipMoneyDelete(VipMoney vipMoney) { return(vipMoneyDal.VipMoneyDelete(vipMoney)); }
//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); }