void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
if (ds.Tables[0].Rows.Count == 0)
{
// this.NewDtl();
return;
}
DataGrid dg = new DataGrid();
dg.Name = "DG" + this.Name;
DataGridTextColumn mycol = new DataGridTextColumn();
mycol.Header = "IDX";
dg.Columns.Add(mycol);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["UIVisible"].ToString() == "0")
{
continue;
}
DataGridTextColumn txtColumn = new DataGridTextColumn();
txtColumn.Header = dr["Name"];
dg.Columns.Add(txtColumn);
}
dg.Width = this.Width;
dg.Height = this.Height;
this.Content = dg;
this.MyDG = dg;
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
if (ds.Tables[0].Rows.Count == 0)
{
//this.NewM2M();
return;
}
//this.Content = "提示:aswd键改变位置，shift+方向键调整大小，双击或右键修改属性。";
DataGrid dg = new DataGrid();
dg.Name = "DG" + this.Name;
DataGridTextColumn mycol = new DataGridTextColumn();
mycol.Header = "提示:aswd键改变位置，shift+方向键调整大小，双击或右键修改属性。";
dg.Columns.Add(mycol);
dg.Width = this.Width;
dg.Height = this.Height;
this.Content = dg;
this.MyDG = dg;
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
MessageBox.Show("系统错误没有找到 fk_mapdata=" + Glo.FK_MapData + "的数据。", "系统错误", MessageBoxButton.OK);
return;
}
this.TB_FrmName.Text = dt.Rows[0]["Name"];
if (dt.Rows[0]["Designer"] != null)
{
this.TB_Designer.Text = dt.Rows[0]["Designer"];
}
if (dt.Rows[0]["DesignerUnit"] != null)
{
this.TB_DesignerUnit.Text = dt.Rows[0]["DesignerUnit"];
}
if (dt.Rows[0]["DesignerContext"] != null)
{
this.TB_DesignerContext.Text = dt.Rows[0]["DesignerContext"];
}
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
try
{
Silverlight.DataSet ds = new Silverlight.DataSet();
ds.FromXml(e.Result);
this.Items.Clear();
foreach (Silverlight.DataRow dr in ds.Tables[0].Rows)
{
ListBoxItem li = new ListBoxItem();
li.Tag = dr["No"];
li.Content = dr["Name"];
this.Items.Add(li);
}
if (this.Items.Count != 0)
{
this.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// da_RunSQLReturnTableCompleted
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
ListBoxItem item = new ListBoxItem();
item.Tag = dr["CfgVal"].ToString();
item.Content = dr["No"] + ":" + dr["Name"];
this.listBox1.Items.Add(item);
}
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet("s");
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
this.listBox1.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
ListBoxItem li = new ListBoxItem();
li.Content = dr["KeyOfEn"] + " - " + dr["Name"];
li.Tag = dr["KeyOfEn"] + "#" + dr["MyDataType"] + "#" + dr["LGType"];
this.listBox1.Items.Add(li);
}
}
/// <summary>
/// 绑定这个控件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
this.SetBlank();
}
else
{
this.TB_EleID.IsEnabled = false;
this.DDL_EleType.IsEnabled = true;
this.IsNew = false;
this.TB_EleID.Text = dt.Rows[0]["EleID"].ToString();
this.TB_EleName.Text = dt.Rows[0]["EleName"].ToString();
foreach (var item in this.DDL_EleType.Items)
{
ComboBoxItem myite = item as ComboBoxItem;
if (myite.Tag.ToString() == dt.Rows[0]["EleType"].ToString())
{
this.DDL_EleType.SelectedItem = myite;
myite.IsSelected = true;
break;
}
}
this.DDL_EleType.IsEnabled = false;
//为每个tag 赋值。
this.TB_Tag1.Text = dt.Rows[0]["Tag1"].ToString();
this.TB_Tag2.Text = dt.Rows[0]["Tag2"].ToString();
this.TB_Tag3.Text = dt.Rows[0]["Tag3"].ToString();
this.TB_Tag4.Text = dt.Rows[0]["Tag4"].ToString();
}
this.ReSetTagDesc();
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
this.listBox1.Items.Clear();
this.listBox1.SelectionMode = SelectionMode.Extended;
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
if (dr["NodeID"].ToString() == Glo.FK_Node.ToString())
{
continue;
}
ListBoxItem lb = new ListBoxItem();
lb.Name = "LB" + dr["NodeID"].ToString();
lb.Tag = dr["NodeID"].ToString();
lb.Content = "Node:" + dr["Name"].ToString() + " Step:" + dr["Step"];
this.listBox1.Items.Add(lb);
}
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
/* 没有数据 */
this.TB_DoDoc.Text = "";
this.TB_MsgErr.Text = "";
this.TB_MsgOK.Text = "";
this.DDL_EventType.SelectedIndex = 0;
}
else
{
this.TB_DoDoc.Text = dt.Rows[0]["DoDoc"].Replace("~", "'");
try
{
this.TB_MsgErr.Text = dt.Rows[0]["MsgError"].Replace("~", "'");
}
catch
{
}
//try
//{
// this.TB_MsgErr.Text = dt.Rows[0]["MsgErr"].Replace("~", "'");
//}
//catch
//{
//}
this.TB_MsgOK.Text = dt.Rows[0]["MsgOK"].Replace("~", "'");
this.DDL_EventType.SelectedIndex = int.Parse(dt.Rows[0]["DoType"]);
}
}
void da_RunSQLReturnTableCompleted(object sender, FF.RunSQLReturnTableCompletedEventArgs e)
{
DataSet ds = new DataSet();
ds.FromXml(e.Result);
DataTable dt = ds.Tables[0];
//string sql = "SELECT * FROM Sys_MapAttr ";
//DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
this.grdLayoutRoot.ColumnDefinitions.Clear();
this.grdLayoutRoot.RowDefinitions.Clear();
#region 设置好布局
foreach (DataColumn dc in dt.Columns)
{
ColumnDefinition cdf = new ColumnDefinition();
// cdf.SetValue(ColumnDefinition.WidthProperty, (double)100);
cdf.MaxWidth = (double)100;
cdf.MinWidth = (double)20;
this.grdLayoutRoot.ColumnDefinitions.Add(cdf);
}
foreach (DataRow dr in dt.Rows)
{
RowDefinition row = new RowDefinition();
row.MaxHeight = (double)100;
row.MinHeight = (double)20;
this.grdLayoutRoot.RowDefinitions.Add(row);
}
#endregion 设置好布局
#region 填充数据.
int columnIdx = 0;
foreach (DataColumn dc in dt.Columns)
{
TextBlock text = new TextBlock();
text.Name = dc.ColumnName;
text.SetValue(Grid.ColumnProperty, columnIdx);
text.SetValue(Grid.HeightProperty, (double)20);
text.Text = dc.ColumnName;
this.grdLayoutRoot.Children.Add(text);
columnIdx++;
}
int rowIdx = 0;
foreach (DataRow dr in dt.Rows)
{
columnIdx = 0;
foreach (DataColumn dc in dt.Columns)
{
TextBlock text = new TextBlock();
text.Name = "r" + columnIdx + "_" + rowIdx;
text.SetValue(Grid.ColumnProperty, columnIdx);
text.SetValue(Grid.RowProperty, rowIdx);
text.Text = dr[dc.ColumnName];
this.grdLayoutRoot.Children.Add(text);
columnIdx++;
}
rowIdx++;
}
#endregion 填充数据
}
