1
/**/
/// <summary>
2
/// 填充comboboxB超医师 geovindu@163.com 涂聚文
3
///2009-02-16
4
/// </summary>
5
private
void
setDBPyhNameComboBox()
6![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
7![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
this.combPhy.DataSource = null;
9![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
DBConnectioin dbc = new DBConnectioin();
11
SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
12
conn.Open();
13
//DbHelperSQL.setComboList(combPhy, "select PhyID,PhyName from Physician", "Physician", "PhyName", "PhyID");
14
string sSQL = "select PhyID,PhyName from Physician";
15
string sTable = "Physician";
16![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
18
DataSet dsCourtesy = new DataSet();
19
SqlDataAdapter daCourtesy = new SqlDataAdapter();
20
DbHelperSQL.setCommand(dsCourtesy, daCourtesy, sSQL, sTable);
21
daCourtesy.Fill(dsCourtesy);
22
combPhy.DataSource = dsCourtesy.Tables[0].DefaultView;
23
DataRow dr = dsCourtesy.Tables[0].NewRow();
24
combPhy.DisplayMember = "PhyName";
25
combPhy.ValueMember = "PhyID";
26
dr["PhyName"] = "全部";
27
dr["PhyID"] = -1;
28
dsCourtesy.Tables[0].Rows.InsertAt(dr, 0);
29
//combPhy.Text = "全部";
30![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
}
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
ProductCatalogListBLL productCatalogListBLL = new ProductCatalogListBLL();
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindClass();
}
}
/// <summary>
///
/// </summary>
void BindClass()
{
List<ProductCatalogListInfo> list = productCatalogListBLL.get_List();
foreach (ProductCatalogListInfo model in list)
{
ListItem li = new ListItem();
li.Text = "╋" + model.ProductCatalogName;
li.Value = model.ProductCatalogId.ToString();
DropDownList1.Items.Add(li);
BindChild(model.ProductCatalogId.ToString(), "├──");
}
}
/// <summary>
///
/// </summary>
/// <param name="ParentID"></param>
/// <param name="separator"></param>
void BindChild(string ParentID, string separator)
{
List<ProductCatalogListInfo> list = productCatalogListBLL.get_List(ParentID);
foreach (ProductCatalogListInfo model in list)
{
ListItem li = new ListItem();
li.Text = separator + model.ProductCatalogName;
li.Value = model.ProductCatalogId.ToString();
DropDownList1.Items.Add(li);
string separator_ = separator + "───";
BindChild(model.ProductCatalogId.ToString(), separator_);
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List<ProductCatalogListInfo> get_List()
{
List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=0 order by ProductCatalogId desc").Tables[0];
foreach (DataRow dr in dt.Rows)
{
ProductCatalogListInfo model = new ProductCatalogListInfo();
model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]);
model.ProductCatalogName = dr["ProductCatalogName"].ToString();
model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]);
List.Add(model);
}
return List;
}
/// <summary>
///
/// </summary>
/// <param name="ParentID"></param>
/// <returns></returns>
public List<ProductCatalogListInfo> get_List(string ParentID)
{
List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=" + ParentID + " order by ProductCatalogId desc").Tables[0];
foreach (DataRow dr in dt.Rows)
{
ProductCatalogListInfo model = new ProductCatalogListInfo();
model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]);
model.ProductCatalogName = dr["ProductCatalogName"].ToString();
model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]);
List.Add(model);
}
return List;
}