Esempio n. 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromWtrrarlinedspllinesur(ref DataRow row, Wtrrarlinedspllinesur entity)
 {
     row.SetField("accepttype", entity.accepttype);
     row.SetField("specnstype", entity.specnstype);
     row.SetField("commentfl", entity.commentfl);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("descrip", entity.descrip);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("unit", entity.unit);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("rushfl", entity.rushfl);
     row.SetField("lineno", entity.lineno);
     row.SetField("seqno", entity.seqno);
     row.SetField("criticalfl", entity.criticalfl);
     row.SetField("superfl", entity.superfl);
     row.SetField("linewhse", entity.linewhse);
     row.SetField("reportno", entity.reportno);
     row.SetField("brandcode", entity.brandcode);
     row.SetField("mfgprod", entity.mfgprod);
     row.SetField("vendprod", entity.vendprod);
     row.SetField("msdsfl", entity.msdsfl);
     row.SetField("origaccepttype", entity.origaccepttype);
     row.SetField("origqtyord", entity.origqtyord);
     row.SetField("rowid-wteral", entity.rowidWteral.ToByteArray());
     row.SetField("userfield", entity.userfield);
 }
Esempio n. 2
0
        public static Wtrrarlinedspllinesur BuildWtrrarlinedspllinesurFromRow(DataRow row)
        {
            Wtrrarlinedspllinesur entity = new Wtrrarlinedspllinesur();

            entity.accepttype     = row.IsNull("accepttype") ? string.Empty : row.Field <string>("accepttype");
            entity.specnstype     = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype");
            entity.commentfl      = row.Field <bool>("commentfl");
            entity.notesfl        = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.shipprod       = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.descrip        = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
            entity.qtyord         = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.unit           = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.prodcost       = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
            entity.rushfl         = row.Field <bool>("rushfl");
            entity.lineno         = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.seqno          = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
            entity.criticalfl     = row.Field <bool>("criticalfl");
            entity.superfl        = row.Field <bool>("superfl");
            entity.linewhse       = row.IsNull("linewhse") ? string.Empty : row.Field <string>("linewhse");
            entity.reportno       = row.IsNull("reportno") ? 0 : row.Field <int>("reportno");
            entity.brandcode      = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode");
            entity.mfgprod        = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod");
            entity.vendprod       = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
            entity.msdsfl         = row.Field <bool>("msdsfl");
            entity.origaccepttype = row.IsNull("origaccepttype") ? string.Empty : row.Field <string>("origaccepttype");
            entity.origqtyord     = row.IsNull("origqtyord") ? decimal.Zero : row.Field <decimal>("origqtyord");
            entity.rowidWteral    = row.Field <byte[]>("rowid-wteral").ToStringEncoded();
            entity.userfield      = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
Esempio n. 3
0
        public static Wtrrarlinedsplline BuildWtrrarlinedspllineFromRow(DataRow row)
        {
            Wtrrarlinedsplline entity = new Wtrrarlinedsplline();

            entity.accepttype          = row.IsNull("accepttype") ? string.Empty : row.Field <string>("accepttype");
            entity.specnstype          = row.IsNull("specnstype") ? string.Empty : row.Field <string>("specnstype");
            entity.commentfl           = row.Field <bool>("commentfl");
            entity.notesfl             = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.shipprod            = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
            entity.descrip             = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
            entity.qtyord              = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord");
            entity.unit                = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
            entity.prodcost            = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
            entity.rushfl              = row.Field <bool>("rushfl");
            entity.lineno              = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
            entity.seqno               = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
            entity.criticalfl          = row.Field <bool>("criticalfl");
            entity.superfl             = row.Field <bool>("superfl");
            entity.reportno            = row.IsNull("reportno") ? 0 : row.Field <int>("reportno");
            entity.brandcode           = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode");
            entity.mfgprod             = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod");
            entity.vendprod            = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
            entity.rowidWteral         = row.Field <byte[]>("rowid-wteral").ToStringEncoded();
            entity.custreserveqty      = row.IsNull("custreserveqty") ? decimal.Zero : row.Field <decimal>("custreserveqty");
            entity.custreservefoundfl  = row.Field <bool>("custreservefoundfl");
            entity.custforecastqty     = row.IsNull("custforecastqty") ? decimal.Zero : row.Field <decimal>("custforecastqty");
            entity.custforecastfoundfl = row.Field <bool>("custforecastfoundfl");
            entity.msdsfl              = row.Field <bool>("msdsfl");
            entity.surplus             = row.Field <bool>("surplus");
            entity.userfield           = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            foreach (var dRow in row.GetChildRows("C_Surplus"))
            {
                Wtrrarlinedspllinesur wtrrarlinedspllinesur = new Wtrrarlinedspllinesur();
                wtrrarlinedspllinesur = (Wtrrarlinedspllinesur)SetKeyFields(entity, Wtrrarlinedspllinesur.BuildWtrrarlinedspllinesurFromRow(dRow), "reportno,lineno", "reportno,lineno");
                entity.wtrrarlinedspllinesur.Add(wtrrarlinedspllinesur);
            }
            return(entity);
        }