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]); }
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格式不正确(正确的格式 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"); }