/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromVaifbuildvalistcriteria(ref DataRow row, Vaifbuildvalistcriteria entity) { row.SetField("vano", entity.vano); row.SetField("vasuf", entity.vasuf); row.SetField("prod", entity.prod); row.SetField("verno", entity.verno); row.SetField("compprod", entity.compprod); row.SetField("whse", entity.whse); row.SetField("custno", entity.custno); row.SetField("vendno", entity.vendno); row.SetField("takenby", entity.takenby); row.SetField("slstage", entity.slstage); row.SetField("sltranstype", entity.sltranstype); row.SetField("slprodstat", entity.slprodstat); row.SetField("detailtype", entity.detailtype); row.SetField("fromentereddate", entity.fromentereddate); row.SetField("toentereddate", entity.toentereddate); row.SetField("frompromiseddate", entity.frompromiseddate); row.SetField("topromiseddate", entity.topromiseddate); row.SetField("fromreqshipdate", entity.fromreqshipdate); row.SetField("toreqshipdate", entity.toreqshipdate); row.SetField("fromestcompdt", entity.fromestcompdt); row.SetField("toestcompdt", entity.toestcompdt); row.SetField("slbotype", entity.slbotype); row.SetField("fromreceiptdt", entity.fromreceiptdt); row.SetField("toreceiptdt", entity.toreceiptdt); row.SetField("irecordcountlimit", entity.irecordcountlimit); row.SetField("userfield", entity.userfield); }
public static Vaifbuildvalistcriteria BuildVaifbuildvalistcriteriaFromRow(DataRow row) { Vaifbuildvalistcriteria entity = new Vaifbuildvalistcriteria(); entity.vano = row.IsNull("vano") ? 0 : row.Field <int>("vano"); entity.vasuf = row.IsNull("vasuf") ? 0 : row.Field <int>("vasuf"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.verno = row.IsNull("verno") ? 0 : row.Field <int>("verno"); entity.compprod = row.IsNull("compprod") ? string.Empty : row.Field <string>("compprod"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.takenby = row.IsNull("takenby") ? string.Empty : row.Field <string>("takenby"); entity.slstage = row.IsNull("slstage") ? string.Empty : row.Field <string>("slstage"); entity.sltranstype = row.IsNull("sltranstype") ? string.Empty : row.Field <string>("sltranstype"); entity.slprodstat = row.IsNull("slprodstat") ? string.Empty : row.Field <string>("slprodstat"); entity.detailtype = row.IsNull("detailtype") ? 0 : row.Field <int>("detailtype"); entity.fromentereddate = row.Field <DateTime?>("fromentereddate"); entity.toentereddate = row.Field <DateTime?>("toentereddate"); entity.frompromiseddate = row.Field <DateTime?>("frompromiseddate"); entity.topromiseddate = row.Field <DateTime?>("topromiseddate"); entity.fromreqshipdate = row.Field <DateTime?>("fromreqshipdate"); entity.toreqshipdate = row.Field <DateTime?>("toreqshipdate"); entity.fromestcompdt = row.Field <DateTime?>("fromestcompdt"); entity.toestcompdt = row.Field <DateTime?>("toestcompdt"); entity.slbotype = row.IsNull("slbotype") ? string.Empty : row.Field <string>("slbotype"); entity.fromreceiptdt = row.Field <DateTime?>("fromreceiptdt"); entity.toreceiptdt = row.Field <DateTime?>("toreceiptdt"); entity.irecordcountlimit = row.IsNull("irecordcountlimit") ? 0 : row.Field <int>("irecordcountlimit"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }