111,097
社区成员




/// <summary>
/// 初始化TreeList数据
/// </summary>
private void InitsTree()
{
vBranchList = ContextHelper.GetvBranch();
var treeBran = vBranchList.Select(p => new
{
p.Branid,
p.Branno,
p.Branna,
p.Principal,
Preid = p.PreId is null ? 0 : p.PreId,
Brantype = (int)p.Brantype,
p.Branpath
}).ToList();
Treelst.DataSource = ContextHelper.LinqToDataTable(treeBran);
Treelst.KeyFieldName = "Branid";
Treelst.ParentFieldName = "Preid";
}
if (from.Name.Substring(0, 1) == "U")
{
sql = "select * from t_" + from.Name.Substring(1, from.Name.Length - 1) + " order by " + from.Name.Substring(1, from.Name.Length - 1) + "ID";
if (from.Text == "产品类型")
{
TreeList tl = from.Controls.Find("treeList", true)[0] as TreeList;
tl.DataSource = mydate.GetDataSet(sql, "t_" + from.Name.Substring(1, from.Name.Length - 1)).Tables["t_" + from.Name.Substring(1, from.Name.Length - 1)];
}
else {
DataGridView dv = from.Controls.Find("dataGridView", true)[0] as DataGridView;
dv.AutoGenerateColumns = false;
dv.DataSource = mydate.GetDataSet(sql, "t_" + from.Name.Substring(1, from.Name.Length - 1)).Tables["t_" + from.Name.Substring(1, from.Name.Length - 1)];
}
}
判断是第一个产品类型里面的
GetDataSet方法是
/// <summary>
/// 获取DataSet
/// </summary>
/// <param name="strSql">查询语句</param>
/// <param name="strTable">表名</param>
/// <returns></returns>
public DataSet GetDataSet(string strSql, string strTable)
{
DataSet ds = null;
try
{
SqlDataAdapter sda = new SqlDataAdapter(strSql, Conn);
ds = new DataSet();
sda.Fill(ds, strTable);
}
catch (Exception e)
{
throw e;
}
return ds;
}
就是一个SQL返回一个DataSet 然后赋值给DataGridView