示例#1
0
 /// <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();
     }
 }
示例#2
0
 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);
 }
示例#3
0
        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);
            }
        }
示例#4
0
        /// <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;
        }
示例#5
0
 /// <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();
     }
 }