示例#1
0
        public static Frtrateshoploadsingle BuildFrtrateshoploadsingleFromRow(DataRow row)
        {
            Frtrateshoploadsingle entity = new Frtrateshoploadsingle();

            entity.whse          = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.whsedesc      = row.IsNull("whsedesc") ? string.Empty : row.Field <string>("whsedesc");
            entity.shipvia       = row.IsNull("shipvia") ? string.Empty : row.Field <string>("shipvia");
            entity.shipviadesc   = row.IsNull("shipviadesc") ? string.Empty : row.Field <string>("shipviadesc");
            entity.orderno       = row.IsNull("orderno") ? 0 : row.Field <int>("orderno");
            entity.ordersuf      = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf");
            entity.zipcd         = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd");
            entity.custno        = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.custname      = row.IsNull("custname") ? string.Empty : row.Field <string>("custname");
            entity.custnotesfl   = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
            entity.orderwght     = row.IsNull("orderwght") ? decimal.Zero : row.Field <decimal>("orderwght");
            entity.shipwght      = row.IsNull("shipwght") ? decimal.Zero : row.Field <decimal>("shipwght");
            entity.ordfrtextra1  = row.IsNull("ordfrtextra1") ? decimal.Zero : row.Field <decimal>("ordfrtextra1");
            entity.ordfrtextra2  = row.IsNull("ordfrtextra2") ? decimal.Zero : row.Field <decimal>("ordfrtextra2");
            entity.shipfrtextra1 = row.IsNull("shipfrtextra1") ? decimal.Zero : row.Field <decimal>("shipfrtextra1");
            entity.shipfrtextra2 = row.IsNull("shipfrtextra2") ? decimal.Zero : row.Field <decimal>("shipfrtextra2");
            entity.error1        = row.IsNull("error1") ? string.Empty : row.Field <string>("error1");
            entity.error2        = row.IsNull("error2") ? string.Empty : row.Field <string>("error2");
            entity.sortby        = row.IsNull("sortby") ? string.Empty : row.Field <string>("sortby");
            entity.userfield     = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
示例#2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromFrtrateshoploadsingle(ref DataRow row, Frtrateshoploadsingle entity)
 {
     row.SetField("whse", entity.whse);
     row.SetField("whsedesc", entity.whsedesc);
     row.SetField("shipvia", entity.shipvia);
     row.SetField("shipviadesc", entity.shipviadesc);
     row.SetField("orderno", entity.orderno);
     row.SetField("ordersuf", entity.ordersuf);
     row.SetField("zipcd", entity.zipcd);
     row.SetField("custno", entity.custno);
     row.SetField("custname", entity.custname);
     row.SetField("custnotesfl", entity.custnotesfl);
     row.SetField("orderwght", entity.orderwght);
     row.SetField("shipwght", entity.shipwght);
     row.SetField("ordfrtextra1", entity.ordfrtextra1);
     row.SetField("ordfrtextra2", entity.ordfrtextra2);
     row.SetField("shipfrtextra1", entity.shipfrtextra1);
     row.SetField("shipfrtextra2", entity.shipfrtextra2);
     row.SetField("error1", entity.error1);
     row.SetField("error2", entity.error2);
     row.SetField("sortby", entity.sortby);
     row.SetField("userfield", entity.userfield);
 }