コード例 #1
0
ファイル: DataProvider.cs プロジェクト: seekerk/recept
 protected virtual void OnChanged(DataProviderEventArgs args)
 {
     if (args.ProcessLossChanged)
     {
         myProcessLossList = null;
         myProcessLossHash = null;
     }
     if (args.RawChanged)
     {
         myRawHash = null;
         myRawList = null;
     }
     if (args.TotalLossChanged)
     {
         myTotalLossList = null;
         myTotalLossHash = null;
     }
     if (Changed != null)
     {
         Changed(this, args);
     }
 }
コード例 #2
0
ファイル: DPodbc.cs プロジェクト: seekerk/recept
        /// <summary>
        /// получение таблицы потерь
        /// </summary>
        /// <returns>Массив записей потерь</returns>
        protected override SortableBindingList <DataTotalLoss> LoadTotalLossList()
        {
            DataTable totalLossTable = null;

            String sql = "SELECT * FROM totalLoss ORDER BY number ASC";

            try
            {
                if (this.conn.State == ConnectionState.Closed)
                {
                    this.conn.Open();
                }
                this.adapter.SelectCommand = new OdbcCommand(sql, this.conn);
                DataSet ds = new DataSet("Loss");
                ds.Locale = CultureInfo.InvariantCulture;
                this.adapter.Fill(ds);
                totalLossTable = ds.Tables[0];
            }
            catch (OdbcException pe)
            {
                MessageBox.Show(pe.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, 0);
                return(null);
            }

            SortableBindingList <DataTotalLoss> ret = new SortableBindingList <DataTotalLoss>();

            for (int i = 0; i < totalLossTable.Rows.Count; i++)
            {
                DataTotalLoss curData = new DataTotalLoss(null);
                curData.Id        = Convert.ToInt32(totalLossTable.Rows[i]["id"], CultureInfo.InvariantCulture);
                curData.Name      = totalLossTable.Rows[i]["name"].ToString();
                curData.Quantity  = Convert.ToDecimal(totalLossTable.Rows[i]["number"], CultureInfo.InvariantCulture);
                curData.Comment   = totalLossTable.Rows[i]["comment"].ToString();
                curData.IsChanged = false;
                ret.Add(curData);
            }
            return(ret);
        }
コード例 #3
0
ファイル: FormDB.cs プロジェクト: seekerk/recept
        // обновление списка и структуры после изменения БД
        void dp_Changed(object sender, DataProviderEventArgs args)
        {
            //int prevIDnum = currentRecord.id;
            //panelTotalLossData1._data = null;
            //panelRawData1._data = null;
            int curItem = listBox1.SelectedIndices[0];

            switch (myRecType)
            {
            case DataBaseType.TotalLossType:
                if (!args.TotalLossChanged)
                {
                    return;     // если обновление не тех данных, то просто выходим
                }
                SortableBindingList <DataTotalLoss> newLoss = Config.DP.TotalLossList;
                for (int i = 0; i < newLoss.Count; i++)
                {
                    if (newLoss[i].Equals(listBox1.Items[curItem]))
                    {
                        curItem = i;
                        break;
                    }
                }
                listBox1.Items.Clear();
                listBox1.Items.AddRange(newLoss.ToArray());
                break;

            case DataBaseType.RawType:
                if (!args.RawChanged)
                {
                    return;
                }
                SortableBindingList <DataRawStruct> newRaw = Config.DP.RawList;
                for (int i = 0; i < newRaw.Count; i++)
                {
                    if (((DataRawStruct)newRaw[i]).Equals(listBox1.Items[curItem]))
                    {
                        curItem = i;
                        break;
                    }
                }
                listBox1.Items.Clear();
                listBox1.Items.AddRange(Config.DP.RawList.ToArray());
                break;

            case DataBaseType.ProcessLossType:
                if (!args.ProcessLossChanged)
                {
                    return;
                }
                newRaw = Config.DP.ProcessLossList;
                for (int i = 0; i < newRaw.Count; i++)
                {
                    if (newRaw[i].Equals(listBox1.Items[curItem]))
                    {
                        curItem = i;
                        break;
                    }
                }
                listBox1.Items.Clear();
                listBox1.Items.AddRange(Config.DP.ProcessLossList.ToArray());
                break;

            default:
                throw new NotImplementedException("Not implemented");
            }
            if (listBox1.Items.Count > curItem)
            {
                listBox1.SelectedIndex = curItem;
            }
            else
            {
                listBox1.SelectedIndex = listBox1.Items.Count - 1;
            }
            this.IsDataChanged = false;
            //throw new Exception("The method or operation is not implemented.");
        }
コード例 #4
0
ファイル: DPodbc.cs プロジェクト: seekerk/recept
        protected override SortableBindingList <DataRawStruct> LoadDataRawList(string tableName)
        {
            DataTable comp_table = null;
            String    sql        = "SELECT * FROM " + tableName + " ORDER BY name ASC";

            try
            {
                if (this.conn.State == ConnectionState.Closed)
                {
                    this.conn.Open();
                }
                this.adapter.SelectCommand = new OdbcCommand(sql, this.conn);
                DataSet ds = new DataSet("tables");
                ds.Locale = CultureInfo.InvariantCulture;
                this.adapter.Fill(ds);
                comp_table = ds.Tables[0];
            }
            catch (OdbcException pe)
            {
                MessageBox.Show(pe.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, 0);
                return(null);
            }

            SortableBindingList <DataRawStruct> ret = new SortableBindingList <DataRawStruct>();

            for (int i = 0; i < comp_table.Rows.Count; i++)
            {
                DataRawStruct curRec = new DataRawStruct(null);
                curRec.Brutto      = Convert.ToDecimal(comp_table.Rows[i]["brutto"] is DBNull ? 0 : comp_table.Rows[i]["brutto"], CultureInfo.InvariantCulture);
                curRec.Caloric     = Convert.ToDecimal(comp_table.Rows[i]["caloric"] is DBNull ? 0 : comp_table.Rows[i]["caloric"], CultureInfo.InvariantCulture);
                curRec.starch      = Convert.ToDecimal(comp_table.Rows[i]["starch"] is DBNull ? 0 : comp_table.Rows[i]["starch"], CultureInfo.InvariantCulture);
                curRec.saccharides = Convert.ToDecimal(comp_table.Rows[i]["saccharides"] is DBNull ? 0 : comp_table.Rows[i]["saccharides"], CultureInfo.InvariantCulture);
                curRec.cellulose   = Convert.ToDecimal(comp_table.Rows[i]["cellulose"] is DBNull ? 0 : comp_table.Rows[i]["cellulose"], CultureInfo.InvariantCulture);
                curRec.cholesterol = Convert.ToDecimal(comp_table.Rows[i]["cholesterol"] is DBNull ? 0 : comp_table.Rows[i]["cholesterol"], CultureInfo.InvariantCulture);
                curRec.Comment     = comp_table.Rows[i]["comment"].ToString();
                curRec.fat         = Convert.ToDecimal(comp_table.Rows[i]["fat"] is DBNull ? 0 : comp_table.Rows[i]["fat"], CultureInfo.InvariantCulture);
                curRec.acid        = Convert.ToDecimal(comp_table.Rows[i]["acid"] is DBNull ? 0 : comp_table.Rows[i]["acid"], CultureInfo.InvariantCulture);
                curRec.ash         = Convert.ToDecimal(comp_table.Rows[i]["ash"] is DBNull ? 0 : comp_table.Rows[i]["ash"], CultureInfo.InvariantCulture);
                curRec.Id          = Convert.ToInt32(comp_table.Rows[i]["id"], CultureInfo.InvariantCulture);
                curRec.MineralCA   = Convert.ToDecimal(comp_table.Rows[i]["mineralCa"] is DBNull ? 0 : comp_table.Rows[i]["mineralCa"], CultureInfo.InvariantCulture);
                curRec.MineralFE   = Convert.ToDecimal(comp_table.Rows[i]["mineralFe"] is DBNull ? 0 : comp_table.Rows[i]["mineralFe"], CultureInfo.InvariantCulture);
                curRec.MineralK    = Convert.ToDecimal(comp_table.Rows[i]["mineralK"] is DBNull ? 0 : comp_table.Rows[i]["mineralK"], CultureInfo.InvariantCulture);
                curRec.MineralMG   = Convert.ToDecimal(comp_table.Rows[i]["mineralMg"] is DBNull ? 0 : comp_table.Rows[i]["mineralMg"], CultureInfo.InvariantCulture);
                curRec.MineralNA   = Convert.ToDecimal(comp_table.Rows[i]["mineralNa"] is DBNull ? 0 : comp_table.Rows[i]["mineralNa"], CultureInfo.InvariantCulture);
                curRec.MineralP    = Convert.ToDecimal(comp_table.Rows[i]["mineralP"] is DBNull ? 0 : comp_table.Rows[i]["mineralP"], CultureInfo.InvariantCulture);
                curRec.Name        = comp_table.Rows[i]["name"].ToString();
                curRec.NormativDoc = comp_table.Rows[i]["normativDoc"].ToString();
                curRec.protein     = Convert.ToDecimal(comp_table.Rows[i]["protein"] is DBNull ? 0 : comp_table.Rows[i]["protein"], CultureInfo.InvariantCulture);
                curRec.vitaminA    = Convert.ToDecimal(comp_table.Rows[i]["vitaminA"] is DBNull ? 0 : comp_table.Rows[i]["vitaminA"], CultureInfo.InvariantCulture);
                curRec.VitaminB    = Convert.ToDecimal(comp_table.Rows[i]["vitaminB"] is DBNull ? 0 : comp_table.Rows[i]["vitaminB"], CultureInfo.InvariantCulture);
                curRec.VitaminB1   = Convert.ToDecimal(comp_table.Rows[i]["vitaminB1"] is DBNull ? 0 : comp_table.Rows[i]["vitaminB1"], CultureInfo.InvariantCulture);
                curRec.VitaminB2   = Convert.ToDecimal(comp_table.Rows[i]["vitaminB2"] is DBNull ? 0 : comp_table.Rows[i]["vitaminB2"], CultureInfo.InvariantCulture);
                curRec.VitaminC    = Convert.ToDecimal(comp_table.Rows[i]["vitaminC"] is DBNull ? 0 : comp_table.Rows[i]["vitaminC"], CultureInfo.InvariantCulture);
                curRec.VitaminPP   = Convert.ToDecimal(comp_table.Rows[i]["vitaminPP"] is DBNull ? 0 : comp_table.Rows[i]["vitaminPP"], CultureInfo.InvariantCulture);
                curRec.Water       = Convert.ToDecimal(comp_table.Rows[i]["water"] is DBNull ? 0 : comp_table.Rows[i]["water"], CultureInfo.InvariantCulture);
                if (comp_table.Columns.Contains("inSostav"))
                {
                    curRec.InSostav = Convert.ToBoolean(comp_table.Rows[i]["inSostav"] is DBNull ? true : comp_table.Rows[i]["inSostav"], CultureInfo.InvariantCulture);
                }

                if (comp_table.Columns.Contains("inRecept"))
                {
                    curRec.InRecept = Convert.ToBoolean(comp_table.Rows[i]["inRecept"] is DBNull ? true : comp_table.Rows[i]["inRecept"], CultureInfo.InvariantCulture);
                }

                curRec.IsChanged = false;
                ret.Add(curRec);
            }

            return(ret);
        }
コード例 #5
0
ファイル: PanelReceptData.cs プロジェクト: seekerk/recept
        internal void LoadData(DataRecept data)
        {
            this.tbName.TextChanged        -= new System.EventHandler(this.tbTextChanged);
            this.tbNum.TextChanged         -= new System.EventHandler(this.tbTextChanged);
            this.tbWater.TextChanged       -= new System.EventHandler(this.tbTextChanged);
            this.tbWaterPlus.TextChanged   -= new System.EventHandler(this.tbTextChanged);
            this.tbWaterMinus.TextChanged  -= new System.EventHandler(this.tbTextChanged);
            this.tbTotalExit.TextChanged   -= new System.EventHandler(this.tbTextChanged);
            this.tbNormativDoc.TextChanged -= new System.EventHandler(this.tbTextChanged);
            this.tbSource.TextChanged      -= new System.EventHandler(this.tbTextChanged);
            this.tbPreview.TextChanged     -= new System.EventHandler(this.tbTextChanged);
            this.cbTotalLoss.TextChanged   -= new System.EventHandler(this.cbTextChanged);
            this.tbAcidity.TextChanged     -= new System.EventHandler(this.tbTextChanged);
            dgvRawList.CellValueChanged    -= new DataGridViewCellEventHandler(dgvRawList_CellValueChanged);

            myData = data;
            // настраиваем список потерь
            if (myTotalLoss == null)
            {
                myTotalLoss = Config.DP.TotalLossList;
                cbTotalLoss.Items.Clear();
                if (myTotalLoss != null && myTotalLoss.Count > 0)
                {
                    cbTotalLoss.Items.AddRange(myTotalLoss.ToArray());
                }
            }

            // настраиваем список компонент
            if (myRaw == null)
            {
                myRaw = Config.DP.RawList;
                cbName.Items.Clear();
                cbSetWater.Items.Clear();
                if (myRaw != null && myRaw.Count > 0)
                {
                    cbName.Items.AddRange(myRaw.ToArray());
                    cbSetWater.Items.AddRange(myRaw.ToArray());
                }
            }

            // настраиваем список производственных потерь
            if (myProcessLoss == null)
            {
                myProcessLoss = Config.DP.ProcessLossList;
                dgvRecProcessLoss.Items.Clear();
                if (myProcessLoss != null && myProcessLoss.Count > 0)
                {
                    dgvRecProcessLoss.Items.AddRange(myProcessLoss.ToArray());
                }
            }

            // шапка формы
            tbName.Text        = data.Name;
            tbNum.Text         = data.Id.ToString(CultureInfo.CurrentCulture);
            tbWater.Text       = data.water.ToString(CultureInfo.CurrentCulture);
            tbWaterPlus.Text   = data.waterPlus.ToString(CultureInfo.CurrentCulture);
            tbWaterMinus.Text  = data.waterMinus.ToString(CultureInfo.CurrentCulture);
            tbTotalExit.Text   = data.TotalExit.ToString(CultureInfo.CurrentCulture);
            tbCountExit.Text   = data.CountExit.ToString(CultureInfo.CurrentCulture);
            tbPreview.Text     = data.preview;
            tbSource.Text      = data.source;
            tbNormativDoc.Text = data.normativDoc;
            if (data.totalLoss != null)
            {
                cbTotalLoss.SelectedIndex = data.totalLoss.TotalLossNum;
            }
            else
            {
                cbTotalLoss.SelectedIndex = 0;
            }
            tbAcidity.Text = data.Acidity.ToString(CultureInfo.CurrentCulture);
            // TODO: добавить хранение элемента "вода" в настройках проги и включить отображение пункта когда он будет готов

            // тело формы
            dgvRawList.Nodes.Clear();
            //dgvRawList.Rows.Clear();
            LoadReceptData(dgvRawList.Nodes, data);
            //MessageBox.Show("Start Load2: " + dgvRawList.Nodes.Count);
            rbCalcExit.Checked  = data.isCalcExit;
            rbCalcWater.Checked = data.isCalcWater;
            rbSetWater.Checked  = data.isSetWater;

            this.tbName.TextChanged        += new System.EventHandler(this.tbTextChanged);
            this.tbNum.TextChanged         += new System.EventHandler(this.tbTextChanged);
            this.tbWater.TextChanged       += new System.EventHandler(this.tbTextChanged);
            this.tbWaterPlus.TextChanged   += new System.EventHandler(this.tbTextChanged);
            this.tbWaterMinus.TextChanged  += new System.EventHandler(this.tbTextChanged);
            this.tbTotalExit.TextChanged   += new System.EventHandler(this.tbTextChanged);
            this.tbNormativDoc.TextChanged += new System.EventHandler(this.tbTextChanged);
            this.tbSource.TextChanged      += new System.EventHandler(this.tbTextChanged);
            this.tbPreview.TextChanged     += new System.EventHandler(this.tbTextChanged);
            this.cbTotalLoss.TextChanged   += new System.EventHandler(this.cbTextChanged);
            dgvRawList.CellValueChanged    += new DataGridViewCellEventHandler(dgvRawList_CellValueChanged);
            this.tbAcidity.TextChanged     += new System.EventHandler(this.tbTextChanged);

            // Устанавливаем радиокнопки выбора
            //            this.rbCalcWater.CheckedChanged -= new System.EventHandler(this.RbCheckedChanged);
            //            this.rbCalcExit.CheckedChanged -= new System.EventHandler(this.RbCheckedChanged);
            //            this.rbSetWater.CheckedChanged -= new System.EventHandler(this.RbCheckedChanged);
            //            rbCalcExit.Checked = data.isCalcExit;
            //            rbCalcWater.Checked = data.isCalcWater;
            //            rbSetWater.Checked = data.isSetWater;
            //            this.rbCalcWater.CheckedChanged += new System.EventHandler(this.RbCheckedChanged);
            //            this.rbCalcExit.CheckedChanged += new System.EventHandler(this.RbCheckedChanged);
            //            this.rbSetWater.CheckedChanged += new System.EventHandler(this.RbCheckedChanged);

            myData.Changed += new EventHandler <DataBaseEventArgs> (_data_Changed);
        }