public static WhereOperationUse FillItemWhereOperationUse(ODLDB210410DataSet.TN148Row anrow) { int seriaFrom = 0; if (!anrow.IsN_IZD_CNull() && anrow.N_IZD_C.Trim() != "") { int.TryParse(anrow.N_IZD_C.Trim(), out seriaFrom); if (seriaFrom < 0) { seriaFrom = 0; } } int seriaTo = 99999999; if (!anrow.IsN_IZD_PONull() && anrow.N_IZD_PO.Trim() != "") { int.TryParse(anrow.N_IZD_PO.Trim(), out seriaTo); if (seriaTo < 0) { seriaTo = 99999999; } } var whereUseItem = new WhereOperationUse(); whereUseItem.SeriaFrom = seriaFrom; whereUseItem.SeriaTo = seriaTo; whereUseItem.InfProductsChipher = 31; return(whereUseItem); }
private static LabourNorm FillItemLabourNorm(ODLDB210410DataSet.TN148Row anrow) { int resultKOD_PROF = 0; byte tarifNetDefault = 2; LabourNorm labourNormItem = new LabourNorm(); if (anrow.IsKOD_PROFNull()) { labourNormItem.ProfCode = 0; } else if (anrow.KOD_PROF.Contains(',')) { labourNormItem.ProfCode = int.Parse(anrow.KOD_PROF.Split(',').First()); } else { int.TryParse(anrow.KOD_PROF.Trim(), out resultKOD_PROF); } labourNormItem.ProfCode = resultKOD_PROF; labourNormItem.InfDetID = (!DicDetNumAndId.ContainsKey(anrow.NDET) ? 0 : DicDetNumAndId[anrow.NDET]); labourNormItem.OperNum = (anrow.IsOPTNull() ? "" : anrow.OPT); if (anrow.IsUCHNull()) { labourNormItem.DepRegion = 0; } else { labourNormItem.DepRegion = anrow.UCH.Contains("ъ") || anrow.UCH.Contains("+") || anrow.UCH.First() == '0' || anrow.UCH.First() == ' ' || anrow.UCH.Last() == '-' || anrow.UCH.Last() == ',' ? 0 : double.Parse(anrow.UCH.Trim().Replace('.', ',').Replace('/', ',')); } labourNormItem.NameKindWork = anrow.IsNAIM_VIDA_RABNull() ? "" : anrow.NAIM_VIDA_RAB; labourNormItem.TariffNetNum = (anrow.IsTarifNull() || anrow.Tarif.Trim() == "") ? tarifNetDefault : byte.Parse(anrow.Tarif.Trim()); labourNormItem.KindPay = anrow.IsB1Null() ? "C" : anrow.B1; labourNormItem.WorkerRate = (anrow.IsRAZRNull() || anrow.RAZR.Equals("+") || anrow.RAZR.Trim() == "") ? 0 : double.Parse(anrow.RAZR.Replace(".", ",").Trim()); labourNormItem.ItemCTN = (anrow.IsPTN_SHTNull() ? 0 : double.Parse(anrow.PTN_SHT.ToString())); labourNormItem.PreparTimeCTN = (anrow.IsPTN_PZVNull() ? 0 : double.Parse(anrow.PTN_PZV.ToString())); labourNormItem.ItemPayNorm = (anrow.IsPLAT_SHTNull() ? 0 : double.Parse(anrow.PLAT_SHT.ToString())); labourNormItem.PreparTimePayNorm = (anrow.IsPLAT_PZVNull() ? 0 : double.Parse(anrow.PLAT_PZV.ToString())); labourNormItem.Valuation = (anrow.IsRASCENull() || anrow.RASCE == "0.00" || anrow.RASCE == "0.0" || anrow.RASCE.Trim() == "") ? 0 : double.Parse(anrow.RASCE); labourNormItem.ValPreparTime = (anrow.IsRASC_PZVNull() ? 0 : double.Parse(anrow.RASC_PZV.ToString())); labourNormItem.CoeffCTN = (anrow.IsPTNNull() ? 0 : double.Parse(anrow.PTN.ToString())); labourNormItem.DocNum = (anrow.IsN_DOKNull() ? "" : anrow.N_DOK); labourNormItem.Date = DateTime.Now; labourNormItem.TaskNumber = (anrow.IsN_zadanNull() ? "" : anrow.N_zadan); return(labourNormItem); }