/// <summary> /// 添加一项工作量统计项 /// </summary> /// <param name="norm"></param> public void AddNorm(Norm norm) { try { string sql = "INSERT INTO [USTA].[dbo].[usta_Norm]([name],[parentId],[comment],[type],[year]) VALUES(@name,@parentId,@comment,@type,@year)"; SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar,50), new SqlParameter("@parentId", SqlDbType.Int), new SqlParameter("@comment", SqlDbType.NVarChar,1024), new SqlParameter("@type", SqlDbType.Int), new SqlParameter("@year", SqlDbType.NVarChar,10) }; parameters[0].Value = norm.name; parameters[1].Value = norm.parentId; parameters[2].Value = norm.comment; parameters[3].Value = norm.type; parameters[4].Value = norm.year; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { Norm norm = new Norm(); norm.normId = Convert.ToInt32(hidNormId.Value); norm.name = TextNormName.Text; norm.comment = TextComment.Text; norm.parentId = Convert.ToInt32(hidParentId.Value); norm.type = Convert.ToInt32(ddltNormType.SelectedValue); DalOperationNorm dalOperationNorm = new DalOperationNorm(); dalOperationNorm.EditNorm(norm); Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page); }
protected void btnSubmit_Click(object sender, EventArgs e) { DalOperationNorm dalOperationNorm = new DalOperationNorm(); Norm norm = new Norm(); norm.name = TextNormName.Text.Trim(); norm.comment = TextComment.Text.Trim(); norm.type = int.Parse(ddltNormType.SelectedValue); //if (parentId.Value != null && parentId.Value != "") //{ // norm.parentId = Convert.ToInt32(parentId.Value); //} //else //{ // norm.parentId = 0; //} if (Request["parentId"] == null || Request["parentId"]=="") { norm.parentId = 0; } else { norm.parentId = Convert.ToInt32(Request["parentId"]); } if (Request["year"] != null && !Request["year"].Trim().Equals("")) { norm.year = Request["year"].Trim(); if (norm.parentId == -1) { if ("课程名称".Equals(norm.name) || "学期".Equals(norm.name) || "类型".Equals(norm.name) || "理论课时".Equals(norm.name) || "实验课时".Equals(norm.name)) { Javascript.Alert("此指标名称在硕士教学中已经存在,不能重复添加!", Page); return; } } if (dalOperationNorm.ExistNormName(TextNormName.Text.Trim(),norm.parentId , norm.year)) { Javascript.Alert("存在此指标名称,不能重复输入", Page); return; } dalOperationNorm.AddNorm(norm); Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page); } else { Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2", Page); } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Norm getNormById(int id) { Norm norm = null; SqlParameter[] parameters = { new SqlParameter("@normId",id)}; string sql = "SELECT [normId],[name],[parentId],[comment],type,year FROM [USTA].[dbo].[usta_Norm] where normId = @normId"; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql, parameters); if (dr.Read()) { norm = new Norm(); norm.normId = Convert.ToInt32( dr["normId"].ToString()); norm.name = dr["name"].ToString(); norm.comment = dr["comment"].ToString(); norm.parentId = Convert.ToInt32(dr["parentId"].ToString()); norm.type = Convert.ToInt32(dr["type"].ToString()); norm.year = dr["year"].ToString(); } dr.Close(); conn.Close(); return norm; }
/// <summary> /// /// </summary> /// <param name="norm"></param> public void EditNorm(Norm norm) { try { string sql = "UPDATE [USTA].[dbo].[usta_Norm] SET [name] = @name,[parentId] = @parentId ,[comment] =@comment,[type]=@type WHERE normId = @normId"; SqlParameter[] parameters = { new SqlParameter("@normId", SqlDbType.Int), new SqlParameter("@name", SqlDbType.NVarChar,50), new SqlParameter("@parentId", SqlDbType.Int), new SqlParameter("@comment", SqlDbType.NVarChar,1024), new SqlParameter("@type", SqlDbType.Int), new SqlParameter("@year", SqlDbType.NVarChar,10) }; parameters[0].Value = norm.normId; parameters[1].Value = norm.name; parameters[2].Value = norm.parentId; parameters[3].Value = norm.comment; parameters[4].Value = norm.type; parameters[5].Value = norm.year; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }