/// <summary>
/// 获得数据List
/// </summary>
public SimpleInfoArray GetWorkShopDataList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TAB_Org_WorkShop order by strWorkShopName");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
SimpleInfoArray list = new SimpleInfoArray();
foreach (DataRow dr in dt.Rows)
{
SimpleInfo _Org_WorkShop = new SimpleInfo();
WorkShopDataRowToModel(_Org_WorkShop, dr);
list.Add(_Org_WorkShop);
}
return(list);
}
/// <summary>
/// 获得数据List
/// </summary>
public SimpleInfoArray GetGroupDataList(string strWorkShopGUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TAB_Org_GuideGroup where strWorkShopGUID=@strWorkShopGUID order by nid");
SqlParameter[] parameters =
{
new SqlParameter("strWorkShopGUID", strWorkShopGUID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters).Tables[0];
SimpleInfoArray list = new SimpleInfoArray();
foreach (DataRow dr in dt.Rows)
{
SimpleInfo _Org_GuideGroup = new SimpleInfo();
GroupDataRowToModel(_Org_GuideGroup, dr);
list.Add(_Org_GuideGroup);
}
return(list);
}
