public void InsertFBQuestion(TrainFBQuestion obj)
{
try
{
int pkid;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 100).Value = obj.Description;
cmd.Parameters.Add(_TypeID, SqlDbType.Int).Value = obj.TrainFBQuesType.ParameterID;
SqlHelper.ExecuteNonQueryReturnPKID("TrainFBQuesInsert", cmd, out pkid);
obj.FBQuestioniD = pkid;
if (obj.FBItems != null)
{
foreach (TrainFBItem item in obj.FBItems)
{
InsertFBItem(item, obj.FBQuestioniD);
}
}
}
catch
{
throw new ApplicationException(_DbError);
}
}
/// <summary>
/// 更新反馈问题
/// </summary>
/// <param name="obj"></param>
private static void UpdateFBQues(TrainFBQuestion obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = obj.FBQuestioniD;
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 100).Value = obj.Description;
cmd.Parameters.Add(_TypeID, SqlDbType.Int).Value = obj.TrainFBQuesType.ParameterID;
SqlHelper.ExecuteNonQuery("TrainFBQuesUpdate", cmd);
}
private List <TrainFBQuestion> UpdateRowPara(string rowIndex, string itemId)
{
TrainFBQuestion item =
_IFacade.GetFBQuestionByID(Convert.ToInt32(itemId));
if (item == null)
{
return(_ITemplatePaperView.QuestionList);
}
List <TrainFBQuestion> items = _ITemplatePaperView.QuestionList;
items[Convert.ToInt32(rowIndex)] = item;
return(items);
}
public void OKEvent(object source, EventArgs e)
{
TrainFBQuestion trainFBQuestion = _ITrainFacade.GetFBQuestionByID(Convert.ToInt32(_FBQuestionID));
try
{
_ITrainFacade.DeleteTrainFBQuestion(trainFBQuestion);
GoToListPage();
}
catch (ApplicationException ae)
{
_View.ResultMessage = ae.Message;
}
}
/// <summary>
/// 交换第id行<==>第id-1行
/// </summary>
/// <param name="id"></param>
public void ddlAssessItemChangedForUpEvent(string id)
{
List <TrainFBQuestion> items = _ITemplatePaperView.QuestionList;
int currRow = Convert.ToInt32(id);
if (currRow == 0)
{
return;
}
TrainFBQuestion tempItem = items[currRow - 1];
items[currRow - 1] = items[currRow];
items[currRow] = tempItem;
_ITemplatePaperView.QuestionList = items;
}
public void InitPresenter(bool isPostBack)
{
AttachViewEvent();
_View.ResultMessage = string.Empty;
_View.OperationType = TrainFBQuesAndItemUtility._DetailOperationTitle;
_View.SetFormReadOnly = true;
if (!isPostBack)
{
_View.FBQuestionMessage = string.Empty;
_View.FBQuesTypeMessage = string.Empty;
_View.TrainFBQuesTypeSource = _ITrainFacade.GetTrainFBQuesTypeByCondition(-1, string.Empty);
_TrainFBQuestion = _ITrainFacade.GetFBQuestionByID(_FBQuestionID);
_View.FBQuestion = _TrainFBQuestion.Description;
_View.TrainFBQuesType = Convert.ToString(_TrainFBQuestion.TrainFBQuesType.ParameterID);
_View.FBItemList = _TrainFBQuestion.FBItems;
}
}
public void UpdateFBQuestion(TrainFBQuestion obj)
{
try
{
UpdateFBQues(obj);
if (obj.FBItems != null)
{
DeleteFBItem(obj.FBQuestioniD);
foreach (TrainFBItem item in obj.FBItems)
{
item.FBItemID = InsertFBItem(item, obj.FBQuestioniD);
}
}
}
catch
{
throw new ApplicationException(_DbError);
}
}
/// <summary>
/// 获取反馈问题
/// </summary>
/// <param name="paperId"></param>
/// <returns></returns>
private List <TrainFBQuestion> GetFeedBackPaperItemsById(int paperId)
{
try
{
List <TrainFBQuestion> items = new List <TrainFBQuestion>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = paperId;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetQustionItemByPaperId", cmd))
{
while (sdr.Read())
{
TrainFBQuestion item = _QuestionDal.GetFBQuestinByPKID(Convert.ToInt32(sdr[_DbItemID]));
items.Add(item);
}
}
return(items);
}
catch
{
throw new ApplicationException(_DbError);
}
}
public void OKEvent(object source, EventArgs e)
{
if (new TrainFBQuesAndItemValidater(_View).Vaildate())
{
try
{
_View.ResultMessage = string.Empty;
TrainFBQuesType fBQuesType =
_ITrainFacade.GetTrainFBQuesTypeByPKID(Convert.ToInt32(_View.TrainFBQuesType));
TrainFBQuestion fBQuestion = new TrainFBQuestion(_FBQuestionID, _View.FBQuestion, fBQuesType,
_View.FBItemList);
_ITrainFacade.UpdateTrainFBQuestion(fBQuestion);
GoToListPage();
}
catch (Exception ex)
{
_View.ResultMessage =
//" <img src='../../image/icon03.jpg' align='absmiddle'' /> <span class='fontred'>" +
ex.Message;// +"</span>";
}
}
}
public TrainFBQuestion GetFBQuestinByPKID(int pkid)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = pkid;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetTrainFBQuesByQuesID", cmd))
{
while (sdr.Read())
{
int queID = (Int32)sdr[_DBPKID];
int queTypeID = (Int32)sdr[_DBTypeID];
string quesDescription = sdr[_DBName].ToString();
string typeName = sdr[_DBTypeName].ToString();
TrainFBQuesType type = new TrainFBQuesType(queTypeID, typeName);
TrainFBQuestion questioon = new TrainFBQuestion(queID, quesDescription, type, null);
questioon.FBItems = new List <TrainFBItem>();
questioon.FBItems = GetFBItemsByQuesId(pkid);
return(questioon);
}
}
return(null);
}
public List <TrainFBQuestion> GetFBQuestionByConditon(string name, int type)
{
List <TrainFBQuestion> questions = new List <TrainFBQuestion>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 100).Value = name;
cmd.Parameters.Add(_TypeID, SqlDbType.Int).Value = type;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetTrainFBQuesByCondition", cmd))
{
while (sdr.Read())
{
int queID = (Int32)sdr[_DBPKID];
int queTypeID = (Int32)sdr[_DBTypeID];
string quesDescription = sdr[_DBName].ToString();
string typeName = sdr[_DBTypeName].ToString();
TrainFBQuesType quesType = new TrainFBQuesType(queTypeID, typeName);
TrainFBQuestion questioon = new TrainFBQuestion(queID, quesDescription, quesType, null);
questioon.FBItems = GetFBItemsByQuesId(queID);
questions.Add(questioon);
}
return(questions);
}
}
public void InitPresenter(bool isPostBack)
{
AttachViewEvent();
_View.ResultMessage = string.Empty;
_View.OperationType = TrainFBQuesAndItemUtility._UpdateOperationTitle;
_View.SetFormReadOnly = false;
if (!isPostBack)
{
_View.FBQuestionMessage = string.Empty;
_View.FBQuesTypeMessage = string.Empty;
_View.TrainFBQuesTypeSource = _ITrainFacade.GetTrainFBQuesTypeByCondition(-1, string.Empty);
TrainFBQuestion trainFBQuestion = _ITrainFacade.GetFBQuestionByID(_FBQuestionID);
_View.FBQuestion = trainFBQuestion.Description;
_View.TrainFBQuesType = Convert.ToString(trainFBQuestion.TrainFBQuesType.ParameterID);
if (trainFBQuestion.FBItems.Count != 0)
{
_View.FBItemList = trainFBQuestion.FBItems;
}
else
{
_View.FBItemList = TrainFBQuesAndItemUtility.AddNullItem(new List <TrainFBItem>());
}
}
}
public void AddTrainFBQuestion(TrainFBQuestion fbquestion)
{
AddTrainFBQuestion addTrainFBQuestion = new AddTrainFBQuestion(fbquestion);
addTrainFBQuestion.Excute();
}
public DeleteTrainFBQuestion(TrainFBQuestion fbquestion)
{
_TrainFBQuesiton = fbquestion;
}
public UpdateTrainFBQuestion(TrainFBQuestion fbquestion, IFBQuestion dalFBQuestion)
{
_TrainFBQuesiton = fbquestion;
_DalFBQuestion = dalFBQuestion;
}
public UpdateTrainFBQuestion(TrainFBQuestion fbquestion)
{
_TrainFBQuesiton = fbquestion;
}
public void DeleteTrainFBQuestion(TrainFBQuestion fbquestion)
{
DeleteTrainFBQuestion deleteTrainFBQuestion = new DeleteTrainFBQuestion(fbquestion);
deleteTrainFBQuestion.Excute();
}
public void UpdateTrainFBQuestion(TrainFBQuestion fbquestion)
{
UpdateTrainFBQuestion updateTrainFBQuestion = new UpdateTrainFBQuestion(fbquestion);
updateTrainFBQuestion.Excute();
}
public AddTrainFBQuestion(TrainFBQuestion fbquestion)
{
_TrainFBQuesiton = fbquestion;
}
