public bool Insert(ProductAnswerInfo productAnswerInfo) { StringBuilder sql=new StringBuilder(); sql.Append("INSERT INTO"); sql.Append(" [Tbl_ProductAnswer]("); sql.Append("[ID],"); sql.Append("[ProductNO],"); sql.Append("[ServiceType],"); sql.Append("[Ask],"); sql.Append("[Answer],"); sql.Append("[YesCount],"); sql.Append("[NoCount]"); sql.Append(") VALUES("); sql.Append("@ID,"); sql.Append("@ProductNO,"); sql.Append("@ServiceType,"); sql.Append("@Ask,"); sql.Append("@Answer,"); sql.Append("@YesCount,"); sql.Append("@NoCount"); sql.Append(")"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms=new IDbDataParameter[]{ dbhelper.CreateParameter("@ID",productAnswerInfo.Id), dbhelper.CreateParameter("@ProductNO",productAnswerInfo.ProductNO), dbhelper.CreateParameter("@ServiceType",productAnswerInfo.ServiceType), dbhelper.CreateParameter("@Ask",productAnswerInfo.Ask), dbhelper.CreateParameter("@Answer",productAnswerInfo.Answer), dbhelper.CreateParameter("@YesCount",productAnswerInfo.YesCount), dbhelper.CreateParameter("@NoCount",productAnswerInfo.NoCount) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }
/// <summary> /// Convert IDataReader To ProductAnswerInfo /// </summary> /// <param name="reader"></param> /// <returns></returns> public static ProductAnswerInfo SetValue(IDataReader reader) { ProductAnswerInfo info = new ProductAnswerInfo(); int idIndex = reader.GetOrdinal("ID"); int productNOIndex = reader.GetOrdinal("ProductNO"); int serviceTypeIndex = reader.GetOrdinal("ServiceType"); int askIndex = reader.GetOrdinal("Ask"); int answerIndex = reader.GetOrdinal("Answer"); int yesCountIndex = reader.GetOrdinal("YesCount"); int noCountIndex = reader.GetOrdinal("NoCount"); info.Id = reader.GetInt32(idIndex); info.ProductNO = reader.GetString(productNOIndex); info.ServiceType = reader.GetInt32(serviceTypeIndex); info.Ask = reader.GetString(askIndex); info.Answer = reader.GetString(answerIndex); info.YesCount = reader.GetInt32(yesCountIndex); info.NoCount = reader.GetInt32(noCountIndex); return info; }
public bool Update(ProductAnswerInfo productAnswerInfo) { StringBuilder sql = new StringBuilder(); sql.Append("UPDATE"); sql.Append(" [Tbl_ProductAnswer]"); sql.Append(" SET"); sql.Append(" [ProductNO]=@ProductNO,"); sql.Append(" [ServiceType]=@ServiceType,"); sql.Append(" [Ask]=@Ask,"); sql.Append(" [Answer]=@Answer,"); sql.Append(" [YesCount]=@YesCount,"); sql.Append(" [NoCount]=@NoCount"); sql.Append(" WHERE"); sql.Append(" [ID]=@ID"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms = new IDbDataParameter[]{ dbhelper.CreateParameter("@ID",productAnswerInfo.Id) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }