Example #1
0
        public string buildBBSContent(HairStyleEntity hst)
        {
            StringBuilder cntBuilder = new StringBuilder();
            cntBuilder.AppendLine("[img]http://hair.sg.com.cn" + pic.Text.Replace(@"\", @"/") + "[/img]");//正面大图
            //cntBuilder.AppendLine("[img=90,120]" + lbl2Small.Text + "[/img]");//侧面小图
            //cntBuilder.AppendLine("[img=90,120]" + lbl3Small.Text + "[/img]");//背面小图
            //cntBuilder.AppendLine("发质:" + hst.HairNatrueName);
            //cntBuilder.AppendLine("发量:" + hst.HairQuantityName);
            //cntBuilder.AppendLine("脸型:" + hst.FaceStyleName);
            //cntBuilder.AppendLine("场合:" + hst.OccasionName);
            //cntBuilder.AppendLine("发型师:" + hst.HairEngineerName);
            //cntBuilder.AppendLine("美发厅:" + hst.HairShopName);
            //cntBuilder.AppendLine("发型解析:" + hst.Description);
            cntBuilder.AppendLine("原文:http://hair.sg.com.cn/HairLastPage.aspx?id=" + hst.ID.ToString() );

            return cntBuilder.ToString();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="engineerOpusInfo"></param>
        /// <param name="action"></param>
        public void HairStyleCreateDeleteUpdate(HairStyleEntity hairStyle, UserAction action,out int newid)
        {
            SqlParameter[] parameters = GetEngineerOpusParameters();

            parameters[0].Value = hairStyle.ID;
            parameters[1].Value = hairStyle.HairName;
            parameters[2].Value = hairStyle.HairStyle;
            parameters[3].Value = hairStyle.FaceStyle;
            parameters[4].Value = hairStyle.Temperament;
            parameters[5].Value = hairStyle.Occasion;
            parameters[6].Value = hairStyle.Sex;

            //parameters[7].Value = hairStyle.BigPic;
            //parameters[8].Value = hairStyle.SmallPic_F;
            //parameters[9].Value = hairStyle.SmallPic_B;
            //parameters[10].Value = hairStyle.SmallPic_S;
            //parameters[11].Value = hairStyle.Pic1;
            //parameters[12].Value = hairStyle.Pic2;
            //parameters[13].Value = hairStyle.Pic3;

            parameters[7].Value = hairStyle.HairShopID;
            parameters[8].Value = hairStyle.HairEngineerID;
            parameters[9].Value = hairStyle.HairQuantity;
            parameters[10].Value = hairStyle.HairNature;
            parameters[11].Value = hairStyle.HairColor;

            parameters[12].Value = hairStyle.CreateTime;
            parameters[13].Value = hairStyle.BBSURL;
            parameters[14].Value = hairStyle.Good;
            parameters[15].Value = hairStyle.Normal;
            parameters[16].Value = hairStyle.Bad;
            parameters[17].Value = hairStyle.Tag;
            parameters[18].Value = hairStyle.Description;
            parameters[19].Value = hairStyle.PictureStoreId;
            parameters[20].Value = hairStyle.PSGIDS;
            parameters[21].Value = hairStyle.IsHairStyle;
            parameters[22].Value = hairStyle.PostID;

            newid = 0;
            if (action == UserAction.Create)
            {
                string commString = "INSERT INTO HairStyle VALUES ('"+hairStyle.HairName+"',"+hairStyle.HairStyle.ToString()+","+hairStyle.FaceStyle.ToString()+","+hairStyle.Temperament.ToString()+","+hairStyle.Occasion.ToString()+","+hairStyle.Sex.ToString()+","+hairStyle.HairShopID.ToString()+","+hairStyle.HairEngineerID.ToString()+","+hairStyle.HairQuantity.ToString()+","+hairStyle.HairNature.ToString()+","+hairStyle.HairColor.ToString()+",'"+hairStyle.CreateTime.ToString()+"','"+hairStyle.BBSURL+"',"+hairStyle.Good.ToString()+","+hairStyle.Normal.ToString()+","+hairStyle.Bad.ToString()+",'"+hairStyle.Tag.ToString()+"',0,0,'"+hairStyle.Description+"',"+hairStyle.PictureStoreId.ToString()+",'"+hairStyle.PSGIDS+"',"+hairStyle.IsHairStyle.CompareTo(false).ToString()+","+hairStyle.PostID.ToString()+");select @@identity;";

                using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
                {
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.CommandText = commString;
                        comm.Connection = conn;
                        conn.Open();
                        try
                        {
                            try
                            {
                                newid = Convert.ToInt32(comm.ExecuteScalar());
                            }
                            catch (InvalidCastException)
                            {
                                newid = 0;
                            }
                        }
                        catch (Exception ex)
                        {
                            throw new Exception(ex.Message);
                        }

                    }
                }

            }
                //SqlHelper.ExecuteNonQuery(DataHelper2.SqlConnectionString, CommandType.StoredProcedure,
                //    "InsertHairStyle", parameters);

            if (action == UserAction.Update)
                SqlHelper.ExecuteNonQuery(DataHelper2.SqlConnectionString, CommandType.StoredProcedure,
                    "UpdateHairStyle", parameters);

            if (action == UserAction.Delete)
                SqlHelper.ExecuteNonQuery(DataHelper2.SqlConnectionString, CommandType.StoredProcedure,
                    "DeleteHairStyle", parameters[0]);
        }
Example #3
0
        protected void btnSubmit_OnClick(object sender,EventArgs e)
        {
            this.btnSubmit.Enabled = false;
            this.btnSubmit.Visible = false;

            if (this.txtPictureStoreTag.Text.Trim() != string.Empty)
            {
                string[] tagCondition = this.txtPictureStoreTag.Text.Split(",".ToCharArray());
                this.lblRedInfo1.Visible = false;

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

            Session["num"] = "";
            Session["picNum"] = "";
            Session["PictureStoreName"] = "";
            Session["PictureStoreDescription"] = "";
            Session["PictureTags"] = "";
            Session["iHairNature"] = "";
            Session["iHairQuantity"] = "";
            Session["iFaceStyle"] = "";
            Session["iSex"] = "";
            Session["iHairStyleClassName"] = "";
            Session["iTemperament"] = "";
            Session["iOccasion"] = "";
            Session["bbsUrl"] = "";
            Session["picString"] = "";
            Session["pic"] = "";
            Session["picSmall"] = "";
            Session["PSGIDS"] = "";

            string PSGIDS = this.GetPSGIDs();
            PictureStore ps = new PictureStore();
            ps.PictureStoreName = txtPictureStoreName.Text.Trim();
            ps.PictureStoreGroupIDs = PSGIDS;
            ps.PictureStoreDescription = txtPictureStoreDescription.Text.Trim();

            //ps.PictureStoreHits = 0;
            ps.PictureStoreCreateTime = DateTime.Now;
            //ps.PictureStoreRawUrl = "";
            //ps.PictureStoreLittleUrl = "";

            ps.PictureStoreID = InfoAdmin.AddPictureStore(ps);

            Byte iHairNature = Byte.Parse(this.ddlHairNature.SelectedItem.Value);
            Byte iHairQuantity = Byte.Parse(this.ddlHairQuantity.SelectedItem.Value);
            Byte iFaceStyle = Byte.Parse(this.ddlFaceStyle.SelectedItem.Value);
            Byte iSex = Byte.Parse(this.ddlSex.SelectedItem.Value);
            Byte iHairStyleClassName = Byte.Parse(this.ddlHairStyleClassName.SelectedItem.Value);
            Byte iTemperament = Byte.Parse(this.ddlTemperament.SelectedItem.Value);
            Byte iOccasion = Byte.Parse(this.ddlOccasion.SelectedItem.Value);
            string bbsUrl = txtBbsurl.Text.Trim();
            int hairShopID = 0;
            int hairEngineerID = 0;

            HairStyleEntity HairStyle = new HairStyleEntity(this.txtPictureStoreName.Text.Trim(),iHairQuantity,bbsUrl, hairShopID, hairEngineerID, iHairStyleClassName, iFaceStyle, iTemperament, iOccasion, iSex, iHairNature,ps.PictureStoreID, this.txtPictureStoreDescription.Text.Trim(),PSGIDS,false,0);
            int newid = 0;
            InfoAdmin.AddHairStyle(HairStyle,out newid);

            //问题1--------------
            string hstyleid = newid.ToString();
            HairStyle.ID = int.Parse(hstyleid);
            //using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString()))
            //{
            //    string commString = "select id from hairstyle order by id desc";
            //    using (SqlCommand comm = new SqlCommand())
            //    {
            //        comm.Connection = conn;
            //        comm.CommandText = commString;
            //        conn.Open();

            //        hstyleid = comm.ExecuteScalar().ToString();
            //        HairStyle.ID = int.Parse( hstyleid);
            //    }
            //}

            //发帖子
            string content = buildBBSContent(HairStyle);

            BBSPost post = new BBSPost();
            int postid = 0;
            bool bSuc = post.AddPost(HairStyle.HairName, content, BBSPost.Category.PhotoGroup, out postid);
            if (bSuc)
            {
                HairStyle.PostID = postid;

                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                {
                    string commString = "update hairstyle set postid=" + HairStyle.PostID.ToString() + " where ID=" + HairStyle.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);
                        }
                    }
                }
            }

            //tag逻辑
            string tagIDs = "";
            string[] tagCollection = txtPictureStoreTag.Text.Split(",".ToCharArray());
            if (tagCollection[0] != string.Empty)
            {
                for (int k = 0; k < tagCollection.Length; k++)
                {
                    string tagID = "";
                    bool isExist = false;
                    PictureStoreTag hst = new PictureStoreTag();
                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                    {
                        string commString = "select * from PictureStoreTag where PictureStoreTagName='" + 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["PictureStoreTagID"].ToString());
                                        hst.TagName = sdr["PictureStoreTagName"].ToString();
                                        hst.PictureStoreIDs = sdr["PictureStoreIDs"].ToString();
                                    }
                                    catch
                                    { }
                                }
                            }
                        }
                    }
                    if (hst.TagID == 0)
                    {
                        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                        {
                            string commString = "insert PictureStoreTag(PictureStoreTagName,PictureStoreIDs) values('" + tagCollection[k] + "','" + hstyleid.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.PictureStoreIDs == string.Empty)
                        {
                            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString))
                            {
                                string commString = "update PictureStoreTag set PictureStoreIDs='" + hstyleid.ToString() + "' where PictureStoreTagID=" + 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 PictureStoreTag set PictureStoreIDs=PictureStoreIDs+'," + hstyleid.ToString() + "' where PictureStoreTagID=" + 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;
                    }
                }
            }
            HairStyleEntity HairStyle1 = new HairStyleEntity(int.Parse(hstyleid),tagIDs,txtPictureStoreName.Text.Trim(), iHairQuantity, bbsUrl, hairShopID, hairEngineerID, iHairStyleClassName, iFaceStyle, iTemperament, iOccasion, iSex, iHairNature, ps.PictureStoreID, this.txtPictureStoreDescription.Text.Trim(), PSGIDS, false, postid);

            InfoAdmin.UpdateHairStyle(HairStyle1);
            //
            //同步TAG
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString()))
            {
                string commString = "update PictureStore set PictureStoreTagIDs = '" + tagIDs + "' where PictureStoreid=" +ps.PictureStoreID.ToString();
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.Connection = conn;
                    comm.CommandText = commString;
                    conn.Open();

                    try
                    {
                        comm.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    { }
                }
            }

            string[] PPSGCollection = PSGIDS.Split(",".ToCharArray());
            foreach (string s in PPSGCollection)
            {
                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString()))
                {
                    string commString = "update PictureStoreGroup set PictureStoreIDs = PictureStoreIDs+',"+hstyleid+"' where PictureStoreGroupID="+s;
                    using (SqlCommand comm = new SqlCommand())
                    {
                        comm.Connection = conn;
                        comm.CommandText = commString;
                        conn.Open();

                        try
                        {
                            comm.ExecuteNonQuery();
                        }
                        catch (Exception ex)
                        { }
                    }
                }
            }

            string[] ppicString = this.pic.Text.Split(";".ToCharArray());
            string[] ppicSmallString = this.picsmall.Text.Split(";".ToCharArray());

            if (ppicString[0] != string.Empty)
            {
                for(int k=0;k<ppicString.Length;k++)
                {
                    using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString()))
                    {
                        string commString = "insert into PictureStoreSet(PictureStoreId,PictureStoreURL,SmallPictureUrl,IsHairStyle,HairStylePos) values(" + hstyleid + ",'" + ppicString[k] + "','"+ppicSmallString[k]+"',0,0)";
                        using (SqlCommand comm = new SqlCommand())
                        {
                            comm.Connection = conn;
                            comm.CommandText = commString;
                            conn.Open();

                            try
                            {
                                comm.ExecuteNonQuery();
                            }
                            catch (Exception ex)
                            { }
                        }
                    }
                }
            }

            this.Response.Redirect("PictureStoreAdmin.aspx");
        }