Exemplo n.º 1
0
        public void dg_OnItemCommand(object sender, DataGridCommandEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
            {
                if (e.CommandName == "recommand")
                {
                    int hairEngineerID = int.Parse(this.dg.DataKeys[e.Item.ItemIndex].ToString());

                    string redirectUrl = "HairEngineerRecommandUpdate.aspx?hairEngineerID="+hairEngineerID.ToString()+"&hairEngineerRecommandID=0&operateType="+Convert.ToInt32(UserAction.Create).ToString();

                    this.Response.Redirect(redirectUrl);
                }
                if (e.CommandName == "delete")
                {
                    int hairEngineerID = int.Parse(this.dg.DataKeys[e.Item.ItemIndex].ToString());

                    HairEngineer he = ProviderFactory.GetHairEngineerDataProviderInstance().GetHairEngineerByHairEngineerID(hairEngineerID);

                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "delete from HairEngineerRecommand where HairEngineerRawID=" + hairEngineerID.ToString();
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.CommandText = commString;
                            comm.Connection = conn;
                            conn.Open();

                            try
                            {
                                comm.ExecuteNonQuery();
                            }
                            catch
                            {

                            }
                        }
                    }

                    //tag逻辑
                    //先处理TAG逻辑,先删除HS所对应的所有TAG
                    if (he.HairEngineerTagIDs != string.Empty)
                    {
                        string[] tempTagC = he.HairEngineerTagIDs.Split(",".ToCharArray());
                        if (tempTagC[0] != string.Empty)
                        {
                            for (int k = 0; k < tempTagC.Length; k++)
                            {
                                HairEngineerTag hst = new HairEngineerTag();
                                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                                {
                                    string commString = "select * from HairEngineerTag where HairEngineerTagID=" + tempTagC[k];
                                    using (SqlCommand comm = new SqlCommand())
                                    {
                                        comm.CommandText = commString;
                                        comm.Connection = conn;
                                        conn.Open();
                                        using (SqlDataReader sdr = comm.ExecuteReader())
                                        {
                                            if (sdr.Read())
                                            {
                                                try
                                                {
                                                    hst.TagID = int.Parse(sdr["HairEngineerTagID"].ToString());
                                                    hst.TagName = sdr["HairEngineerTagName"].ToString();
                                                    hst.HairEngineerIDs = sdr["HairEngineerIDs"].ToString();
                                                }
                                                catch
                                                { }
                                            }
                                        }
                                    }
                                }
                                string[] tempHairEngineerIDC = hst.HairEngineerIDs.Split(",".ToCharArray());
                                string hairEngineerIDs = "";

                                int tempNum = 0;
                                for (int i = 0; i < tempHairEngineerIDC.Length; i++)
                                {
                                    if (tempHairEngineerIDC[i] != he.HairEngineerID.ToString())
                                    {
                                        tempNum++;
                                        if (tempNum == 1)
                                        {
                                            hairEngineerIDs = tempHairEngineerIDC[i];
                                        }
                                        else
                                        {
                                            hairEngineerIDs += "," + tempHairEngineerIDC[i];
                                        }
                                    }
                                }
                                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                                {
                                    string commString = "update HairEngineerTag set HairEngineerIDs='" + hairEngineerIDs + "' where HairEngineerTagID=" + hst.TagID.ToString();
                                    using (SqlCommand comm = new SqlCommand())
                                    {
                                        comm.CommandText = commString;
                                        comm.Connection = conn;
                                        conn.Open();
                                        try
                                        {
                                            comm.ExecuteNonQuery();
                                        }
                                        catch
                                        { }
                                    }
                                }
                            }
                        }
                    }
                    //

                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "update HairShop set HairShopEngineerNum = HairShopEngineerNum-1 where HairShopID=" + he.HairShopID.ToString();
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.CommandText = commString;
                            comm.Connection = conn;
                            conn.Open();
                            try
                            {
                                comm.ExecuteNonQuery();
                            }
                            catch (Exception ex)
                            {
                                throw new Exception(ex.Message);
                            }
                        }
                    }

                    if (InfoAdmin.DeleteHairEngineer(hairEngineerID))
                    {
                        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                        {
                            string commString = "select * from HairStyle where hairEngineerID=" + hairEngineerID.ToString();
                            using (SqlCommand comm = new SqlCommand())
                            {
                                comm.CommandText = commString;
                                comm.Connection = conn;
                                conn.Open();

                                using (SqlDataReader sdr = comm.ExecuteReader())
                                {
                                    while (sdr.Read())
                                    {
                                        string hid = sdr["ID"].ToString();

                                        this.deleteHairStyle(int.Parse(hid));

                                        using (SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                                        {
                                            string commString2 = "delete from picturestoreset where picturestoreid=" + hid;
                                            using (SqlCommand comm2 = new SqlCommand())
                                            {
                                                comm2.CommandText = commString2;
                                                comm2.Connection = conn2;
                                                conn2.Open();

                                                try
                                                {
                                                    comm2.ExecuteNonQuery();
                                                }
                                                catch
                                                {

                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }

                        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                        {
                            string commString = "delete from enginpics where ownerid=" + hairEngineerID.ToString();
                            using (SqlCommand comm = new SqlCommand())
                            {
                                comm.CommandText = commString;
                                comm.Connection = conn;
                                conn.Open();

                                try
                                {
                                    comm.ExecuteNonQuery();
                                }
                                catch
                                {

                                }
                            }
                        }

                        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                        {
                            string commString = "delete from HairEngineerRecommand where HairEngineerRawID=" + hairEngineerID.ToString();
                            using (SqlCommand comm = new SqlCommand())
                            {
                                comm.CommandText = commString;
                                comm.Connection = conn;
                                conn.Open();

                                try
                                {
                                    comm.ExecuteNonQuery();
                                }
                                catch
                                {

                                }
                            }
                        }

                        StringHelper.AlertInfo("删除成功",this.Page);
                        this.Response.Redirect("HairEngineerAdmin.aspx");
                    }
                    else
                    {
                        StringHelper.AlertInfo("删除失败", this.Page);
                    }
                }
            }
        }
        /// <summary>
        /// ��ȡ����ʦTAG�б�
        /// </summary>
        /// <param name="count"></param>
        /// <returns></returns>
        public List<HairEngineerTag> GetHairEngineerTags(int count)
        {
            List<HairEngineerTag> list = new List<HairEngineerTag>();

            string commText = "";
            switch (count)
            {
                case 0:
                    commText = "select * from HairEngineerTag Order by HairEngineerTagID desc";
                    break;
                default:
                    commText = "select top "+count.ToString()+" * from HairEngineerTag order by HairEngineerTagID desc";
                    break;
            }

            using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
            {
                {
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.Connection = conn;
                        comm.CommandText = commText;
                        conn.Open();

                        using (SqlDataReader sdr = comm.ExecuteReader())
                        {
                            while (sdr.Read())
                            {
                                HairEngineerTag hairEngineerTag = new HairEngineerTag();

                                hairEngineerTag.HairEngineerIDs = sdr["HairEngineerIDs"].ToString();
                                hairEngineerTag.TagID = int.Parse(sdr["HairEngineerTagID"].ToString());
                                hairEngineerTag.TagName = sdr["HairEngineerTagName"].ToString();

                                list.Add(hairEngineerTag);
                            }
                        }
                    }
                }
            }

            return list;
        }
        /// <summary>
        /// �������ʦTAGʵ��
        /// </summary>
        /// <param name="hairEngineerTagID"></param>
        /// <returns></returns>
        public HairEngineerTag GetHairEngineerTagByHairEngineerTagID(int hairEngineerTagID)
        {
            HairEngineerTag hairEngineerTag = new HairEngineerTag();

            string commText = "select * from HairEngineerTag where HairEngineerTagID = " + hairEngineerTagID.ToString();

            using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
            {
                {
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.Connection = conn;
                        comm.CommandText = commText;
                        conn.Open();

                        using (SqlDataReader sdr = comm.ExecuteReader())
                        {
                            while (sdr.Read())
                            {
                                hairEngineerTag.HairEngineerIDs = sdr["HairEngineerIDs"].ToString();
                                hairEngineerTag.TagID = int.Parse(sdr["HairEngineerTagID"].ToString());
                                hairEngineerTag.TagName = sdr["HairEngineerTagName"].ToString();
                            }
                        }
                    }
                }
            }

            return hairEngineerTag;
        }
        /// <summary>
        /// ����ʦTAG ��ӣ�ɾ�����޸�
        /// </summary>
        /// <param name="hairEngineerTag"></param>
        /// <param name="ua"></param>
        /// <returns></returns>
        public bool HairEngineerTagCreateDeleteUpdate(HairEngineerTag hairEngineerTag, UserAction ua)
        {
            bool result = false;

            string commandText = string.Empty;
            switch (ua)
            {
                case UserAction.Create:
                    commandText = "insert into HairEngineerTag(HairEngineerTagName,HairEngineerIDs) values('"+hairEngineerTag.TagName+"','"+hairEngineerTag.HairEngineerIDs+"')";
                    break;
                case UserAction.Delete:
                    commandText = "delete from HairEngineerTag where HairEngineerTagID="+hairEngineerTag.TagID.ToString();
                    break;
                case UserAction.Update:
                    commandText = "update HairEngineerTag set HairEngineerTagName = '"+hairEngineerTag.TagName+"',HairEngineerIDs='"+hairEngineerTag.HairEngineerIDs+"' where HairEngineerTagID="+hairEngineerTag.TagID.ToString();
                    break;
            }
            using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
            {
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.CommandText = commandText;
                    comm.Connection = conn;
                    conn.Open();
                    try
                    {
                        comm.ExecuteNonQuery();
                        result = true;
                    }
                    catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }

                }
            }

            return result;
        }
Exemplo n.º 5
0
        protected void btnHairEngineerAdd_Click(object sender, EventArgs e)
        {
            if (this.txtHairEngineerTag.Text.Trim() != string.Empty)
            {
                string[] tagCondition = this.txtHairEngineerTag.Text.Split(",".ToCharArray());
                this.lblRedInfo.Visible = false;

                for (int k = 0; k < tagCondition.Length; k++)
                {
                    if (tagCondition[k] == string.Empty)
                    {
                        this.lblRedInfo.Text = "TAG格式不正确(正确的格式&nbsp;&nbsp; 1,2,3)";
                        this.lblRedInfo.Visible = true;
                        return;
                    }
                }
            }

            HairEngineer he = new HairEngineer();
            he.HairEngineerName = txtHairEngineerName.Text.Trim();
            //he.HairEngineerAge = txtHairEngineerAge.Text.Trim();
            he.HairEngineerSex = int.Parse(rBtnListHairEngineerSex.SelectedValue);
            he.HairEngineerTel = txtHairEngineerTel.Text.Trim();
            he.HairEngineerRawPrice = txtHairEngineerRawPrice.Text.Trim();
            he.HairEngineerYear = txtHairEngineerYear.Text.Trim();
            he.HairEngineerSkill = txtHairEngineerSkill.Text.Trim();
            he.HairEngineerDescription = txtHairEngineerDescription.Text.Trim();
            he.HairEngineerConstellation = this.ddlConstellation.SelectedItem.Text;
            he.HairEngineerClassID = txtHairEngineerClass.Text.Trim();
            he.HairEngineerClassName = txtHairEngineerClass.Text.Trim();
            he.HairShopID = int.Parse(ddlHairShop.SelectedValue);
            he.HairShopName = ddlHairShop.SelectedItem.Text;
            he.IsImportant = this.chkIsImportant.Checked;

            UpLoadClass upload = new UpLoadClass();
            //he.HairEngineerPhoto = upload.UpLoadImg(fileLogo, "/uploadfiles/pictures/");

            he.HairEngineerTagIDs = "";

            int id = InfoAdmin.AddHairEngineer(he);
            he.HairEngineerID = id;
               string content=buildBBSContent(he);
            int postId = 0;
            BBSPost post = new BBSPost();
            bool bSuc = post.AddPost(he.HairEngineerName, content, BBSPost.Category.HairEngineer, out postId);
            he.PostId = postId;
            if (bSuc)
            {
                //update postid
                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "update HairEngineer set postid=" + he.PostId.ToString() + " where HairEngineerID=" + he.HairEngineerID.ToString();
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();
                        try
                        {
                            comm.ExecuteNonQuery();
                        }
                        catch (Exception ex)
                        {
                            throw new Exception(ex.Message);
                        }
                    }
                }
            }

            Session["HairEngineerInfo"] = he;
            if (txtHairEngineerTag.Text.Trim() != string.Empty)
            {
                //TAG逻辑
                string tagIDs = "";
                string[] tagCollection = txtHairEngineerTag.Text.Split(",".ToCharArray());
                for (int k = 0; k < tagCollection.Length; k++)
                {
                    string tagID = "";
                    bool isExist = false;
                    HairEngineerTag hst = new HairEngineerTag();
                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "select * from HairEngineerTag where HairEngineerTagName='" + tagCollection[k] + "'";
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.CommandText = commString;
                            comm.Connection = conn;
                            conn.Open();
                            using (SqlDataReader sdr = comm.ExecuteReader())
                            {
                                if (sdr.Read())
                                {
                                    try
                                    {
                                        hst.TagID = int.Parse(sdr["HairEngineerTagID"].ToString());
                                        hst.TagName = sdr["HairEngineerTagName"].ToString();
                                        hst.HairEngineerIDs = sdr["HairEngineerIDs"].ToString();
                                    }
                                    catch
                                    { }
                                }
                            }
                        }
                    }
                    if (hst.TagID == 0)
                    {
                        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                        {
                            string commString = "insert HairEngineerTag(HairEngineerTagName,HairEngineerIDs) values('" + tagCollection[k] + "','" + id.ToString() + "');select @@identity;";
                            using (SqlCommand comm = new SqlCommand())
                            {
                                comm.CommandText = commString;
                                comm.Connection = conn;
                                conn.Open();

                                tagID = comm.ExecuteScalar().ToString();
                            }
                        }
                    }
                    else
                    {
                        tagID = hst.TagID.ToString();
                        if (hst.HairEngineerIDs == string.Empty)
                        {
                            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                            {
                                string commString = "update HairEngineerTag set HairEngineerIDs='" + id.ToString() + "' where HairEngineerTagID=" + hst.TagID.ToString();
                                using (SqlCommand comm = new SqlCommand())
                                {
                                    comm.CommandText = commString;
                                    comm.Connection = conn;
                                    conn.Open();
                                    try
                                    {
                                        comm.ExecuteNonQuery();
                                    }
                                    catch
                                    { }
                                }
                            }
                        }
                        else
                        {
                            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                            {
                                string commString = "update HairEngineerTag set HairEngineerIDs=HairEngineerIDs+'," + id.ToString() + "' where HairEngineerTagID=" + hst.TagID.ToString();
                                using (SqlCommand comm = new SqlCommand())
                                {
                                    comm.CommandText = commString;
                                    comm.Connection = conn;
                                    conn.Open();
                                    try
                                    {
                                        comm.ExecuteNonQuery();
                                    }
                                    catch
                                    { }
                                }
                            }
                        }
                    }
                    if (k == 0)
                    {
                        tagIDs = tagID;
                    }
                    else
                    {
                        tagIDs += "," + tagID;
                    }
                }
                he.HairEngineerTagIDs = tagIDs;
                he.HairEngineerID = id;
                ProviderFactory.GetHairEngineerDataProviderInstance().HairEngineerCreateDeleteUpdate(he, UserAction.Update, out id);
            }
            id = he.HairEngineerID;

            //个人图片逻辑
            string photoIDs = "";
            string[] photoSmallString = lblpicsmallString.Text.Split(";".ToCharArray());
            string[] photoString = lblpicSring.Text.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

            for(int k=0;k<photoString.Length;k++)
            {
                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "insert into enginpics(picurl,picsmallurl,ownerid,classid) values('" + photoString[k] + "','"+photoSmallString[k]+"'," + id.ToString() + ",1);select @@identity;";
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();
                        try
                        {
                            photoIDs += "," + comm.ExecuteScalar().ToString();
                        }
                        catch (Exception ex)
                        {
                            throw new Exception(ex.Message);
                        }
                    }
                }
            }
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
            {
                string commString = "update HairEngineer set HairEngineerPhotoIDs = '"+photoIDs+"' where HairEngineerID=" + id.ToString();
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.CommandText = commString;
                    comm.Connection = conn;
                    conn.Open();
                    try
                    {
                        comm.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
            }
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
            {
                string commString = "update HairShop set HairShopEngineerNum = HairShopEngineerNum+1 where HairShopID="+he.HairShopID.ToString();
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.CommandText = commString;
                    comm.Connection = conn;
                    conn.Open();
                    try
                    {
                        comm.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
            }
            ResetControlState();

            this.Response.Redirect("HairEngineerAddSwitch.aspx?id="+id.ToString()+"&shopid="+this.ddlHairShop.SelectedItem.Value);
        }
Exemplo n.º 6
0
        public void deleteHairEngineer(int heid)
        {
            int hairEngineerID = heid;

            HairEngineer he = ProviderFactory.GetHairEngineerDataProviderInstance().GetHairEngineerByHairEngineerID(hairEngineerID);

            //tag逻辑
            //先处理TAG逻辑,先删除HS所对应的所有TAG
            if (he.HairEngineerTagIDs != string.Empty)
            {
                string[] tempTagC = he.HairEngineerTagIDs.Split(",".ToCharArray());
                for (int k = 0; k < tempTagC.Length; k++)
                {
                    HairEngineerTag hst = new HairEngineerTag();
                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "select * from HairEngineerTag where HairEngineerTagID=" + tempTagC[k];
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.CommandText = commString;
                            comm.Connection = conn;
                            conn.Open();
                            using (SqlDataReader sdr = comm.ExecuteReader())
                            {
                                if (sdr.Read())
                                {
                                    try
                                    {
                                        hst.TagID = int.Parse(sdr["HairEngineerTagID"].ToString());
                                        hst.TagName = sdr["HairEngineerTagName"].ToString();
                                        hst.HairEngineerIDs = sdr["HairEngineerIDs"].ToString();
                                    }
                                    catch
                                    { }
                                }
                            }
                        }
                    }
                    string[] tempHairEngineerIDC = hst.HairEngineerIDs.Split(",".ToCharArray());
                    string hairEngineerIDs = "";

                    int tempNum = 0;
                    for (int i = 0; i < tempHairEngineerIDC.Length; i++)
                    {
                        if (tempHairEngineerIDC[i] != he.HairEngineerID.ToString())
                        {
                            tempNum++;
                            if (tempNum == 1)
                            {
                                hairEngineerIDs = tempHairEngineerIDC[i];
                            }
                            else
                            {
                                hairEngineerIDs += "," + tempHairEngineerIDC[i];
                            }
                        }
                    }
                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "update HairEngineerTag set HairEngineerIDs='" + hairEngineerIDs + "' where HairEngineerTagID=" + hst.TagID.ToString();
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.CommandText = commString;
                            comm.Connection = conn;
                            conn.Open();
                            try
                            {
                                comm.ExecuteNonQuery();
                            }
                            catch
                            { }
                        }
                    }
                }
            }
            //

            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
            {
                string commString = "update HairShop set HairShopEngineerNum = HairShopEngineerNum-1 where HairShopID=" + he.HairShopID.ToString();
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.CommandText = commString;
                    comm.Connection = conn;
                    conn.Open();
                    try
                    {
                        comm.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
            }

            if (InfoAdmin.DeleteHairEngineer(hairEngineerID))
            {
                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "select * from HairStyle where hairEngineerID=" + hairEngineerID.ToString();
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();

                        using (SqlDataReader sdr = comm.ExecuteReader())
                        {
                            while (sdr.Read())
                            {
                                string hid = sdr["ID"].ToString();

                                this.deleteHairStyle(int.Parse(hid));

                                using (SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                                {
                                    string commString2 = "delete from picturestoreset where picturestoreid=" + hid;
                                    using (SqlCommand comm2 = new SqlCommand())
                                    {
                                        comm2.CommandText = commString2;
                                        comm2.Connection = conn2;
                                        conn2.Open();

                                        try
                                        {
                                            comm2.ExecuteNonQuery();
                                        }
                                        catch
                                        {

                                        }
                                    }
                                }
                            }
                        }
                    }
                }

                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "delete from enginpics where ownerid=" + hairEngineerID.ToString();
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();

                        try
                        {
                            comm.ExecuteNonQuery();
                        }
                        catch
                        {

                        }
                    }
                }

                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "delete from HairEngineerRecommand where HairEngineerRawID=" + hairEngineerID.ToString();
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();

                        try
                        {
                            comm.ExecuteNonQuery();
                        }
                        catch
                        {

                        }
                    }
                }
            }
            else
            {
                StringHelper.AlertInfo("删除失败", this.Page);
            }
        }