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