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