/// <summary>
/// 资产增长
/// </summary>
/// <param name="eq"></param>
/// <returns>true:成功；false：失败</returns>
public static bool Add(Equipment eq)
{
SqlParameter param1 = new SqlParameter("@eqNo", SqlDbType.VarChar, 50);
param1.Value = eq.EqNo;
SqlParameter param2 = new SqlParameter("@type", SqlDbType.VarChar, 50);
param2.Value = eq.Type;
SqlParameter param3 = new SqlParameter("@name", SqlDbType.VarChar, 50);
param3.Value = eq.Name;
SqlParameter param4 = new SqlParameter("@lable", SqlDbType.VarChar, 50);
param4.Value = eq.Lable;
SqlParameter param5 = new SqlParameter("@model", SqlDbType.VarChar, 50);
param5.Value = eq.Model;
SqlParameter param6 = new SqlParameter("@plus", SqlDbType.VarChar, 50);
param6.Value = eq.Plus;
SqlParameter param7 = new SqlParameter("@count", SqlDbType.Int);
param7.Value = eq.Count;
SqlParameter param8 = new SqlParameter("@unitt", SqlDbType.VarChar, 50);
param8.Value = eq.Unit;
SqlParameter param9 = new SqlParameter("@price", SqlDbType.Money);
param9.Value = eq.Price;
SqlParameter param10 = new SqlParameter("@maker", SqlDbType.VarChar, 50);
param10.Value = eq.Maker;
SqlParameter param11 = new SqlParameter("@birth", SqlDbType.VarChar, 50);
param11.Value = eq.Birthday;
SqlParameter param12 = new SqlParameter("@addtype", SqlDbType.VarChar, 50);
param12.Value = eq.AddType;
SqlParameter param13 = new SqlParameter("@keepplace", SqlDbType.VarChar, 50);
param13.Value = eq.KeepPlace;
SqlParameter param14 = new SqlParameter("@keeper", SqlDbType.Int);
param14.Value = eq.Keeper;
SqlParameter param15 = new SqlParameter("@usetime", SqlDbType.VarChar, 50);
param15.Value = eq.UseTime;
SqlParameter param16 = new SqlParameter("@booker", SqlDbType.VarChar, 50);
param16.Value = eq.Booker;
SqlParameter param17 = new SqlParameter("@bookdatae", SqlDbType.VarChar, 50);
param17.Value = eq.BookDate;
byte[] Photo = File.ReadAllBytes(eq.Photo);
SqlParameter param18 = new SqlParameter("@image", SqlDbType.Image, Photo.Length);
param18.Value = Photo;
string sql = "insert into equipment values(@eqNo,@type,@name,@lable,@model,@plus,@count,@unitt,@price,@maker,@birth,@addtype,@keepplace,@keeper,@usetime,@booker,@bookdatae,@image)";
sqlHandler sh = new sqlHandler();
try
{
int result = sh.ExecuteSQL(sql, param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18);
return(result > 0);
}
catch
{
return(false);
}
}
public static bool Update(Equipment eq)
{
string sql = "";
if (eq.Photo == "")
{
sql = "update equipment set type=@type,name=@name,label=@lable,model=@model,plus=@plus,count=@count,unit=@unitt,price=@price,maker=@maker,birthday=@birth,addtype=@addtype,keepplace=@keepplace,keeper=@keeper,usetime=@usetime,booker=@booker,boodDate=@bookdatae where eqno=@eqNo";
}
else
{
sql = "update equipment set type=@type,name=@name,label=@lable,model=@model,plus=@plus,count=@count,unit=@unitt,price=@price,maker=@maker,birthday=@birth,addtype=@addtype,keepplace=@keepplace,keeper=@keeper,usetime=@usetime,booker=@booker,boodDate=@bookdatae,photo=@photo where eqno=@eqNo";
}
SqlParameter param1 = new SqlParameter("@eqNo", SqlDbType.VarChar, 50);
param1.Value = eq.EqNo;
SqlParameter param2 = new SqlParameter("@type", SqlDbType.VarChar, 50);
param2.Value = eq.Type;
SqlParameter param3 = new SqlParameter("@name", SqlDbType.VarChar, 50);
param3.Value = eq.Name;
SqlParameter param4 = new SqlParameter("@lable", SqlDbType.VarChar, 50);
param4.Value = eq.Lable;
SqlParameter param5 = new SqlParameter("@model", SqlDbType.VarChar, 50);
param5.Value = eq.Model;
SqlParameter param6 = new SqlParameter("@plus", SqlDbType.VarChar, 50);
param6.Value = eq.Plus;
SqlParameter param7 = new SqlParameter("@count", SqlDbType.Int);
param7.Value = eq.Count;
SqlParameter param8 = new SqlParameter("@unitt", SqlDbType.VarChar, 50);
param8.Value = eq.Unit;
SqlParameter param9 = new SqlParameter("@price", SqlDbType.Money);
param9.Value = eq.Price;
SqlParameter param10 = new SqlParameter("@maker", SqlDbType.VarChar, 50);
param10.Value = eq.Maker;
SqlParameter param11 = new SqlParameter("@birth", SqlDbType.VarChar, 50);
param11.Value = eq.Birthday;
SqlParameter param12 = new SqlParameter("@addtype", SqlDbType.VarChar, 50);
param12.Value = eq.AddType;
SqlParameter param13 = new SqlParameter("@keepplace", SqlDbType.VarChar, 50);
param13.Value = eq.KeepPlace;
SqlParameter param14 = new SqlParameter("@keeper", SqlDbType.Int);
param14.Value = eq.Keeper;
SqlParameter param15 = new SqlParameter("@usetime", SqlDbType.VarChar, 50);
param15.Value = eq.UseTime;
SqlParameter param16 = new SqlParameter("@booker", SqlDbType.VarChar, 50);
param16.Value = eq.Booker;
SqlParameter param17 = new SqlParameter("@bookdatae", SqlDbType.VarChar, 50);
param17.Value = eq.BookDate;
SqlParameter param18 = null;
if (eq.Photo != null)
{
try
{
byte[] Photo = File.ReadAllBytes(eq.Photo);
param18 = new SqlParameter("@photo", SqlDbType.Image, Photo.Length);
param18.Value = Photo;
}
catch
{
param18 = null;
}
}
sqlHandler sh = new sqlHandler();
try
{
// 执行数据命令来新增数据记录。
//insertCMD.ExecuteNonQuery();
if (param18 != null)
{
int result = sh.ExecuteSQL(sql, param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18);
return(result > 0);
}
else
{
int result = sh.ExecuteSQL(sql, param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17);
return(result > 0);
}
}
catch
{
return(false);
}
}
