用命名空间
namespace PublicData
{
/// <summary>
/// PublicData 的摘要说明。
/// </summary>
public class PublicInfo
{
public SqlConnection LinkSqlInfo()
{
string LinkSqlData = "data source=Localhost;initial catalog=DATASQL;persist security info=False;user id=sa;workstation id=AHUI;packet size=4096";
SqlConnection myConnection = new SqlConnection(LinkSqlData);
return myConnection;
}
}
}
[WebMethod] public DataSet GetModuleTree(string TreeID,string UserName,string PassWord){
PublicData.PublicInfo thisPublic = new PublicData.PublicInfo();
DataSet ds = new DataSet();
if(thisPublic.UserTest(UserName,PassWord) && TreeID != null){
try{
SqlConnection mySqlConnection = thisPublic.LinkSqlInfo();
SqlDataAdapter thisDataAdapter = new SqlDataAdapter("SELECT This_ID,UPID,TextValue,(SELECT COUNT(*) FROM MODULETREE WHERE Up.This_ID = UPID) Down FROM MODULETREE Up WHERE UPID="+TreeID+" ORDER BY OrderId",mySqlConnection);
thisDataAdapter.Fill(ds,"0");
}
catch(Exception){
ds = null;
}
}
return ds;
}