public fmFieldSetting(DbConnection aConnection, ClientType DatabaseType, ListView aListView, TWizardType aWizardType, String EEPAlias)
{
InitializeComponent();
FConnection = aConnection;
FInfoCommand = new InfoCommand(DatabaseType);
FDatabaseType = DatabaseType;
FListView = aListView;
FSelectedBlockFieldItem = null;
FSelectedListViewItem = null;
FDisplayValue = false;
FWizardType = aWizardType;
DBAlias = EEPAlias;
InitData();
lvwColumnSorter = new ListViewColumnSorter();
this.lvFields.ListViewItemSorter = lvwColumnSorter;
}
private void SetFieldNames(string TableName, ListView LV, String DataSetName)
{
int I;
DataRow[] DRs;
DataRow DR;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
TableName = WzdUtils.RemoveQuote(TableName, FClientData.DatabaseType);
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME = '" + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName);
InfoDataSet aDataSet = GetRootInfoDataSet(DataSetName);
DataTable dtTableSchema = aDataSet.RealDataSet.Tables[0];
for (I = 0; I < dtTableSchema.Columns.Count; I++)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = dtTableSchema.Columns[I].ColumnName;
DRs = dsColdef.Tables[0].Select("FIELD_NAME='" + lvi.Text + "'");
TBlockFieldItem aBlockFieldItem = new TBlockFieldItem();
aBlockFieldItem.DataField = lvi.Text;
aBlockFieldItem.DataType = dtTableSchema.Columns[I].DataType;
lvi.Tag = aBlockFieldItem;
if (DRs.Length == 1)
{
DR = DRs[0];
lvi.SubItems.Add(DR["CAPTION"].ToString());
aBlockFieldItem.Description = DR["CAPTION"].ToString();
aBlockFieldItem.CheckNull = DR["CHECK_NULL"].ToString().ToUpper();
aBlockFieldItem.DefaultValue = DR["DEFAULT_VALUE"].ToString();
aBlockFieldItem.ControlType = DR["NEEDBOX"].ToString();
aBlockFieldItem.EditMask = DR["EDITMASK"].ToString();
if (aBlockFieldItem.DataType == typeof(DateTime))
{
if (aBlockFieldItem.ControlType == null || aBlockFieldItem.ControlType == "")
aBlockFieldItem.ControlType = "DateTimeBox";
}
aBlockFieldItem.QueryMode = DR["QUERYMODE"].ToString();
}
LV.Items.Add(lvi);
}
/*
string[] S = new string[4];
S[2] = TableName;
DataTable dtTableSchema = InternalConnection.GetSchema("Columns", S);
DataRow[] DRs1 = dtTableSchema.Select("", "ORDINAL_POSITION ASC");
for (I = 0; I < DRs1.Length; I++)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = DRs1[I][3].ToString();
DRs = dsColdef.Tables[0].Select("FIELD_NAME='" + lvi.Text + "'");
if (DRs.Length == 1)
{
DR = DRs[0];
lvi.SubItems.Add(DR["CAPTION"].ToString());
}
LV.Items.Add(lvi);
}
*/
}
private void LoadBlockFieldItems(XmlNode Node, TBlockFieldItems BlockFieldItems)
{
TBlockFieldItem BFI;
int I;
XmlNode BlockFieldItemNode;
for (I = 0; I < Node.ChildNodes.Count; I++)
{
BlockFieldItemNode = Node.ChildNodes[I];
BFI = new TBlockFieldItem();
BFI.DataField = BlockFieldItemNode.Attributes["DataField"].Value;
BFI.Description = BlockFieldItemNode.Attributes["Description"].Value;
BFI.Length = int.Parse(BlockFieldItemNode.Attributes["Length"].Value.ToString());
foreach (XmlNode RefNode in BlockFieldItemNode.ChildNodes)
{
BFI.RefField = new TRefField();
BFI.RefField.SelectCommand = RefNode.Attributes["SelectCommand"].Value;
BFI.RefField.ValueMember = RefNode.Attributes["ValueMember"].Value;
BFI.RefField.DisplayMember = RefNode.Attributes["DisplayMember"].Value;
foreach (XmlNode ColumnNode in RefNode.ChildNodes)
{
RefColumns aColumn = new RefColumns();
aColumn.Column = ColumnNode.Attributes["Column"].Value;
aColumn.HeaderText = ColumnNode.Attributes["HeaderText"].Value;
aColumn.Width = int.Parse(ColumnNode.Attributes["Width"].Value);
BFI.RefField.LookupColumns.Add(aColumn);
}
}
//IPC保留缺口
//BlockFieldItem.CheckNull = DR["CHECK_NULL"].ToString();
//BlockFieldItem.DefaultValue = DR["DEFAULT_VALUE"].ToString();
BlockFieldItems.Add(BFI);
}
}
private List<TBlockFieldItem> SetFields(ClientParam cParam)
{
DataTable dtDD = ReportCreator.GetDDTable(cParam.ClientType, cParam.SelectAlias, cParam.RealTableName);
DataTable dtTableSchema = FInfoDataSet.RealDataSet.Tables[0];
List<TBlockFieldItem> list = new List<TBlockFieldItem>();
for (int I = 0; I < dtTableSchema.Columns.Count; I++)
{
DataRow[] DRs = dtDD.Select("FIELD_NAME='" + dtTableSchema.Columns[I].ColumnName + "'");
TBlockFieldItem aBlockFieldItem = new TBlockFieldItem();
aBlockFieldItem.DataField = dtTableSchema.Columns[I].ColumnName;
aBlockFieldItem.DataType = dtTableSchema.Columns[I].DataType;
if (DRs.Length == 1)
{
DataRow DR = DRs[0];
aBlockFieldItem.Description = DR["CAPTION"].ToString();
aBlockFieldItem.CheckNull = DR["CHECK_NULL"].ToString().ToUpper();
aBlockFieldItem.DefaultValue = DR["DEFAULT_VALUE"].ToString();
aBlockFieldItem.ControlType = DR["NEEDBOX"].ToString();
aBlockFieldItem.EditMask = DR["EDITMASK"].ToString();
if (aBlockFieldItem.DataType == typeof(DateTime))
{
if (aBlockFieldItem.ControlType == null || aBlockFieldItem.ControlType == "")
aBlockFieldItem.ControlType = "DateTimeBox";
}
aBlockFieldItem.QueryMode = DR["QUERYMODE"].ToString();
list.Add(aBlockFieldItem);
}
}
return list;
}
private String GenWebDataSource(TBlockFieldItem FieldItem, String TableName, String Kind, String ExtraName)
{
return GenWebDataSource(FieldItem, TableName, Kind, ExtraName, false);
}
private String GenExtComboBox(TBlockFieldItem FieldItem, String TableName, String Kind, String ExtraName, String DSID)
{
String Name = "ext" + TableName + FieldItem.DataField + ExtraName;
bool isExist = false;
foreach (ExtComboBox bExtComboBox in FExtComboBoxList)
{
if (String.Compare(bExtComboBox.ID, Name) == 0)
{
isExist = true;
break;
}
}
ExtComboBox aExtComboBox = new ExtComboBox();
aExtComboBox.ID = Name;
aExtComboBox.DataSourceID = DSID;
aExtComboBox.AutoRender = false;
if (Kind == "ExtRefVal")
{
DataSet aDataSet = new DataSet();
try
{
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
if (aInfoCommand.Connection.State != ConnectionState.Open) aInfoCommand.Connection.Open();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, FieldItem.RefValNo);
aExtComboBox.DisplayField = aDataSet.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aExtComboBox.ValueField = aDataSet.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
ExtSimpleColumn aExtSimpleColumn = new ExtSimpleColumn();
aExtSimpleColumn.DataField = aDataSet.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aExtComboBox.Columns.Add(aExtSimpleColumn);
ExtSimpleColumn bExtSimpleColumn = new ExtSimpleColumn();
bExtSimpleColumn.DataField = aDataSet.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
aExtComboBox.Columns.Add(bExtSimpleColumn);
}
catch (SqlException sex)
{
if (sex.Number == 208)
{
string sSysDBAlias = WzdUtils.GetSystemDBName();
ClientType sSysDBType = WzdUtils.GetSystemDBType();
DbConnection sysConn = WzdUtils.AllocateConnection(sSysDBAlias, sSysDBType, false);
if (sysConn.State != ConnectionState.Open) sysConn.Open();
DbCommand comm = sysConn.CreateCommand();
comm.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(comm);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, FieldItem.RefValNo);
aExtComboBox.DisplayField = aDataSet.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aExtComboBox.ValueField = aDataSet.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
ExtSimpleColumn aExtSimpleColumn = new ExtSimpleColumn();
aExtSimpleColumn.DataField = aDataSet.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aExtComboBox.Columns.Add(aExtSimpleColumn);
ExtSimpleColumn bExtSimpleColumn = new ExtSimpleColumn();
bExtSimpleColumn.DataField = aDataSet.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
aExtComboBox.Columns.Add(bExtSimpleColumn);
}
}
}
else if (Kind == "ExtComboBox")
{
aExtComboBox.DisplayField = FieldItem.ComboTextField;
aExtComboBox.ValueField = FieldItem.ComboValueField;
ExtSimpleColumn aExtSimpleColumn = new ExtSimpleColumn();
aExtSimpleColumn.DataField = FieldItem.ComboTextField;
aExtComboBox.Columns.Add(aExtSimpleColumn);
ExtSimpleColumn bExtSimpleColumn = new ExtSimpleColumn();
bExtSimpleColumn.DataField = FieldItem.ComboValueField;
aExtComboBox.Columns.Add(bExtSimpleColumn);
aExtComboBox.AutoRender = false;
}
if (!isExist)
FExtComboBoxList.Add(aExtComboBox);
#if VS90
if (!isExist)
{
WebDevPage.IHTMLElement Page = FDesignerDocument.pageContentElement;
////InsertControl(Page, aExtComboBox);
}
#endif
return aExtComboBox.ID;
}
private void AddBlockItem(string BlockName, string ProviderName, string TableName, ListView LV)
{
int I;
TBlockItem BlockItem = new TBlockItem();
TBlockFieldItem BlockFieldItem;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
String OWNER = String.Empty, SS = TableName;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet DS = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, DS, TableName);
BlockItem.Name = BlockName;
BlockItem.ProviderName = ProviderName;
BlockItem.TableName = TableName;
for (I = 0; I < LV.Items.Count; I++)
{
ListViewItem aItem = LV.Items[I];
BlockFieldItem = new TBlockFieldItem();
if (aItem.Tag != null)
{
BlockFieldItem.DataField = ((TBlockFieldItem)aItem.Tag).DataField;
BlockFieldItem.CheckNull = ((TBlockFieldItem)aItem.Tag).CheckNull;
BlockFieldItem.DefaultValue = ((TBlockFieldItem)aItem.Tag).DefaultValue;
BlockFieldItem.Description = ((TBlockFieldItem)aItem.Tag).Description;
BlockFieldItem.RefValNo = ((TBlockFieldItem)aItem.Tag).RefValNo;
BlockFieldItem.ControlType = ((TBlockFieldItem)aItem.Tag).ControlType;
BlockFieldItem.ComboEntityName = ((TBlockFieldItem)aItem.Tag).ComboEntityName;
BlockFieldItem.ComboRemoteName = ((TBlockFieldItem)aItem.Tag).ComboRemoteName;
BlockFieldItem.ComboTextField = ((TBlockFieldItem)aItem.Tag).ComboTextField;
BlockFieldItem.ComboValueField = ((TBlockFieldItem)aItem.Tag).ComboValueField;
BlockFieldItem.ComboTextFieldCaption = ((TBlockFieldItem)aItem.Tag).ComboTextFieldCaption;
BlockFieldItem.ComboValueFieldCaption = ((TBlockFieldItem)aItem.Tag).ComboValueFieldCaption;
BlockFieldItem.DataType = ((TBlockFieldItem)aItem.Tag).DataType;
BlockFieldItem.QueryMode = ((TBlockFieldItem)aItem.Tag).QueryMode;
BlockFieldItem.EditMask = ((TBlockFieldItem)aItem.Tag).EditMask;
BlockFieldItem.Length = ((TBlockFieldItem)aItem.Tag).Length;
BlockFieldItem.ComboOtherFields = ((TBlockFieldItem)aItem.Tag).ComboOtherFields;
BlockFieldItem.IsKey = ((TBlockFieldItem)aItem.Tag).IsKey;
BlockFieldItem.HideGridColumn = ((TBlockFieldItem)aItem.Tag).HideGridColumn;
}
else
{
BlockFieldItem.DataField = aItem.Text;
}
/*
BlockFieldItem.DataField = LV.Items[I].Text;
DRs = DS.Tables[0].Select("FIELD_NAME='" + BlockFieldItem.DataField + "'");
if (DRs.Length == 1)
{
DR = DRs[0];
if (!DR.IsNull("FIELD_LENGTH"))
BlockFieldItem.Length = int.Parse(DR["FIELD_LENGTH"].ToString());
if (DR["IS_KEY"].ToString() == "Y")
{
BlockFieldItem.IsKey = true;
}
else
{
BlockFieldItem.IsKey = false;
}
BlockFieldItem.Description = DR["CAPTION"].ToString();
if (LV.Items[I].SubItems.Count == 3)
{
BlockFieldItem.RefValNo = aItem.SubItems[2].Text;
}
if (BlockFieldItem.Description == "")
{
BlockFieldItem.Description = BlockFieldItem.DataField;
}
BlockFieldItem.CheckNull = DR["CHECK_NULL"].ToString().ToUpper();
BlockFieldItem.DefaultValue = DR["DEFAULT_VALUE"].ToString();
}
*/
BlockItem.BlockFieldItems.Add(BlockFieldItem);
}
FClientData.Blocks.Add(BlockItem);
}
private void lvSelectedFields_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvSelectedFields.SelectedItems.Count == 1)
{
if (!FDisplayValue_D)
SetValue_D();
ListViewItem aViewItem = lvSelectedFields.SelectedItems[0];
FSelectedListViewItem_D = aViewItem;
FSelectedBlockFieldItem_D = (TBlockFieldItem)aViewItem.Tag;
FDisplayValue_D = true;
DisplayValue_D();
FDisplayValue_D = false;
}
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, WebValidate InWebValidate, List<WebValidateBox> InWebValidateBoxList, List<System.Web.UI.WebControls.Label> InLabelList)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
aWebValidate = InWebValidate;
FKind = Kind;
aWebValidateBoxList = InWebValidateBoxList;
FWebGridView = null;
aLabelList = InLabelList;
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, String DataSourceID, List<MyWebDropDownList> InWebDropDownList, List<System.Web.UI.WebControls.Label> InLabelList)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FDataSourceID = DataSourceID;
FKind = Kind;
aWebDropDownList = InWebDropDownList;
FWebGridView = null;
aLabelList = InLabelList;
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, String DataSourceID, DbConnection GlobalConnection, List<AjaxTools.AjaxRefVal> InWebRefValList, ClientType aDatabaseType, WebGridView aGridView, List<System.Web.UI.WebControls.Label> InLabelList)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FDataSourceID = DataSourceID;
FConnection = GlobalConnection;
aAjaxRefValList = InWebRefValList;
FKind = Kind;
FDatabaseType = aDatabaseType;
FWebGridView = aGridView;
aLabelList = InLabelList;
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, String DataSourceID, DbConnection GlobalConnection, List<WebRefVal> InWebRefValList, ClientType aDatabaseType, WebGridView aGridView)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FDataSourceID = DataSourceID;
FConnection = GlobalConnection;
aWebRefValList = InWebRefValList;
FKind = Kind;
FDatabaseType = aDatabaseType;
FWebGridView = aGridView;
}
private InfoRefVal GenRefVal(TBlockFieldItem FieldItem, string TableName)
{
String Name = "rv" + TableName + FieldItem.DataField;
InfoRefVal Result = FDesignerHost.CreateComponent(typeof(InfoRefVal), Name) as InfoRefVal;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet aDataSet = new DataSet();
//SYS_REFVAL
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, FieldItem.RefValNo);
if (aDataSet.Tables[0].Rows.Count != 1)
throw new Exception(String.Format("Unknown REFVAL_NO in SYS_REFVAL: {0}", FieldItem.RefValNo));
Result.Caption = aDataSet.Tables[0].Rows[0]["CAPTION"].ToString();
Result.DisplayMember = aDataSet.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
Result.ValueMember = aDataSet.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
Result.SelectAlias = aDataSet.Tables[0].Rows[0]["SELECT_ALIAS"].ToString();
Result.SelectCommand = aDataSet.Tables[0].Rows[0]["SELECT_COMMAND"].ToString();
//SYS_REFVSL_D1 --> Columns
aDataSet.Clear();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", FieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, FieldItem.RefValNo);
foreach (DataRow DR in aDataSet.Tables[0].Rows)
{
RefColumns RC = new RefColumns();
RC.Column = DR["FIELD_NAME"].ToString();
RC.HeaderText = DR["HEADER_TEXT"].ToString();
Result.Columns.Add(RC);
}
return Result;
}
private void CreateQueryField(TBlockFieldItem aFieldItem, String Range, InfoRefVal aRefVal, InfoBindingSource ibs)
{
if (aFieldItem.QueryMode == null)
return;
InfoNavigator navigator1 = FRootForm.Controls["infoNavigator1"] as InfoNavigator;
if (navigator1 != null)
{
if (aFieldItem.QueryMode.ToUpper() == "NORMAL" || aFieldItem.QueryMode.ToUpper() == "RANGE")
{
QueryField qField = new QueryField();
qField.FieldName = aFieldItem.DataField;
qField.Caption = aFieldItem.Description;
if (qField.Caption == "")
qField.Caption = aFieldItem.DataField;
if (aFieldItem.QueryMode.ToUpper() == "NORMAL")
{
if (aFieldItem.DataType == typeof(DateTime))
qField.Condition = "=";
if (aFieldItem.DataType == typeof(int) || aFieldItem.DataType == typeof(float) ||
aFieldItem.DataType == typeof(double) || aFieldItem.DataType == typeof(Int16))
qField.Condition = "=";
if (aFieldItem.DataType == typeof(String))
qField.Condition = "%";
}
if (aFieldItem.QueryMode.ToUpper() == "RANGE")
{
qField.Condition = "And";
if (Range == "")
{
qField.Condition = "<=";
CreateQueryField(aFieldItem, ">=", aRefVal, null);
}
else
{
qField.Condition = Range;
}
}
switch (aFieldItem.ControlType.ToUpper())
{
case "TEXTBOX":
qField.Mode = "TextBox";
break;
case "COMBOBOX":
qField.Mode = "ComboBox";
qField.RefVal = aRefVal;
break;
case "REFVALBOX":
qField.Mode = "RefVal";
qField.RefVal = aRefVal;
break;
case "DATETIMEBOX":
qField.Mode = "Calendar";
break;
}
navigator1.QueryFields.Add(qField);
}
}
ClientQuery aClientQuery = FRootForm.Container.Components["clientQuery1"] as ClientQuery;
if (aClientQuery != null)
{
if (ibs != null && aClientQuery != null)
aClientQuery.BindingSource = ibs;
if (aFieldItem.QueryMode.ToUpper() == "NORMAL" || aFieldItem.QueryMode.ToUpper() == "RANGE")
{
QueryColumns qColumn = new QueryColumns();
qColumn.Column = aFieldItem.DataField;
qColumn.Caption = aFieldItem.Description;
if (qColumn.Caption == "")
qColumn.Caption = aFieldItem.DataField;
if (aFieldItem.QueryMode.ToUpper() == "NORMAL")
{
if (aFieldItem.DataType == typeof(DateTime))
qColumn.Operator = "=";
if (aFieldItem.DataType == typeof(int) || aFieldItem.DataType == typeof(float) ||
aFieldItem.DataType == typeof(double) || aFieldItem.DataType == typeof(Int16))
qColumn.Operator = "=";
if (aFieldItem.DataType == typeof(String))
qColumn.Operator = "%";
}
if (aFieldItem.QueryMode.ToUpper() == "RANGE")
{
qColumn.Condition = "And";
if (Range == "")
{
qColumn.Operator = "<=";
CreateQueryField(aFieldItem, ">=", aRefVal, null);
}
else
{
qColumn.Operator = Range;
//qColumn.Condition = Range;
}
}
switch (aFieldItem.ControlType.ToUpper())
{
case "TEXTBOX":
qColumn.ColumnType = "ClientQueryTextBoxColumn";
break;
case "COMBOBOX":
qColumn.ColumnType = "ClientQueryComboBoxColumn";
qColumn.InfoRefVal = aRefVal;
break;
case "REFVALBOX":
qColumn.ColumnType = "ClientQueryRefValColumn";
qColumn.InfoRefVal = aRefVal;
break;
case "DATETIMEBOX":
qColumn.ColumnType = "ClientQueryCalendarColumn";
break;
case "CHECKBOX":
qColumn.ColumnType = "ClientQueryCheckBoxColumn";
break;
}
aClientQuery.Columns.Add(qColumn);
}
}
}
private void SetFieldNamesByProvider(String TableName, String ProviderName, ListView aListView)
{
if (ProviderName == null || ProviderName.Trim() == "")
return;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
TableName = WzdUtils.RemoveQuote(TableName, FClientData.DatabaseType);
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME = '" + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName);
aListView.Items.Clear();
InfoDataSet aDataSet = new InfoDataSet();
try
{
aDataSet.SetWizardDesignMode(true);
aDataSet.RemoteName = ProviderName;
aDataSet.AlwaysClose = true;
aDataSet.Active = true;
DataTable Table = aDataSet.RealDataSet.Tables[0];
foreach (DataColumn Column in Table.Columns)
{
ListViewItem aItem = new ListViewItem(Column.ColumnName);
DataRow[] DRS = dsColdef.Tables[0].Select("FIELD_NAME='" + Column.ColumnName + "'");
if (DRS.Length == 1)
aItem.SubItems.Add(DRS[0]["CAPTION"].ToString());
else
aItem.SubItems.Add("");
aListView.Items.Add(aItem);
TBlockFieldItem aFieldItem = new TBlockFieldItem();
aFieldItem.DataField = Column.ColumnName;
aItem.Tag = aFieldItem;
}
}
finally
{
aDataSet.Dispose();
}
}
public void GetFieldNames(string DatabaseName, string TableName, String DataSetName, ListView SrcListView, ListView DestListView)
{
System.Windows.Forms.TreeNode Node = tvRelation.SelectedNode;
if (Node == null)
return;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
String OWNER = String.Empty, SS = TableName;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, "COLDEF");
int Index = FInfoDataSet.RealDataSet.Tables.IndexOf(WzdUtils.RemoveSpace(DataSetName));
DataTable Table = FInfoDataSet.RealDataSet.Tables[Index];
int I;
ListViewItem ViewItem;
for (I = 0; I < DestListView.Items.Count; I++)
{
ViewItem = DestListView.Items[I];
if (Table.Columns.IndexOf(ViewItem.Text) < 0)
{
if (ViewItem.Tag != null)
if (ViewItem.Tag.GetType().Equals(typeof(TBlockFieldItem)))
{
TBlockFieldItem B = (TBlockFieldItem)ViewItem.Tag;
B.Collection.Remove(B);
}
}
}
SrcListView.Items.Clear();
bool Found;
int J;
DataRow[] DRs = null;
for (I = 0; I < Table.Columns.Count; I++)
{
Found = false;
for (J = 0; J < DestListView.Items.Count; J++)
{
ViewItem = DestListView.Items[J];
if (string.Compare(Table.Columns[I].ColumnName, ViewItem.Text, false) == 0)
{
Found = true;
break;
}
}
if (Found == false)
{
TBlockFieldItem FieldItem = new TBlockFieldItem();
FieldItem.DataField = Table.Columns[I].ColumnName;
FieldItem.DataType = Table.Columns[I].DataType;
ViewItem = SrcListView.Items.Add(Table.Columns[I].ColumnName);
ViewItem.Tag = FieldItem;
DRs = dsColdef.Tables[0].Select("TABLE_NAME = '" + WzdUtils.RemoveQuote(TableName, FClientData.DatabaseType) + "' and FIELD_NAME = '" + Table.Columns[I].ColumnName + "'");
if (DRs.Length == 1)
{
FieldItem.Description = DRs[0]["CAPTION"].ToString();
FieldItem.CheckNull = DRs[0]["CHECK_NULL"].ToString();
FieldItem.DefaultValue = DRs[0]["DEFAULT_VALUE"].ToString();
FieldItem.IsKey = DRs[0]["IS_KEY"].ToString().ToUpper() == "Y";
FieldItem.ControlType = DRs[0]["NEEDBOX"].ToString();
FieldItem.EditMask = DRs[0]["EDITMASK"].ToString();
if (DRs[0]["FIELD_LENGTH"] != null && DRs[0]["FIELD_LENGTH"].ToString() != String.Empty)
FieldItem.Length = int.Parse(DRs[0]["FIELD_LENGTH"].ToString());
if (DRs[0]["IS_KEY"] != null && DRs[0]["IS_KEY"].ToString() == "Y")
FieldItem.IsKey = true;
}
ViewItem.SubItems.Add(FieldItem.Description);
}
}
}
private void lvMasterDesField_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvMasterDesField.SelectedItems.Count == 1)
{
if (!FDisplayValue)
SetValue();
ListViewItem aViewItem = lvMasterDesField.SelectedItems[0];
FSelectedListViewItem = aViewItem;
FSelectedBlockFieldItem = (TBlockFieldItem)aViewItem.Tag;
FDisplayValue = true;
DisplayValue();
FDisplayValue = false;
}
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, List<AjaxTools.AjaxDateTimePicker> InWebDateTimePickerList, List<System.Web.UI.WebControls.Label> InLabelList, WebGridView aGridView)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FKind = Kind;
aAjaxDateTimePickerList = InWebDateTimePickerList;
aLabelList = InLabelList;
FWebGridView = aGridView;
}
private void SetFieldNames(String TableName, ListView LV)
{
int I;
DataRow[] DRs;
DataRow DR;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
String OWNER = String.Empty, SS = TableName;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName);
DataTable dtTableSchema = FInfoDataSet.RealDataSet.Tables[0];
for (I = 0; I < dtTableSchema.Columns.Count; I++)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = dtTableSchema.Columns[I].ColumnName;
DRs = dsColdef.Tables[0].Select("FIELD_NAME='" + lvi.Text + "'");
TBlockFieldItem aBlockFieldItem = new TBlockFieldItem();
aBlockFieldItem.DataField = lvi.Text;
aBlockFieldItem.DataType = dtTableSchema.Columns[I].DataType;
lvi.Tag = aBlockFieldItem;
if (DRs.Length > 0)
{
DR = DRs[0];
lvi.SubItems.Add(DR["CAPTION"].ToString());
aBlockFieldItem.Description = DR["CAPTION"].ToString();
aBlockFieldItem.CheckNull = DR["CHECK_NULL"].ToString().ToUpper();
aBlockFieldItem.DefaultValue = DR["DEFAULT_VALUE"].ToString();
aBlockFieldItem.ControlType = DR["NEEDBOX"].ToString();
aBlockFieldItem.EditMask = DR["EDITMASK"].ToString();
if (aBlockFieldItem.DataType == typeof(DateTime))
{
if (aBlockFieldItem.ControlType == null || aBlockFieldItem.ControlType == "")
aBlockFieldItem.ControlType = "DateTimeBox";
}
else if (aBlockFieldItem.DataType == typeof(Int16) || aBlockFieldItem.DataType == typeof(Int32)
|| aBlockFieldItem.DataType == typeof(Int64) || aBlockFieldItem.DataType == typeof(float)
|| aBlockFieldItem.DataType == typeof(double) || aBlockFieldItem.DataType == typeof(decimal))
{
if (aBlockFieldItem.ControlType == null || aBlockFieldItem.ControlType == "")
aBlockFieldItem.ControlType = "NumberBox";
}
aBlockFieldItem.QueryMode = DR["QUERYMODE"].ToString();
if (DR["FIELD_LENGTH"] != null && DR["FIELD_LENGTH"].ToString() != "")
aBlockFieldItem.Length = Convert.ToInt32(DR["FIELD_LENGTH"]);
if (DR["IS_KEY"] != null && DR["IS_KEY"].ToString() == "Y")
aBlockFieldItem.IsKey = true;
}
LV.Items.Add(lvi);
}
/*
string[] S = new string[4];
S[2] = TableName;
DataTable dtTableSchema = InternalConnection.GetSchema("Columns", S);
DataRow[] DRs1 = dtTableSchema.Select("", "ORDINAL_POSITION ASC");
for (I = 0; I < DRs1.Length; I++)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = DRs1[I][3].ToString();
DRs = dsColdef.Tables[0].Select("FIELD_NAME='" + lvi.Text + "'");
if (DRs.Length == 1)
{
DR = DRs[0];
lvi.SubItems.Add(DR["CAPTION"].ToString());
}
LV.Items.Add(lvi);
}
*/
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, List<System.Web.UI.WebControls.CheckBox> InWebCheckBoxList, List<System.Web.UI.WebControls.Label> InLabelList)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FKind = Kind;
aWebCheckBoxList = InWebCheckBoxList;
aLabelList = InLabelList;
}
private void GenDefault(TBlockFieldItem aFieldItem, JQDefault aDefault, JQValidate aValidate)
{
if (aFieldItem.DefaultValue != "" && aFieldItem.DefaultValue != null)
{
JQDefaultColumn aDefaultItem = new JQDefaultColumn();
aDefaultItem.FieldName = aFieldItem.DataField;
aDefaultItem.DefaultValue = aFieldItem.DefaultValue;
aDefault.Columns.Add(aDefaultItem);
}
if (aFieldItem.CheckNull != null && aFieldItem.CheckNull.ToUpper() == "Y")
{
JQValidateColumn aValidateItem = new JQValidateColumn();
aValidateItem.FieldName = aFieldItem.DataField;
aValidateItem.CheckNull = aFieldItem.CheckNull.ToUpper() == "Y";
//aValidateItem.ValidateLabelLink = "Caption" + aFieldItem.DataField;
aValidate.Columns.Add(aValidateItem);
}
}
public WebControlTemplate(String Kind, TBlockFieldItem BlockFieldItem, String TableName, List<System.Web.UI.WebControls.TextBox> InWebTextBoxList, List<System.Web.UI.WebControls.Label> InLabelList, WebGridView aGridView)
{
FFieldItem = BlockFieldItem;
FTableName = TableName;
FKind = Kind;
aWebTextBoxList = InWebTextBoxList;
aLabelList = InLabelList;
FWebGridView = aGridView;
}
//private void AddDetailBlockItem(string MasterItemName, System.Windows.Forms.TreeNodeCollection NodeCollection)
//{
// for (int I = 0; I < NodeCollection.Count; I++)
// {
// TDetailItem DetailItem = (TDetailItem)NodeCollection[I].Tag;
// TBlockItem BlockItem = new TBlockItem();
// BlockItem.Name = NodeCollection[I].Text;
// BlockItem.RelationName = DetailItem.Relation.RelationName;
// BlockItem.TableName = DetailItem.TableName;
// if (NodeCollection[I].Parent != null)
// {
// BlockItem.ParentItemName = NodeCollection[I].Parent.Text;
// }
// else
// {
// BlockItem.ParentItemName = MasterItemName;
// }
// FClientData.Blocks.Add(BlockItem);
// BlockItem.BlockFieldItems = DetailItem.BlockFieldItems;
// AddDetailBlockItem(MasterItemName, NodeCollection[I].Nodes);
// }
//}
private void AddDetailBlockItem(string MasterItemName, System.Windows.Forms.TreeNodeCollection NodeCollection, ListView LV)
{
for (int I = 0; I < NodeCollection.Count; I++)
{
TBlockItem BlockItem = new TBlockItem();
BlockItem.Name = NodeCollection[I].Text;
BlockItem.TableName = ((TDetailItem)NodeCollection[I].Tag).TableName;
BlockItem.Relation = ((TDetailItem)NodeCollection[I].Tag).Relation;
BlockItem.RelationName = ((TDetailItem)NodeCollection[I].Tag).Relation.RelationName;
for (int J = 0; J < LV.Items.Count; J++)
{
ListViewItem aItem = LV.Items[J];
TBlockFieldItem BlockFieldItem = new TBlockFieldItem();
if (aItem.Tag != null)
{
BlockFieldItem.DataField = ((TBlockFieldItem)aItem.Tag).DataField;
BlockFieldItem.CheckNull = ((TBlockFieldItem)aItem.Tag).CheckNull;
BlockFieldItem.DefaultValue = ((TBlockFieldItem)aItem.Tag).DefaultValue;
BlockFieldItem.Description = ((TBlockFieldItem)aItem.Tag).Description;
BlockFieldItem.RefValNo = ((TBlockFieldItem)aItem.Tag).RefValNo;
BlockFieldItem.ControlType = ((TBlockFieldItem)aItem.Tag).ControlType;
BlockFieldItem.ComboRemoteName = ((TBlockFieldItem)aItem.Tag).ComboRemoteName;
BlockFieldItem.ComboEntityName = ((TBlockFieldItem)aItem.Tag).ComboEntityName;
BlockFieldItem.ComboTextField = ((TBlockFieldItem)aItem.Tag).ComboTextField;
BlockFieldItem.ComboValueField = ((TBlockFieldItem)aItem.Tag).ComboValueField;
BlockFieldItem.ComboTextFieldCaption = ((TBlockFieldItem)aItem.Tag).ComboTextFieldCaption;
BlockFieldItem.ComboValueFieldCaption = ((TBlockFieldItem)aItem.Tag).ComboValueFieldCaption;
BlockFieldItem.DataType = ((TBlockFieldItem)aItem.Tag).DataType;
BlockFieldItem.QueryMode = ((TBlockFieldItem)aItem.Tag).QueryMode;
BlockFieldItem.EditMask = ((TBlockFieldItem)aItem.Tag).EditMask;
BlockFieldItem.Length = ((TBlockFieldItem)aItem.Tag).Length;
BlockFieldItem.ComboOtherFields = ((TBlockFieldItem)aItem.Tag).ComboOtherFields;
BlockFieldItem.IsKey = ((TBlockFieldItem)aItem.Tag).IsKey;
}
else
{
BlockFieldItem.DataField = aItem.Text;
}
BlockItem.BlockFieldItems.Add(BlockFieldItem);
}
if (NodeCollection[I].Parent != null)
{
BlockItem.ParentItemName = NodeCollection[I].Parent.Text;
}
else
{
BlockItem.ParentItemName = MasterItemName;
}
FClientData.Blocks.Add(BlockItem);
AddDetailBlockItem(MasterItemName, NodeCollection[I].Nodes, LV);
}
}
private void CreateQueryField(TBlockFieldItem aFieldItem, String Range, InfoComboBox aComboBox, String TableName)
{
if (aFieldItem.QueryMode == null)
return;
WebNavigator navigator2 = FPage.FindControl("WebNavigator1") as WebNavigator;
if (navigator2 != null)
{
if (aFieldItem.QueryMode.ToUpper() == "NORMAL" || aFieldItem.QueryMode.ToUpper() == "RANGE")
{
WebQueryField qField = new WebQueryField();
qField.FieldName = aFieldItem.DataField;
qField.Caption = aFieldItem.Description;
if (qField.Caption == "")
qField.Caption = aFieldItem.DataField;
if (aFieldItem.QueryMode.ToUpper() == "NORMAL")
{
if (aFieldItem.DataType == typeof(DateTime))
qField.Condition = "=";
if (aFieldItem.DataType == typeof(int) || aFieldItem.DataType == typeof(float) ||
aFieldItem.DataType == typeof(double) || aFieldItem.DataType == typeof(Int16))
qField.Condition = "=";
if (aFieldItem.DataType == typeof(String))
qField.Condition = "%";
}
if (aFieldItem.QueryMode.ToUpper() == "RANGE")
{
if (Range == "")
{
qField.Condition = "<=";
CreateQueryField(aFieldItem, ">=", aComboBox, TableName);
}
else
{
qField.Condition = Range;
}
navigator2.QueryMode = WebNavigator.QueryModeType.ClientQuery;
}
switch (aFieldItem.ControlType.ToUpper())
{
case "TEXTBOX":
qField.Mode = "TextBox";
break;
case "COMBOBOX":
qField.Mode = "ComboBox";
qField.RefVal = "wrv" + TableName + aFieldItem.DataField + "QF";
break;
case "REFVALBOX":
qField.Mode = "RefVal";
qField.RefVal = "wrv" + TableName + aFieldItem.DataField + "QF";
break;
case "DATETIMEBOX":
qField.Mode = "Calendar";
break;
}
navigator2.QueryFields.Add(qField);
}
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(navigator2, null, "", "M");
}
WebClientQuery WebClientQuery1 = (WebClientQuery)FPage.FindControl("WebClientQuery1");
if (WebClientQuery1 != null)
{
if (aFieldItem.QueryMode.ToUpper() == "NORMAL" || aFieldItem.QueryMode.ToUpper() == "RANGE")
{
WebQueryColumns qColumns = new WebQueryColumns();
qColumns.Column = aFieldItem.DataField;
qColumns.Caption = aFieldItem.Description;
if (qColumns.Caption == "")
qColumns.Caption = aFieldItem.DataField;
qColumns.Condition = "And";
if (aFieldItem.QueryMode.ToUpper() == "NORMAL")
{
if (aFieldItem.DataType == typeof(DateTime))
qColumns.Operator = "=";
if (aFieldItem.DataType == typeof(int) || aFieldItem.DataType == typeof(float) ||
aFieldItem.DataType == typeof(double) || aFieldItem.DataType == typeof(Int16))
qColumns.Operator = "=";
if (aFieldItem.DataType == typeof(String))
qColumns.Operator = "%";
}
if (aFieldItem.QueryMode.ToUpper() == "RANGE")
{
qColumns.Condition = "And";
if (Range == "")
{
qColumns.Operator = "<=";
CreateQueryField(aFieldItem, ">=", aComboBox, TableName);
}
else
{
qColumns.Operator = Range;
}
}
switch (aFieldItem.ControlType.ToUpper())
{
case "TEXTBOX":
qColumns.ColumnType = "ClientQueryTextBoxColumn";
break;
case "COMBOBOX":
qColumns.ColumnType = "ClientQueryComboBoxColumn";
qColumns.WebRefVal = "wrv" + TableName + aFieldItem.DataField + "QF";
break;
case "REFVALBOX":
qColumns.ColumnType = "ClientQueryRefValColumn";
qColumns.WebRefVal = "wrv" + TableName + aFieldItem.DataField + "QF";
WebDataSource aWebDataSource = new WebDataSource();
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", aFieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, aFieldItem.RefValNo);
WebRefVal aWebRefVal = new WebRefVal();
aWebRefVal.ID = qColumns.WebRefVal;
aWebRefVal.DataTextField = FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aWebRefVal.DataValueField = FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
aWebRefVal.DataSourceID = String.Format("wds{0}{1}", TableName, aFieldItem.DataField);
aWebRefVal.Visible = false;
FWebRefValListPage.Add(aWebRefVal);
break;
case "DATETIMEBOX":
qColumns.ColumnType = "ClientQueryCalendarColumn";
break;
case "CHECKBOX":
qColumns.ColumnType = "ClientQueryCheckBoxColumn";
break;
}
WebClientQuery1.Columns.Add(qColumns);
}
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(WebClientQuery1, null, "", "M");
}
}
private String GenWebDataSource(TBlockFieldItem FieldItem, String TableName, String Kind, String ExtraName, bool isAjaxControl)
{
String Name = "wds" + TableName + FieldItem.DataField + ExtraName;
bool isExist = false;
foreach (WebDataSource bWebDataSource in FWebDataSourceList)
{
if (String.Compare(bWebDataSource.ID, Name) == 0)
{
isExist = true;
break;
}
}
#if VS90
object oDataSource = FDesignerDocument.webControls.item(Name, 0);
if (oDataSource != null && oDataSource is WebDevPage.IHTMLElement)
{
WebDevPage.IHTMLElement eDataSoruce = oDataSource as WebDevPage.IHTMLElement;
if (eDataSoruce.tagName.ToLower() == "infolight:webdatasource")
return Name;
}
WebDevPage.IHTMLElement form = ((WebDevPage.IHTMLElementCollection)FDesignerDocument.pageContentElement.children).item("form1", 0) as WebDevPage.IHTMLElement;
if (Kind == "RefValBox")
{
WebDataSource aWebDataSource = new WebDataSource();
try
{
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, FieldItem.RefValNo);
aWebDataSource.SelectAlias = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_ALIAS"].ToString();
aWebDataSource.SelectCommand = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_COMMAND"].ToString();
}
catch (SqlException sex)
{
if (sex.Number == 208)
{
string sSysDBAlias = WzdUtils.GetSystemDBName();
ClientType sSysDBType = WzdUtils.GetSystemDBType();
DbConnection sysConn = WzdUtils.AllocateConnection(sSysDBAlias, sSysDBType, false);
if (sysConn.State != ConnectionState.Open) sysConn.Open();
DbCommand comm = sysConn.CreateCommand();
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(comm);
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
comm.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, FieldItem.RefValNo);
aWebDataSource.SelectAlias = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_ALIAS"].ToString();
aWebDataSource.SelectCommand = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_COMMAND"].ToString();
}
}
if (!isExist)
{
aWebDataSource.ID = Name;
FWebDataSourceList.Add(aWebDataSource);
if (isAjaxControl)
form.insertAdjacentHTML("afterBegin", "<InfoLight:WebDataSource ID=\"" + Name + "\" runat=\"server\" SelectAlias=\"" + aWebDataSource.SelectAlias + "\" SelectCommand=\"" + aWebDataSource.SelectCommand + "\" CacheDataSet=\"True\"></InfoLight:WebDataSource>");
else
form.insertAdjacentHTML("afterBegin", "<InfoLight:WebDataSource ID=\"" + Name + "\" runat=\"server\" SelectAlias=\"" + aWebDataSource.SelectAlias + "\" SelectCommand=\"" + aWebDataSource.SelectCommand + "\"></InfoLight:WebDataSource>");
}
}
else if (Kind == "ComboBox")
{
string type = FindSystemDBType("SystemDB");
string cmd = "";
if (type == "1")
cmd = String.Format("Select * from [{0}]", TableName);
else if (type == "2")
cmd = String.Format("Select * from [{0}]", TableName);
else if (type == "3")
cmd = String.Format("Select * from {0}", TableName);
else if (type == "4")
cmd = String.Format("Select * from {0}", TableName);
else if (type == "5")
cmd = String.Format("Select * from {0}", TableName);
else if (type == "6")
cmd = String.Format("Select * from {0}", TableName);
else if (type == "7")
cmd = String.Format("Select * from {0}", TableName);
if (!isExist)
{
WebDataSource aWebDataSource = new WebDataSource();
aWebDataSource.ID = Name;
FWebDataSourceList.Add(aWebDataSource);
if (isAjaxControl)
form.insertAdjacentHTML("afterBegin", "<InfoLight:WebDataSource ID=\"" + Name + "\" runat=\"server\" SelectAlias=\"" + FClientData.Owner.SelectedAlias + "\" SelectCommand=\"" + cmd + "\" CacheDataSet=\"True\"></InfoLight:WebDataSource>");
else
form.insertAdjacentHTML("afterBegin", "<InfoLight:WebDataSource ID=\"" + Name + "\" runat=\"server\" SelectAlias=\"" + FClientData.Owner.SelectedAlias + "\" SelectCommand=\"" + cmd + "\"></InfoLight:WebDataSource>");
}
}
return Name;
#else
WebDataSource aWebDataSource = new WebDataSource();
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
//SYS_REFVAL
if (Kind == "RefVal")
{
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", FieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, FieldItem.RefValNo);
aWebDataSource.SelectAlias = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_ALIAS"].ToString();
aWebDataSource.SelectCommand = FSYS_REFVAL.Tables[0].Rows[0]["SELECT_COMMAND"].ToString();
}
//WebDropDownList
else if (Kind == "ComboBox")
{
string type = FindSystemDBType("SystemDB");
aWebDataSource.SelectAlias = FClientData.Owner.SelectedAlias;
if (type == "1")
aWebDataSource.SelectCommand = String.Format("Select * from [{0}]", FieldItem.ComboEntityName);
else if (type == "2")
aWebDataSource.SelectCommand = String.Format("Select * from [{0}]", FieldItem.ComboEntityName);
else if (type == "3")
aWebDataSource.SelectCommand = String.Format("Select * from {0}", FieldItem.ComboEntityName);
else if (type == "4")
aWebDataSource.SelectCommand = String.Format("Select * from {0}", FieldItem.ComboEntityName);
else if (type == "5")
aWebDataSource.SelectCommand = String.Format("Select * from {0}", FieldItem.ComboEntityName);
}
aWebDataSource.ID = Name;
if (isAjaxControl)
{
aWebDataSource.CacheDataSet = true;
}
if (!isExist)
FWebDataSourceList.Add(aWebDataSource);
return aWebDataSource.ID;
#endif
}
private void GenDefault(TBlockFieldItem aFieldItem, WebDefault aDefault, WebValidate aValidate)
{
if (aFieldItem.DefaultValue != "" && aFieldItem.DefaultValue != null)
{
DefaultFieldItem aDefaultItem = new DefaultFieldItem();
aDefaultItem.FieldName = aFieldItem.DataField;
aDefaultItem.DefaultValue = aFieldItem.DefaultValue;
aDefault.Fields.Add(aDefaultItem);
}
if (aFieldItem.CheckNull != null && aFieldItem.CheckNull.ToUpper() == "Y")
{
ValidateFieldItem aValidateItem = new ValidateFieldItem();
aValidateItem.FieldName = aFieldItem.DataField;
aValidateItem.CheckNull = aFieldItem.CheckNull.ToUpper() == "Y";
aValidateItem.ValidateLabelLink = "Caption" + aFieldItem.DataField;
aValidate.Fields.Add(aValidateItem);
}
}
private void CreateWebQueryField(TBlockFieldItem aFieldItem, string Range, bool NewLine)
{
#if VS90
WebQueryColumnsCollection QueryColumns = new WebQueryColumnsCollection(null, typeof(QueryColumns));
if (string.Compare(aFieldItem.QueryMode, "normal", true) == 0
|| string.Compare(aFieldItem.QueryMode, "range", true) == 0)
{
if (QueryColumns != null)
{
WebQueryColumns column = new WebQueryColumns();
column.Column = aFieldItem.DataField;
column.Caption = string.IsNullOrEmpty(aFieldItem.Description) ? aFieldItem.DataField : aFieldItem.Description;
if (string.Compare(aFieldItem.ControlType, "textbox", true) == 0)
{
column.ColumnType = "ClientQueryTextBoxColumn";
}
else if (string.Compare(aFieldItem.ControlType, "combobox", true) == 0)
{
column.ColumnType = "ClientQueryTextBoxColumn";
}
else if (string.Compare(aFieldItem.ControlType, "refvalbox", true) == 0)
{
column.ColumnType = "ClientQueryTextBoxColumn";
}
else if (string.Compare(aFieldItem.ControlType, "datetimebox", true) == 0)
{
column.ColumnType = "ClientQueryCalendarColumn";
}
if (string.Compare(aFieldItem.QueryMode, "normal", true) == 0)
{
column.Operator = (aFieldItem.DataType == typeof(string)) ? "%" : "=";
}
else
{
WebQueryColumns columnrev = new WebQueryColumns();
columnrev.Column = column.Column;
columnrev.Caption = column.Caption;
columnrev.ColumnType = column.ColumnType;
columnrev.Operator = ">=";
QueryColumns.Add(columnrev);
column.Operator = "<=";
}
QueryColumns.Add(column);
}
}
WebDevPage.IHTMLElement ClientQuery = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebClientQuery1", 0);
if (ClientQuery != null)
{
SetCollectionValue(ClientQuery, typeof(WebClientQuery).GetProperty("Columns"), QueryColumns);
}
#else
WebClientQuery WebClientQuery1 = (WebClientQuery)FPage.FindControl("WebClientQuery1");
if (WebClientQuery1 != null)
{
if (aFieldItem.QueryMode.ToUpper() == "NORMAL" || aFieldItem.QueryMode.ToUpper() == "RANGE")
{
WebQueryColumns qColumns = new WebQueryColumns();
qColumns.Column = aFieldItem.DataField;
qColumns.Caption = aFieldItem.Description;
if (qColumns.Caption == "")
qColumns.Caption = aFieldItem.DataField;
qColumns.Condition = "And";
if (aFieldItem.QueryMode.ToUpper() == "NORMAL")
{
if (aFieldItem.DataType == typeof(DateTime))
qColumns.Operator = "=";
if (aFieldItem.DataType == typeof(int) || aFieldItem.DataType == typeof(float) ||
aFieldItem.DataType == typeof(double) || aFieldItem.DataType == typeof(Int16))
qColumns.Operator = "=";
if (aFieldItem.DataType == typeof(String))
qColumns.Operator = "%";
}
qColumns.NewLine = NewLine;
if (aFieldItem.QueryMode.ToUpper() == "RANGE")
{
qColumns.Condition = "And";
if (Range == "")
{
qColumns.Operator = "<=";
qColumns.NewLine = false;
CreateWebQueryField(aFieldItem, ">=", true);
}
else
{
qColumns.Operator = Range;
}
}
switch (aFieldItem.ControlType.ToUpper())
{
case "DATETIMEBOX":
qColumns.ColumnType = "ClientQueryCalendarColumn";
break;
case "CHECKBOX":
qColumns.ColumnType = "ClientQueryCheckBoxColumn";
break;
default:
qColumns.ColumnType = "ClientQueryTextBoxColumn";
break;
}
WebClientQuery1.Columns.Add(qColumns);
}
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(WebClientQuery1, null, "", "M");
}
#endif
}
private string GenTempateHTML(string template, string controlType, TBlockItem BlockItem, TBlockFieldItem BFI)
{
bool isAjaxPage = false;
object obj = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxScriptManager1", 0);
if (obj != null)
isAjaxPage = true;
StringBuilder builder = new StringBuilder();
String FormatStyle = this.FormatEditMask(BFI.EditMask);
if (template == "edit")
{
switch (controlType)
{
case "RefValBox":
IDbConnection conn = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, false);
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = conn;
String OWNER = String.Empty, SS = this.FClientData.RealTableName, TableName = String.Empty;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, this.FClientData.TableName);
DataSet aDataSet = new DataSet();
StringBuilder RefColumns = new StringBuilder("<Columns>");
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", BFI.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, BFI.RefValNo);
if (aDataSet != null && aDataSet.Tables.Count > 0 && aDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in aDataSet.Tables[0].Rows)
{
RefColumns.Append(Environment.NewLine);
RefColumns.Append("<InfoLight:WebRefColumn ColumnName=\"" + DR["FIELD_NAME"].ToString() + "\" HeadText=\"" + DR["HEADER_TEXT"].ToString() + "\" Width=\"100\" />");
}
RefColumns.Append(Environment.NewLine);
RefColumns.Append("</columns>");
}
else
{
RefColumns = new StringBuilder("");
}
String DataSourceID = GenWebDataSource(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "RefVal", "");
String refvalHTML = String.Empty;
if (isAjaxPage)
{
refvalHTML = String.Format("<AjaxTools:AjaxRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"[{1}]\"{5}) %>' " +
"DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ResxDataSet=\"\">" +
RefColumns.ToString() +
"</AjaxTools:AjaxRefVal>",
WzdUtils.RemoveSpecialCharacters("arv" + BlockItem.TableName + BFI.DataField + "E"),
BFI.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
else
{
refvalHTML = String.Format("<InfoLight:WebRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"[{1}]\"{5}) %>' " +
"ButtonImageUrl=\"../Image/refval/RefVal.gif\" DataBindingField=\"{1}\" DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ReadOnly=\"False\" ResxDataSet=\"\" " +
"ResxFilePath=\"\" UseButtonImage=\"True\"> " +
RefColumns.ToString() +
"</InfoLight:WebRefVal>",
WzdUtils.RemoveSpecialCharacters("wrv" + BlockItem.TableName + BFI.DataField + "E"),
BFI.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
builder.AppendLine(refvalHTML);
break;
case "ComboBox":
String comboHTML = string.Format("<InfoLight:WebDropDownList runat=\"server\" ID=\"{0}\" DataSourceID=\"{1}\" DataTextField=\"{2}\" DataValueField=\"{3}\" DataMember=\"{4}\" SelectedValue='<%# Bind(\"[{5}]\"{6}) %>'></InfoLight:WebDropDownList>",
WzdUtils.RemoveSpecialCharacters("wdd" + BlockItem.TableName + BFI.DataField + "E"),
GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", ""),
BFI.ComboTextField,
BFI.ComboValueField,
BFI.ComboEntityName,
BFI.DataField,
FormatStyle);
builder.AppendLine(comboHTML);
break;
case "ValidateBox":
String validateHTML = String.Format("<InfoLight:WebValidateBox ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"[{1}]\"{3}) %>' ValidateField=\"{1}\" WebValidateID=\"{2}\"></InfoLight:WebValidateBox>",
WzdUtils.RemoveSpecialCharacters("wvb" + BlockItem.TableName + BFI.DataField + "E"),
BFI.DataField,
"wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName),
FormatStyle);
builder.AppendLine(validateHTML);
break;
case "CheckBox":
String checkHTML = String.Format("<asp:CheckBox ID=\"{0}\" runat=\"server\" Checked='<%# Bind(\"[{1}]\"{2}) %>'></asp:CheckBox>",
WzdUtils.RemoveSpecialCharacters("cb" + BlockItem.TableName + BFI.DataField + "E"),
BFI.DataField,
FormatStyle);
builder.AppendLine(checkHTML);
break;
case "DateTimeBox":
String dtHTML = String.Empty;
if (isAjaxPage)
{
dtHTML = String.Format("<AjaxTools:AjaxDateTimePicker runat=\"server\" DateFormat=\"{0}\" DateTimeType=\"{1}\" Localize=\"False\" MinYear=\"1950\" MaxYear=\"2050\" ToolTip=\"{2}\" Width=\"100px\" ID=\"{3}\" {4}='<%# Bind(\"[{5}]\"{6}) %>'></AjaxTools:AjaxDateTimePicker>",
"None",
(BFI.DataType == typeof(DateTime)) ? "DateTime" : "Varchar",
BFI.DataField,
WzdUtils.RemoveSpecialCharacters("wdt" + BlockItem.TableName + BFI.DataField + "E"),
(BFI.DataType == typeof(DateTime)) ? "Text" : "DateString",
BFI.DataField,
FormatStyle);
}
else
{
dtHTML = String.Format("<InfoLight:WebDateTimePicker runat=\"server\" UseButtonImage=\"True\" DateFormat=\"{0}\" DateTimeType=\"{1}\" Localize=\"False\" MinYear=\"1950\" MaxYear=\"2050\" ToolTip=\"{2}\" Width=\"100px\" ID=\"{3}\" {4}='<%# Bind(\"[{5}]\"{6}) %>'></InfoLight:WebDateTimePicker>",
"None",
(BFI.DataType == typeof(DateTime)) ? "DateTime" : "Varchar",
BFI.DataField,
WzdUtils.RemoveSpecialCharacters("wdt" + BlockItem.TableName + BFI.DataField + "E"),
(BFI.DataType == typeof(DateTime)) ? "Text" : "DateString",
BFI.DataField,
FormatStyle);
}
builder.AppendLine(dtHTML);
break;
}
}
else if (template == "footer")
{
switch (controlType)
{
case "RefValBox":
IDbConnection conn = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, false);
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = conn;
String OWNER = String.Empty, SS = this.FClientData.RealTableName, TableName = String.Empty;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, this.FClientData.TableName);
DataSet aDataSet = new DataSet();
StringBuilder RefColumns = new StringBuilder("<Columns>");
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", BFI.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, BFI.RefValNo);
if (aDataSet != null && aDataSet.Tables.Count > 0 && aDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in aDataSet.Tables[0].Rows)
{
RefColumns.Append(Environment.NewLine);
RefColumns.Append("<InfoLight:WebRefColumn ColumnName=\"" + DR["FIELD_NAME"].ToString() + "\" HeadText=\"" + DR["HEADER_TEXT"].ToString() + "\" Width=\"100\" />");
}
RefColumns.Append(Environment.NewLine);
RefColumns.Append("</columns>");
}
else
{
RefColumns = new StringBuilder("");
}
String DataSourceID = GenWebDataSource(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "RefVal", "");
String refvalHTML = String.Empty;
if (isAjaxPage)
{
refvalHTML = String.Format("<AjaxTools:AjaxRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"[{1}]\"{5}) %>' " +
"DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ResxDataSet=\"\">" +
RefColumns.ToString() +
"</AjaxTools:AjaxRefVal>",
WzdUtils.RemoveSpecialCharacters("arv" + BlockItem.TableName + BFI.DataField + "F"),
BFI.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
else
{
refvalHTML = String.Format("<InfoLight:WebRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"[{1}]\"{5}) %>' " +
"ButtonImageUrl=\"../Image/refval/RefVal.gif\" DataBindingField=\"{1}\" DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ReadOnly=\"False\" ResxDataSet=\"\" " +
"ResxFilePath=\"\" UseButtonImage=\"True\"> " +
RefColumns.ToString() +
"</InfoLight:WebRefVal>",
WzdUtils.RemoveSpecialCharacters("wrv" + BlockItem.TableName + BFI.DataField + "F"),
BFI.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
builder.AppendLine(refvalHTML);
break;
case "ComboBox":
string comboHTML = string.Format("<InfoLight:WebDropDownList runat=\"server\" ID=\"{0}\" DataSourceID=\"{1}\" DataTextField=\"{2}\" DataValueField=\"{3}\" DataMember=\"{4}\"></InfoLight:WebDropDownList>",
WzdUtils.RemoveSpecialCharacters("wdd" + BlockItem.TableName + BFI.DataField + "F"),
GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", ""),
BFI.ComboTextField,
BFI.ComboValueField,
BFI.ComboEntityName);
builder.AppendLine(comboHTML);
break;
case "ValidateBox":
String validateHTML = String.Format("<InfoLight:WebValidateBox ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"[{1}]\"{3}) %>' ValidateField=\"{1}\" WebValidateID=\"{2}\"></InfoLight:WebValidateBox>",
WzdUtils.RemoveSpecialCharacters("wvb" + BlockItem.TableName + BFI.DataField + "F"),
BFI.DataField,
"wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName),
FormatStyle);
builder.AppendLine(validateHTML);
break;
case "CheckBox":
String checkHTML = String.Format("<asp:CheckBox ID=\"{0}\" runat=\"server\" Checked='<%# Bind(\"[{1}]\"{2}) %>'></asp:CheckBox>",
WzdUtils.RemoveSpecialCharacters("cb" + BlockItem.TableName + BFI.DataField + "F"),
BFI.DataField,
FormatStyle);
builder.AppendLine(checkHTML);
break;
case "DateTimeBox":
String dtHTML = String.Empty;
if (isAjaxPage)
{
dtHTML = String.Format("<AjaxTools:AjaxDateTimePicker runat=\"server\" DateFormat=\"{0}\" DateTimeType=\"{1}\" Localize=\"False\" MinYear=\"1950\" MaxYear=\"2050\" ToolTip=\"{2}\" Width=\"100px\" ID=\"{3}\" {4}='<%# Bind(\"[{5}]\"{6}) %>'></AjaxTools:AjaxDateTimePicker>",
"None",
(BFI.DataType == typeof(DateTime)) ? "DateTime" : "Varchar",
BFI.DataField,
WzdUtils.RemoveSpecialCharacters("wdt" + BlockItem.TableName + BFI.DataField + "F"),
(BFI.DataType == typeof(DateTime)) ? "Text" : "DateString",
BFI.DataField,
FormatStyle);
}
else
{
dtHTML = string.Format("<InfoLight:WebDateTimePicker runat=\"server\" UseButtonImage=\"True\" DateFormat=\"{0}\" DateTimeType=\"{1}\" Localize=\"False\" MinYear=\"1950\" MaxYear=\"2050\" ToolTip=\"{2}\" Width=\"100px\" ID=\"{3}\"></InfoLight:WebDateTimePicker>",
"None",
(BFI.DataType == typeof(DateTime)) ? "DateTime" : "Varchar",
BFI.DataField,
WzdUtils.RemoveSpecialCharacters("wdt" + BlockItem.TableName + BFI.DataField + "F"));
}
builder.AppendLine(dtHTML);
break;
}
}
else if (template == "item")
{
switch (controlType)
{
case "RefValBox":
IDbConnection conn = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, false);
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = conn;
String OWNER = String.Empty, SS = this.FClientData.RealTableName, TableName = String.Empty;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, this.FClientData.TableName);
DataSet aDataSet = new DataSet();
StringBuilder RefColumns = new StringBuilder("<Columns>");
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", BFI.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, BFI.RefValNo);
if (aDataSet != null && aDataSet.Tables.Count > 0 && aDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in aDataSet.Tables[0].Rows)
{
RefColumns.Append(Environment.NewLine);
RefColumns.Append("<InfoLight:WebRefColumn ColumnName=\"" + DR["FIELD_NAME"].ToString() + "\" HeadText=\"" + DR["HEADER_TEXT"].ToString() + "\" Width=\"100\" />");
}
RefColumns.Append(Environment.NewLine);
RefColumns.Append("</columns>");
}
else
{
RefColumns = new StringBuilder("");
}
String DataSourceID = GenWebDataSource(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "RefVal", "");
String refvalHTML = String.Format("<InfoLight:WebRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"[{1}]\"{5}) %>' " +
"ButtonImageUrl=\"../Image/refval/RefVal.gif\" DataBindingField=\"{1}\" DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ReadOnly=\"True\" BorderStyle=\"None\" ResxDataSet=\"\" " +
"ResxFilePath=\"\" UseButtonImage=\"True\" Width=\"100px\" BackColor=\"Transparent\"> " +
RefColumns.ToString() +
"</InfoLight:WebRefVal>",
WzdUtils.RemoveSpecialCharacters("wrv" + BlockItem.TableName + BFI.DataField + "E"),
BFI.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
builder.AppendLine(refvalHTML);
break;
default:
string labelHTML = string.Format("<asp:Label runat=\"server\" ToolTip=\"{0}\" ID=\"{1}\" Text='<%# Bind(\"[{2}]\"{3}) %>'></asp:Label>",
BFI.DataField,
WzdUtils.RemoveSpecialCharacters("l" + BlockItem.TableName + BFI.DataField),
BFI.DataField,
FormatStyle);
builder.AppendLine(labelHTML);
break;
}
}
return builder.ToString();
}
private void SetFieldNamesByProvider(String TableName, String ProviderName, ListView aListView)
{
if (ProviderName == null || ProviderName.Trim() == "")
return;
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = InternalConnection;
String OWNER = String.Empty, SS = TableName;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName);
aListView.Items.Clear();
InfoDataSet aDataSet = new InfoDataSet();
try
{
aDataSet.SetWizardDesignMode(true);
aDataSet.RemoteName = ProviderName;
aDataSet.AlwaysClose = true;
aDataSet.Active = true;
DataTable Table = aDataSet.RealDataSet.Tables[0];
foreach (DataColumn Column in Table.Columns)
{
ListViewItem aItem = new ListViewItem(Column.ColumnName);
DataRow[] DRS = dsColdef.Tables[0].Select("FIELD_NAME='" + Column.ColumnName + "'");
TBlockFieldItem aFieldItem = new TBlockFieldItem();
if (DRS.Length > 0)
{
aItem.SubItems.Add(DRS[0]["CAPTION"].ToString());
aFieldItem.Description = DRS[0]["CAPTION"].ToString();
aFieldItem.QueryMode = DRS[0]["QUERYMODE"].ToString();
if (DRS[0]["IS_KEY"] != null && DRS[0]["IS_KEY"].ToString() == "Y")
aFieldItem.IsKey = true;
}
else
{
aItem.SubItems.Add("");
aFieldItem.Description = "";
}
aListView.Items.Add(aItem);
aFieldItem.DataField = Column.ColumnName;
aFieldItem.DataType = Column.DataType;
if (DRS.Length > 0 && DRS[0]["CAPTION"] != null)
aItem.Tag = aFieldItem;
}
}
finally
{
aDataSet.Dispose();
}
}
private string GenTemplateFieldHTML(string controlType, TBlockItem BlockItem, TBlockFieldItem BFI)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("<asp:TemplateField HeaderText=\"" + (string.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description) + "\" SortExpression=\"" + BFI.DataField + "\">");
builder.AppendLine("<EditItemTemplate>");
builder.AppendLine(GenTempateHTML("edit", controlType, BlockItem, BFI));
builder.AppendLine("</EditItemTemplate>");
builder.AppendLine("<FooterTemplate>");
builder.AppendLine(GenTempateHTML("footer", controlType, BlockItem, BFI));
builder.AppendLine("</FooterTemplate>");
builder.AppendLine("<ItemTemplate>");
builder.AppendLine(GenTempateHTML("item", controlType, BlockItem, BFI));
builder.AppendLine("</ItemTemplate>");
builder.AppendLine("</asp:TemplateField>");
return builder.ToString();
}
