private void btnOKClick(object vipNoBorrow)
{
this.Invoke(new Action(() =>
{
VipNoBorrow vipNoBorrowModel = vipNoBorrow as VipNoBorrow;
if (vipNoBorrowBLL.VipNoBorrowInsert(vipNoBorrowModel, vipNoBorrowModel.RkrId) == 1)
{
MessageBox.Show("租车成功");
LogInfo logInfo = new LogInfo();
logInfo.UserId = StaticData.userLocal.UserId;
logInfo.Content = "为非会员‘" + txtVipNoName.Text + "'租车" + txtVNNumber.Text.ToString() + "辆";
logInfo.LogTime = DateTime.Now;
logInfo.DpId = StaticData.departLocal.DpId;
bool b = new LogBLL().LogInsert(logInfo);
this.Close();
txtVNCard.Text = "";
txtVNName.Text = "";
txtVNNumber.Text = "";
txtVNPhone.Text = "";
}
else if (vipNoBorrowBLL.VipNoBorrowInsert(vipNoBorrowModel, vipNoBorrowModel.RkrId) == -1)
{
MessageBox.Show("租车失败");
}
else if (vipNoBorrowBLL.VipNoBorrowInsert(vipNoBorrowModel, vipNoBorrowModel.RkrId) == -2)
{
MessageBox.Show("余额不足，请先充值");
}
}));
}
private void SelectIndexThread(object id)
{
this.Invoke(new Action(() =>
{
VipNoBorrow vnBorrowTemp = new VipNoBorrow();
vnBorrowTemp.BbkId = (int)id;
vnBorrowTemp = vnBorrowBLL.VipNoBorrowSelectByBBKId(vnBorrowTemp);
BorrowKind borrowKind = new BorrowKind();
borrowKind.BkId = vnBorrowTemp.RkrId;
txtBorrowKind.Text = borrowKindBLL.BorrowKindSelectById(borrowKind).BbkName;
if (vnBorrowTemp.IsNight)
{
labNightCost.Text = "包夜租车";
}
else
{
labNightCost.Text = "";
}
txtVNPhone.Text = vnBorrowTemp.VnPhone;
txtVNCard.Text = vnBorrowTemp.VnCard;
txtBorrowTime.Text = vnBorrowTemp.BbkTime.ToString();
//txtBBKTime.Text = (DateTime.Now - vnBorrowTemp.BbkTime).ToString().Substring (0,8);
txtVNNum.Text = vnBorrowTemp.LeftNum.ToString();
txtMark.Text = vnBorrowTemp.Mark;
}));
}
/// <summary>
/// 值查未还的
/// </summary>
/// <param name="dpId"></param>
/// <returns></returns>
public List <VipNoBorrow> VipNoBorrowSelectByDpIdAndTime(int dpId, DateTime startTime, DateTime endTime)
{
string sql = "VIP_NO_BORROW_SELECT_BY_DPID_AND_TIME";
List <VipNoBorrow> listVipNoBorrow = new List <VipNoBorrow>();
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);
}
VipNoBorrow vipNoBorrowTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipNoBorrowTemp = new VipNoBorrow();
vipNoBorrowTemp.BbkId = Convert.ToInt32(dt.Rows[i]["BBKID"]);
vipNoBorrowTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipNoBorrowTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
vipNoBorrowTemp.RkrId = Convert.ToInt32(dt.Rows[i]["RKRID"]);
vipNoBorrowTemp.VnName = Convert.ToString(dt.Rows[i]["VNNAME"]);
vipNoBorrowTemp.VnPhone = Convert.ToString(dt.Rows[i]["VNPHONE"]);
vipNoBorrowTemp.VnCard = Convert.ToString(dt.Rows[i]["VNCARD"]);
vipNoBorrowTemp.VnNumber = Convert.ToInt32(dt.Rows[i]["VNNUMBER"]);
vipNoBorrowTemp.BbkTime = Convert.ToDateTime(dt.Rows[i]["BBKTIME"]);
vipNoBorrowTemp.IsReturn = (bool)dt.Rows[i]["ISRETURN"];
vipNoBorrowTemp.LeftNum = (int)dt.Rows[i]["LEFTNUM"];
vipNoBorrowTemp.IsNight = (bool)dt.Rows[i]["ISNIGHT"];
try
{
vipNoBorrowTemp.Mark = dt.Rows[i]["MARK"].ToString();
}
catch (Exception)
{
vipNoBorrowTemp.Mark = "";
}
listVipNoBorrow.Add(vipNoBorrowTemp);
}
return(listVipNoBorrow);
}
catch (Exception ex)
{
except.ExceptionInsert("查询非会员租车出错：" + ex.Message, "VipNoBorrowSelectByDpId", 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;
}
/// <summary>
/// 非会员租车添加
/// </summary>
/// <param name="vipNoBorrow">非会员租车记录</param>
/// <param name="bkid">租车类别ID</param>
/// <returns>若余额不足则返回-2，若添加成功则返回1，若不成功返回-1</returns>
public int VipNoBorrowInsert(VipNoBorrow vipNoBorrow, int bkid)
{
int result;
try
{
string sql = "VIP_NO_BORROW_INSERT";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@BKID", SqlDbType.Int),
new SqlParameter("@VNNAME", SqlDbType.VarChar, 50),
new SqlParameter("@VNCARD", SqlDbType.VarChar, 200),
new SqlParameter("@VNNUMBER", SqlDbType.Int),
new SqlParameter("@VNPHONE", SqlDbType.VarChar, 50),
new SqlParameter("@RETURN", SqlDbType.Int),
new SqlParameter("@BBKTIME", SqlDbType.DateTime),
new SqlParameter("@USERID", SqlDbType.Int),
new SqlParameter("@MARK", SqlDbType.VarChar, 1000)
};
para[0].Value = vipNoBorrow.VipId;
para[1].Value = vipNoBorrow.DpId;
para[2].Value = bkid;
para[3].Value = vipNoBorrow.VnName;
para[4].Value = vipNoBorrow.VnCard;
para[5].Value = vipNoBorrow.VnNumber;
para[6].Value = vipNoBorrow.VnPhone;
para[7].Direction = ParameterDirection.ReturnValue;
para[8].Value = vipNoBorrow.BbkTime;
para[9].Value = vipNoBorrow.UserId;
para[10].Value = vipNoBorrow.Mark;
result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
int rtn = int.Parse(para[7].Value.ToString());
if (rtn == -2)
{
//若余额不足
return(rtn);
}
return(result > 0 ? 1 : -1);
}
catch (Exception ex)
{
except.ExceptionInsert("添加非会员租车出错：" + ex.Message, "VipNoBorrowInsert", DateTime.Now);
return(-1);
}
}
/// <summary>
/// 根据BBKID获得非会员租车信息
/// </summary>
/// <returns></returns>
public VipNoBorrow VipNoBorrowSelectByBBKId(VipNoBorrow vipNoBorrow)
{
string sql = "VIP_NO_BORROW_SELECT_BY_BBKID";
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BBKID", SqlDbType.Int)
};
para[0].Value = vipNoBorrow.BbkId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
//BBKID,VIPID,DPID,CUID,VNNAME,VNPHONE,VNCARD,VNNUMBER
VipNoBorrow vipNoBorrowInfo = new VipNoBorrow();
vipNoBorrowInfo.BbkId = Convert.ToInt32(dt.Rows[0]["BBKID"]);
vipNoBorrowInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]);
vipNoBorrowInfo.DpId = Convert.ToInt32(dt.Rows[0]["DPID"]);
vipNoBorrowInfo.RkrId = Convert.ToInt32(dt.Rows[0]["RKRID"]);
vipNoBorrowInfo.VnName = Convert.ToString(dt.Rows[0]["VNNAME"]);
vipNoBorrowInfo.VnPhone = Convert.ToString(dt.Rows[0]["VNPHONE"]);
vipNoBorrowInfo.VnCard = Convert.ToString(dt.Rows[0]["VNCARD"]);
vipNoBorrowInfo.VnNumber = Convert.ToInt32(dt.Rows[0]["VNNUMBER"]);
vipNoBorrowInfo.BbkTime = Convert.ToDateTime(dt.Rows[0]["BBKTIME"]);
vipNoBorrowInfo.IsReturn = (bool)dt.Rows[0]["ISRETURN"];
vipNoBorrowInfo.LeftNum = (int)dt.Rows[0]["LEFTNUM"];
vipNoBorrowInfo.IsNight = (bool)dt.Rows[0]["ISNIGHT"];
try
{
vipNoBorrowInfo.Mark = dt.Rows [0]["MARK"].ToString();
}
catch (Exception)
{
vipNoBorrowInfo.Mark = "";
}
return(vipNoBorrowInfo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询非会员租车出错：" + ex.Message, "VipNoBorrowSelectByBBKId", DateTime.Now);
return(null);
}
}
/// <summary>
/// 根据非会员ID删除非会员租车
/// </summary>
/// <param name="vipNoBorrow"></param>
/// <returns></returns>
public bool VipNoBorrowDeleteByVipId(VipNoBorrow vipNoBorrow)
{
string sql = "VIP_NO_BORROW_DELETE_BY_VIPID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int)
};
para[0].Value = vipNoBorrow.VipId;
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("删除非会员租车出错：" + ex.Message, "VipNoBorrowDeleteByVipId", 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;
}
/// <summary>
/// 获取所有非会员租车
/// </summary>
/// <returns></returns>
public List <VipNoBorrow> VipNoBorrowSelect()
{
string sql = "VIP_NO_BORROW_SELECT";
List <VipNoBorrow> listVipNoBorrow = new List <VipNoBorrow>();
dt = new DataTable();
try
{
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null))
{
dt.Load(dr);
}
VipNoBorrow vipNoBorrowTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipNoBorrowTemp = new VipNoBorrow();
vipNoBorrowTemp.BbkId = Convert.ToInt32(dt.Rows[i]["BBKID"]);
vipNoBorrowTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipNoBorrowTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
vipNoBorrowTemp.RkrId = Convert.ToInt32(dt.Rows[i]["RKRID"]);
vipNoBorrowTemp.VnName = Convert.ToString(dt.Rows[i]["VNNAME"]);
vipNoBorrowTemp.VnPhone = Convert.ToString(dt.Rows[i]["VNPHONE"]);
vipNoBorrowTemp.VnCard = Convert.ToString(dt.Rows[i]["VNCARD"]);
vipNoBorrowTemp.VnNumber = Convert.ToInt32(dt.Rows[i]["VNNUMBER"]);
vipNoBorrowTemp.BbkTime = Convert.ToDateTime(dt.Rows[i]["BBKTIME"]);
vipNoBorrowTemp.IsReturn = (bool)dt.Rows[i]["ISRETURN"];
vipNoBorrowTemp.LeftNum = (int)dt.Rows[i]["LEFTNUM"];
listVipNoBorrow.Add(vipNoBorrowTemp);
}
return(listVipNoBorrow);
}
catch (Exception ex)
{
except.ExceptionInsert("查询非会员租车出错：" + ex.Message, "VipNoBorrowSelect", DateTime.Now);
return(null);
}
}
/// <summary>
/// 取消包夜功能
/// </summary>
/// <param name="BBID">租车ID</param>
/// <param name="isVip">是否为会员</param>
/// <returns></returns>
public bool notNightBorrow(VipNoBorrow vipNoBorrow)
{
return(vipBorrowDal.notNightBorrow(vipNoBorrow.BbkId.ToString(), false));
}
/// <summary>
/// 根据BBKID获得非会员租车信息
/// </summary>
/// <returns></returns>
public VipNoBorrow VipNoBorrowSelectByBBKId(VipNoBorrow vipNoBorrow)
{
return(vipNoBorrowDal.VipNoBorrowSelectByBBKId(vipNoBorrow));
}
public bool VipNoBorrowDeleteByBBKId(VipNoBorrow vipNoBorrow)
{
return(vipNoBorrowDal.VipNoBorrowDeleteByBBKId(vipNoBorrow));
}
/// <summary>
/// 非会员租车添加
/// </summary>
/// <param name="vipNoBorrow">非会员租车记录</param>
/// <param name="bkid">租车类别ID</param>
/// <returns>若余额不足则返回-2，若添加成功则返回1，若不成功返回-1</returns>
public int VipNoBorrowInsert(VipNoBorrow vipNoBorrow, int bkid)
{
return(vipNoBorrowDal.VipNoBorrowInsert(vipNoBorrow, bkid));
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtVNName.Text == "")
{
epInfo.SetError(txtVNName, "请输入租车人姓名");
return;
}
try
{
if (int.Parse(txtVNNumber.Text.ToString()) <= 0)
{
epInfo.SetError(txtVNNumber, "租车数目必须大于零");
return;
}
//if (int.Parse(txtVNNumber.Text.ToString()) > 3)
//{
// epInfo.SetError(txtVNNumber, "对不起一次租车数量过多，请尝试多次租车!");
// return;
//}
}
catch (Exception)
{
epInfo.SetError(txtVNNumber, "租车数目必须为整数");
return;
}
if (!CheckPhone(txtVNPhone.Text))
{
epInfo.SetError(txtVNPhone, "租车人电话输入错误");
return;
}
if (txtVNCard != null && txtVNCard.Text.Trim() != "")
{
if (!CheckCidInfo(txtVNCard.Text))
{
epInfo.SetError(txtVNCard, "租车人身份证号输入错误");
return;
}
}
VipNoBorrow vipNoBorrowModel = new VipNoBorrow();
vipNoBorrowModel.VipId = int.Parse(txtVipNoId.Text);
vipNoBorrowModel.DpId = StaticData.departLocal.DpId;
vipNoBorrowModel.VnName = txtVNName.Text;
vipNoBorrowModel.VnPhone = txtVNPhone.Text;
if (txtVNCard != null && txtVNCard.Text.Trim() != "")
{
vipNoBorrowModel.VnCard = txtVNCard.Text;
}
else
{
vipNoBorrowModel.VnCard = "空";
}
vipNoBorrowModel.VnNumber = int.Parse(txtVNNumber.Text);
vipNoBorrowModel.BbkTime = DateTime.Now;
vipNoBorrowModel.RkrId = (int)cmbBorrowKind.SelectedValue;
vipNoBorrowModel.UserId = StaticData.userLocal.UserId;
if (txtCashPledge.TextLength <= 0)
{
BorrowBikeMark = "押金:0元";
}
else
{
BorrowBikeMark = "押金:" + txtCashPledge.Text.Trim() + "元";
}
if (rbStudent.Checked)
{
BorrowBikeMark += "，所押证件;学生证";
}
if (rbOneCard.Checked)
{
BorrowBikeMark += "，所押证件:一卡通";
}
if (rbCard.Checked)
{
BorrowBikeMark += "，所押证件:身份证";
}
if (txtMark.TextLength > 0)
{
BorrowBikeMark += "," + txtMark.Text.Trim();
}
vipNoBorrowModel.Mark = BorrowBikeMark;
Thread th = new Thread(new ParameterizedThreadStart(btnOKClick));
th.IsBackground = true;
th.Start(vipNoBorrowModel);
}
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;
}
private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
//DateTime startTime = DateTime.Now.Date;
label1.Text = "0";
VIPInfo vipTemp = new VIPInfo();
VipNoInfo vipNoTemp = new VipNoInfo();
DepartInfo departTemp = new DepartInfo();
VipNoBorrow vipNoBorrowTemp = new VipNoBorrow();
if (bikeNoList != null && bikeNoList.Count != 0)
{
bikeList.AddRange(bikeNoList);
}
if (bikeList == null || bikeList.Count == 0)
{
btnSearch.Enabled = true;
progressBar2.Visible = false;
label1.Text = "0次";
MessageBox.Show("未查询到相应数据!");
return;
}
label1.Text = bikeList.Count.ToString() + "次";
lvBorrow.Items.Clear();
for (int i = 0; i < bikeList.Count; i++)
{
try
{
lvBorrow.Items.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
lvBorrow.Items[i].SubItems.Add("");
if (bikeList[i].IsVip)
{
vipTemp.VipId = bikeList[i].VipId;
vipTemp = vipBLL.VipSelectById_MainPage(vipTemp);
departTemp.DpId = bikeList[i].DpId;
departTemp = departBLL.DepartSelectById(departTemp);
lvBorrow.Items[i].SubItems[0].Text = vipTemp.VipNumber;
lvBorrow.Items[i].SubItems[1].Text = vipTemp.VipName;
lvBorrow.Items[i].SubItems[2].Text = departTemp.DpName;
lvBorrow.Items[i].SubItems[3].Text = bikeList[i].BrNumber.ToString();
lvBorrow.Items[i].SubItems[4].Text = bikeList[i].RbkTime.ToString();
lvBorrow.Items[i].SubItems[5].Text = bikeList[i].BuTimeString;
lvBorrow.Items[i].SubItems[6].Text = bikeList[i].BuCost.ToString();
lvBorrow.Items[i].SubItems[7].Text = bikeList[i].Mark;
lvBorrow.Items[i].ForeColor = Color.BlueViolet;
}
else
{
vipNoTemp.VipId = bikeList[i].VipId;
vipNoTemp = vipNoBLL.VipNoSelectByVIPNoId(vipNoTemp);
departTemp.DpId = bikeList[i].DpId;
departTemp = departBLL.DepartSelectById(departTemp);
vipNoBorrowTemp.BbkId = bikeList[i].BbkId;
vipNoBorrowTemp = vipNoBorrowBLL.VipNoBorrowSelectByBBKId(vipNoBorrowTemp);
lvBorrow.Items[i].SubItems[0].Text = vipNoTemp.VipNumber;
lvBorrow.Items[i].SubItems[1].Text = vipNoBorrowTemp.VnName;
lvBorrow.Items[i].SubItems[2].Text = departTemp.DpName;
lvBorrow.Items[i].SubItems[3].Text = bikeList[i].BrNumber.ToString();
lvBorrow.Items[i].SubItems[4].Text = bikeList[i].RbkTime.ToString();
lvBorrow.Items[i].SubItems[5].Text = bikeList[i].BuTimeString;
lvBorrow.Items[i].SubItems[6].Text = bikeList[i].BuCost.ToString();
lvBorrow.Items[i].SubItems[7].Text = bikeList[i].Mark;
lvBorrow.Items[i].ForeColor = Color.Red;
}
}
catch (Exception)
{
}
}
}
catch (Exception)
{
}
btnSearch.Enabled = true;
progressBar2.Visible = false;
}
