protected void btnCommit_Click(object sender, EventArgs e) { DalOperationNorm daln = new DalOperationNorm(); NormConfirm ncom = new NormConfirm { teacherNo = Request["teacherNo"].Trim(), term = Request["term"].Trim(), question = txtproblem.Text, type = 1, value = Request["value"].Trim(), answer = "" }; daln.AddNormConfirm(ncom); Javascript.RefreshParentWindow("/Teacher/NormView.aspx", Page); }
/// <summary> /// /// </summary> /// <param name="normConfirm"></param> public void AddNormConfirm(NormConfirm normConfirm) { try { string sql = "INSERT INTO [USTA].[dbo].[usta_NormConfirm]([term],[teacherNo],[question],[answer],value,type) VALUES(@term ,@teacherNo,@question,@answer,@value,@type)"; SqlParameter[] parameters = { new SqlParameter("@term",normConfirm.term), new SqlParameter("@teacherNo",normConfirm.teacherNo), new SqlParameter("@question",normConfirm.question), new SqlParameter("@answer",normConfirm.answer), new SqlParameter("@value",normConfirm.value), new SqlParameter("@type",normConfirm.type)}; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception e) { MongoDBLog.LogRecord(e); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// /// </summary> /// <param name="normConfirm"></param> public void UpdataNormConfirm(NormConfirm normConfirm) { try { if (GetNormConfirm(normConfirm.term, normConfirm.teacherNo) != null) return; string sql = "UPDATE [USTA].[dbo].[usta_NormConfirm] SET [term] = @term,[teacherNo] = @teacherNo,[question] = @question,[answer] = @answer,[value] = @value ,[type] = @type WHERE id=@id"; SqlParameter[] parameters = { new SqlParameter("@id",normConfirm.id), new SqlParameter("@term",normConfirm.term), new SqlParameter("@teacherNo",normConfirm.teacherNo), new SqlParameter("@question",normConfirm.question), new SqlParameter("@answer",normConfirm.answer), new SqlParameter("@value",normConfirm.value), new SqlParameter("@type",normConfirm.type)}; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception e) { MongoDBLog.LogRecord(e); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public NormConfirm GetNormConfirm(int id) { NormConfirm normConfirm = null; string sql = "SELECT [id],[term],[teacherNo],[question],[answer],[value],[type],[isDelete],[createTime] FROM [USTA].[dbo].[usta_NormConfirm] WHERE id=@id and isDelete =0"; SqlParameter[] parameters = { new SqlParameter("@id",id)}; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql, parameters); if (dr.Read()) { normConfirm = new NormConfirm { id=int.Parse(dr["id"].ToString().Trim()), term=dr["term"].ToString().Trim(), teacherNo = dr["teacherNo"].ToString().Trim(), question = dr["question"].ToString().Trim(), answer = dr["answer"].ToString().Trim(), value = dr["value"].ToString().Trim(), isDelete = 0, type = int.Parse(dr["type"].ToString()), createTime = DateTime.Parse(dr["createTime"].ToString()) }; } dr.Close(); conn.Close(); return normConfirm; }
protected void btnConfirm_Click(object sender, EventArgs e) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); DalOperationNorm dalOperationNorm = new DalOperationNorm(); NormConfirm nc = new NormConfirm{ term=term, teacherNo = UserCookiesInfo.userNo, question="OK", answer="", value = GetNormValue(0), type = 0, }; dalOperationNorm.AddNormConfirm(nc); Javascript.JavaScriptLocationHref("/Teacher/NormView.aspx", Page); }