string _last_sql = string.Empty;//最后执行的sql,用于刷新界面
/// <summary>
/// 绑定列表数据
/// </summary>
private void BindData()
{
var dt = ServerProxy.GetTable(_last_sql);
dgv.DataSource = dt;
dgv.Columns["Id"].Visible = false;
dgv.Columns["CreateAt"].Visible = false;
dgv.Columns["statu"].Visible = false;
}
/// <summary>
/// 初始化字典列表内容
/// </summary>
private void InitDictItem()
{
//初始化代码
var sql = string.Format("sp_Search_dictionary '{0}','查询字段'", this.Text);
var dt = ServerProxy.GetTable(sql);
cbField.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
cbField.Items.Add(dr["值"]);
}
if (cbField.Items.Count > 0)
{
cbField.SelectedIndex = 0;
}
}