예제 #1
0
        public static Poeilineextend BuildPoeilineextendFromRow(DataRow row)
        {
            Poeilineextend entity = new Poeilineextend();

            entity.poeirowid               = row.Field <byte[]>("poeirowid").ToStringEncoded();
            entity.shipprod                = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.descrip                 = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
            entity.vendprod                = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
            entity.upcid                   = row.IsNull("upcid") ? string.Empty : row.Field <string>("upcid");
            entity.qtyord                  = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.unit                    = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.stkqtyord               = row.IsNull("stkqtyord") ? decimal.Zero : row.Field <decimal>("stkqtyord");
            entity.stkqtyrcv               = row.IsNull("stkqtyrcv") ? decimal.Zero : row.Field <decimal>("stkqtyrcv");
            entity.rcvunit                 = row.IsNull("rcvunit") ? string.Empty : row.Field <string>("rcvunit");
            entity.qtyunavail              = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail");
            entity.unavailunit             = row.IsNull("unavailunit") ? string.Empty : row.Field <string>("unavailunit");
            entity.qtyassign               = row.IsNull("qtyassign") ? decimal.Zero : row.Field <decimal>("qtyassign");
            entity.binloc1                 = row.IsNull("binloc1") ? string.Empty : row.Field <string>("binloc1");
            entity.binloc2                 = row.IsNull("binloc2") ? string.Empty : row.Field <string>("binloc2");
            entity.reasunavty              = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty");
            entity.sruninreasfl            = row.Field <bool>("sruninreasfl");
            entity.ignoreltfl              = row.Field <bool>("ignoreltfl");
            entity.copybinlocsfl           = row.Field <bool>("copybinlocsfl");
            entity.netbillty               = row.IsNull("netbillty") ? string.Empty : row.Field <string>("netbillty");
            entity.rebamtnetbill           = row.IsNull("rebamtnetbill") ? decimal.Zero : row.Field <decimal>("rebamtnetbill");
            entity.cbReasUnAvTySensitive   = row.Field <bool>("cbReasUnAvTy-sensitive");
            entity.fiQtyUnavailSensitive   = row.Field <bool>("fiQtyUnavail-sensitive");
            entity.fiBinLocation1Sensitive = row.Field <bool>("fiBinLocation1-sensitive");
            entity.fiBinLocation2Sensitive = row.Field <bool>("fiBinLocation2-sensitive");
            entity.btnOKSensitive          = row.Field <bool>("Btn_OK-sensitive");
            entity.tgCopyBinLocsSensitive  = row.Field <bool>("tgCopyBinLocs-sensitive");
            entity.tgIgnoreLTFlSensitive   = row.Field <bool>("tgIgnoreLTFl-sensitive");
            entity.netbilltySensitive      = row.Field <bool>("netbillty-sensitive");
            entity.rebamtnetbillSensitive  = row.Field <bool>("rebamtnetbill-sensitive");
            entity.tgCopyBinLocsHidden     = row.Field <bool>("tgCopyBinLocs-hidden");
            entity.netbilltyHidden         = row.Field <bool>("netbillty-hidden");
            entity.rebamtnetbillHidden     = row.Field <bool>("rebamtnetbill-hidden");
            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 UpdateRowFromPoeilineextend(ref DataRow row, Poeilineextend entity)
 {
     row.SetField("poeirowid", entity.poeirowid.ToByteArray());
     row.SetField("shipprod", entity.shipprod);
     row.SetField("descrip", entity.descrip);
     row.SetField("vendprod", entity.vendprod);
     row.SetField("upcid", entity.upcid);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("unit", entity.unit);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("stkqtyrcv", entity.stkqtyrcv);
     row.SetField("rcvunit", entity.rcvunit);
     row.SetField("qtyunavail", entity.qtyunavail);
     row.SetField("unavailunit", entity.unavailunit);
     row.SetField("qtyassign", entity.qtyassign);
     row.SetField("binloc1", entity.binloc1);
     row.SetField("binloc2", entity.binloc2);
     row.SetField("reasunavty", entity.reasunavty);
     row.SetField("sruninreasfl", entity.sruninreasfl);
     row.SetField("ignoreltfl", entity.ignoreltfl);
     row.SetField("copybinlocsfl", entity.copybinlocsfl);
     row.SetField("netbillty", entity.netbillty);
     row.SetField("rebamtnetbill", entity.rebamtnetbill);
     row.SetField("cbReasUnAvTy-sensitive", entity.cbReasUnAvTySensitive);
     row.SetField("fiQtyUnavail-sensitive", entity.fiQtyUnavailSensitive);
     row.SetField("fiBinLocation1-sensitive", entity.fiBinLocation1Sensitive);
     row.SetField("fiBinLocation2-sensitive", entity.fiBinLocation2Sensitive);
     row.SetField("Btn_OK-sensitive", entity.btnOKSensitive);
     row.SetField("tgCopyBinLocs-sensitive", entity.tgCopyBinLocsSensitive);
     row.SetField("tgIgnoreLTFl-sensitive", entity.tgIgnoreLTFlSensitive);
     row.SetField("netbillty-sensitive", entity.netbilltySensitive);
     row.SetField("rebamtnetbill-sensitive", entity.rebamtnetbillSensitive);
     row.SetField("tgCopyBinLocs-hidden", entity.tgCopyBinLocsHidden);
     row.SetField("netbillty-hidden", entity.netbilltyHidden);
     row.SetField("rebamtnetbill-hidden", entity.rebamtnetbillHidden);
     row.SetField("userfield", entity.userfield);
 }