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