/// <summary>
/// Convert IDataReader To ProductAttrValueInfo
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static ProductAttrValueInfo SetValue(IDataReader reader)
{
ProductAttrValueInfo info = new ProductAttrValueInfo();
int proIDIndex = reader.GetOrdinal("ProID");
int attrIDIndex = reader.GetOrdinal("AttrID");
int attrValueIndex = reader.GetOrdinal("AttrValue");
info.ProID = reader.GetString(proIDIndex);
info.AttrID = reader.GetInt32(attrIDIndex);
info.AttrValue = reader.GetString(attrValueIndex);
return info;
}
public bool Insert(ProductAttrValueInfo productAttrValueInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductAttrValue](");
sql.Append("[ProID],");
sql.Append("[AttrID],");
sql.Append("[AttrValue]");
sql.Append(") VALUES(");
sql.Append("@ProID,");
sql.Append("@AttrID,");
sql.Append("@AttrValue");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProID",productAttrValueInfo.ProID),
dbhelper.CreateParameter("@AttrID",productAttrValueInfo.AttrID),
dbhelper.CreateParameter("@AttrValue",productAttrValueInfo.AttrValue)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductAttrValueInfo productAttrValueInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductAttrValue]");
sql.Append(" SET");
sql.Append(" [AttrValue]=@AttrValue");
sql.Append(" WHERE");
sql.Append(" [ProID]=@ProID");
sql.Append(" AND");
sql.Append(" [AttrID]=@AttrID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProID",productAttrValueInfo.ProID),
dbhelper.CreateParameter("@AttrID",productAttrValueInfo.AttrID)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
