/// <summary>
/// 添加一个影像的信息
/// 返回 true 表示成功，否侧该影像已存在
/// </summary>
/// <param name="_image"></param>
/// <returns></returns>
public bool AddData(Renting_Management_System.Models.ImageMod _image)
{
image = new Renting_Management_System.Models.ImageMod();
image = SelectByID(_image.ImageID);
if (image != null)
{ return false; }
else
{
StringBuilder insertStr = new StringBuilder();
insertStr.Append("Insert Into [Image] (影像编号,影像名称,用户编号,影类代码,地点代码,影像原价,影像租价,库存数量,货架号,出租状态,影像描述) ");
insertStr.Append("Values ('");
insertStr.Append(_image.ImageID + "','");
insertStr.Append(_image.ImageName + "','");
insertStr.Append(_image.UserID + "','");
insertStr.Append(_image.ImageTypeCode + "','");
insertStr.Append(_image.LocalCode + "',");
insertStr.Append(_image.ImageCostPrice + ",");
insertStr.Append(_image.ImageRentalPrice + ",");
insertStr.Append(_image.StorageQuantity + ",'");
insertStr.Append(_image.ShelvesNumber + "','");
insertStr.Append(_image.RentState + "','");
insertStr.Append(_image.ImageDescription);
insertStr.Append("')");
da = new DBConnection();
da.InsertQuery(insertStr.ToString());
return true;
}
}
/// <summary>
/// 删除一个影像
/// 返回 true 表示成功，否侧数据不存在
/// </summary>
/// <param name="_image"></param>
/// <returns></returns>
public bool DeleteData(Renting_Management_System.Models.ImageMod _image)
{
image = new Renting_Management_System.Models.ImageMod();
image = SelectByID(_image.ImageID);
if (image == null)
{ return false; }
else
{
StringBuilder deleteStr = new StringBuilder();
deleteStr.Append("Delete From [Image] ");
deleteStr.Append("Where 影像编号 = '");
deleteStr.Append(_image.ImageID);
deleteStr.Append("'");
da = new DBConnection();
da.DeleteQuery(deleteStr.ToString());
return true;
}
}
/// <summary>
/// 通过影像名称获取一个影像的记录
/// 返回 null 表示数据不存在，否侧返回一个影像的记录
/// </summary>
/// <param name="_imageName"></param>
/// <returns></returns>
public Renting_Management_System.Models.ImageMod SelectByName(string _imageName)
{
StringBuilder selectStr = new StringBuilder();
selectStr.Append("Select * From [Image] ");
selectStr.Append("Where 影像名称 = '");
selectStr.Append(_imageName);
selectStr.Append("'");
DataSet ds = new DataSet();
da = new DBConnection();
ds = da.SelectQuery(selectStr.ToString());
if (ds.Tables[0].Rows.Count == 0)
{ return null; }
else
{
image = new Renting_Management_System.Models.ImageMod();
image.ImageID = ds.Tables[0].Rows[0]["影像编号"].ToString().Trim();
image.ImageName = ds.Tables[0].Rows[0]["影像名称"].ToString().Trim();
image.UserID = ds.Tables[0].Rows[0]["用户编号"].ToString().Trim();
image.ImageTypeCode = ds.Tables[0].Rows[0]["影类代码"].ToString().Trim();
image.LocalCode = ds.Tables[0].Rows[0]["地点代码"].ToString().Trim();
image.ImageCostPrice = int.Parse(ds.Tables[0].Rows[0]["影像原价"].ToString().Trim());
image.ImageRentalPrice = int.Parse(ds.Tables[0].Rows[0]["影像租价"].ToString().Trim());
image.StorageQuantity = int.Parse(ds.Tables[0].Rows[0]["库存数量"].ToString().Trim());
image.ShelvesNumber = ds.Tables[0].Rows[0]["货架号"].ToString().Trim();
image.RentState = ds.Tables[0].Rows[0]["出租状态"].ToString().Trim();
image.ImageDescription = ds.Tables[0].Rows[0]["影像描述"].ToString().Trim();
return image;
}
}
/// <summary>
/// 修改一个影像的记录
/// 返回 true 表示成功，否侧数据不存在
/// </summary>
/// <param name="_image"></param>
/// <returns></returns>
public bool ModifyData(Renting_Management_System.Models.ImageMod _image)
{
image = new Renting_Management_System.Models.ImageMod();
image = SelectByID(_image.ImageID);
if (image == null)
{ return false; }
else
{
StringBuilder updateStr = new StringBuilder();
updateStr.Append("Update [Image] ");
updateStr.Append("Set ");
updateStr.Append("影像名称 = '");
updateStr.Append(_image.ImageName);
updateStr.Append("',用户编号 = '");
updateStr.Append(_image.UserID);
updateStr.Append("',影类代码 = '");
updateStr.Append(_image.ImageTypeCode);
updateStr.Append("',地点代码 = '");
updateStr.Append(_image.LocalCode);
updateStr.Append("',影像原价 = ");
updateStr.Append(_image.ImageCostPrice);
updateStr.Append(",影像租价 = ");
updateStr.Append(_image.ImageRentalPrice);
updateStr.Append(",库存数量 = ");
updateStr.Append(_image.StorageQuantity);
updateStr.Append(",货架号 = '");
updateStr.Append(_image.ShelvesNumber);
updateStr.Append("',出租状态 = '");
updateStr.Append(_image.RentState);
updateStr.Append("',影像描述 = '");
updateStr.Append(_image.ImageDescription);
updateStr.Append("'");
updateStr.Append("Where 影像编号 = '");
updateStr.Append(_image.ImageID);
updateStr.Append("'");
da = new DBConnection();
da.UpdateQuery(updateStr.ToString());
return true;
}
}
