/***************************************************************************
?*?Created:???????2009-11-25?16:05:00
?*?NameSpace:?????DAL
?*?Filename:??????AnalysisDAL.cs
?*?Author:????????余虎成
?*?Version:???????1.0
?*?Description:???問卷統計數據分析數據庫訪問類
*?***************************************************************************/
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.IO;
using?System.Data;


namespace?BLL
{
????public?class?AnalysisBLL
????{
????????#region?查找所有的問卷統計信息
???????
????????//

?????????//查找所有的問卷統計信息
?????????//

?????????//
????????public?static?List?GetAllAnalysis（）
????????{
??????????
???????????return??DAL.AnalysisDAL.SelectAllAnalysisDAL（）;
????????}
????????#endregion

????????#region?添加一個新的問卷
????????///?

????????///?添加一個新的問卷
????????///?

????????///?
????????///?
????????public?static?bool?AddAnalysis（Models.Analysis?Ana）
????????{
????????????return?DAL.AnalysisDAL.InsertAnalysisDAL（Ana）;
????????}
????????#endregion

????????#region?通過Analysis表中的SurveryId得到問卷名
????????///?

????????///?通過Analysis表中的SurveryId得到問卷名
????????///?

????????///?
????????public?static?List?getSurveryByAnalysis（）
????????{
????????????List?list?=?BLL.AnalysisBLL.GetAllAnalysis（）;
????????????List?SurveryList?=?new?List（）;
????????????foreach?（Models.Analysis?sta?in?list）
????????????{
????????????????int?surveryid?=?sta.SurveryId;

????????????????Models.Survery?survery?=?BLL.SurveryBLL.InfoSurvery（surveryid）;
????????????????SurveryList.Add（survery）;
????????????}
????????????return?SurveryList;
????????}
????????#endregion

????????#region??通過Analysis表中的SurveryId得到Analysis詳情
????????///?

????????///?通過Analysis表中的SurveryId得到Analysis詳情
????????///?

????????///?
????????///?
????????public?static?List?getAnalysis（Models.Analysis?ana?）
????????{
????????????return?DAL.AnalysisDAL.SelectAnalysisDAL（ana）;
????????}
????????#endregion

????????public?static?DataTable??GetAllUser（int?surveryid）
????????{
????????????return?DAL.UserDAL.getAllUser（surveryid）;
????????}

????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????2629??2009-12-02?13:10??QuestionnaireOnline\BLL\AnalysisBLL.cs

?????文件???????2352??2009-11-30?19:32??QuestionnaireOnline\BLL\AnswerBLL.cs

?????文件???????8704??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\BLL.dll

?????文件??????34304??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\BLL.pdb

?????文件??????24064??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\DAL.dll

?????文件??????62976??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\DAL.pdb

?????文件???????8704??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\Models.dll

?????文件??????40448??2009-12-02?13:10??QuestionnaireOnline\BLL\bin\Debug\Models.pdb

?????文件???????3299??2009-11-27?21:59??QuestionnaireOnline\BLL\BLL.csproj

?????文件????????269??2009-11-25?10:07??QuestionnaireOnline\BLL\BLL.csproj.vspscc

?????文件????????529??2009-11-26?16:23??QuestionnaireOnline\BLL\ManagerBll.cs

?????文件????????166??2009-11-27?21:59??QuestionnaireOnline\BLL\mssccprj.scc

?????文件????????443??2009-12-02?13:10??QuestionnaireOnline\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件???????8704??2009-12-02?13:10??QuestionnaireOnline\BLL\obj\Debug\BLL.dll

?????文件??????34304??2009-12-02?13:10??QuestionnaireOnline\BLL\obj\Debug\BLL.pdb

?????文件???????4808??2009-12-02?13:10??QuestionnaireOnline\BLL\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1344??2009-11-24?21:45??QuestionnaireOnline\BLL\Properties\AssemblyInfo.cs

????....SHR???????107??2009-11-25?11:29??QuestionnaireOnline\BLL\Properties\vssver2.scc

?????文件???????3159??2009-12-01?11:07??QuestionnaireOnline\BLL\QuestionBLL.cs

?????文件???????2117??2009-11-30?16:48??QuestionnaireOnline\BLL\StatisticsBLL.cs

?????文件???????1273??2009-11-27?16:29??QuestionnaireOnline\BLL\SurQuetionBLL.cs

?????文件???????4277??2009-11-30?16:53??QuestionnaireOnline\BLL\SurveryBLL.cs

?????文件???????1511??2009-11-27?21:59??QuestionnaireOnline\BLL\UserBll.cs

????....SHR???????369??2009-12-02?13:10??QuestionnaireOnline\BLL\vssver2.scc

?????文件???????7861??2009-11-30?15:18??QuestionnaireOnline\DAL\AnalysisDAL.cs

?????文件???????6480??2009-11-30?19:32??QuestionnaireOnline\DAL\AnswerDAL.cs

?????文件??????24064??2009-12-02?13:10??QuestionnaireOnline\DAL\bin\Debug\DAL.dll

?????文件??????62976??2009-12-02?13:10??QuestionnaireOnline\DAL\bin\Debug\DAL.pdb

?????文件???????8704??2009-12-02?13:10??QuestionnaireOnline\DAL\bin\Debug\Models.dll

?????文件??????40448??2009-12-02?13:10??QuestionnaireOnline\DAL\bin\Debug\Models.pdb

............此處省略183個文件信息