예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromLoadexcptreceiptsttresults(ref DataRow row, Loadexcptreceiptsttresults entity)
 {
     row.SetField("receiptdt", entity.receiptdt);
     row.SetField("pono", entity.pono);
     row.SetField("posuf", entity.posuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("rcvnetavl", entity.rcvnetavl);
     row.SetField("rcvsafety", entity.rcvsafety);
     row.SetField("leadtime", entity.leadtime);
     row.SetField("ignoreltfl", entity.ignoreltfl);
     row.SetField("safetypct", entity.safetypct);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("qtyrcv", entity.qtyrcv);
     row.SetField("unit", entity.unit);
     row.SetField("qtycosted", entity.qtycosted);
     row.SetField("netamt", entity.netamt);
     row.SetField("netrcv", entity.netrcv);
     row.SetField("enterdt", entity.enterdt);
     row.SetField("userfield", entity.userfield);
 }
예제 #2
0
        public static Loadexcptreceiptsttresults BuildLoadexcptreceiptsttresultsFromRow(DataRow row)
        {
            Loadexcptreceiptsttresults entity = new Loadexcptreceiptsttresults();

            entity.receiptdt  = row.Field <DateTime?>("receiptdt");
            entity.pono       = row.IsNull("pono") ? 0 : row.Field <int>("pono");
            entity.posuf      = row.IsNull("posuf") ? 0 : row.Field <int>("posuf");
            entity.lineno     = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.rcvnetavl  = row.IsNull("rcvnetavl") ? decimal.Zero : row.Field <decimal>("rcvnetavl");
            entity.rcvsafety  = row.IsNull("rcvsafety") ? decimal.Zero : row.Field <decimal>("rcvsafety");
            entity.leadtime   = row.IsNull("leadtime") ? 0 : row.Field <int>("leadtime");
            entity.ignoreltfl = row.Field <bool>("ignoreltfl");
            entity.safetypct  = row.IsNull("safetypct") ? decimal.Zero : row.Field <decimal>("safetypct");
            entity.qtyord     = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.qtyrcv     = row.IsNull("qtyrcv") ? decimal.Zero : row.Field <decimal>("qtyrcv");
            entity.unit       = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.qtycosted  = row.IsNull("qtycosted") ? decimal.Zero : row.Field <decimal>("qtycosted");
            entity.netamt     = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt");
            entity.netrcv     = row.IsNull("netrcv") ? decimal.Zero : row.Field <decimal>("netrcv");
            entity.enterdt    = row.Field <DateTime?>("enterdt");
            entity.userfield  = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }