public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List <lsttbl_DWColumn>;
if (ds == null)
{
return(null);
}
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.HavingKey = new InqSummaryInfoMDX(new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType), "SUM");
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
if (Lib.StringIsDigit(this.txtValue.Text))
{
ret.Value = this.txtValue.Text;
}
else
{
ret.Value = Lib.GetStringDigit(this.txtValue.Text);
}
ret.FilterType = "NUM";
return(ret);
}
catch { return(null); }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List<lsttbl_DWColumn>;
if (ds == null) return null;
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.WhereKey = new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType);
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
if (item.ColName == "Year")
{
ret.Value = this.txtValue.Date.Year;
}
else if (item.ColName == "Quarter")
{
ret.Value = this.txtValue.Date.Day;
}
else if (item.ColName == "Period")
{
ret.Value = this.txtValue.Date.ToString("yyyyMM");
}
else
{
ret.Value = this.txtValue.Date.ToString("yyyy/MM/dd");
}
ret.FilterType = "DATE";
return ret;
}
catch { return null; }
}
public override void Set_Info(InqFilterInfoMDX info)
{
if (!info.HasWhereKey()) return;
this.cbbKeyField.Value = info.WhereKey.UniqueName;
this.cbbOperator.Value = info.Operator;
this.txtValue.Text = info.Value.ToString();
this.cbbAndOr.Value = info.Logic;
}
public override void Set_Info(InqFilterInfoMDX info)
{
if (!info.HasHavingKey())
{
return;
}
this.cbbKeyField.Value = info.HavingKey.Field.KeyField;
this.cbbOperator.Value = info.Operator;
this.txtValue.Text = info.Value.ToString();
this.cbbAndOr.Value = info.Logic;
}
public override void Set_Info(InqFilterInfoMDX info)
{
if (!info.HasWhereKey()) return;
this.cbbKeyField.Value = info.WhereKey.KeyField;
this.cbbOperator.Value = info.Operator;
this.txtValue.Value = info.ToTimeValue();
this.cbbAndOr.Value = info.Logic;
var ds = this.cbbKeyField.DataSource as List<lsttbl_DWColumn>;
var fieldName = ds.FirstOrDefault(p => p.KeyField == info.WhereKey.KeyField).ColName;
this.Set_FormatString(fieldName);
}
public override void Set_Info(InqFilterInfoMDX info)
{
if (!info.HasWhereKey())
{
return;
}
this.cbbKeyField.Value = info.WhereKey.KeyField;
this.cbbOperator.Value = info.Operator;
this.txtValue.Value = info.ToTimeValue();
this.cbbAndOr.Value = info.Logic;
var ds = this.cbbKeyField.DataSource as List <lsttbl_DWColumn>;
var fieldName = ds.FirstOrDefault(p => p.KeyField == info.WhereKey.KeyField).ColName;
this.Set_FormatString(fieldName);
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List<lsttbl_DWColumn>;
if (ds == null) return null;
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.WhereKey = new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType);
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
ret.Value = this.txtValue.Text;
return ret;
}
catch { return null; }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
InqFilterInfoMDX ret = new InqFilterInfoMDX();
InqFieldInfoMDX whereKey = new InqFieldInfoMDX();
whereKey.Name = cbbKeyField.Text;
whereKey.UniqueName = Lib.NTE(cbbKeyField.Value);
ret.WhereKey = whereKey;
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
ret.Value = this.txtValue.Text;
ret.FilterType = "NORMAL";
return ret;
}
catch { return null; }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
InqFilterInfoMDX ret = new InqFilterInfoMDX();
InqFieldInfoMDX whereKey = new InqFieldInfoMDX();
whereKey.Name = cbbKeyField.Text;
whereKey.UniqueName = Lib.NTE(cbbKeyField.Value);
ret.WhereKey = whereKey;
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
ret.Value = this.txtValue.Text;
ret.FilterType = "NORMAL";
return(ret);
}
catch { return(null); }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List <lsttbl_DWColumn>;
if (ds == null)
{
return(null);
}
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.WhereKey = new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType);
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
ret.Value = this.txtValue.Text;
return(ret);
}
catch { return(null); }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List<lsttbl_DWColumn>;
if (ds == null) return null;
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.HavingKey = new InqSummaryInfoMDX(new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType), "SUM");
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
if (Lib.StringIsDigit(this.txtValue.Text))
ret.Value = this.txtValue.Text;
else
ret.Value = Lib.GetStringDigit(this.txtValue.Text);
ret.FilterType = "NUM";
return ret;
}
catch { return null; }
}
public override InqFilterInfoMDX Get_FilterInfo()
{
try
{
var ds = this.cbbKeyField.DataSource as List <lsttbl_DWColumn>;
if (ds == null)
{
return(null);
}
var keyField = Lib.NTE(this.cbbKeyField.Value);
var item = ds.FirstOrDefault(p => p.KeyField == keyField);
var ret = new InqFilterInfoMDX();
ret.WhereKey = new InqFieldInfoMDX(item.TblName_Virtual, item.ColName, item.DataType);
ret.Logic = Lib.NTE(this.cbbAndOr.Value);
ret.Operator = this.cbbOperator.Text;
if (item.ColName == "Year")
{
ret.Value = this.txtValue.Date.Year;
}
else if (item.ColName == "Quarter")
{
ret.Value = this.txtValue.Date.Day;
}
else if (item.ColName == "Period")
{
ret.Value = this.txtValue.Date.ToString("yyyyMM");
}
else
{
ret.Value = this.txtValue.Date.ToString("yyyy/MM/dd");
}
ret.FilterType = "DATE";
return(ret);
}
catch { return(null); }
}
public virtual void Set_Info(InqFilterInfoMDX info)
{
}
public virtual void Set_Info(InqFilterInfoMDX info)
{
}
