Пример #1
0
        private static void FilltmpInfTarifDetRow(ref InfTariff infTariff)
        {
            DataRow rowTempInfDet = InfTariffDataTable.NewRow();

            rowTempInfDet[0] = infTariff.TariffNetNum;
            rowTempInfDet[1] = infTariff.KindPay;
            rowTempInfDet[2] = infTariff.WorkerRate;
            rowTempInfDet[3] = infTariff.HourCost;
            InfTariffDataTable.Rows.Add(rowTempInfDet);
        }
Пример #2
0
        private static InfTariff FillInfTarifItem(ODLDB210410DataSet.TARIFRow trow)
        {
            InfTariff infTariff = new InfTariff();

            infTariff.KindPay      = trow.VO;
            infTariff.HourCost     = double.Parse(trow.STOIM_RAZR);
            infTariff.TariffNetNum = byte.Parse(trow.N_TARIF_SETKI);
            infTariff.WorkerRate   = double.Parse(trow.RAZR.Replace('.', ','));
            return(infTariff);
        }
Пример #3
0
        public static void InsertFromTARIF()
        {
            foreach (var item in TarifDataTable)
            {
                InfTariff infTariff = FillInfTarifItem(item);
                FilltmpInfTarifDetRow(ref infTariff);
            }

            SqlCeBulkCopy bulkInsert   = new SqlCeBulkCopy(connString);
            DataTable     tmpInfTariff = InfTariffDataTable;

            if (tmpInfTariff.Rows.Count > 0)
            {
                bulkInsert.DestinationTableName = "infTariff";
                bulkInsert.WriteToServer(tmpInfTariff);
            }
            bulkInsert.Close();
            bulkInsert.Dispose();
            tmpInfTariff.Dispose();
        }