public bool Insert(ProductInfo productInfo) { StringBuilder sql=new StringBuilder(); sql.Append("INSERT INTO"); sql.Append(" [Tbl_Product]("); sql.Append("[ProductNO],"); sql.Append("[CateIDPath],"); sql.Append("[NickName],"); sql.Append("[ProductName],"); sql.Append("[MarketPrice],"); sql.Append("[InnerPrice],"); sql.Append("[BrandID],"); sql.Append("[BrandName]"); sql.Append(") VALUES("); sql.Append("@ProductNO,"); sql.Append("@CateIDPath,"); sql.Append("@NickName,"); sql.Append("@ProductName,"); sql.Append("@MarketPrice,"); sql.Append("@InnerPrice,"); sql.Append("@BrandID,"); sql.Append("@BrandName"); sql.Append(")"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms=new IDbDataParameter[]{ dbhelper.CreateParameter("@ProductNO",productInfo.ProductNO), dbhelper.CreateParameter("@CateIDPath",productInfo.CateIDPath), dbhelper.CreateParameter("@NickName",productInfo.NickName), dbhelper.CreateParameter("@ProductName",productInfo.ProductName), dbhelper.CreateParameter("@MarketPrice",productInfo.MarketPrice), dbhelper.CreateParameter("@InnerPrice",productInfo.InnerPrice), dbhelper.CreateParameter("@BrandID",productInfo.BrandID), dbhelper.CreateParameter("@BrandName",productInfo.BrandName) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }
public bool Update(ProductInfo productInfo) { StringBuilder sql = new StringBuilder(); sql.Append("UPDATE"); sql.Append(" [Tbl_Product]"); sql.Append(" SET"); sql.Append(" [CateIDPath]=@CateIDPath,"); sql.Append(" [NickName]=@NickName,"); sql.Append(" [ProductName]=@ProductName,"); sql.Append(" [MarketPrice]=@MarketPrice,"); sql.Append(" [InnerPrice]=@InnerPrice,"); sql.Append(" [BrandID]=@BrandID,"); sql.Append(" [BrandName]=@BrandName"); sql.Append(" WHERE"); sql.Append(" [ProductNO]=@ProductNO"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms = new IDbDataParameter[]{ dbhelper.CreateParameter("@ProductNO",productInfo.ProductNO) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }
/// <summary> /// Convert IDataReader To ProductInfo /// </summary> /// <param name="reader"></param> /// <returns></returns> public static ProductInfo SetValue(IDataReader reader) { ProductInfo info = new ProductInfo(); int productNOIndex = reader.GetOrdinal("ProductNO"); int cateIDPathIndex = reader.GetOrdinal("CateIDPath"); int nickNameIndex = reader.GetOrdinal("NickName"); int productNameIndex = reader.GetOrdinal("ProductName"); int marketPriceIndex = reader.GetOrdinal("MarketPrice"); int innerPriceIndex = reader.GetOrdinal("InnerPrice"); int brandIDIndex = reader.GetOrdinal("BrandID"); int brandNameIndex = reader.GetOrdinal("BrandName"); info.ProductNO = reader.GetString(productNOIndex); info.CateIDPath = reader.GetString(cateIDPathIndex); info.NickName = reader.GetString(nickNameIndex); info.ProductName = reader.GetString(productNameIndex); info.MarketPrice = reader.GetDecimal(marketPriceIndex); info.InnerPrice = reader.GetDecimal(innerPriceIndex); info.BrandID = reader.GetInt32(brandIDIndex); info.BrandName = reader.GetString(brandNameIndex); return info; }