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);
}
}
}
}
