Пример #1
0
        protected override void Update(string conditionSql, int unionType, string comboValue)
        {
            string cellName = CommonUtil.GetCellName(m_db.Conn);

            string sql = SqlForErrorHistory.GetListSql(conditionSql, unionType, cellName);

            System.Data.DataTable table = m_db.getDataTable(sql);

            errorHistory.DataContext = table;
        }
Пример #2
0
        /// <summary>
        /// 検索条件SQLを取得
        /// </summary>
        /// <returns></returns>
        public override string GetConditionSql()
        {
            List <string> values = new List <string>();

            //  検索期間
            if (this.checkStartEnd.IsChecked == true)
            {
                if (this.dateStart.SelectedDate != null)
                {
                    string sql = SqlForErrorHistory.GetStartSql((DateTime)this.dateStart.SelectedDate);
                    values.Add(sql);
                }
                if (this.dateEnd.SelectedDate != null)
                {
                    string sql = SqlForErrorHistory.GetEndSql((DateTime)this.dateEnd.SelectedDate);
                    values.Add(sql);
                }
            }

            return(string.Join(" and ", values));
        }