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); }
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
var btn = sender as DevExpress.Web.ASPxEditors.ASPxButton;
if (btn == null) return;
if (btn.ID == this.btnNewDS.ID)
{
MySession.DSDefine_CurEditing = null;
// Clear Selected field
this.lbxFieldSelected.Items.Clear();
MySession.DSDefine_SelFieldInfo.Clear();
this.lbxMetricFieldSelected.Items.Clear();
MySession.DSDefine_SelSumInfo.Clear();
// Clear filtered field
this.FilterControlSet.Clear();
this.ctrlCollect.Controls.Clear();
// Clear Input
this.txtDisplayNameDS.Text = "";
this.cboDatasource.Text = "";
this.txtDisplayName0.Text = "";
this.txtDisplayName.Text = "";
this.cboFuncs.Text = "";
this.cboOrderBy1.Text = "";
this.lblSavingMsg.Text = "";
// Update Display to clientside...
this.upp_SelectClause.Update();
this.upp_Filter.Update();
this.upp_SavingMsg.Update();
// Focus
this.txtDisplayName.Focus();
}
else if (btn.ID == this.btnIn_1.ID)
{
var item = this.lbxField.SelectedItem;
if (item == null) return;
var tblName = Lib.NTE(item.GetValue("TblName_Virtual"));
var colName = Lib.NTE(item.GetValue("ColName"));
var colAlias = Lib.NTE(item.GetValue("ColAliasVI"));
var colDataType = Lib.NTE(item.GetValue("DataType"));
var info = new InqFieldInfoMDX(tblName, colName, colAlias, colDataType);
var sel_InqFieldInfo = MySession.DSDefine_SelFieldInfo;
if (sel_InqFieldInfo.Exists(p => p.KeyField == info.KeyField)) return;
sel_InqFieldInfo.Add(info);
Helpers.SetDataSource(this.lbxFieldSelected, sel_InqFieldInfo, "KeyField", "ColAliasVI");
}
else if (btn.ID == this.btnIn_2.ID)
{
var item = this.lbxMetricField.SelectedItem;
if (item == null) return;
var tblName = Lib.NTE(item.GetValue("TblName_Virtual"));
var colName = Lib.NTE(item.GetValue("ColName"));
var colAlias = Lib.NTE(item.GetValue("ColAliasVI"));
var colDataType = Lib.NTE(item.GetValue("DataType"));
var fieldInfo = new InqFieldInfoMDX(tblName, colName, colAlias, colDataType);
var info = new InqSummaryInfoMDX(fieldInfo, "SUM", colAlias);
var sel_InqSummaryInfo = MySession.DSDefine_SelSumInfo;
if (sel_InqSummaryInfo.Exists(p => p.Field.KeyField == info.Field.KeyField)) return;
sel_InqSummaryInfo.Add(info);
Helpers.SetDataSource(this.lbxMetricFieldSelected, sel_InqSummaryInfo, "Field.KeyField", "FieldAlias");
}
else if (btn.ID == this.btnOut_1.ID)
{
var item = lbxFieldSelected.SelectedItem;
lbxFieldSelected.Items.Remove(item);
MySession.DSDefine_SelFieldInfo.RemoveAll(p => p.KeyField == Lib.NTE(item.GetValue("KeyField")));
}
else if (btn.ID == this.btnOut_2.ID)
{
var item = lbxMetricFieldSelected.SelectedItem;
lbxMetricFieldSelected.Items.Remove(item);
MySession.DSDefine_SelSumInfo.RemoveAll(p => p.Field.KeyField == Lib.NTE(item.GetValue("Field.KeyField")));
}
}
#if DEBUG
catch (Exception ex)
{
throw ex;
}
#else
catch { }
#endif
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
var btn = sender as DevExpress.Web.ASPxEditors.ASPxButton;
if (btn == null)
{
return;
}
if (btn.ID == this.btnNewDS.ID)
{
MySession.DSDefine_CurEditing = null;
// Clear Selected field
this.lbxFieldSelected.Items.Clear();
MySession.DSDefine_SelFieldInfo.Clear();
this.lbxMetricFieldSelected.Items.Clear();
MySession.DSDefine_SelSumInfo.Clear();
// Clear filtered field
this.FilterControlSet.Clear();
this.ctrlCollect.Controls.Clear();
// Clear Input
this.txtDisplayNameDS.Text = "";
this.cboDatasource.Text = "";
this.txtDisplayName0.Text = "";
this.txtDisplayName.Text = "";
this.cboFuncs.Text = "";
this.cboOrderBy1.Text = "";
this.lblSavingMsg.Text = "";
// Update Display to clientside...
this.upp_SelectClause.Update();
this.upp_Filter.Update();
this.upp_SavingMsg.Update();
}
else if (btn.ID == this.btnIn_1.ID)
{
var item = this.lbxField.SelectedItem;
if (item == null)
{
return;
}
var tblName = Lib.NTE(item.GetValue("TblName"));
var colName = Lib.NTE(item.GetValue("ColName"));
var colAlias = Lib.NTE(item.GetValue("ColAliasVI"));
var colDataType = Lib.NTE(item.GetValue("DataType"));
var info = new InqFieldInfoMDX(tblName, colName, colAlias, colDataType);
var sel_InqFieldInfo = MySession.DSDefine_SelFieldInfo;
if (sel_InqFieldInfo.Exists(p => p.KeyField == info.KeyField))
{
return;
}
sel_InqFieldInfo.Add(info);
Helpers.SetDataSource(this.lbxFieldSelected, sel_InqFieldInfo, "KeyField", "ColAliasVI");
}
else if (btn.ID == this.btnIn_2.ID)
{
var item = this.lbxMetricField.SelectedItem;
if (item == null)
{
return;
}
var tblName = Lib.NTE(item.GetValue("TblName"));
var colName = Lib.NTE(item.GetValue("ColName"));
var colAlias = Lib.NTE(item.GetValue("ColAliasVI"));
var colDataType = Lib.NTE(item.GetValue("DataType"));
var fieldInfo = new InqFieldInfoMDX(tblName, colName, colAlias, colDataType);
var info = new InqSummaryInfoMDX(fieldInfo, "SUM", colAlias);
var sel_InqSummaryInfo = MySession.DSDefine_SelSumInfo;
if (sel_InqSummaryInfo.Exists(p => p.Field.KeyField == info.Field.KeyField))
{
return;
}
sel_InqSummaryInfo.Add(info);
Helpers.SetDataSource(this.lbxMetricFieldSelected, sel_InqSummaryInfo, "Field.KeyField", "FieldAlias");
}
else if (btn.ID == this.btnOut_1.ID)
{
var item = lbxFieldSelected.SelectedItem;
lbxFieldSelected.Items.Remove(item);
MySession.DSDefine_SelFieldInfo.RemoveAll(p => p.KeyField == Lib.NTE(item.GetValue("KeyField")));
}
else if (btn.ID == this.btnOut_2.ID)
{
var item = lbxMetricFieldSelected.SelectedItem;
lbxMetricFieldSelected.Items.Remove(item);
MySession.DSDefine_SelSumInfo.RemoveAll(p => p.Field.KeyField == Lib.NTE(item.GetValue("Field.KeyField")));
}
}
catch { }
}
