/// <summary> /// 获取所有非会员 /// </summary> /// <returns></returns> public List <VipNoInfo> VipNoSelect() { string sql = "VIP_NO_SELECT"; List <VipNoInfo> listVipNo = new List <VipNoInfo>(); dt = new DataTable(); try { using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null)) { dt.Load(dr); } VipNoInfo vipNoTemp; for (int i = 0; i < dt.Rows.Count; i++) { vipNoTemp = new VipNoInfo(); vipNoTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]); vipNoTemp.VipNumber = Convert.ToString(dt.Rows[i]["VIPNUMBER"]); vipNoTemp.VipName = Convert.ToString(dt.Rows[i]["VIPNAME"]); vipNoTemp.VipPwd = Convert.ToString(dt.Rows[i]["VIPPWD"]); vipNoTemp.VipPhone = Convert.ToString(dt.Rows[i]["VIPPWD"]); vipNoTemp.VipCard = Convert.ToString(dt.Rows[i]["VIPCARD"]); vipNoTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]); vipNoTemp.LvId = Convert.ToInt32(dt.Rows[i]["LVID"]); vipNoTemp.AddDate = (DateTime)dt.Rows[i]["ADDDATE"]; listVipNo.Add(vipNoTemp); } return(listVipNo); } catch (Exception ex) { except.ExceptionInsert("查询非会员出错:" + ex.Message, "VipNoSelect", DateTime.Now); return(null); } }
public VipNoInfo VipNoCheck(VipNoInfo vipNo) { VipNoInfo vipNoTemp = new VipNoInfo(); try { string sql = "VIP_NO_CHECK"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPNUMBER", SqlDbType.VarChar, 200), new SqlParameter("@VIPPWD", SqlDbType.VarChar, 50) }; para[0].Value = vipNo.VipNumber; para[1].Value = vipNo.VipPwd; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { while (dr.Read()) { vipNoTemp.VipId = (int)dr["VIPID"]; } } return(vipNoTemp); } catch (Exception ex) { except.ExceptionInsert("查询VIP信息出错:" + ex.Message, "VipNoCheck", DateTime.Now); return(null); } }
//根据非会员卡号 private void FillVipNoMessage(string VipNoCard) { try { VipNoInfo vipNoTemp = new VipNoInfo(); vipNoTemp = vipNoBLL.VipNoSelectByVIPNoNumber(VipNoCard); if (vipNoTemp == null) { epMessge.SetError(txtVipNoNumber, "该卡号不存在"); return; } epMessge.SetError(txtVipNoNumber, ""); if (int.Parse(cmbDeaprtNo.SelectedValue.ToString()) == vipNoTemp.DpId) { cmbVipNo.SelectedValue = vipNoTemp.VipId; } else { IsCardChang = true; cmbDeaprtNo.SelectedValue = vipNoTemp.DpId; vipNoId = vipNoTemp.VipId; } } catch (Exception ex) { } }
public ChangeVipNoWindow(int id) { InitializeComponent(); VipId = id; vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); levelBLL = new VipLevelBLL(); vipNoInfo.VipId = id; }
public VipNoManageWindow(bool isAdmin) { InitializeComponent(); bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作,一般去查列表,这个列表在本页面内先声明,然后在这个dowork方法里去取数填充他 bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作,去到数后,这里取用去到的列表绑定到控件 vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); departBLL = new DepartBLL(); IsAdmin = isAdmin; }
public BeforeBorrow(bool isvip, bool isBorrow) { InitializeComponent(); isVip = isvip; vipBLL = new VipBLL(); vipInfo = new VIPInfo(); vipNoBLL = new VipNoBLL(); vipNoInfo = new VipNoInfo(); IsBorrow = isBorrow; }
public BeforeBorrow(string num, bool isvip, bool isBorrow) { InitializeComponent(); txtCard.Text = num; isVip = isvip; vipBLL = new VipBLL(); vipInfo = new VIPInfo(); vipNoBLL = new VipNoBLL(); vipNoInfo = new VipNoInfo(); IsBorrow = isBorrow; }
public AddVipNoWindow() { InitializeComponent(); levelBLL = new VipLevelBLL(); bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作,一般去查列表,这个列表在本页面内先声明,然后在这个dowork方法里去取数填充他 bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作,去到数后,这里取用去到的列表绑定到控件 departBLL = new DepartBLL(); vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); vipLevelList = new List <VipLevelInfo>(); }
public VipNoBorrowWindow(int id) { InitializeComponent(); vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); vipLevelBLL = new VipLevelBLL(); dpBLL = new DepartBLL(); borrowKindBLL = new BorrowKindBLL(); vipNoInfo.VipId = id; vipNoBorrowBLL = new VipNoBorrowBLL(); }
private void btnvipNoSearch_Click(object sender, EventArgs e) { vipNoTemp = null; if (!IsCardSelect) { try { vipNoId = (int)cmbVipNoId.SelectedValue; } catch (Exception) { MessageBox.Show("请选择非会员"); return; } IsCardSelect = false; vipNoTemp = vipNoList.Find(item => item.VipId == vipNoId); } else { string vipNoNumber = txtVipNoNumber.Text.Trim(); vipNoTemp = vipNoList.Find(item => item.VipNumber == vipNoNumber); if (vipNoTemp == null) { progressBar2.Visible = true; btnvipNoSearch.Enabled = false; backgroundWorker1.RunWorkerAsync(); return; } cmbVipNoId.SelectedValue = vipNoTemp.VipId; IsCardSelect = false; } if (vipNoTemp == null) { MessageBox.Show("无该会员信息!"); return; } txtVipNoNumber.Text = vipNoTemp.VipNumber; txtMark.Text = vipNoTemp.Mark; txtVipNoPhone.Text = vipNoTemp.VipPhone; txtVipNoCard.Text = vipNoTemp.VipCard; txtMark.Text = vipNoTemp.Mark; int vipLV = vipNoTemp.LvId; VipLevelInfo levelInfo = new VipLevelInfo(); levelInfo.LvId = vipLV; levelInfo = vipLVBLL.VipLevelSelectById(levelInfo); txtVipNoLevel.Text = levelInfo.LvName; vipNoId = vipNoTemp.VipId; SelectMoneyLeft(vipNoId, false); }
public List <VipNoInfo> VipNoSelectByDPId(VipNoInfo vipNo) { string sql = "VIP_NO_SELECT_BY_DPID"; dt = new DataTable(); List <VipNoInfo> vipNoList = new List <VipNoInfo>(); try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DPID", SqlDbType.Int) }; para[0].Value = vipNo.DpId; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { dt.Load(dr); } VipNoInfo vipNoInfo; for (int i = 0; i < dt.Rows.Count; i++) { vipNoInfo = new VipNoInfo(); vipNoInfo.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]); vipNoInfo.VipNumber = Convert.ToString(dt.Rows[i]["VIPNUMBER"]); vipNoInfo.VipName = Convert.ToString(dt.Rows[i]["VIPNAME"]); vipNoInfo.VipPwd = Convert.ToString(dt.Rows[i]["VIPPWD"]); vipNoInfo.VipPhone = Convert.ToString(dt.Rows[i]["VIPPHONE"]); vipNoInfo.VipCard = Convert.ToString(dt.Rows[i]["VIPCARD"]); vipNoInfo.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]); vipNoInfo.LvId = Convert.ToInt32(dt.Rows[i]["LVID"]); vipNoInfo.AddDate = (DateTime)dt.Rows[i]["ADDDATE"]; try { vipNoInfo.Mark = dt.Rows [i]["MARK"].ToString(); } catch (Exception) { vipNoInfo.Mark = ""; } vipNoList.Add(vipNoInfo); } return(vipNoList); } catch (Exception ex) { except.ExceptionInsert("查询非会员出错:" + ex.Message, "VipNoSelectByDPId", DateTime.Now); return(null); } }
public VipNoReturnWindow(int id) { InitializeComponent(); vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); //vipLVBLL = new VipLevelBLL(); //dpBLL = new DepartBLL(); vnBorrowBLL = new VipNoBorrowBLL(); vnBorrow = new VipNoBorrow(); borrowKindBLL = new BorrowKindBLL(); bRetBLL = new BikeReturnBLL(); vnBorrow.VipId = id; vipNoInfo.VipId = id; first = true; }
public ReChargeWindow(bool isAdmin) { InitializeComponent(); chargeMoney = 0; vipBLL = new VipBLL(); vipInfo = new VIPInfo(); vipLVBLL = new VipLevelBLL(); dpBLL = new DepartBLL(); moneyBLL = new VipMoneyBLL(); vipNoInfo = new VipNoInfo(); bgWord.DoWork += new DoWorkEventHandler(bgWord_DoWork); bgWord.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bgWord_RunWorkerCompleted); bgWord.ProgressChanged += new ProgressChangedEventHandler(bgWord_ProgressChanged); bgWord.WorkerReportsProgress = true; IsAdmin = isAdmin; }
private void btnOK_Click(object sender, EventArgs e) { if (txtCard.Text.Trim() == "") { epMessage.SetError(txtCard, "请刷入卡号或姓名!"); return; } if (txtPwd.Text.Trim() == "") { epMessage.SetError(txtPwd, "请输入密码!"); return; } if (isVip) { vipInfo.VipNumber = txtCard.Text.Trim(); vipInfo.VipPWD = txtPwd.Text.Trim(); vipInfo = vipBLL.VipCheck(vipInfo); if (vipInfo.VipId == 0) { MessageBox.Show("租车密码与卡号不相符!"); } else { isTrue = true; vipId = vipInfo.VipId; this.Close(); } } else { vipNoInfo.VipNumber = txtCard.Text.Trim(); vipNoInfo.VipPwd = txtPwd.Text.Trim(); vipNoInfo = vipNoBLL.VipNoCheck(vipNoInfo); if (vipNoInfo.VipId == 0) { MessageBox.Show("租车密码与卡号不相符!"); } else { isTrue = true; vipId = vipNoInfo.VipId; this.Close(); } } }
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; }
public VipNoCharge(bool isAdmin) { InitializeComponent(); vipLVBLL = new VipLevelBLL(); dpBLL = new DepartBLL(); moneyBLL = new VipMoneyBLL(); vipNoInfo = new VipNoInfo(); vipNoBLL = new VipNoBLL(); bgWord.DoWork += new DoWorkEventHandler(bgWord_DoWork); bgWord.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bgWord_RunWorkerCompleted); bgWord.ProgressChanged += new ProgressChangedEventHandler(bgWord_ProgressChanged); bgWord.WorkerReportsProgress = true; vipNoChangeBg.DoWork += new DoWorkEventHandler(vipNoChangeBg_DoWork); vipNoChangeBg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(vipNoChangeBg_RunWorkerCompleted); vipNoChangeBg.ProgressChanged += new ProgressChangedEventHandler(vipNoChangeBg_ProgressChanged); vipNoChangeBg.WorkerReportsProgress = true; IsAdmin = isAdmin; }
/// <summary> /// 根据卡号获得非会员 /// </summary> /// <returns></returns> public VipNoInfo VipNoSelectByVIPNoNumber(string vipNumber) { string sql = "VIP_NO_SELECT_BY_VIPNUMBER"; dt = new DataTable(); try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPNUMBER", SqlDbType.VarChar, 200) }; para[0].Value = vipNumber; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { dt.Load(dr); } VipNoInfo vipNoInfo = new VipNoInfo(); vipNoInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]); vipNoInfo.VipNumber = Convert.ToString(dt.Rows[0]["VIPNUMBER"]); vipNoInfo.VipName = Convert.ToString(dt.Rows[0]["VIPNAME"]); vipNoInfo.VipPwd = Convert.ToString(dt.Rows[0]["VIPPWD"]); vipNoInfo.VipPhone = Convert.ToString(dt.Rows[0]["VIPPWD"]); vipNoInfo.VipCard = Convert.ToString(dt.Rows[0]["VIPCARD"]); vipNoInfo.DpId = Convert.ToInt32(dt.Rows[0]["DPID"]); vipNoInfo.LvId = Convert.ToInt32(dt.Rows[0]["LVID"]); vipNoInfo.AddDate = (DateTime)dt.Rows[0]["ADDDATE"]; try { vipNoInfo.Mark = dt.Rows [0]["MARK"].ToString(); } catch (Exception) { vipNoInfo.Mark = ""; } return(vipNoInfo); } catch (Exception ex) { except.ExceptionInsert("查询非会员出错:" + ex.Message, "VipNoSelectByVIPNoNumber", DateTime.Now); return(null); } }
/// <summary> /// 删除非会员 /// </summary> /// <param name="vipNo"></param> /// <returns></returns> public bool VipNoDelete(VipNoInfo vipNo) { string sql = "VIP_NO_DELETE"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPID", SqlDbType.Int) }; para[0].Value = vipNo.VipId; int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("删除非会员出错:" + ex.Message, "VipNoDelete", DateTime.Now); return(false); } }
private void GetVipNoInfoById(object vipNo) { VipNoInfo vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId((VipNoInfo)vipNo); this.Invoke(new Action(() => { txtVipNoNumber.Text = vipNoTemp.VipNumber; txtVipNoName.Text = vipNoTemp.VipName; txtVipNoPWD.Text = vipNoTemp.VipPwd; txtVipNoPhone.Text = vipNoTemp.VipPhone; txtVipNoCard.Text = vipNoTemp.VipCard; txtMark.Text = vipNoTemp.Mark; cmbLevel.SelectedValue = vipNoTemp.LvId; vipNoDpId = vipNoTemp.DpId; departInfo = new DepartInfo(); departBLL = new DepartBLL(); departInfo.DpId = vipNoTemp.DpId; departInfo = departBLL.DepartSelectById(departInfo); txtDPID.Text = departInfo.DpName; })); }
//根据非会员ID private void FillVipNoMessage() { try { int id = Int32.Parse(cmbVipNo.SelectedValue.ToString()); VipNoInfo vipNoTemp = new VipNoInfo(); vipNoTemp.VipId = id; vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId(vipNoTemp); txtVipNoNumber.Text = vipNoTemp.VipNumber; txtVipNoPhone.Text = vipNoTemp.VipPhone; txtVipNoCard.Text = vipNoTemp.VipCard; int vipLV = vipNoTemp.LvId; VipLevelInfo levelInfo = new VipLevelInfo(); levelInfo.LvId = vipLV; levelInfo = vipLVBLL.VipLevelSelectById(levelInfo); txtVipNoLevel.Text = levelInfo.LvName; } catch (Exception ex) { } }
private void FillVipNoId() { try { List <VipNoInfo> vipNoList = new List <VipNoInfo>(); VipNoInfo vipNoTemp = new VipNoInfo(); vipNoTemp.DpId = Int32.Parse(cmbDeaprtNo.SelectedValue.ToString()); vipNoList = vipNoBLL.VipNoSelectByDPId(vipNoTemp); cmbVipNo.DataSource = vipNoList; cmbVipNo.DisplayMember = "VIPNAME"; cmbVipNo.ValueMember = "VIPID"; VNFirst = false; if (IsCardChang) { IsCardChang = false; cmbVipNo.SelectedValue = vipNoId; } } catch (Exception ex) { } }
/// <summary> /// 非会员更新 /// </summary> /// <param name="vipNo"></param> /// <returns></returns> public bool VipNoUpdate(VipNoInfo vipNo) { int result; try { string sql = "VIP_NO_UPDATE"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@VIPID", SqlDbType.Int), new SqlParameter("@VIPNUMBER", SqlDbType.VarChar, 200), new SqlParameter("@VIPNAME", SqlDbType.VarChar, 50), new SqlParameter("@VIPPWD", SqlDbType.VarChar, 50), new SqlParameter("@VIPPHONE", SqlDbType.VarChar, 50), new SqlParameter("@VIPCARD", SqlDbType.VarChar, 200), new SqlParameter("@DPID", SqlDbType.Int), new SqlParameter("@LVID", SqlDbType.Int), new SqlParameter("@MARK", SqlDbType.VarChar, 1000) }; para[0].Value = vipNo.VipId; para[1].Value = vipNo.VipNumber; para[2].Value = vipNo.VipName; para[3].Value = vipNo.VipPwd; para[4].Value = vipNo.VipPhone; para[5].Value = vipNo.VipCard; para[6].Value = vipNo.DpId; para[7].Value = vipNo.LvId; para[8].Value = vipNo.Mark; result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("修改非会员出错:" + ex.Message, "VipNoUpdate", DateTime.Now); return(false); } }
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) { } }
private void 除非会员ToolStripMenuItem_Click(object sender, EventArgs e) { if (lvVipNo.SelectedItems.Count != 1) { MessageBox.Show("请选择一行!"); } else { DialogResult result = MessageBox.Show("该操作不可逆,请问您确认删除该会员吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } int id = Convert.ToInt32(lvVipNo.SelectedItems[0].Tag); string vipNoName = lvVipNo.SelectedItems[0].SubItems[2].Text; vipNoInfo = new VipNoInfo(); vipNoInfo.VipId = id; vipNoInfo.VipName = vipNoName; Thread th = new Thread(new ParameterizedThreadStart(BtnDeleteClick)); th.IsBackground = true; th.Start(vipNoInfo); } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker1.ReportProgress(20); vipNoTemp = vipNoBLL.VipNoSelectByVIPNoNumber(txtVipNoNumber.Text.Trim()); backgroundWorker1.ReportProgress(70); }
public VipNoInfo VipNoCheck(VipNoInfo vipNo) { return(vipNoDal.VipNoCheck(vipNo)); }
public List <VipNoInfo> VipNoSelectByDPId(VipNoInfo vipNo) { return(vipNoDal.VipNoSelectByDPId(vipNo)); }
/// <summary> /// 根据VIPID获得非会员 /// </summary> /// <returns></returns> public VipNoInfo VipNoSelectByVIPNoId(VipNoInfo vipNo) { return(vipNoDal.VipNoSelectByVIPNoId(vipNo)); }
/// <summary> /// 删除非会员 /// </summary> /// <param name="vipNo"></param> /// <returns></returns> public bool VipNoDelete(VipNoInfo vipNo) { return(vipNoDal.VipNoDelete(vipNo)); }
/// <summary> /// 非会员添加 /// </summary> /// <param name="vipNo"></param> /// <returns></returns> public bool VipNoInsert(VipNoInfo vipNo) { return(vipNoDal.VipNoInsert(vipNo)); }