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; }