/// <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); }
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); }