/// <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); } }