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