protected void btnInput_Click(object sender, EventArgs e) { if (lbType.SelectedIndex < 0) { SessionSet.PageMessage = "请先选题型!"; return; } string strId = Request.QueryString.Get("id"); PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); PaperStrategySubject paperStrategySubject = new PaperStrategySubject(); paperStrategySubject.PaperStrategyId = int.Parse(strId); paperStrategySubject.PaperStrategySubjectId = Grid1.Rows.Count + 1; paperStrategySubject.ItemTypeId = int.Parse(lbType.SelectedValue); paperStrategySubject.TypeName = lbType.SelectedItem.Text; paperStrategySubject.SubjectName = lbType.SelectedItem.Text; paperStrategySubject.UnitScore = 0; paperStrategySubject.TotalScore = 0; paperStrategySubject.Memo = ""; paperStrategySubject.ItemCount = 0; paperStrategySubject.OrderIndex = 0; paperStrategySubject.Remark = ""; paperStrategySubjectBLL.AddPaperStrategySubject(paperStrategySubject); Grid1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strID = Request.QueryString.Get("id"); ViewState["mode"] = Request.QueryString.Get("mode"); if (ViewState["mode"].ToString() == "Insert") { if (!string.IsNullOrEmpty(strID)) { PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); PaperStrategySubject paperStrategySubject = paperStrategySubjectBLL.GetPaperStrategySubject(int.Parse(strID)); if (paperStrategySubject != null) { txtSubjectName.Text = paperStrategySubject.SubjectName; txtScore.Text = paperStrategySubject.UnitScore.ToString(); ddlType.SelectedValue = paperStrategySubject.ItemTypeId.ToString(); labelTotalCount.Text = paperStrategySubject.ItemCount.ToString(); } hfSubjectId.Value = strID; } } else { FillPage(int.Parse(strID)); } } }
public PaperStrategySubject GetPaperStrategySubject(int PaperStrategySubjectId) { PaperStrategySubject Paper; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_PAPER_STRATEGY_SUBJECT_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_PAPER_STRATEGY_SUBJECT_ID", DbType.Int32, PaperStrategySubjectId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { Paper = SubjectNamelObject(dataReader); } else { Paper = new PaperStrategySubject(); } } return(Paper); }
private void FillPage(int nID) { PaperStrategyBookChapterBLL paperStrategyBookChapterBLL = new PaperStrategyBookChapterBLL(); PaperStrategyBookChapter paperStrategyBookChapter = paperStrategyBookChapterBLL.GetPaperStrategyBookChapter(nID); if (paperStrategyBookChapter != null) { txtMemo.Text = paperStrategyBookChapter.Memo; txtChapterName.Text = paperStrategyBookChapter.RangeName; HfRangeName.Value = paperStrategyBookChapter.RangeName; txtSubjectName.Text = paperStrategyBookChapter.SubjectName; txtExCludeChapters.Text = paperStrategyBookChapter.ExcludeChapterId; if (string.IsNullOrEmpty(paperStrategyBookChapter.ExcludeChapterId) == false) { FillExcludeCategorysID(paperStrategyBookChapter.ExcludeChapterId); } txtNd1.Text = paperStrategyBookChapter.ItemDifficulty1Count.ToString(); txtNd2.Text = paperStrategyBookChapter.ItemDifficulty2Count.ToString(); txtNd3.Text = paperStrategyBookChapter.ItemDifficulty3Count.ToString(); txtNd4.Text = paperStrategyBookChapter.ItemDifficulty4Count.ToString(); txtNd5.Text = paperStrategyBookChapter.ItemDifficulty5Count.ToString(); txtNDR.Text = paperStrategyBookChapter.ItemDifficultyRandomCount.ToString(); txtScore.Text = paperStrategyBookChapter.UnitScore.ToString(); txtSeconds.Text = paperStrategyBookChapter.UnitLimitTime.ToString(); hfSubjectId.Value = paperStrategyBookChapter.StrategySubjectId.ToString(); HfRangeType.Value = paperStrategyBookChapter.RangeType.ToString(); HfChapterId.Value = paperStrategyBookChapter.RangeId.ToString(); ddlType.SelectedValue = paperStrategyBookChapter.ItemTypeId.ToString(); PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); PaperStrategySubject paperStrategySubject = paperStrategySubjectBLL.GetPaperStrategySubject(int.Parse(hfSubjectId.Value)); if (paperStrategySubject != null) { labelTotalCount.Text = paperStrategySubject.ItemCount.ToString(); } } if (ViewState["mode"].ToString() == "ReadOnly") { SaveButton.Visible = false; CancelButton.Visible = true; ddlType.Enabled = false; txtNDR.Enabled = false; txtNd1.Enabled = false; txtNd2.Enabled = false; txtNd3.Enabled = false; txtNd4.Enabled = false; txtNd5.Enabled = false; txtSeconds.Enabled = false; txtMemo.Enabled = false; } }
private void FillPage(int nID) { PaperStrategyItemCategoryBLL paperStrategyItemCategoryBLL = new PaperStrategyItemCategoryBLL(); PaperStrategyItemCategory paperStrategyItemCategory = paperStrategyItemCategoryBLL.GetPaperStrategyItemCategory(nID); if (paperStrategyItemCategory != null) { if (paperStrategyItemCategory.ExcludeCategorysId != null) { FillExcludeCategorysID(paperStrategyItemCategory.ExcludeCategorysId); } txtMemo.Text = paperStrategyItemCategory.Memo; txtItemCategoryName.Text = paperStrategyItemCategory.CategoryName; txtSubjectName.Text = paperStrategyItemCategory.SubjectName; hfExCludeItemCategoryIDS.Value = paperStrategyItemCategory.ExcludeCategorysId; txtNd1.Text = paperStrategyItemCategory.ItemDifficulty1Count.ToString(); txtNd2.Text = paperStrategyItemCategory.ItemDifficulty2Count.ToString(); txtNd3.Text = paperStrategyItemCategory.ItemDifficulty3Count.ToString(); txtNd4.Text = paperStrategyItemCategory.ItemDifficulty4Count.ToString(); txtNd5.Text = paperStrategyItemCategory.ItemDifficulty5Count.ToString(); txtNDR.Text = paperStrategyItemCategory.ItemDifficultyRandomCount.ToString(); txtScore.Text = paperStrategyItemCategory.UnitScore.ToString(); txtSeconds.Text = paperStrategyItemCategory.UnitLimitTime.ToString(); hfSubjectId.Value = paperStrategyItemCategory.StrategySubjectId.ToString(); hfItemCategoryID.Value = paperStrategyItemCategory.ItemCategoryId.ToString(); ddlType.SelectedValue = paperStrategyItemCategory.ItemTypeId.ToString(); PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); PaperStrategySubject paperStrategySubject = paperStrategySubjectBLL.GetPaperStrategySubject(int.Parse(hfSubjectId.Value)); if (paperStrategySubject != null) { labelTotalCount.Text = paperStrategySubject.ItemCount.ToString(); } } if (ViewState["mode"].ToString() == "ReadOnly") { SaveButton.Visible = false; CancelButton.Visible = true; ddlType.Enabled = false; txtNDR.Enabled = false; txtNd1.Enabled = false; txtNd2.Enabled = false; txtNd3.Enabled = false; txtNd4.Enabled = false; txtNd5.Enabled = false; txtSeconds.Enabled = false; txtMemo.Enabled = false; } }
protected void btnSaveAs_Click(object sender, EventArgs e) { int totalScore = 0; string strId = Request.QueryString.Get("id"); IList <PaperStrategySubject> paperStrategySubjects = new List <PaperStrategySubject>(); for (int i = 0; i < Grid1.Rows.Count; i++) { string strPaperStrategySubjectId = ((HiddenField)Grid1.Rows[i].FindControl("hfPaperStrategySubjectId")).Value; string strItemTypeId = ((HiddenField)Grid1.Rows[i].FindControl("hfItemTypeId")).Value; string strSubjectName = ((TextBox)Grid1.Rows[i].FindControl("txtSubjectName")).Text; string strUnitScore = ((TextBox)Grid1.Rows[i].FindControl("txtUnitScore")).Text; string strItemCount = ((TextBox)Grid1.Rows[i].FindControl("txtItemCount")).Text; if (strUnitScore == "") { strUnitScore = "0"; } if (strItemCount == "") { strItemCount = "0"; } totalScore += int.Parse(strUnitScore); PaperStrategySubject paperStrategySubject = new PaperStrategySubject(); paperStrategySubject.PaperStrategySubjectId = int.Parse(strPaperStrategySubjectId); paperStrategySubject.PaperStrategyId = int.Parse(strId); paperStrategySubject.ItemCount = int.Parse(strItemCount); paperStrategySubject.ItemTypeId = int.Parse(strItemTypeId); paperStrategySubject.OrderIndex = 0; paperStrategySubject.Remark = ""; paperStrategySubject.SubjectName = strSubjectName; paperStrategySubject.UnitScore = int.Parse(strUnitScore); paperStrategySubject.TotalScore = int.Parse(strUnitScore); paperStrategySubject.Memo = ""; paperStrategySubjects.Add(paperStrategySubject); } PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); paperStrategySubjectBLL.UpdatePaperStrategySubject(int.Parse(strId), totalScore, paperStrategySubjects); Grid1.DataBind(); }
public IList <PaperStrategySubject> GetPaperStrategySubjectByPaperStrategyId(int PaperStrategyId) { IList <PaperStrategySubject> Papers = new List <PaperStrategySubject>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_PAPER_STRATEGY_SUBJECT_Q"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_PAPER_STRATEGY_ID", DbType.Int32, PaperStrategyId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { PaperStrategySubject Paper = SubjectNamelObject(dataReader); Papers.Add(Paper); } } return(Papers); }
public void AddPaperStrategySubject(PaperStrategySubject Paper) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_PAPER_STRATEGY_SUBJECT_I"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_PAPER_STRATEGY_ID", DbType.Int32, Paper.PaperStrategyId); db.AddOutParameter(dbCommand, "p_PAPER_STRATEGY_SUBJECT_ID", DbType.Int32, Paper.PaperStrategySubjectId); db.AddInParameter(dbCommand, "p_Order_Index", DbType.String, Paper.OrderIndex); db.AddInParameter(dbCommand, "p_Item_Count", DbType.Int32, Paper.ItemCount); db.AddInParameter(dbCommand, "p_Item_Type_Id", DbType.Int32, Paper.ItemTypeId); db.AddInParameter(dbCommand, "p_Remark", DbType.String, Paper.Remark); db.AddInParameter(dbCommand, "p_Subject_Name", DbType.String, Paper.SubjectName); db.AddInParameter(dbCommand, "p_Total_Score", DbType.Decimal, Paper.TotalScore); db.AddInParameter(dbCommand, "p_Unit_Score", DbType.Decimal, Paper.UnitScore); db.AddInParameter(dbCommand, "p_memo", DbType.String, Paper.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); transaction.Commit(); } catch (System.SystemException ex) { transaction.Rollback(); throw ex; } connection.Close(); }
public void AddPaperStrategySubject(PaperStrategySubject PaperStrategySubject) { dal.AddPaperStrategySubject(PaperStrategySubject); }
protected void btnSaveAndNext_Click(object sender, EventArgs e) { string strId = Request.QueryString.Get("id"); string strMode = ViewState["mode"].ToString(); if (strMode != "ReadOnly") { if (Grid1.Rows.Count == 0) { SessionSet.PageMessage = "请选择大题!"; return; } int totalScore = 0; IList <PaperStrategySubject> paperStrategySubjects = new List <PaperStrategySubject>(); for (int i = 0; i < Grid1.Rows.Count; i++) { string strPaperStrategySubjectId = ((HiddenField)Grid1.Rows[i].FindControl("hfPaperStrategySubjectId")).Value; string strItemTypeId = ((HiddenField)Grid1.Rows[i].FindControl("hfItemTypeId")).Value; string strSubjectName = ((TextBox)Grid1.Rows[i].FindControl("txtSubjectName")).Text; string strUnitScore = ((TextBox)Grid1.Rows[i].FindControl("txtUnitScore")).Text; string strItemCount = ((TextBox)Grid1.Rows[i].FindControl("txtItemCount")).Text; if (strUnitScore == "") { strUnitScore = "0"; } if (strItemCount == "") { strItemCount = "0"; } totalScore += int.Parse(strUnitScore); PaperStrategySubject paperStrategySubject = new PaperStrategySubject(); paperStrategySubject.PaperStrategySubjectId = int.Parse(strPaperStrategySubjectId); paperStrategySubject.PaperStrategyId = int.Parse(strId); paperStrategySubject.ItemCount = int.Parse(strItemCount); paperStrategySubject.ItemTypeId = int.Parse(strItemTypeId); paperStrategySubject.OrderIndex = 0; paperStrategySubject.Remark = ""; paperStrategySubject.SubjectName = strSubjectName; paperStrategySubject.UnitScore = int.Parse(strUnitScore); paperStrategySubject.TotalScore = int.Parse(strUnitScore); paperStrategySubject.Memo = ""; paperStrategySubjects.Add(paperStrategySubject); } PaperStrategySubjectBLL paperStrategySubjectBLL = new PaperStrategySubjectBLL(); paperStrategySubjectBLL.UpdatePaperStrategySubject(int.Parse(strId), totalScore, paperStrategySubjects); } PaperStrategyBLL paperStrategyBLL = new PaperStrategyBLL(); RailExam.Model.PaperStrategy paperStrategy = paperStrategyBLL.GetPaperStrategy(int.Parse(strId)); if (paperStrategy.StrategyMode == 2) //按教材 { string strPaperID = Request.QueryString.Get("Paperid"); if (!string.IsNullOrEmpty(strPaperID)) { Response.Redirect("PaperStrategyEditThird.aspx?mode=" + strMode + "&id=" + strId + "&Paperid=" + strPaperID); } else { Response.Redirect("PaperStrategyEditThird.aspx?mode=" + strMode + "&id=" + strId); } } if (paperStrategy.StrategyMode == 3) //按试题辅助分类 { string strPaperID = Request.QueryString.Get("Paperid"); if (!string.IsNullOrEmpty(strPaperID)) { Response.Redirect("PaperStrategyItemThird.aspx?mode=" + strMode + "&id=" + strId + "&Paperid=" + strPaperID); } else { Response.Redirect("PaperStrategyItemThird.aspx?mode=" + strMode + "&id=" + strId); } } }