public DeliveryFreightSetMapping GetDeliveryFreightSetMapping(DeliveryFreightSetMapping query) { query.Replace4MySQL(); StringBuilder strSql = new StringBuilder("select product_freight_set,delivery_freight_set from delivery_freight_set_mapping where 1=1"); if (query.Product_Freight_Set != 0) { strSql.AppendFormat(" and product_freight_set={0}", query.Product_Freight_Set); } return _dbAccess.getSinggleObj<DeliveryFreightSetMapping>(strSql.ToString()); }