private List <FBPaperItem> GetFBItem()
{
//List<TrainFBQuestion> question= _DalFBQues.GetFBQuestionByConditon(string.Empty, -1);
FeedBackPaper paper = _IFeedBackPaper.GetFeedBackPaperById(_Course.CourseFeedBackPaper.FeedBackPaperId);
if (paper == null || paper.FBQuestions == null)
{
return(new List <FBPaperItem>());
}
List <TrainFBQuestion> question = paper.FBQuestions;
List <FBPaperItem> paperItems = new List <FBPaperItem>();
foreach (TrainFBQuestion ques in question)
{
if (ques.FBItems.Count != 0 && ques.FBItems != null)
{
FBPaperItem item = new FBPaperItem();
item.FBQuestion = ques.Description;
item.FBQueItems = GetItemString(ques.FBItems);
item.Worths = GetItemWorth(ques.FBItems);
paperItems.Add(item);
}
}
return(paperItems);
}
public List <FeedBackPaper> GetFeedBackPaperByPaperName(string paperName)
{
List <FeedBackPaper> papers = new List <FeedBackPaper>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmPaperName, SqlDbType.NVarChar, 50).Value = paperName;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetFeedBackPaperByPaperName", cmd))
{
while (sdr.Read())
{
FeedBackPaper paper = new FeedBackPaper();
paper.FeedBackPaperId = Convert.ToInt32(sdr[_DbPKID]);
paper.FeedBackPaperName = sdr[_DbPaperName].ToString();
papers.Add(paper);
}
return(papers);
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public FeedBackPaper GetFeedBackPaperById(int id)
{
FeedBackPaper templatePaper = null;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = id;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetFeedBackPaperByPaperId", cmd))
{
while (sdr.Read())
{
templatePaper = new FeedBackPaper();
templatePaper.FeedBackPaperId = Convert.ToInt32(sdr[_DbPKID]);
templatePaper.FeedBackPaperName = sdr[_DbPaperName].ToString();
templatePaper.FBQuestions = GetFeedBackPaperItemsById(templatePaper.FeedBackPaperId);
}
return(templatePaper);
}
}
public void UpdateFeedBackPaper(FeedBackPaper feedBackPaper)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmCount, SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = feedBackPaper.FeedBackPaperId;
cmd.Parameters.Add(_ParmPaperName, SqlDbType.NVarChar, 50).Value = feedBackPaper.FeedBackPaperName;
SqlHelper.ExecuteNonQuery("FeedBackPaperUpdate", cmd);
DeleteAllItemsInPaper(feedBackPaper.FeedBackPaperId);
if (feedBackPaper.FBQuestions != null)
{
foreach (TrainFBQuestion item in feedBackPaper.FBQuestions)
{
ManagePaperItems(feedBackPaper.FeedBackPaperId, item.FBQuestioniD);
}
}
}
catch
{
throw new ApplicationException(_DbError);
}
}
public int InsertFeedBackPaper(FeedBackPaper feedBackPaper)
{
try
{
int pkid;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmPaperName, SqlDbType.NVarChar, 50).Value = feedBackPaper.FeedBackPaperName;
cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQueryReturnPKID("FeedBackPaperInsert", cmd, out pkid);
if (feedBackPaper.FBQuestions != null)
{
foreach (TrainFBQuestion item in feedBackPaper.FBQuestions)
{
ManagePaperItems(pkid, item.FBQuestioniD);
}
}
return(pkid);
}
catch
{
throw new ApplicationException(_DbError);
}
}
///<summary>
///</summary>
///<param name="iPaper"></param>
///<param name="paper"></param>
public UpdateFeedBackPaper(IFeedBackPaper iPaper, FeedBackPaper paper)
{
_IFeedBackPaper = iPaper;
_Paper = paper;
}
/// <summary>
/// 该事务执行后，会修改考评表的基本信息
/// 异常情况:
/// 1.当前要修改的考评表是否存在，如果不在则给出提示，事务中断
/// 2.PaperName不可与已有Paper的PaperName重复，否则给出提示，事务中断
/// 业务流程：
/// 1.有效性判断
/// 2.如果通过有效性判断，则调用IDal层方法进行考评表修改
/// </summary>
public UpdateFeedBackPaper(FeedBackPaper paper)
{
_Paper = paper;
}
///<summary>
///</summary>
public InsertFeedBackPaper(IFeedBackPaper iPaper, FeedBackPaper paper)
{
_IFeedBackPaper = iPaper;
_Paper = paper;
}
/// <summary>
/// 该事务执行后，会增加一张没有考评项的考评表
/// 异常情况:
/// 1.Title不可与已有Paper的Title重复，否则给出提示，事务中断
/// 业务流程：
/// 1.有效性判断
/// 2.如果通过有效性判断，则调用IDal层方法进行考评表新增
/// </summary>
public InsertFeedBackPaper(FeedBackPaper paper)
{
_Paper = paper;
}
public void UpdateFeedBackPaper(FeedBackPaper feedBackPaper)
{
UpdateFeedBackPaper _update = new UpdateFeedBackPaper(feedBackPaper);
_update.Excute();
}
public void AddAFeedBackPaper(FeedBackPaper feedBackPaper)
{
InsertFeedBackPaper _insert = new InsertFeedBackPaper(feedBackPaper);
_insert.Excute();
}