/// <summary>
/// 添加一个租借的记录
/// 返回 true 表示成功，否侧该记录已存在
/// </summary>
/// <param name="_rent"></param>
/// <returns></returns>
public bool AddData(Renting_Management_System.Models.RentMod _rent)
{
rent = new Renting_Management_System.Models.RentMod();
rent =SelectBy_CustomerID_N_ImageID(_rent.CustomerID, _rent.ImageID);
if (rent == null)
{
StringBuilder insertStr = new StringBuilder();
insertStr.Append("Insert Into [Rent](影像编号,客户编号,用户编号,出租数量,出租日期,归还日期,出租押金,归还状态,描述)");
insertStr.Append("Values ('");
insertStr.Append(_rent.ImageID + "','");
insertStr.Append(_rent.CustomerID + "','");
insertStr.Append(_rent.UserID + "',");
insertStr.Append(_rent.QuantityOfRent + ",'");
insertStr.Append(_rent.RentDate.ToShortDateString() + "','");
insertStr.Append(_rent.ReturnDate.ToShortDateString() + "',");
insertStr.Append(_rent.Deposit + ",'");
insertStr.Append(_rent.ReturnState + "','");
insertStr.Append(_rent.Description + "'");
da = new DBConnection();
da.InsertQuery(insertStr.ToString());
return true;
}
else
{
return false;
}
}
/// <summary>
/// 删除一个租借记录
/// 返回 true 表示成功，否侧该记录不存在
/// </summary>
/// <param name="_rent"></param>
/// <returns></returns>
public bool DeletData(Renting_Management_System.Models.RentMod _rent)
{
rent = new Renting_Management_System.Models.RentMod();
rent =SelectBy_CustomerID_N_ImageID(_rent.CustomerID, _rent.ImageID);
if (rent != null)
{
StringBuilder deleteStr = new StringBuilder();
deleteStr.Append("Delete From [Rent]");
deleteStr.Append("Where 客户编号 = '");
deleteStr.Append(_rent.CustomerID);
deleteStr.Append("' And 影像编号 = '");
deleteStr.Append(_rent.ImageID);
deleteStr.Append("'");
da = new DBConnection();
da.DeleteQuery(deleteStr.ToString());
return true;
}
else
{
return false;
}
}
/// <summary>
/// 通过客户编号和影像编号，获取一个租借记录
/// 返回 null 表示记录不存在，否侧返回一个租借的记录
/// </summary>
/// <param name="_customerID"></param>
/// <param name="_imageID"></param>
/// <returns></returns>
public Renting_Management_System.Models.RentMod SelectBy_CustomerID_N_ImageID(string _customerID, string _imageID)
{
StringBuilder selectStr = new StringBuilder();
selectStr.Append("Select * From [Rent] ");
selectStr.Append("Where 客户编号 = '");
selectStr.Append(_customerID);
selectStr.Append("' And 影像编号 = '");
selectStr.Append(_imageID);
selectStr.Append("'");
da = new DBConnection();
DataSet ds = new DataSet();
ds = da.SelectQuery(selectStr.ToString());
if (ds.Tables[0].Rows.Count == 0)
{ return null; }
else
{
rent = new Renting_Management_System.Models.RentMod();
rent.ImageID = ds.Tables[0].Rows[0]["影像编号"].ToString().Trim();
rent.CustomerID = ds.Tables[0].Rows[0]["客户编号"].ToString().Trim();
rent.UserID = ds.Tables[0].Rows[0]["用户编号"].ToString().Trim();
rent.QuantityOfRent = int.Parse(ds.Tables[0].Rows[0]["影像编号"].ToString().Trim());
rent.RentDate = DateTime.Parse(ds.Tables[0].Rows[0]["出租日期"].ToString().Trim());
rent.ReturnDate = DateTime.Parse(ds.Tables[0].Rows[0]["归还日期"].ToString().Trim());
rent.Deposit = int.Parse(ds.Tables[0].Rows[0]["出租押金"].ToString().Trim());
rent.ReturnState = ds.Tables[0].Rows[0]["归还状态"].ToString().Trim();
rent.Description = ds.Tables[0].Rows[0]["描述"].ToString().Trim();
return rent;
}
}
/// <summary>
/// 修改一个租借的记录
/// 返回 true 表示成功，否侧该记录不存在
/// </summary>
/// <param name="_rent"></param>
/// <returns></returns>
public bool ModifyData(Renting_Management_System.Models.RentMod _rent)
{
rent = new Renting_Management_System.Models.RentMod();
rent =SelectBy_CustomerID_N_ImageID(_rent.CustomerID, _rent.ImageID);
if (rent != null)
{
StringBuilder updateStr = new StringBuilder();
updateStr.Append("Update [Rent]");
updateStr.Append("Set ");
updateStr.Append("用户编号 = '");
updateStr.Append(_rent.UserID);
updateStr.Append("',出租数量 = ");
updateStr.Append(_rent.QuantityOfRent);
updateStr.Append(",出租日期 = '");
updateStr.Append(_rent.RentDate.ToShortDateString());
updateStr.Append("',归还日期 = '");
updateStr.Append(_rent.ReturnDate.ToShortDateString());
updateStr.Append("',出租押金 = ");
updateStr.Append(_rent.Deposit);
updateStr.Append(",归还状态 = '");
updateStr.Append(_rent.ReturnState);
updateStr.Append("',描述 = '");
updateStr.Append(_rent.Description);
updateStr.Append("'");
updateStr.Append("Where 客户编号 = '");
updateStr.Append(_rent.CustomerID);
updateStr.Append("' And 影像编号 = '");
updateStr.Append(_rent.ImageID);
updateStr.Append("'");
da = new DBConnection();
da.UpdateQuery(updateStr.ToString());
return true;
}
else
{
return false;
}
}
