public void btnSubmitPic_OnClick(object sender, EventArgs e) { UpLoadClass upload = new UpLoadClass(); string pName = upload.UpLoadImg(pic, "/uploadfiles/pictures/"); if (pName != string.Empty) { this.img.Visible = true; this.img.ImageUrl = pName; } }
public void btnPicSubmit_OnClick(object sender, EventArgs e) { UpLoadClass upload = new UpLoadClass(); string picPath = upload.UpLoadImg(fileLogo, "/uploadfiles/pictures/"); System.Threading.Thread.Sleep(1000); string picSmallPath = upload.UpLoadImg(smallLogo, "/uploadfiles/pictures/"); if (picPath != string.Empty) { if (this.lblpicSring.Text == string.Empty) { lblpicSring.Text = picPath; lblpicsmallString.Text = picSmallPath; lblPic.Text = "<img width=100 height=50 src="+picSmallPath+"></img> <img width=200 heigth=100 src=" + picPath + "></img>"; } else { lblpicSring.Text = lblpicSring.Text + ";" + picPath; lblpicsmallString.Text = lblpicsmallString.Text + ";" + picSmallPath; lblPic.Text += " <img width=100 height=50 src=" + picSmallPath + "></img> <img width=200 heigth=100 src=" + picPath + "></img>"; } } }
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 btnPicUpload1_OnClick(object sender, EventArgs e) { this.lblRedInfo.Visible = false; this.btnPicUpload.Enabled = false; if (uploadpic1.FileName == string.Empty || uploadpicsmall.Value == string.Empty) { this.lblRedInfo.Text = "上传大小图片地址不能为空!"; this.lblRedInfo.Visible = true; this.btnPicUpload.Enabled = true; return; } PictureStore ps = (PictureStore)ViewState["PictureStoreInfo"]; UpLoadClass upload = new UpLoadClass(); string filepath = ""; string newfilepath = upload.UploadImageFile(uploadpic1, "/uploadfiles/pictures/"); PicOperate WaterMark = new PicOperate(); //Water Mark Operation filepath = newfilepath.Substring(0, newfilepath.LastIndexOf(".")) + "_new" + System.IO.Path.GetExtension(newfilepath); WaterMark.AddWaterMarkOperate(newfilepath, Server.MapPath(WaterSettings.WaterMarkPath), filepath, WaterSettings.CopyrightText); filepath = GetPath(filepath); System.Threading.Thread.Sleep(1000); string filepathSmall = upload.UpLoadImg(uploadpicsmall, "/uploadfiles/pictures/"); string hairStyleID = ""; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select id 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()) { hairStyleID = sdr["id"].ToString(); } } } } if (filepath != string.Empty) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "insert into PictureStoreSet(PictureStoreId,PictureStoreURL,SmallPictureUrl,IsHairStyle,HairStylePos) values(" + hairStyleID + ",'" + filepath + "','" + filepathSmall + "',0,0)"; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); try { comm.ExecuteNonQuery(); } catch (Exception ex) { } } } int pssid = 0; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ToString())) { string commString = "select top 1 * from PictureStoreSet where IsHairStyle=0 order by id desc"; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commString; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { if (sdr.Read()) { pssid = Convert.ToInt32(sdr["ID"].ToString()); } } } } this.lblImg.Text = "<img src='" + filepathSmall + "' width=100 height=50 /><a href='" + filepath + "' target='_blank'><img src='" + filepath + "' width=200 height=100 /></a> <a href='PictureStoreOperate.aspx?id=" + pssid + "&pid=" + ps.PictureStoreID.ToString() + "'>删除</a>" + " " + this.lblImg.Text; this.btnPicUpload.Enabled = true; } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { this.Response.Write("<script>enableButton();</script>"); if (this.txtHairShopTag.Text.Trim() != string.Empty) { string[] tagCondition = this.txtHairShopTag.Text.Split(",".ToCharArray()); this.lblRedInfo.Visible = false; for (int k = 0; k < tagCondition.Length; k++) { if (tagCondition[k] == string.Empty) { this.lblRedInfo.Text = "TAG格式不正确(正确的格式 1,2,3)"; this.lblRedInfo.Visible = true; return; } } } HairShop hs = new HairShop(); hs.HairShopName = txtHairShopName.Text.Trim(); hs.HairShopShortName = txtHairShopShortName.Text.Trim(); hs.TypeID = int.Parse(ddlTypeTable.SelectedValue); hs.TypeName = ddlTypeTable.SelectedItem.Text; hs.HairShopWebSite = txtHairShopWebSite.Text.Trim(); hs.HairShopEmail = txtHairShopEmail.Text.Trim(); hs.HairShopDiscount = txtHairShopDiscount.Text.Trim(); hs.TravelInfo = txtTravelInfo.Text.Trim(); if (fileLogo.Value != string.Empty) { //获取上传图片后的路径 UpLoadClass upload = new UpLoadClass(); if (!PicOperate.isPermission(StringHelper.GetExtraType(fileLogo.Value))) { this.lblInfo.Text = "上传图片格式不对"; this.lblInfo.Visible = true; return; } hs.HairShopLogo = upload.UpLoadImg(fileLogo, "/uploadfiles/logo/"); } else { hs.HairShopLogo = string.Empty; } hs.HairShopCreateTime = txtHairShopCreateTime.Text.Trim(); hs.HairShopCityID = int.Parse(ddlCity.SelectedValue); hs.HairShopMapZoneID = int.Parse(ddlMapZone.SelectedValue); hs.HairShopHotZoneID = int.Parse(ddlHotZone.SelectedValue); hs.HairShopAddress = txtHairShopAddress.Text.Trim(); hs.HairShopPhoneNum = txtHairShopPhoneNum.Text.Trim(); hs.HairShopOpenTime = txtHairShopOpenTime.Text.Trim(); //TAG逻辑,先复制空,然后插入TAG表,然后UPDATE美发厅表 hs.HairShopTagIDs = ""; //List<string> IDs = new List<string>(); //int chkI = chkListWorkRange.Items.Count; //for (int i = 0; i < chkI; i++) //{ // if (chkListWorkRange.Items[i].Selected) // { // IDs.Add(chkListWorkRange.Items[i].Value); // } //} //IDs.Sort(); //hs.WorkRangeIDs = string.Join(",", IDs.ToArray()); //hs.IsBest = chkIsBest.Checked; hs.IsJoin = chkIsJoin.Checked; hs.IsPostMachine = chkIsPostMachine.Checked; hs.IsPostStation = chkIsPostStation.Checked; hs.HairShopDescription = txtDescription.Text.Trim(); //Session["HairShopInfo"] = hs; try { hs.HairCutDiscountMin = Decimal.Parse(txtHairCutPriceMin.Text.Trim()); } catch { hs.HairCutDiscountMin = 0; } try { hs.HairMarcelDiscountMin = Decimal.Parse(txtMarcelPriceMin.Text.Trim()); } catch { hs.HairMarcelDiscountMin = 0; } try { hs.HairDyeDiscountMin = Decimal.Parse(txtHairDyePriceMin.Text.Trim()); } catch { hs.HairDyeDiscountMin = 0; } try { hs.HairShapeDiscountMin = Decimal.Parse(txtShapePriceMin.Text.Trim()); } catch { hs.HairShapeDiscountMin = 0; } try { hs.HairConservationDiscountMin = Decimal.Parse(txtConservationPriceMin.Text.Trim()); } catch { hs.HairConservationDiscountMin = 0; } try { hs.HairCutDiscount = Decimal.Parse(tbHairCutDiscount.Text.Trim()); } catch { hs.HairCutDiscount = 0; } try { hs.HairCutPirce = Decimal.Parse(tbHairCutPrice.Text.Trim()); } catch { hs.HairCutPirce = 0; } try { hs.HairMarcelDiscount = Decimal.Parse(tbMarclDiscount.Text.Trim()); } catch { hs.HairMarcelDiscount = 0; } try { hs.HairMarcelPrice = Decimal.Parse(tbMarcelPrice.Text.Trim()); } catch { hs.HairMarcelPrice = 0; } try { hs.HairDyeDiscount = Decimal.Parse(tbHairDyeDiscount.Text.Trim()); } catch { hs.HairDyeDiscount = 0; } try { hs.HairDyePrice = Decimal.Parse(tbHairDyePrice.Text.Trim()); } catch { hs.HairDyePrice = 0; } try { hs.HairShapePrice = Decimal.Parse(tbShapePrice.Text.Trim()); } catch { hs.HairShapePrice = 0; } try { hs.HairShapeDiscount = Decimal.Parse(tbShapeDiscount.Text.Trim()); } catch { hs.HairShapeDiscount = 0; } try { hs.HairConservationPrice = Decimal.Parse(tbConservationPrice.Text.Trim()); } catch { hs.HairConservationPrice = 0; } try { hs.HairConservationDiscount = Decimal.Parse(tbConservationDiscount.Text.Trim()); } catch { hs.HairConservationDiscount = 0; } hs.LocationMapURL = tbLocation.Text.Trim(); try { hs.Square = int.Parse(TextBox4.Text.Trim()).ToString(); } catch { hs.Square = "0"; } hs.IsServeHairCut = chkCut.Checked; hs.IsServeMarce = chkMarcel.Checked; hs.IsServeDye = chkDye.Checked; hs.MemberInfo = txtMemberInfo.Text.Trim(); string productIDs = ""; int num = 0; foreach (ListItem li in this.chkList.Items) { if (li.Selected) { num++; if (num == 1) { productIDs = li.Value; hs.ProductsName = li.Text; } else { productIDs += ","+li.Value; hs.ProductsName += "," + li.Text; } } } hs.ProductIDs = productIDs; //InfoAdmin.AddHairShop(hs); int newid = 0; InfoAdmin.AddHairShopInfo(hs,out newid); Session["HairShop"] = hs; string id = newid.ToString(); string tagIDs = ""; string[] tagCollection = txtHairShopTag.Text.Split(",".ToCharArray()); if (tagCollection[0] != string.Empty) { for (int k = 0; k < tagCollection.Length; k++) { string tagID = ""; bool isExist = false; HairShopTag hst = new HairShopTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from HairShopTag where HairShopTagName='" + 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["HairShopTagID"].ToString()); hst.TagName = sdr["HairShopTagName"].ToString(); hst.HairShopIDs = sdr["HairShopIDs"].ToString(); } catch { } } } } } if (hst.TagID == 0) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "insert HairShopTag(HairShopTagName,HairShopIDs) 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.HairShopIDs == string.Empty) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairShopTag set HairShopIDs='" + id.ToString() + "' where HairShopTagID=" + 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 HairShopTag set HairShopIDs=HairShopIDs+'," + id.ToString() + "' where HairShopTagID=" + 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; } } } hs.HairShopTagIDs = tagIDs; hs.HairShopID = int.Parse(id.ToString()); int nnewid = 0; ProviderFactory.GetHairShopDataProviderInstance().HairShopCreateDeleteUpdate(hs, UserAction.Update,out nnewid); this.Response.Redirect("HairShopAddNext1.aspx?id="+id.ToString()); //this.Response.Redirect("HairEngineerAdd.aspx"); }
public void btnUpload_OnClick(object sender, EventArgs e) { UpLoadClass upload = new UpLoadClass(); this.lblInfo.Visible = false; if (!PicOperate.isPermission(StringHelper.GetExtraType(big.Value))) { this.lblInfo.Text = "大图片格式不对"; this.lblInfo.Visible = true; return; } //if (!PicOperate.isPermission(StringHelper.GetExtraType(small.Value))) //{ // this.lblInfo.Text = "小图片格式不对"; // this.lblInfo.Visible = true; // return; //} string big1 = upload.UpLoadImg(big, "/uploadfiles/pictures/"); System.Threading.Thread.Sleep(1000); string small1 = string.Empty; if (small.Value != string.Empty) { small1 = upload.UpLoadImg(small, "/uploadfiles/pictures/"); } this.lblBig.Text = big1; this.lblSmall.Text = small1; this.lblInfo.Visible = true; this.lblInfo.Text = "<img width=100 height=50 src='"+small1+"'></img> <img src='"+big1+"' width=200 height=100></img>"; }
protected void btnSubmit_OnClick(object sender, EventArgs e) { if (this.txtHairShopTag.Text.Trim() != string.Empty) { string[] tagCondition = this.txtHairShopTag.Text.Split(",".ToCharArray()); this.lblRedInfo.Visible = false; for (int k = 0; k < tagCondition.Length; k++) { if (tagCondition[k] == string.Empty) { this.lblRedInfo.Text = "TAG格式不正确(正确的格式 1,2,3)"; this.lblRedInfo.Visible = true; return; } } } if (ddlHotZone.SelectedItem.Value == "28") { this.lblInfo.Visible = true; this.lblInfo.Text = "美发商圈未指定!"; return; } HairShop hs = (HairShop)ViewState["HairShop"]; //先处理TAG逻辑,先删除HS所对应的所有TAG if (hs.HairShopTagIDs != string.Empty) { string[] tempTagC = hs.HairShopTagIDs.Split(",".ToCharArray()); for (int k = 0; k < tempTagC.Length; k++) { HairShopTag hst = new HairShopTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from HairShopTag where HairShopTagID=" + 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["HairShopTagID"].ToString()); hst.TagName = sdr["HairShopTagName"].ToString(); hst.HairShopIDs = sdr["HairShopIDs"].ToString(); } catch { } } } } } string[] tempHairShopIDC = hst.HairShopIDs.Split(",".ToCharArray()); string hairShopIDs = ""; int tempNum = 0; for (int i = 0; i < tempHairShopIDC.Length; i++) { if (tempHairShopIDC[i] != hs.HairShopID.ToString()) { tempNum++; if (tempNum == 1) { hairShopIDs = tempHairShopIDC[i]; } else { hairShopIDs += "," + tempHairShopIDC[i]; } } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairShopTag set HairShopIDs='" + hairShopIDs + "' where HairShopTagID=" + hst.TagID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commString; comm.Connection = conn; conn.Open(); try { comm.ExecuteNonQuery(); } catch { } } } } } // hs.HairShopName = txtHairShopName.Text.Trim(); hs.HairShopShortName = txtHairShopShortName.Text.Trim(); hs.TypeID = int.Parse(ddlTypeTable.SelectedValue); hs.HairShopWebSite = txtHairShopWebSite.Text.Trim(); hs.HairShopEmail = txtHairShopEmail.Text.Trim(); hs.HairShopDiscount = txtHairShopDiscount.Text.Trim(); //获取上传图片后的路径 if (fileLogo.Value!="") { UpLoadClass upload = new UpLoadClass(); hs.HairShopLogo = upload.UpLoadImg(fileLogo, "/uploadfiles/logo/"); upload = null; } else { hs.HairShopLogo = imgLogo.ImageUrl; } try { hs.HairCutDiscountMin = Decimal.Parse(txtHairCutPriceMin.Text.Trim()); } catch { hs.HairCutDiscountMin = 0; } try { hs.HairMarcelDiscountMin = Decimal.Parse(txtMarcelPriceMin.Text.Trim()); } catch { hs.HairMarcelDiscountMin = 0; } try { hs.HairDyeDiscountMin = Decimal.Parse(txtHairDyePriceMin.Text.Trim()); } catch { hs.HairDyeDiscountMin = 0; } try { hs.HairShapeDiscountMin = Decimal.Parse(txtShapePriceMin.Text.Trim()); } catch { hs.HairShapeDiscountMin = 0; } try { hs.HairConservationDiscountMin = Decimal.Parse(txtConservationPriceMin.Text.Trim()); } catch { hs.HairConservationDiscountMin = 0; } hs.HairShopCreateTime = txtHairShopCreateTime.Text.Trim(); hs.HairShopCityID = int.Parse(ddlCity.SelectedValue); hs.HairShopMapZoneID = int.Parse(ddlMapZone.SelectedValue); hs.HairShopHotZoneID = int.Parse(ddlHotZone.SelectedValue); hs.HairShopAddress = txtHairShopAddress.Text.Trim(); hs.HairShopPhoneNum = txtHairShopPhoneNum.Text.Trim(); hs.HairShopOpenTime = txtHairShopOpenTime.Text.Trim(); hs.TravelInfo = txtTravelInfo.Text.Trim(); hs.HairShopTagIDs = ""; try { hs.HairCutDiscount = Decimal.Parse(tbHairCutDiscount.Text.Trim()); } catch { hs.HairCutDiscount = 0; } try { hs.HairCutPirce = Decimal.Parse(tbHairCutPrice.Text.Trim()); } catch { hs.HairCutPirce = 0; } try { hs.HairMarcelDiscount = Decimal.Parse(tbMarclDiscount.Text.Trim()); } catch { hs.HairMarcelDiscount = 0; } try { hs.HairMarcelPrice = Decimal.Parse(tbMarcelPrice.Text.Trim()); } catch { hs.HairMarcelPrice = 0; } try { hs.HairDyeDiscount = Decimal.Parse(tbHairDyeDiscount.Text.Trim()); } catch { hs.HairDyeDiscount = 0; } try { hs.HairDyePrice = Decimal.Parse(tbHairDyePrice.Text.Trim()); } catch { hs.HairDyePrice = 0; } try { hs.HairShapePrice = Decimal.Parse(tbShapePrice.Text.Trim()); } catch { hs.HairShapePrice = 0; } try { hs.HairShapeDiscount = Decimal.Parse(tbShapeDiscount.Text.Trim()); } catch { hs.HairShapeDiscount = 0; } try { hs.HairConservationPrice = Decimal.Parse(tbConservationPrice.Text.Trim()); } catch { hs.HairConservationPrice = 0; } try { hs.HairConservationDiscount = Decimal.Parse(tbConservationDiscount.Text.Trim()); } catch { hs.HairConservationDiscount = 0; } hs.LocationMapURL = tbLocation.Text.Trim(); try { hs.Square = int.Parse(tbSquare.Text.Trim()).ToString(); } catch { hs.Square = "0"; } hs.IsServeHairCut = chkCut.Checked; hs.IsServeMarce = chkMarcel.Checked; hs.IsServeDye = chkDye.Checked; hs.IsJoin = chkIsJoin.Checked; hs.IsPostMachine = chkIsPostMachine.Checked; hs.IsPostStation = chkIsPostStation.Checked; hs.HairShopDescription = txtDescription.Text.Trim(); hs.MemberInfo = txtMemberInfo.Text.Trim(); string productIDs = ""; int num = 0; foreach (ListItem li in this.chkList.Items) { if (li.Selected) { num++; if (num == 1) { productIDs = li.Value; } else { productIDs += "," + li.Value; } } } hs.ProductIDs = productIDs; //TAG逻辑 string tagIDs = ""; string id = hs.HairShopID.ToString(); string[] tagCollection = txtHairShopTag.Text.Split(",".ToCharArray()); if (tagCollection[0] != string.Empty) { for (int k = 0; k < tagCollection.Length; k++) { string tagID = ""; bool isExist = false; HairShopTag hst = new HairShopTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from HairShopTag where HairShopTagName='" + 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["HairShopTagID"].ToString()); hst.TagName = sdr["HairShopTagName"].ToString(); hst.HairShopIDs = sdr["HairShopIDs"].ToString(); } catch { } } } } } if (hst.TagID == 0) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "insert HairShopTag(HairShopTagName,HairShopIDs) 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.HairShopIDs == string.Empty) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairShopTag set HairShopIDs='" + id.ToString() + "' where HairShopTagID=" + 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 HairShopTag set HairShopIDs=HairShopIDs+'," + id.ToString() + "' where HairShopTagID=" + 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; } } } hs.HairShopTagIDs = tagIDs; Session["HairShopInfo"] = hs; InfoAdmin.UpdateHairShopInfo(hs); this.Response.Redirect("HairShopAdmin.aspx"); }
protected void btnPicUpload1_OnClick(object sender, EventArgs e) { this.lblRedInfo.Visible = false; this.btnPicUpload.Enabled = false; if (uploadpic1.FileName == string.Empty || uploadpicsmall.Value == string.Empty) { this.lblRedInfo.Text = "上传大小图片地址均不能为空!"; this.lblRedInfo.Visible = true; this.btnPicUpload.Enabled = true; return; } UpLoadClass upload = new UpLoadClass(); string filepath = ""; string newfilepath = upload.UploadImageFile(uploadpic1, "/uploadfiles/pictures/"); PicOperate WaterMark = new PicOperate(); //Water Mark Operation filepath = newfilepath.Substring(0, newfilepath.LastIndexOf(".")) + "_new" + System.IO.Path.GetExtension(newfilepath); WaterMark.AddWaterMarkOperate(newfilepath, Server.MapPath(WaterSettings.WaterMarkPath), filepath, WaterSettings.CopyrightText); filepath = GetPath(filepath); System.Threading.Thread.Sleep(1000); string filepathSmall = upload.UpLoadImg(uploadpicsmall, "/uploadfiles/pictures/"); if (filepath != string.Empty) { int num = Convert.ToInt32(Session["num"].ToString()); num++; Session["num"] = num; int picNum = int.Parse(Session["picNum"].ToString()); picNum++; if (picNum == 1) { Session["pic" + num.ToString()] = filepath; Session["picSmall" + num.ToString()] = filepathSmall; this.picString.Text = "<img width=100 heigth=50 src='" + filepathSmall + "' /> <img width=200 heigth=100 src='" + filepath + "' /> <a href='PictureStoreOperate2.aspx?num="+num.ToString()+"'>删除</a>"; this.pic.Text = filepath; this.picsmall.Text = filepathSmall; } else { this.picString.Text += " <img width=100 heigth=50 src='" + filepathSmall + "' /> <img width=200 heigth=100 src='" + filepath + "' /> <a href='PictureStoreOperate2.aspx?num=" + num.ToString() + "'>删除</a>"; this.pic.Text += ";" + filepath; this.picsmall.Text += ";" + filepathSmall; } Session["pic" + num.ToString()] = filepath; Session["picSmall" + num.ToString()] = filepathSmall; Session["picString"] = this.picString.Text; Session["pic"] = this.pic.Text; Session["picSmall"] = this.picsmall.Text; Session["picNum"] = picNum; Session["PSGIDS"] = this.GetPSGIDs(); Session["PictureStoreName"] = txtPictureStoreName.Text.Trim(); Session["PictureStoreDescription"] = txtPictureStoreDescription.Text.Trim(); Session["PictureTags"] = txtPictureStoreTag.Text.Trim(); Session["iHairNature"] = this.ddlHairNature.SelectedItem.Value; Session["iHairQuantity"] = this.ddlHairQuantity.SelectedItem.Value; Session["iFaceStyle"] = this.ddlFaceStyle.SelectedItem.Value; Session["iSex"] = this.ddlSex.SelectedItem.Value; Session["iHairStyleClassName"] = this.ddlHairStyleClassName.SelectedItem.Value; Session["iTemperament"] = this.ddlTemperament.SelectedItem.Value; Session["iOccasion"] = this.ddlOccasion.SelectedItem.Value; Session["bbsUrl"] = txtBbsurl.Text.Trim(); this.btnPicUpload.Enabled = true; } }