public static Physinvsummary BuildPhysinvsummaryFromRow(DataRow row) { Physinvsummary entity = new Physinvsummary(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.userId = row.IsNull("user_id") ? string.Empty : row.Field <string>("user_id"); entity.elapsed = row.IsNull("elapsed") ? string.Empty : row.Field <string>("elapsed"); entity.lastCnt = row.IsNull("last_cnt") ? string.Empty : row.Field <string>("last_cnt"); entity.startDt = row.IsNull("start_dt") ? string.Empty : row.Field <string>("start_dt"); entity.endDt = row.IsNull("end_dt") ? string.Empty : row.Field <string>("end_dt"); entity.chStart = row.IsNull("ch_start") ? string.Empty : row.Field <string>("ch_start"); entity.chEnd = row.IsNull("ch_end") ? string.Empty : row.Field <string>("ch_end"); entity.physStatus = row.IsNull("phys_status") ? string.Empty : row.Field <string>("phys_status"); entity.invCompPcnt = row.IsNull("inv_comp_pcnt") ? decimal.Zero : row.Field <decimal>("inv_comp_pcnt"); entity.invCorPcnt = row.IsNull("inv_cor_pcnt") ? decimal.Zero : row.Field <decimal>("inv_cor_pcnt"); entity.locCompPcnt = row.IsNull("loc_comp_pcnt") ? decimal.Zero : row.Field <decimal>("loc_comp_pcnt"); entity.locCorPcnt = row.IsNull("loc_cor_pcnt") ? decimal.Zero : row.Field <decimal>("loc_cor_pcnt"); entity.unitCompPcnt = row.IsNull("unit_comp-pcnt") ? decimal.Zero : row.Field <decimal>("unit_comp-pcnt"); entity.unitCorPcnt = row.IsNull("unit_cor_pcnt") ? decimal.Zero : row.Field <decimal>("unit_cor_pcnt"); entity.invCnt = row.IsNull("inv_cnt") ? 0 : row.Field <int>("inv_cnt"); entity.invCor = row.IsNull("inv_cor") ? 0 : row.Field <int>("inv_cor"); entity.invUnc = row.IsNull("inv_unc") ? 0 : row.Field <int>("inv_unc"); entity.locCnt = row.IsNull("loc_cnt") ? 0 : row.Field <int>("loc_cnt"); entity.locCor = row.IsNull("loc_cor") ? 0 : row.Field <int>("loc_cor"); entity.locUnc = row.IsNull("loc_unc") ? 0 : row.Field <int>("loc_unc"); entity.unitCnt = row.IsNull("unit_cnt") ? decimal.Zero : row.Field <decimal>("unit_cnt"); entity.unitCor = row.IsNull("unit_cor") ? decimal.Zero : row.Field <decimal>("unit_cor"); entity.unitUnc = row.IsNull("unit_unc") ? decimal.Zero : row.Field <decimal>("unit_unc"); entity.isLocUnc = row.Field <bool>("is_loc_unc"); entity.isInvUnc = row.Field <bool>("is_inv_unc"); entity.isLocDis = row.Field <bool>("is_loc_dis"); entity.isInvDis = row.Field <bool>("is_inv_dis"); entity.isZoneDis = row.Field <bool>("is_zone_dis"); entity.isLocNact = row.Field <bool>("is_loc_nact"); entity.isPhysical = row.Field <bool>("is_physical"); entity.isDeactivated = row.Field <bool>("is_deactivated"); entity.deactivateDt = row.IsNull("deactivate_dt") ? string.Empty : row.Field <string>("deactivate_dt"); entity.countBinsLeft = row.IsNull("count_bins_left") ? 0 : row.Field <int>("count_bins_left"); entity.countInvsLeft = row.IsNull("count_invs_left") ? 0 : row.Field <int>("count_invs_left"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPhysinvsummary(ref DataRow row, Physinvsummary entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("user_id", entity.userId); row.SetField("elapsed", entity.elapsed); row.SetField("last_cnt", entity.lastCnt); row.SetField("start_dt", entity.startDt); row.SetField("end_dt", entity.endDt); row.SetField("ch_start", entity.chStart); row.SetField("ch_end", entity.chEnd); row.SetField("phys_status", entity.physStatus); row.SetField("inv_comp_pcnt", entity.invCompPcnt); row.SetField("inv_cor_pcnt", entity.invCorPcnt); row.SetField("loc_comp_pcnt", entity.locCompPcnt); row.SetField("loc_cor_pcnt", entity.locCorPcnt); row.SetField("unit_comp-pcnt", entity.unitCompPcnt); row.SetField("unit_cor_pcnt", entity.unitCorPcnt); row.SetField("inv_cnt", entity.invCnt); row.SetField("inv_cor", entity.invCor); row.SetField("inv_unc", entity.invUnc); row.SetField("loc_cnt", entity.locCnt); row.SetField("loc_cor", entity.locCor); row.SetField("loc_unc", entity.locUnc); row.SetField("unit_cnt", entity.unitCnt); row.SetField("unit_cor", entity.unitCor); row.SetField("unit_unc", entity.unitUnc); row.SetField("is_loc_unc", entity.isLocUnc); row.SetField("is_inv_unc", entity.isInvUnc); row.SetField("is_loc_dis", entity.isLocDis); row.SetField("is_inv_dis", entity.isInvDis); row.SetField("is_zone_dis", entity.isZoneDis); row.SetField("is_loc_nact", entity.isLocNact); row.SetField("is_physical", entity.isPhysical); row.SetField("is_deactivated", entity.isDeactivated); row.SetField("deactivate_dt", entity.deactivateDt); row.SetField("count_bins_left", entity.countBinsLeft); row.SetField("count_invs_left", entity.countInvsLeft); row.SetField("userfield", entity.userfield); }