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