////新增图片
//public bool InserItemsPic(int ItemID,string BigImg,string SmallImg,string Alt) {
// if (sqlHelper.ExcuteCommandInt("insert into Images(ItemID,BigImg,SmallImg,Alt) values ("
// +ItemID+",'"+BigImg+"','"+SmallImg+"','"+Alt+"')") > 0)
// return true;
// else
// return false;
//}
public bool InserItemsPic(Entity.PicturesItem picture)
{
if (sqlHelper.ExcuteCommandInt("insert into Images(ItemID,BigImg,SmallImg,Alt) values ("
+ picture.getItemID()+ ",'"
+picture.getBigImg()+ "','"
+picture.getSmallImg() + "','"
+picture.getAlt()+ "')") > 0)
return true;
else
return false;
}
//更新指定图片
//public bool UpdatePicByID(int intImageID,int ItemID, string BigImg, string SmallImg, string Alt)
//{
// if (sqlHelper.ExcuteCommandInt("update Images set ItemID="+ItemID+",BigImg='"+BigImg+"',SmallImg='"+SmallImg+"',Alt='"+Alt+"' where ImageID="+intImageID+")") > 0)
// return true;
// else
// return false;
//}
public bool UpdatePicByID(Entity.PicturesItem picture)
{
if (sqlHelper.ExcuteCommandInt("update Images set ItemID="
+picture.getItemID()+ ",BigImg='"
+picture.getBigImg() + "',SmallImg='"
+picture.getSmallImg()+ "',Alt='"
+picture.getAlt() + "' where ImageID="
+picture.getIntImageID() + ")") > 0)
return true;
else
return false;
}
//更新商品信息
//public bool UpdateSingleItem(int ItemID, int ProductID, int BrandID, string Name, string Area)
//{
// if (helper.ExcuteCommandInt("update Items set ProductID=" + ProductID + ",BrandID=" + BrandID + ", Name='" + Name + "', Area='" + Area + "' where IID =" + ItemID + "") > 0)
// return true;
// else
// return false;
//}
public bool UpdateSingleItem(Entity.Items item)
{
return helper.ExcuteCommandInt("update Items set ProductID="
+ item.getProductID() + ",BrandID="
+ item.getBrandID() + ", Name='"
+ item.getName() + "', Area='"
+ item.getArea() + "' where IID ="
+ item.getItemID() + "") > 0;
}
//更新商品价格
public bool UpdateSinglePrice(Entity.Items item)
{
//int ItemID, string AgoraPrice, string MemberPrice, string VipPrice, string SeckillPrice
if (helper.ExcuteCommandInt("update Items set AgoraPrice='"
+ item.getAgoraPrice()+ "',MemberPrice='"
+ item.getMemberPrice()+ "',VipPrice='"
+ item.getVipPrice()+ "',SeckillPrice='"
+ item.getSeckillPrice()+ "' where IID ="
+ item.getItemID()+ "") > 0)
{
return true;
}
else
return false;
}
//更新秒杀信息
//public bool UpdateSingleItem(int ItemID, string Days, string Hours, string Minutes, string Seconds, string IsSecondKill)
//{
// if (helper.ExcuteCommandInt("update Items set Days='"
// + Days + "',Hours='" + Hours + "',Minutes='" + Minutes + "',Seconds='" + Seconds + "',IsSecondKill='" + IsSecondKill + "' where IID=" + ItemID + "") > 0)
// return true;
// else
// return false;
//}
public bool UpdateSingleItemSeckill(Entity.Items items)
{
if (helper.ExcuteCommandInt("update Items set Days='"
+items.getDays()+ "',Hours='"
+items.getHours()+ "',Minutes='"
+items.getMinutes()+ "',Seconds='"
+items.getSeconds()+ "',IsSecondKill='"
+items.getIsSecondKill()+ "' where IID="
+items.getItemID() + "") > 0)
return true;
else
return false;
}
