Ejemplo n.º 1
0
        private void checkDictionarySource(DataTable dtCase)
        {
            DataTable dtSource = dbF.getDataByTable("frmsource", "visiofile='" + vsdFile + "'");

            foreach (DataRow drSource in dtSource.Rows)
            {
                checkSource(drSource, dtCase);
            }
        }
Ejemplo n.º 2
0
        private void checkSource(DataRow drSource, DataTable dtCase)
        {
            string    streamName   = drSource["streamname"].ToString();
            string    sourceType   = drSource["sourcetype"].ToString();
            DataTable dtDic_Source = db.getDataByTable("dictionarysource", "categoryvalue='" + sourceType + "'");
            DataRow   dr           = dtDic_Source.Rows[0];

            foreach (DataRow drCase in dtCase.Rows)
            {
                string caseid   = drCase["case_id"].ToString();
                string caseName = drCase["casename"].ToString();
                string sql      = "update frmcase_feed set flowstop=0 where streamname='" + streamName + "' and case_id=" + caseid;
                if (dr[caseName].ToString() == "0")
                {
                    sql = "update frmcase_feed set flowstop=1 where streamname='" + streamName + "' and case_id=" + caseid;
                }
                dbF.saveDataBySQL(sql);
            }
        }
Ejemplo n.º 3
0
        private void Window_Loaded_1(object sender, RoutedEventArgs e)
        {
            DataTable dtSource = db.getDataByTable("dictionarysource", "");

            gridSource.ItemsSource = dtSource.DefaultView;

            DataTable dtSink = db.getDataByTable("dictionarysink", "");

            gridSink.ItemsSource = dtSink.DefaultView;


            DataTable dtCondenser = db.getDataByTable("dictionarycondenser", "");

            gridCondenser.ItemsSource = dtCondenser.DefaultView;


            DataTable dtReboiler = db.getDataByTable("dictionaryreboiler", "");

            gridReboiler.ItemsSource = dtReboiler.DefaultView;
        }