コード例 #1
0
ファイル: ProductExports.cs プロジェクト: tousekdominik/SkSys
 public ProductExports(MySQLDriver driver)
 {
     this._SQL = driver;
     _units = new Units(_SQL);
     _products = new Products(_SQL);
     _months = new Months();
     _deadlines = new Deadlines(_SQL);
 }
コード例 #2
0
ファイル: Materials.cs プロジェクト: tousekdominik/SkSys
        private Material parseLine(String line)
        {
            String IDString = MySQLDriver.parseCollumn(line, "ID", true);
            String NameString = MySQLDriver.parseCollumn(line, "NAME");
            String PriceString = MySQLDriver.parseCollumn(line, "PRICE", true).Replace('.', ',');
            String AmountString = MySQLDriver.parseCollumn(line, "AMOUNT", true).Replace('.', ',');
            String IDCompanyString = MySQLDriver.parseCollumn(line, "ID_COMPANY", true);
            String InvoiceNumberString = MySQLDriver.parseCollumn(line, "INVOICE_NUMBER", true);
            String IDUnitString = MySQLDriver.parseCollumn(line, "ID_UNIT", true);
            String MonthString = MySQLDriver.parseCollumn(line, "MONTH", true);
            String YearString = MySQLDriver.parseCollumn(line, "YEAR", true);
            String CurrencyString = MySQLDriver.parseCollumn(line, "CURRENCY", true);
            String ShippingDateString = MySQLDriver.parseCollumn(line, "SHIPPINGDATE", true);
            String CourseDateString = MySQLDriver.parseCollumn(line, "COURSEDATE", true);
            String CourseString = MySQLDriver.parseCollumn(line, "COURSE", true).Replace('.', ',');
            String MaterialTypeIdString = MySQLDriver.parseCollumn(line, "ID_MATERIALTYPE", true);
            String ShippingString = MySQLDriver.parseCollumn(line, "SHIPPINGPRICE", true).Replace('.',',');
            String DeadlineString = MySQLDriver.parseCollumn(line, "ID_DEADLINE", true);

            int matTypeId = int.Parse(MaterialTypeIdString);
            MaterialType materialTypeItem = new MaterialType(0, "");
            if (matTypeId != 0)
            {
                materialTypeItem = _materialTypes.GetRecord(matTypeId);
            }

            Month actmonth = new Months().getMonth(int.Parse(MonthString));

            Deadline dead = _deadlines.GetRecord(int.Parse(DeadlineString));
            if (dead == null)
            {
                dead = Deadlines.Default;
            }

            try
            {
                return new Material(int.Parse(IDString), NameString, float.Parse(PriceString), float.Parse(AmountString), _companies.GetRecord(int.Parse(IDCompanyString)),
                    int.Parse(InvoiceNumberString), _units.GetRecord(int.Parse(IDUnitString)), materialTypeItem, actmonth, int.Parse(YearString),
                    _currencies.getCurrency(int.Parse(CurrencyString)), DateTimeUtils.SQLDateToDateTime(ShippingDateString), DateTimeUtils.SQLDateToDateTime(CourseDateString),
                    float.Parse(CourseString), float.Parse(ShippingString), dead);
            }
            catch (Exception) {
                _SQL.getConnector().setError();
                return Default;
            }
        }