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