Ejemplo n.º 1
0
        public static Kpworkorder BuildKpworkorderFromRow(DataRow row)
        {
            Kpworkorder entity = new Kpworkorder();

            entity.whse                = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
            entity.prod                = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
            entity.kitverno            = row.IsNull("kitverno") ? 0 : row.Field <int>("kitverno");
            entity.kpetrowid           = row.Field <byte[]>("kpetrowid").ToStringEncoded();
            entity.wostarted           = row.Field <bool>("wostarted");
            entity.wono                = row.IsNull("wono") ? 0 : row.Field <int>("wono");
            entity.wosuf               = row.IsNull("wosuf") ? 0 : row.Field <int>("wosuf");
            entity.wonoC               = row.IsNull("wono-c") ? string.Empty : row.Field <string>("wono-c");
            entity.unit                = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.conv                = row.IsNull("conv") ? decimal.Zero : row.Field <decimal>("conv");
            entity.unitdesc            = row.IsNull("unitdesc") ? string.Empty : row.Field <string>("unitdesc");
            entity.qtyord              = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.qtyship             = row.IsNull("qtyship") ? decimal.Zero : row.Field <decimal>("qtyship");
            entity.stkqtyord           = row.IsNull("stkqtyord") ? decimal.Zero : row.Field <decimal>("stkqtyord");
            entity.stkqtyship          = row.IsNull("stkqtyship") ? decimal.Zero : row.Field <decimal>("stkqtyship");
            entity.bofl                = row.Field <bool>("bofl");
            entity.enterdt             = row.Field <DateTime?>("enterdt");
            entity.refer               = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
            entity.ordertype           = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype");
            entity.orderaltno          = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno");
            entity.orderaltsuf         = row.IsNull("orderaltsuf") ? 0 : row.Field <int>("orderaltsuf");
            entity.orderaltlineno      = row.IsNull("orderaltlineno") ? 0 : row.Field <int>("orderaltlineno");
            entity.orderaltseqno       = row.IsNull("orderaltseqno") ? 0 : row.Field <int>("orderaltseqno");
            entity.notesfl             = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.keyfl               = row.Field <bool>("keyfl");
            entity.optfl               = row.Field <bool>("optfl");
            entity.reqfl               = row.Field <bool>("reqfl");
            entity.allow8791fl         = row.IsNull("allow8791fl") ? string.Empty : row.Field <string>("allow8791fl");
            entity.allowcomptiefl      = row.IsNull("allowcomptiefl") ? string.Empty : row.Field <string>("allowcomptiefl");
            entity.allowshipoverridefl = row.IsNull("allowshipoverridefl") ? string.Empty : row.Field <string>("allowshipoverridefl");
            entity.confirmdeletefl     = row.IsNull("confirmdeletefl") ? string.Empty : row.Field <string>("confirmdeletefl");
            entity.fromsourcingfl      = row.Field <bool>("fromsourcingfl");
            entity.userfield           = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Ejemplo n.º 2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromKpworkorder(ref DataRow row, Kpworkorder entity)
 {
     row.SetField("whse", entity.whse);
     row.SetField("prod", entity.prod);
     row.SetField("kitverno", entity.kitverno);
     row.SetField("kpetrowid", entity.kpetrowid.ToByteArray());
     row.SetField("wostarted", entity.wostarted);
     row.SetField("wono", entity.wono);
     row.SetField("wosuf", entity.wosuf);
     row.SetField("wono-c", entity.wonoC);
     row.SetField("unit", entity.unit);
     row.SetField("conv", entity.conv);
     row.SetField("unitdesc", entity.unitdesc);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("qtyship", entity.qtyship);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("stkqtyship", entity.stkqtyship);
     row.SetField("bofl", entity.bofl);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("refer", entity.refer);
     row.SetField("ordertype", entity.ordertype);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("orderaltsuf", entity.orderaltsuf);
     row.SetField("orderaltlineno", entity.orderaltlineno);
     row.SetField("orderaltseqno", entity.orderaltseqno);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("keyfl", entity.keyfl);
     row.SetField("optfl", entity.optfl);
     row.SetField("reqfl", entity.reqfl);
     row.SetField("allow8791fl", entity.allow8791fl);
     row.SetField("allowcomptiefl", entity.allowcomptiefl);
     row.SetField("allowshipoverridefl", entity.allowshipoverridefl);
     row.SetField("confirmdeletefl", entity.confirmdeletefl);
     row.SetField("fromsourcingfl", entity.fromsourcingfl);
     row.SetField("userfield", entity.userfield);
 }