先在页面中将droplistdown控件AutoPostBack=true,然后开始绑定数据
1、Controller中执行绑定
ddlTransactor.DataBind(UIHelper.GetDepartName());
2、UIHelper中整理需要的数据
public static DDLBindInfo GetDepartName()
{
DDLBindInfo info = new DDLBindInfo()
{
TextField = "DepartName",
ValueField = "DepartID",
DataSource = BaseDataHelper.GetDepartName(),
TopItemText = "请选择所办理部门"
};
return info;
}
3、BaseDataHelper中通过bll层取得详细的数据
internal static DataSet GetDepartName()
{
BLL.DepartName bll = new BLL.DepartName();
string where = "LevelID='4'";
return bll.GetList(where);
}
4、bll层控制dat层与数据库交互
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
5、dat层从数据库中提取数据
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DepartID,......) ");
strSql.Append(" FROM DepartName,DeaprtNickName,LevelID ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
1、Controller中执行绑定
ddlTransactor.DataBind(UIHelper.GetDepartName());
2、UIHelper中整理需要的数据
public static DDLBindInfo GetDepartName()
{
DDLBindInfo info = new DDLBindInfo()
{
TextField = "DepartName",
ValueField = "DepartID",
DataSource = BaseDataHelper.GetDepartName(),
TopItemText = "请选择所办理部门"
};
return info;
}
3、BaseDataHelper中通过bll层取得详细的数据
internal static DataSet GetDepartName()
{
BLL.DepartName bll = new BLL.DepartName();
string where = "LevelID='4'";
return bll.GetList(where);
}
4、bll层控制dat层与数据库交互
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
5、dat层从数据库中提取数据
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DepartID,......) ");
strSql.Append(" FROM DepartName,DeaprtNickName,LevelID ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}