示例#1
0
        public string create(childCreate use)
        {
            Guid childId = Guid.NewGuid();

            try
            {
                SqlConnection con = new SqlConnection(data);
                SqlCommand    cmd = new SqlCommand("INSERT INTO courseChild (childId, parentId, name, creator) VALUES (@childId, @parentId, @name, @creator)", con);
                cmd.Parameters.AddWithValue("@childId", childId);
                cmd.Parameters.AddWithValue("@parentId", use.parentId);
                cmd.Parameters.AddWithValue("@name", use.name);
                cmd.Parameters.AddWithValue("@creator", use.userId);

                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();

                createOptions(childId, use.userId);
            }
            catch (SqlException ex)
            {
                return(ex.ToString());
            }
            catch (Exception ex)
            {
                return("ErrorChild : " + ex.ToString());
            }

            return(childId.ToString());
        }
示例#2
0
        public string createString(string parentId, string name, string user)
        {
            if (parentId.Length <= 0 || parentId == null)
            {
                return("parentNull");
            }
            if (name.Length <= 0 || name == null)
            {
                return("nameNull");
            }
            if (user.Length <= 0 || user == null)
            {
                return("userNull");
            }

            string childId = "ErrorInChild";

            try
            {
                childCreate creator = new childCreate();
                creator.parentId = new Guid(parentId);
                creator.name     = name;
                creator.userId   = new Guid(user);
                childId          = create(creator);
            }
            catch (Exception ex)
            {
                return("ErrorChildString : " + ex.ToString());
            }

            return(childId);
        }