protected void btnAddPic_Click(object sender, EventArgs e) { UpLoadClass upload = new UpLoadClass(); string filepath = upload.UpLoadImg(uploadpic, "/uploadfiles/pictures/"); upload = null; List<PictureStore> list = (List<PictureStore>)ViewState["PicList"]; PictureStore ps = new PictureStore(); ps.PictureStoreName = txtPictureStoreName.Text.Trim(); ps.PictureStoreGroupIDs = ddlPicGroup.SelectedValue; ps.PictureStoreDescription = txtPictureStoreDescriptioin.Text.Trim(); ps.PictureStoreTagIDs = InfoAdmin.GetPictureStoreTagIDs(txtPictureStoreTag.Text.Trim()); //ps.PictureStoreHits = 0; ps.PictureStoreCreateTime = DateTime.Now; //处理图片 PicOperate po = new PicOperate(); string newfilepath = filepath.Substring(0, filepath.LastIndexOf(".")) + "_new" + Path.GetExtension(filepath); po.AddWaterMarkOperate(Server.MapPath(filepath), Server.MapPath(WaterSettings.WaterMarkPath), Server.MapPath(newfilepath), WaterSettings.CopyrightText); //ps.PictureStoreRawUrl = newfilepath; //ps.PictureStoreLittleUrl = po.CreateMicroPic(newfilepath, "", WaterSettings.PictureScaleSize[0], WaterSettings.PictureScaleSize[1]); po = null; //更新图片标签 ps.PictureStoreID = InfoAdmin.AddPictureStore(ps); foreach (string tagid in ps.PictureStoreTagIDs.Split(',')) { InfoAdmin.SetPictureStoreTag(ps.PictureStoreID, int.Parse(tagid)); } list.Add(ps); ViewState["PicList"] = list; this.bindPicList(); this.clearText(); }
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"); }