public bool Insert(ProductPicInfo productPicInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductPic](");
sql.Append("[OrderID],");
sql.Append("[ProductNO],");
sql.Append("[SmallPic],");
sql.Append("[MidPic],");
sql.Append("[BigPic]");
sql.Append(") VALUES(");
sql.Append("@OrderID,");
sql.Append("@ProductNO,");
sql.Append("@SmallPic,");
sql.Append("@MidPic,");
sql.Append("@BigPic");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@OrderID",productPicInfo.OrderID),
dbhelper.CreateParameter("@ProductNO",productPicInfo.ProductNO),
dbhelper.CreateParameter("@SmallPic",productPicInfo.SmallPic),
dbhelper.CreateParameter("@MidPic",productPicInfo.MidPic),
dbhelper.CreateParameter("@BigPic",productPicInfo.BigPic)
};
long ret=(long)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
productPicInfo.Id=ret;
return true;
}
}
/// <summary>
/// Convert IDataReader To ProductPicInfo
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static ProductPicInfo SetValue(IDataReader reader)
{
ProductPicInfo info = new ProductPicInfo();
int idIndex = reader.GetOrdinal("ID");
int orderIDIndex = reader.GetOrdinal("OrderID");
int productNOIndex = reader.GetOrdinal("ProductNO");
int smallPicIndex = reader.GetOrdinal("SmallPic");
int midPicIndex = reader.GetOrdinal("MidPic");
int bigPicIndex = reader.GetOrdinal("BigPic");
info.Id = reader.GetInt64(idIndex);
info.OrderID = reader.GetInt32(orderIDIndex);
info.ProductNO = reader.GetString(productNOIndex);
if(!reader.IsDBNull(smallPicIndex))
info.SmallPic = reader.GetString(smallPicIndex);
if(!reader.IsDBNull(midPicIndex))
info.MidPic = reader.GetString(midPicIndex);
if(!reader.IsDBNull(bigPicIndex))
info.BigPic = reader.GetString(bigPicIndex);
return info;
}
public bool Update(ProductPicInfo productPicInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductPic]");
sql.Append(" SET");
sql.Append(" [OrderID]=@OrderID,");
sql.Append(" [ProductNO]=@ProductNO,");
sql.Append(" [SmallPic]=@SmallPic,");
sql.Append(" [MidPic]=@MidPic,");
sql.Append(" [BigPic]=@BigPic");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productPicInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
