本文整理汇总了C#中Srvtools.InfoCommand.GetInternalCommand方法的典型用法代码示例。如果您正苦于以下问题:C# InfoCommand.GetInternalCommand方法的具体用法?C# InfoCommand.GetInternalCommand怎么用?C# InfoCommand.GetInternalCommand使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Srvtools.InfoCommand
的用法示例。
在下文中一共展示了InfoCommand.GetInternalCommand方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetControlXml
/// <summary>
/// 取得Control对应的xml
/// </summary>
/// <param name="item">blockfielditem</param>
/// <param name="tableName">tablename</param>
/// <param name="id">控件的id</param>
/// <returns>xml</returns>
private string GetControlXml(TBlockFieldItem item, string tableName, ref string id)
{
WebControl control = null;
PropertyInfo info = null;
#region DropDownList
if (string.Compare(item.ControlType, "combobox", true) == 0)
{
control = new WebDropDownList();
control.ID = string.Format("{0}DropDownList", item.DataField);
control.Width = new Unit(130, UnitType.Pixel);
(control as WebDropDownList).DataSourceID = GenWebDataSource(item, tableName, "ComboBox", string.Empty);
(control as WebDropDownList).DataMember = item.ComboEntityName;
(control as WebDropDownList).DataTextField = item.ComboTextField;
(control as WebDropDownList).DataValueField = item.ComboValueField;
info = control.GetType().GetProperty("SelectedValue");
}
#endregion
#region RefVal
else if (string.Compare(item.ControlType, "refvalbox", true) == 0)
{
#warning GenWebDataSource未完成FSYS_REFVAL部分
control = new WebRefVal();
control.ID = string.Format("{0}RefVal", item.DataField);
if (!string.IsNullOrEmpty(item.RefValNo) || (item.RefField != null))
{
(control as WebRefVal).DataSourceID = GenWebDataSource(item, tableName, "RefVal", string.Empty);
(control as WebRefVal).DataBindingField = item.DataField;
(control as WebRefVal).DataTextField = FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
(control as WebRefVal).DataValueField = FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
if (!string.IsNullOrEmpty(item.RefValNo))
{
IDbConnection conn = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, false);
InfoCommand command = new InfoCommand(FClientData.DatabaseType);
command.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//command.Connection = conn;
command.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", item.RefValNo);
IDbDataAdapter adapter = WzdUtils.AllocateDataAdapter(FClientData.DatabaseType);
adapter.SelectCommand = command.GetInternalCommand();
DataSet dataset = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, adapter, dataset, item.RefValNo);
if (dataset != null && dataset.Tables.Count > 0 && dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in dataset.Tables[0].Rows)
{
WebRefColumn refcolumn = new WebRefColumn();
refcolumn.ColumnName = DR["FIELD_NAME"].ToString();
refcolumn.HeadText = DR["HEADER_TEXT"].ToString();
refcolumn.Width = 100;
(control as WebRefVal).Columns.Add(refcolumn);
}
}
}
info = control.GetType().GetProperty("BindingValue");
}
else
{
control = new TextBox();
control.ID = string.Format("{0}TextBox", item.DataField);
(control as TextBox).MaxLength = item.Length;
info = control.GetType().GetProperty("Text");
}
}
#endregion
#region DateTimePicker
else if (string.Compare(item.ControlType, "datetimebox", true) == 0)
{
control = new WebDateTimePicker();
control.ID = string.Format("{0}DateTimePicker", item.DataField);
(control as WebDateTimePicker).MaxLength = item.Length;
if (string.IsNullOrEmpty(item.EditMask))
{
(control as WebDateTimePicker).DateFormat = dateFormat.ShortDate;
}
if (item.DataType == typeof(DateTime))
{
info = control.GetType().GetProperty("Text");
}
else if (item.DataType == typeof(string))
{
(control as WebDateTimePicker).DateTimeType = dateTimeType.VarChar;
info = control.GetType().GetProperty("DataString");
}
}
#endregion
#region ValidateBox
else if (string.Compare(item.ControlType, "validatebox", true) == 0)
{
control = new WebValidateBox();
//.........这里部分代码省略.........
示例2: GetDDTable
public static DataTable GetDDTable(ClientType databaseType, string dbName, string tableName)
{
XmlDocument doc = new XmlDocument();
doc.Load(SystemFile.DBFile);
XmlNode nDataBase = doc.SelectSingleNode("InfolightDB/DataBase");
foreach (XmlNode node in nDataBase.ChildNodes)
{
if (node.Name == dbName)
{
string conString = node.Attributes["String"].Value;
string password = WzdUtils.GetPwdString(node.Attributes["Password"].Value);
if ((conString.Length > 0) && (password.Length > 0) && password != String.Empty)
{
if (conString[conString.Length - 1] != ';')
{
conString = conString + ";Password=" + password;
}
else
{
conString = conString + "Password=" + password;
}
}
//Connection
DbConnection con = WzdUtils.AllocateConnection(dbName, databaseType, false);
//Command
InfoCommand cmd = new InfoCommand(databaseType);
cmd.Connection = con;
tableName = WzdUtils.RemoveQuote(tableName, databaseType);
String OWNER = String.Empty, SS = tableName;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
tableName = SS;
}
cmd.CommandText = "Select * from COLDEF where TABLE_NAME = '" + tableName + "' OR TABLE_NAME='" + OWNER + "." + tableName + "'";
//Adapter
IDbDataAdapter adapter = WzdUtils.AllocateDataAdapter(databaseType);
adapter.SelectCommand = cmd.GetInternalCommand();
DataTable tab = new DataTable();
WzdUtils.FillDataAdapter(databaseType, adapter, tab);
return tab;
}
}
return null;
}