private void SetInfo() { string id = Request["id"]; PictureStore ps = InfoAdmin.GetPictureStoreByPictureStoreID(int.Parse(id)); txtPictureStoreName.Text = ps.PictureStoreName; txtPictureStoreDescription.Text = ps.PictureStoreDescription; //txtPictureStoreTag.Text = InfoAdmin.GetPictureStoreTagNames(ps.PictureStoreTagIDs); string[] PSGIDSCollection = ps.PictureStoreGroupIDs.Split(",".ToCharArray()); foreach (string ss in PSGIDSCollection) { foreach (ListItem llli in this.chkJPList.Items) { if (llli.Value == ss) { llli.Selected = true; break; } } foreach (ListItem llli in this.chkMXList.Items) { if (llli.Value == ss) { llli.Selected = true; break; } } foreach (ListItem llli in this.chkFXList.Items) { if (llli.Value == ss) { llli.Selected = true; break; } } } string hairStyleTagIDs = ""; string hairStyleID = ""; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select * from HairStyle where PictureStoreId=" + ps.PictureStoreID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { if (sdr.Read()) { hairStyleTagIDs = sdr["tag"].ToString(); hairStyleID = sdr["id"].ToString(); this.ddlFaceStyle.SelectedValue = sdr["facestyle"].ToString(); this.ddlHairNature.SelectedValue = sdr["hairnature"].ToString(); this.ddlHairQuantity.SelectedValue = sdr["hairquantity"].ToString(); this.ddlHairStyleClassName.SelectedValue = sdr["hairstyle"].ToString(); this.ddlOccasion.SelectedValue = sdr["occasion"].ToString(); this.ddlSex.SelectedValue = sdr["sex"].ToString(); this.ddlTemperament.SelectedValue = sdr["temperament"].ToString(); this.txtBbsurl.Text = sdr["bbsUrl"].ToString(); } } } } //tag逻辑 if (hairStyleTagIDs != string.Empty) { string[] tempTagC = hairStyleTagIDs.Split(",".ToCharArray()); for (int k = 0; k < tempTagC.Length; k++) { PictureStoreTag hst = new PictureStoreTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from PictureStoreTag where PictureStoreTagID=" + 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["PictureStoreTagID"].ToString()); hst.TagName = sdr["PictureStoreTagName"].ToString(); hst.PictureStoreIDs = sdr["PictureStoreIDs"].ToString(); } catch { } } } } } if (k == 0) { this.txtPictureStoreTag.Text = hst.TagName; } else { this.txtPictureStoreTag.Text += "," + hst.TagName; } } } // int i = 0; string imgString = string.Empty; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select * from PictureStoreSet where PictureStoreId=" + hairStyleID; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { while (sdr.Read()) { i++; if (i == 1) { imgString = "<img src='" + sdr["SmallPictureUrl"].ToString() + "' width=100 height=50 /><a href='" + sdr["PictureStoreURL"].ToString() + "' target='_blank'><img src='" + sdr["PictureStoreURL"].ToString() + "' width=200 height=100 /></a> <a href='PictureStoreOperate.aspx?id=" + sdr["id"].ToString() + "&pid=" + ps.PictureStoreID.ToString() + "'>删除</a>"; } else { imgString += "<img src='" + sdr["SmallPictureUrl"].ToString() + "' width=100 height=50 /><a href='" + sdr["PictureStoreURL"].ToString() + "' target='_blank'><img src='" + sdr["PictureStoreURL"].ToString() + "' width=200 height=100 /></a> <a href='PictureStoreOperate.aspx?id=" + sdr["id"].ToString() + "&pid=" + ps.PictureStoreID.ToString() + "'>删除</a>"; } } } } } this.lblImg.Text = imgString; ViewState["PictureStoreInfo"] = ps; }
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"); }
protected void btnSubmit_OnClick(object sender, EventArgs e) { 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; } } } string PSGIDS = this.GetPSGIDs(); PictureStore ps = (PictureStore)ViewState["PictureStoreInfo"]; //先删除 string hstyleid = string.Empty; string hairStyleTagIDs = ""; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select id,tag from hairstyle where picturestoreid =" + ps.PictureStoreID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { if (sdr.Read()) { hstyleid = sdr["id"].ToString(); hairStyleTagIDs = sdr["tag"].ToString(); } } } } //先处理TAG逻辑,先删除HS所对应的所有TAG if (hairStyleTagIDs != string.Empty) { string[] tempTagC = hairStyleTagIDs.Split(",".ToCharArray()); for (int k = 0; k < tempTagC.Length; k++) { PictureStoreTag hst = new PictureStoreTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from PictureStoreTag where PictureStoreTagID=" + 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["PictureStoreTagID"].ToString()); hst.TagName = sdr["PictureStoreTagName"].ToString(); hst.PictureStoreIDs = sdr["PictureStoreIDs"].ToString(); } catch { } } } } } string[] tempPictureStoreIDC = hst.PictureStoreIDs.Split(",".ToCharArray()); string pictureStoreIDs = ""; int tempNum = 0; for (int i = 0; i < tempPictureStoreIDC.Length; i++) { if (tempPictureStoreIDC[i] != hstyleid.ToString()) { tempNum++; if (tempNum == 1) { pictureStoreIDs = tempPictureStoreIDC[i]; } else { pictureStoreIDs += "," + tempPictureStoreIDC[i]; } } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update PictureStoreTag set PictureStoreIDs='" + pictureStoreIDs + "' where PictureStoreTagID=" + hst.TagID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commString; comm.Connection = conn; conn.Open(); try { comm.ExecuteNonQuery(); } catch { } } } } } // if (ps.PictureStoreGroupIDs != "") { string[] PSGIDSCollection1 = ps.PictureStoreGroupIDs.Split(",".ToCharArray()); foreach (string sso in PSGIDSCollection1) { string ids = ""; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select picturestoreids from picturestoregroup where picturestoregroupid=" + sso; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); object obj= comm.ExecuteScalar(); if(obj != null) ids = obj.ToString(); } } string[] iids = ids.Split(",".ToCharArray()); ids = string.Empty; for (int i = 1; i < iids.Length; i++) { if (iids[i] != hstyleid) { ids += "," + iids[i]; } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "update picturestoregroup set picturestoreids = '" + ids + "' where picturestoregroupid=" + sso; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); try { comm.ExecuteNonQuery(); } catch { } } } } } ps.PictureStoreName = txtPictureStoreName.Text.Trim(); ps.PictureStoreGroupIDs = PSGIDS; ps.PictureStoreDescription = txtPictureStoreDescription.Text.Trim(); //ps.PictureStoreHits = 0; ps.PictureStoreCreateTime = DateTime.Now; //ps.PictureStoreRawUrl = string.Empty; //ps.PictureStoreLittleUrl = string.Empty; //if (uploadpic.Value != "") //{ // UpLoadClass upload = new UpLoadClass(); // string filepath = upload.UpLoadImg(uploadpic, "/uploadfiles/pictures/"); // upload = null; // //处理图片 // 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; //} string[] ppicString = this.pic.Text.Split(";".ToCharArray()); if (ppicString[0] != string.Empty) { foreach (string pps in ppicString) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "insert into PictureStoreSet(PictureStoreId,PictureStoreURL,IsHairStyle,HairStylePos) values(" + hstyleid + ",'" + pps + "',0,0)"; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); try { comm.ExecuteNonQuery(); } catch (Exception ex) { } } } } } InfoAdmin.UpdatePictureStore(ps); string iHairNature = this.ddlHairNature.SelectedItem.Value; string iHairQuantity = this.ddlHairQuantity.SelectedItem.Value; string iFaceStyle = this.ddlFaceStyle.SelectedItem.Value; string iSex = this.ddlSex.SelectedItem.Value; string iHairStyleClassName = this.ddlHairStyleClassName.SelectedItem.Value; string iTemperament = this.ddlTemperament.SelectedItem.Value; string iOccasion = this.ddlOccasion.SelectedItem.Value; int hairShopID = 0; int hairEngineerID = 0; // //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; } } } // using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "update HairStyle set tag='" + tagIDs + "',bbsUrl='"+txtBbsurl.Text+"',hairname='" + ps.PictureStoreName + "',hairShopID=" + hairShopID.ToString() + ",hairEngineerID=" + hairEngineerID.ToString() + ",hairnature=" + iHairNature + ",hairquantity=" + iHairQuantity + ",facestyle=" + iFaceStyle + ",sex=" + iSex + ",hairstyle=" + iHairStyleClassName + ",temperament=" + iTemperament + ",occasion=" + iOccasion + ",descr='" + ps.PictureStoreDescription + "', psgids='" + PSGIDS + "' where picturestoreid=" + ps.PictureStoreID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); try { comm.ExecuteNonQuery(); } catch (Exception ex) { } } } //同步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) { } } } } this.Response.Redirect("PictureStoreAdmin.aspx"); }
public void dg_OnItemCommand(object sender, DataGridCommandEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { if (e.CommandName == "recommand") { int pictureStoreID = int.Parse(this.dg.DataKeys[e.Item.ItemIndex].ToString()); string redirectUrl = "PictureStoreUpdate.aspx?pictureStoreID=" + pictureStoreID.ToString() + "&pictureStoreRecommandID=0&operateType=" + Convert.ToInt32(UserAction.Create).ToString(); this.Response.Redirect(redirectUrl); } if (e.CommandName == "delete") { int pictureStoreID = int.Parse(this.dg.DataKeys[e.Item.ItemIndex].ToString()); int hairStyleID = 0; string hstyleid = string.Empty; string hairStyleTagIDs = ""; if (InfoAdmin.DeletePictureStore(pictureStoreID)) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from hairStyle where picturestoreid=" + pictureStoreID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commString; comm.Connection = conn; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { if (sdr.Read()) { hairStyleID = int.Parse(sdr["id"].ToString()); hstyleid = sdr["id"].ToString(); hairStyleTagIDs = sdr["tag"].ToString(); } } } } //先处理TAG逻辑,先删除HS所对应的所有TAG if (hairStyleTagIDs != string.Empty) { string[] tempTagC = hairStyleTagIDs.Split(",".ToCharArray()); for (int k = 0; k < tempTagC.Length; k++) { PictureStoreTag hst = new PictureStoreTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from PictureStoreTag where PictureStoreTagID=" + 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["PictureStoreTagID"].ToString()); hst.TagName = sdr["PictureStoreTagName"].ToString(); hst.PictureStoreIDs = sdr["PictureStoreIDs"].ToString(); } catch { } } } } } string[] tempPictureStoreIDC = hst.PictureStoreIDs.Split(",".ToCharArray()); string pictureStoreIDs = ""; int tempNum = 0; for (int i = 0; i < tempPictureStoreIDC.Length; i++) { if (tempPictureStoreIDC[i] != hstyleid.ToString()) { tempNum++; if (tempNum == 1) { pictureStoreIDs = tempPictureStoreIDC[i]; } else { pictureStoreIDs += "," + tempPictureStoreIDC[i]; } } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update PictureStoreTag set PictureStoreIDs='" + pictureStoreIDs + "' where PictureStoreTagID=" + hst.TagID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commString; comm.Connection = conn; conn.Open(); try { comm.ExecuteNonQuery(); } catch { } } } } } this.deleteHairStyle(hairStyleID); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "delete from picturestoreset where picturestoreid=" + hairStyleID.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 PictureStoreRecommand where PictureStoreRawID=" + pictureStoreID.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("PictureStoreAdmin.aspx"); } else { StringHelper.AlertInfo("删除失败", this.Page); } } } }