public bool Insert(ProductExInfo productExInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductEx](");
sql.Append("[ProductNO],");
sql.Append("[Intro],");
sql.Append("[Standards],");
sql.Append("[Packing],");
sql.Append("[Service]");
sql.Append(") VALUES(");
sql.Append("@ProductNO,");
sql.Append("@Intro,");
sql.Append("@Standards,");
sql.Append("@Packing,");
sql.Append("@Service");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productExInfo.ProductNO),
dbhelper.CreateParameter("@Intro",productExInfo.Intro),
dbhelper.CreateParameter("@Standards",productExInfo.Standards),
dbhelper.CreateParameter("@Packing",productExInfo.Packing),
dbhelper.CreateParameter("@Service",productExInfo.Service)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
/// <summary>
/// Convert IDataReader To ProductExInfo
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static ProductExInfo SetValue(IDataReader reader)
{
ProductExInfo info = new ProductExInfo();
int productNOIndex = reader.GetOrdinal("ProductNO");
int introIndex = reader.GetOrdinal("Intro");
int standardsIndex = reader.GetOrdinal("Standards");
int packingIndex = reader.GetOrdinal("Packing");
int serviceIndex = reader.GetOrdinal("Service");
info.ProductNO = reader.GetString(productNOIndex);
info.Intro = reader.GetString(introIndex);
info.Standards = reader.GetString(standardsIndex);
info.Packing = reader.GetString(packingIndex);
info.Service = reader.GetString(serviceIndex);
return info;
}
public bool Update(ProductExInfo productExInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductEx]");
sql.Append(" SET");
sql.Append(" [Intro]=@Intro,");
sql.Append(" [Standards]=@Standards,");
sql.Append(" [Packing]=@Packing,");
sql.Append(" [Service]=@Service");
sql.Append(" WHERE");
sql.Append(" [ProductNO]=@ProductNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productExInfo.ProductNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
