コード例 #1
0
        public static Potallycomponent BuildPotallycomponentFromRow(DataRow row)
        {
            Potallycomponent entity = new Potallycomponent();

            entity.lRandomMix      = row.Field <bool>("lRandomMix");
            entity.cMode           = row.IsNull("cMode") ? string.Empty : row.Field <string>("cMode");
            entity.cProd           = row.IsNull("cProd") ? string.Empty : row.Field <string>("cProd");
            entity.iQtyOrd         = row.IsNull("iQtyOrd") ? 0 : row.Field <int>("iQtyOrd");
            entity.lCancel         = row.Field <bool>("lCancel");
            entity.cWhse           = row.IsNull("cWhse") ? string.Empty : row.Field <string>("cWhse");
            entity.cTallyProd      = row.IsNull("cTallyProd") ? string.Empty : row.Field <string>("cTallyProd");
            entity.lMemoMix        = row.Field <bool>("lMemoMix");
            entity.iLength         = row.IsNull("iLength") ? 0 : row.Field <int>("iLength");
            entity.iICSpecRecNo    = row.IsNull("iICSpecRecNo") ? 0 : row.Field <int>("iICSpecRecNo");
            entity.iQtyShip        = row.IsNull("iQtyShip") ? 0 : row.Field <int>("iQtyShip");
            entity.lDelayResrvFl   = row.Field <bool>("lDelayResrvFl");
            entity.proddesc        = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
            entity.qtyavail        = row.IsNull("qtyavail") ? decimal.Zero : row.Field <decimal>("qtyavail");
            entity.compseqno       = row.IsNull("compseqno") ? 0 : row.Field <int>("compseqno");
            entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin");
            entity.tariffcd        = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd");
            entity.upcid           = row.IsNull("upcid") ? string.Empty : row.Field <string>("upcid");
            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 UpdateRowFromPotallycomponent(ref DataRow row, Potallycomponent entity)
 {
     row.SetField("lRandomMix", entity.lRandomMix);
     row.SetField("cMode", entity.cMode);
     row.SetField("cProd", entity.cProd);
     row.SetField("iQtyOrd", entity.iQtyOrd);
     row.SetField("lCancel", entity.lCancel);
     row.SetField("cWhse", entity.cWhse);
     row.SetField("cTallyProd", entity.cTallyProd);
     row.SetField("lMemoMix", entity.lMemoMix);
     row.SetField("iLength", entity.iLength);
     row.SetField("iICSpecRecNo", entity.iICSpecRecNo);
     row.SetField("iQtyShip", entity.iQtyShip);
     row.SetField("lDelayResrvFl", entity.lDelayResrvFl);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("qtyavail", entity.qtyavail);
     row.SetField("compseqno", entity.compseqno);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("upcid", entity.upcid);
     row.SetField("userfield", entity.userfield);
 }