Ejemplo n.º 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromSleeprodlistcriteria(ref DataRow row, Sleeprodlistcriteria entity)
 {
     row.SetField("imptype", entity.imptype);
     row.SetField("slupdtno", entity.slupdtno);
     row.SetField("recordlimit", entity.recordlimit);
     row.SetField("dispprodbeg", entity.dispprodbeg);
     row.SetField("dispprodend", entity.dispprodend);
     row.SetField("disperror", entity.disperror);
     row.SetField("disphold", entity.disphold);
     row.SetField("dispignore", entity.dispignore);
     row.SetField("dispdelete", entity.dispdelete);
     row.SetField("dispupdate", entity.dispupdate);
     row.SetField("dispnewprod", entity.dispnewprod);
     row.SetField("dispslgroup", entity.dispslgroup);
     row.SetField("dispslgroupfl", entity.dispslgroupfl);
     row.SetField("dispwhse", entity.dispwhse);
     row.SetField("dispwhsefl", entity.dispwhsefl);
     row.SetField("dispprodcat", entity.dispprodcat);
     row.SetField("dispprodcatfl", entity.dispprodcatfl);
     row.SetField("disppricetype", entity.disppricetype);
     row.SetField("disppricetypefl", entity.disppricetypefl);
     row.SetField("dispprodline", entity.dispprodline);
     row.SetField("dispprodlinefl", entity.dispprodlinefl);
     row.SetField("dispvendno", entity.dispvendno);
     row.SetField("dispvendnofl", entity.dispvendnofl);
     row.SetField("dispsortty", entity.dispsortty);
     row.SetField("colnum1", entity.colnum1);
     row.SetField("colnum2", entity.colnum2);
     row.SetField("userfield", entity.userfield);
 }
Ejemplo n.º 2
0
        public static Sleeprodlistcriteria BuildSleeprodlistcriteriaFromRow(DataRow row)
        {
            Sleeprodlistcriteria entity = new Sleeprodlistcriteria();

            entity.imptype         = row.IsNull("imptype") ? string.Empty : row.Field <string>("imptype");
            entity.slupdtno        = row.IsNull("slupdtno") ? string.Empty : row.Field <string>("slupdtno");
            entity.recordlimit     = row.IsNull("recordlimit") ? 0 : row.Field <int>("recordlimit");
            entity.dispprodbeg     = row.IsNull("dispprodbeg") ? string.Empty : row.Field <string>("dispprodbeg");
            entity.dispprodend     = row.IsNull("dispprodend") ? string.Empty : row.Field <string>("dispprodend");
            entity.disperror       = row.Field <bool>("disperror");
            entity.disphold        = row.Field <bool>("disphold");
            entity.dispignore      = row.Field <bool>("dispignore");
            entity.dispdelete      = row.Field <bool>("dispdelete");
            entity.dispupdate      = row.Field <bool>("dispupdate");
            entity.dispnewprod     = row.Field <bool>("dispnewprod");
            entity.dispslgroup     = row.IsNull("dispslgroup") ? string.Empty : row.Field <string>("dispslgroup");
            entity.dispslgroupfl   = row.Field <bool>("dispslgroupfl");
            entity.dispwhse        = row.IsNull("dispwhse") ? string.Empty : row.Field <string>("dispwhse");
            entity.dispwhsefl      = row.Field <bool>("dispwhsefl");
            entity.dispprodcat     = row.IsNull("dispprodcat") ? string.Empty : row.Field <string>("dispprodcat");
            entity.dispprodcatfl   = row.Field <bool>("dispprodcatfl");
            entity.disppricetype   = row.IsNull("disppricetype") ? string.Empty : row.Field <string>("disppricetype");
            entity.disppricetypefl = row.Field <bool>("disppricetypefl");
            entity.dispprodline    = row.IsNull("dispprodline") ? string.Empty : row.Field <string>("dispprodline");
            entity.dispprodlinefl  = row.Field <bool>("dispprodlinefl");
            entity.dispvendno      = row.IsNull("dispvendno") ? decimal.Zero : row.Field <decimal>("dispvendno");
            entity.dispvendnofl    = row.Field <bool>("dispvendnofl");
            entity.dispsortty      = row.IsNull("dispsortty") ? string.Empty : row.Field <string>("dispsortty");
            entity.colnum1         = row.IsNull("colnum1") ? 0 : row.Field <int>("colnum1");
            entity.colnum2         = row.IsNull("colnum2") ? 0 : row.Field <int>("colnum2");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }