/// <summary>
/// 获取所有会员租车
/// </summary>
/// <returns></returns>
public List <VipBorrowInfo> VipBorrowSelect()
{
string sql = "VIP_BORROW_SELECT";
List <VipBorrowInfo> listVipBorrow = new List <VipBorrowInfo>();
dt = new DataTable();
try
{
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null))
{
dt.Load(dr);
}
VipBorrowInfo vipBorrowTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipBorrowTemp = new VipBorrowInfo();
vipBorrowTemp.BbkId = Convert.ToInt32(dt.Rows[i]["BBKID"]);
vipBorrowTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipBorrowTemp.BbkTime = Convert.ToDateTime(dt.Rows[i]["BBKTIME"]);
vipBorrowTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
vipBorrowTemp.BbkNumber = Convert.ToInt32(dt.Rows[i]["BBKNUM"]);
vipBorrowTemp.RkrId = Convert.ToInt32(dt.Rows[i]["RKRID"]);
vipBorrowTemp.IsReturn = (bool)dt.Rows[i]["ISRETURN"];
vipBorrowTemp.LeftNum = (int)dt.Rows[i]["LEFTNUM"];
listVipBorrow.Add(vipBorrowTemp);
}
return(listVipBorrow);
}
catch (Exception ex)
{
except.ExceptionInsert("查询会员租车出错：" + ex.Message, "VipBorrowSelect", DateTime.Now);
return(null);
}
}
private void cmbBorrowTimeSelectedIndexChanged(object id)
{
this.Invoke(new Action(() =>
{
VipBorrowInfo borrowTemp = new VipBorrowInfo();
borrowTemp.BbkId = (int)id;
//borrowTemp = borrowBLL.VipBorrowSelectById(borrowTemp);//NZZ2014-08-03修改为下面一句话
borrowTemp = borrowList.Find(item => item.BbkId == (int)id);
BorrowKind borrowKind = new BorrowKind();
borrowKind.BkId = borrowTemp.RkrId;
txtKind.Text = borrowKindBLL.BorrowKindSelectById(borrowKind).BbkName;
txtBorrowNum.Text = borrowTemp.BbkNumber.ToString();
txtUnReturn.Text = borrowTemp.LeftNum.ToString();
txtBorrowMark.Text = borrowTemp.Mark;
if (borrowTemp.IsNight)
{
labNightCost.ForeColor = Color.Red;
labNightCost.Text = "包夜租车";
}
else
{
labNightCost.Text = "";
}
}));
}
private void btnOKClick()
{
this.Invoke(new Action(() =>
{
int result = 0;
VipBorrowInfo borrowInfo = new VipBorrowInfo();
borrowInfo.BbkNumber = int.Parse(txtNum.Text.Trim());
borrowInfo.BbkTime = DateTime.Now;
borrowInfo.DpId = StaticData.departLocal.DpId;
borrowInfo.VipId = int.Parse(txtVIPNum.Text.Trim());
borrowInfo.UserId = StaticData.userLocal.UserId;
borrowInfo.Mark = txtMark.Text.Trim();
if ((int)cmbKind.SelectedValue == 1)
{
borrowInfo.RkrId = 1;
result = vipBorrowBLL.VipBorrowInsert(borrowInfo, 1);
}
else if ((int)cmbKind.SelectedValue == 2)
{
borrowInfo.RkrId = 2;
result = vipBorrowBLL.VipBorrowInsert(borrowInfo, 2);
}
else if ((int)cmbKind.SelectedValue == 3)
{
borrowInfo.RkrId = 3;
result = vipBorrowBLL.VipBorrowInsert(borrowInfo, 3);
}
if (result == -2)
{
MessageBox.Show("该用户余额不足以支付起始扣费金额，请充值!");
CheckMiGo miGo = new CheckMiGo();
miGo.ShowDialog();
if (miGo.isTrue)
{
ReChargeWindow rechargeWinodw = new ReChargeWindow(true);
rechargeWinodw.ShowDialog();
txtBalance.Text = (double.Parse(txtBalance.Text) + rechargeWinodw.chargeMoney).ToString();
}
}
else if (result == -1)
{
MessageBox.Show("系统出错，请联系管理员!");
}
else if (result == 1)
{
MessageBox.Show("租车成功!");
btnOK.Enabled = false;
LogInfo logInfo = new LogInfo();
logInfo.UserId = StaticData.userLocal.UserId;
logInfo.Content = "为会员‘" + txtVipName.Text + "'租车" + txtNum.Text.ToString() + "辆";
logInfo.LogTime = DateTime.Now;
logInfo.DpId = StaticData.departLocal.DpId;
bool b = new LogBLL().LogInsert(logInfo);
this.Close();
}
}));
}
public List <VipBorrowInfo> VipBorrowSelectByDpIdAndTime(int dpId, DateTime startTime, DateTime endTime)
{
string sql = "VIP_BORROW_SELECT_BY_DPID_AND_TIME";
List <VipBorrowInfo> listVipBorrow = new List <VipBorrowInfo>();
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@STARTTIME", SqlDbType.DateTime),
new SqlParameter("@ENDTIME", SqlDbType.DateTime)
};
para[0].Value = dpId;
para[1].Value = startTime;
para[2].Value = endTime;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
VipBorrowInfo vipBorrowTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipBorrowTemp = new VipBorrowInfo();
vipBorrowTemp.BbkId = Convert.ToInt32(dt.Rows[i]["BBKID"]);
vipBorrowTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipBorrowTemp.BbkTime = Convert.ToDateTime(dt.Rows[i]["BBKTIME"]);
vipBorrowTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
vipBorrowTemp.BbkNumber = Convert.ToInt32(dt.Rows[i]["BBKNUM"]);
vipBorrowTemp.RkrId = Convert.ToInt32(dt.Rows[i]["RKRID"]);
vipBorrowTemp.IsReturn = (bool)dt.Rows[i]["ISRETURN"];
vipBorrowTemp.LeftNum = (int)dt.Rows[i]["LEFTNUM"];
vipBorrowTemp.IsNight = (bool)dt.Rows[i]["ISNIGHT"];
try
{
vipBorrowTemp.Mark = dt.Rows[i]["MARK"].ToString();
}
catch (Exception)
{
vipBorrowTemp.Mark = "";
}
listVipBorrow.Add(vipBorrowTemp);
}
return(listVipBorrow);
}
catch (Exception ex)
{
except.ExceptionInsert("查询会员租车出错：" + ex.Message, "VipBorrowSelectByDpId", DateTime.Now);
return(null);
}
}
/// <summary>
/// 会员租车添加
/// </summary>
/// <param name="vipBorrow">租车记录</param>
/// <param name="bkid">租车类型ID</param>
/// <returns>若余额不足返回-2，若租车成功返回1，若租车不成功返回-1</returns>
public int VipBorrowInsert(VipBorrowInfo vipBorrow, int bkid)
{
int result;
try
{
string sql = "VIP_BORROW_INSERT";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int),
new SqlParameter("@BBKTIME", SqlDbType.DateTime),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@BBKNUM", SqlDbType.Int),
new SqlParameter("@BKID", SqlDbType.Int),
new SqlParameter("@USERID", SqlDbType.Int),
new SqlParameter("@RETURN", SqlDbType.Int),
new SqlParameter("@MARK", SqlDbType.VarChar, 1000)
};
para[0].Value = vipBorrow.VipId;
para[1].Value = vipBorrow.BbkTime;
para[2].Value = vipBorrow.DpId;
para[3].Value = vipBorrow.BbkNumber;
para[4].Value = bkid;
para[5].Value = vipBorrow.UserId;
para[para.Length - 2].Direction = ParameterDirection.ReturnValue;
if (vipBorrow.Mark == null)
{
vipBorrow.Mark = "";
}
para[7].Value = vipBorrow.Mark;
result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
int rtn = int.Parse(para[6].Value.ToString());
if (rtn == -2)
{
//若余额不足
return(rtn);
}
return(result > 0 ? 1 : -1);
}
catch (Exception ex)
{
except.ExceptionInsert("添加会员租车出错：" + ex.Message, "VipBorrowInsert", DateTime.Now);
return(-1);
}
}
/// <summary>
/// 填充租车信息
/// </summary>
private void FillVipBorrowMessage()
{
try
{
if (borrowList == null || borrowList.Count == 0)
{
DialogResult result = MessageBox.Show("该用户没有需要还的车辆!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No || result == DialogResult.Yes)
{
isDispose = true;
}
this.Close();
return;
}
cmbBorrowTime.DataSource = borrowList;
cmbBorrowTime.DisplayMember = "BBKTIME";
cmbBorrowTime.ValueMember = "BBKID";
first = false;
int id = (int)cmbBorrowTime.SelectedValue;
VipBorrowInfo borrowTemp = new VipBorrowInfo();
borrowTemp.BbkId = id;
borrowTemp = borrowBLL.VipBorrowSelectById(borrowTemp);
BorrowKind borrowKind = new BorrowKind();
borrowKind.BkId = borrowTemp.RkrId;
txtKind.Text = borrowKindBLL.BorrowKindSelectById(borrowKind).BbkName;
txtBorrowNum.Text = borrowTemp.BbkNumber.ToString();
txtUnReturn.Text = borrowTemp.LeftNum.ToString();
txtBorrowT.Text = borrowList[0].Times.ToString();
txtBorrowMark.Text = borrowTemp.Mark;
if (borrowTemp.IsNight)
{
labNightCost.ForeColor = Color.Red;
labNightCost.Text = "包夜租车";
}
else
{
labNightCost.Text = "";
}
}
catch (Exception)
{
MessageBox.Show("网络不稳定，请重新加载！");
}
}
/// <summary>
/// 根据BBKID获得会员租车信息
/// </summary>
/// <returns></returns>
public VipBorrowInfo VipBorrowSelectById(VipBorrowInfo vipBorrow)
{
string sql = "VIP_BORROW_SELECT_BY_ID";
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BBKID", SqlDbType.Int)
};
para[0].Value = vipBorrow.BbkId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
//BBKID,VIPID,BBKTIME,DPID,BBKNUM
VipBorrowInfo vipBorrowInfo = new VipBorrowInfo();
vipBorrowInfo.BbkId = Convert.ToInt32(dt.Rows[0]["BBKID"]);
vipBorrowInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]);
vipBorrowInfo.BbkTime = Convert.ToDateTime(dt.Rows[0]["BBKTIME"]);
vipBorrowInfo.DpId = Convert.ToInt32(dt.Rows[0]["DPID"]);
vipBorrowInfo.BbkNumber = Convert.ToInt32(dt.Rows[0]["BBKNUM"]);
vipBorrowInfo.RkrId = Convert.ToInt32(dt.Rows[0]["RKRID"]);
vipBorrowInfo.IsReturn = (bool)dt.Rows[0]["ISRETURN"];
vipBorrowInfo.LeftNum = (int)dt.Rows[0]["LEFTNUM"];
vipBorrowInfo.IsNight = (bool)dt.Rows[0]["ISNIGHT"];
try
{
vipBorrowInfo.Mark = dt.Rows[0]["MARK"].ToString();
}
catch (Exception)
{
vipBorrowInfo.Mark = "";
}
return(vipBorrowInfo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询会员租车出错：" + ex.Message, "VipBorrowSelectById", DateTime.Now);
return(null);
}
}
/// <summary>
/// 删除会员租车
/// </summary>
/// <param name="vipBorrow"></param>
/// <returns></returns>
public bool VipBorrowDelete(VipBorrowInfo vipBorrow)
{
string sql = "VIP_BORROW_DELETE";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BBKID", SqlDbType.Int)
};
para[0].Value = vipBorrow.BbkId;
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("删除会员租车出错：" + ex.Message, "VipBorrowDelete", DateTime.Now);
return(false);
}
}
public BorrowReturnWindow(bool isAdmin)
{
InitializeComponent();
bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作，一般去查列表，这个列表在本页面内先声明，然后在这个dowork方法里去取数填充他
bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作，去到数后，这里取用去到的列表绑定到控件
vipBorrowBLL = new VipBorrowBLL();
vipNoBLL = new VipNoBLL();
departBLL = new DepartBLL();
depart = new DepartInfo();
departList = new List <DepartInfo>();
vipBorrow = new VipBorrowInfo();
vipBorrowList = new List <VipBorrowInfo>();
vipNoBorrow = new VipNoBorrow();
vipNoBorrowList = new List <VipNoBorrow>();
vipBLL = new VipBLL();
vipLvBLL = new VipLevelBLL();
vipNoBorrowBLL = new VipNoBorrowBLL();
bikeReturnBLL = new BikeReturnBLL();
IsAdmin = isAdmin;
}
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);
}
/// <summary>
/// 根据BBKID获得会员租车信息
/// </summary>
/// <returns></returns>
public VipBorrowInfo VipBorrowSelectById(VipBorrowInfo vipBorrow)
{
return(vipBorrowDal.VipBorrowSelectById(vipBorrow));
}
/// <summary>
/// 删除会员租车
/// </summary>
/// <param name="vipBorrow"></param>
/// <returns></returns>
public bool VipBorrowDelete(VipBorrowInfo vipBorrow)
{
return(vipBorrowDal.VipBorrowDelete(vipBorrow));
}
/// <summary>
/// 会员租车添加
/// </summary>
/// <param name="vipBorrow">租车记录</param>
/// <param name="bkid">租车类型ID</param>
/// <returns>若余额不足返回-2，若租车成功返回1，若租车不成功返回-1</returns>
public int VipBorrowInsert(VipBorrowInfo vipBorrow, int bkid)
{
return(vipBorrowDal.VipBorrowInsert(vipBorrow, bkid));
}
/// <summary>
/// 取消包夜功能
/// </summary>
/// <param name="BBID">租车ID</param>
/// <param name="isVip">是否为会员</param>
/// <returns></returns>
public bool notNightBorrow(VipBorrowInfo vipBorrowTemp)
{
return(vipBorrowDal.notNightBorrow(vipBorrowTemp.BbkId.ToString(), true));
}
private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (bikeNoList != null)
{
bikeList.AddRange(bikeNoList);
}
if (bikeList == null || bikeList.Count == 0)
{
MessageBox.Show("未查询到相应还车信息!");
lvReturnMessage.Items.Clear();
progressBar1.Visible = false;
btnOK.Enabled = true;
return;
}
lvReturnMessage.BeginUpdate();
lvReturnMessage.Items.Clear();
for (int i = 0; i < bikeList.Count; i++)
{
lvReturnMessage.Items.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
lvReturnMessage.Items[i].SubItems.Add("");
if (bikeList[i].IsVip)
{
vipTemp.VipId = bikeList[i].VipId;
vipTemp = vipBLL.VipSelectById(vipTemp);
departTemp.DpId = bikeList[i].DpId;
departTemp = departBLL.DepartSelectById(departTemp);
vipLvInfo.LvId = vipTemp.VipLevelId;
vipLvInfo = vipLvBLL.VipLevelSelectById(vipLvInfo);
vipBorrow.BbkId = bikeList[i].BbkId;
vipBorrow = vipBorrowBLL.VipBorrowSelectById(vipBorrow);
lvReturnMessage.Items[i].SubItems[0].Text = vipTemp.VipNumber;
lvReturnMessage.Items[i].SubItems[1].Text = vipTemp.VipName;
lvReturnMessage.Items[i].SubItems[2].Text = vipLvInfo.LvName;
lvReturnMessage.Items[i].SubItems[3].Text = vipBorrow.BbkTime.ToString();
lvReturnMessage.Items[i].SubItems[4].Text = bikeList[i].BrNumber.ToString();
lvReturnMessage.Items[i].SubItems[5].Text = kind[vipBorrow.RkrId];
lvReturnMessage.Items[i].SubItems[6].Text = bikeList[i].RbkTime.ToString();
lvReturnMessage.Items[i].SubItems[7].Text = bikeList[i].BuTimeString;
lvReturnMessage.Items[i].SubItems[8].Text = bikeList[i].BuCost.ToString();
lvReturnMessage.Items[i].SubItems[9].Text = departTemp.DpName;
}
else
{
vipNoTemp.VipId = bikeList[i].VipId;
vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId(vipNoTemp);
departTemp.DpId = bikeList[i].DpId;
departTemp = departBLL.DepartSelectById(departTemp);
vipLvInfo.LvId = vipNoTemp.LvId;
vipLvInfo = vipLvBLL.VipLevelSelectById(vipLvInfo);
vipNoBorrowTemp.BbkId = bikeList[i].BbkId;
vipNoBorrowTemp = vipNoBorrowBLL.VipNoBorrowSelectByBBKId(vipNoBorrowTemp);
lvReturnMessage.Items[i].SubItems[0].Text = vipNoTemp.VipNumber;
lvReturnMessage.Items[i].SubItems[1].Text = vipNoBorrowTemp.VnName;
lvReturnMessage.Items[i].SubItems[2].Text = vipLvInfo.LvName;
lvReturnMessage.Items[i].SubItems[3].Text = vipNoBorrowTemp.BbkTime.ToString();
lvReturnMessage.Items[i].SubItems[4].Text = bikeList[i].BrNumber.ToString();
lvReturnMessage.Items[i].SubItems[5].Text = kind[vipNoBorrowTemp.RkrId];
lvReturnMessage.Items[i].SubItems[6].Text = bikeList[i].RbkTime.ToString();
lvReturnMessage.Items[i].SubItems[7].Text = bikeList[i].BuTimeString;
lvReturnMessage.Items[i].SubItems[8].Text = bikeList[i].BuCost.ToString();
lvReturnMessage.Items[i].SubItems[9].Text = departTemp.DpName;
}
}
lvReturnMessage.EndUpdate();
progressBar1.Visible = false;
btnOK.Enabled = true;
}
