public string buildBBSContent(HairEngineer he) { StringBuilder content=new StringBuilder(); string picstr = lblpicSring.Text.Replace(@"\", @"/"); string[] pics = picstr.Split(";".ToCharArray()); foreach (string pic in pics) { string p1 = "http://hair.sg.com.cn" + pic; content.AppendLine("[img]" + p1 + "[/img]"); } content.AppendLine("美发师名称:" + he.HairEngineerName); content.AppendLine("所属美发店名称: " + he.HairShopName); content.AppendLine("简介: " + he.HairEngineerDescription); content.AppendLine("职位: " + he.HairEngineerClassID); content.AppendLine("剪发价格: " + he.HairEngineerRawPrice.ToString()); content.AppendLine("技术擅长: " + he.HairEngineerSkill); content.AppendLine("工作年限: " + he.HairEngineerYear.ToString()); content.AppendLine("星座: " + he.HairEngineerConstellation); content.AppendLine("预约电话: " + he.HairEngineerTel); content.AppendLine("原文:http://hair.sg.com.cn/HairdresserLastPage.aspx?id=" + he.HairEngineerID.ToString() ); return content.ToString(); }
/// <summary> /// ͨ������ʦID����ȡ����ʦʵ�� /// </summary> /// <param name="hairEngineerID"></param> /// <returns></returns> public HairEngineer GetHairEngineerByHairEngineerID(int hairEngineerID) { HairEngineer hairEngineer = new HairEngineer(); using (SqlDataReader sdr = SqlHelper.ExecuteReader(DataHelper2.SqlConnectionString, CommandType.Text, "select * from HairEngineer he left join HairShop hs on hs.HairShopID = he.HairShopID where he.HairEngineerID=" + hairEngineerID.ToString() + " order by he.HairEngineerID desc")) { while (sdr.Read()) { hairEngineer.HairEngineerID = int.Parse(sdr["HairEngineerID"].ToString()); hairEngineer.HairEngineerAge = sdr["HairEngineerAge"].ToString(); hairEngineer.HairEngineerName = sdr["HairEngineerName"].ToString(); hairEngineer.HairEngineerSex = int.Parse(sdr["HairEngineerSex"].ToString()); //hairEngineer.HairEngineerPhoto = sdr["HairEngineerPhoto"].ToString(); hairEngineer.HairShopID = int.Parse(sdr["HairShopID"].ToString()); hairEngineer.HairShopName = sdr["HairShopName"].ToString(); hairEngineer.HairEngineerYear = sdr["HairEngineerYear"].ToString(); hairEngineer.HairEngineerSkill = sdr["HairEngineerSkill"].ToString(); hairEngineer.HairEngineerTagIDs = sdr["HairEngineerTagIDs"].ToString(); hairEngineer.HairEngineerPictureStoreIDs = sdr["HairEngineerPictureStoreIDs"].ToString(); hairEngineer.HairEngineerHits = int.Parse(sdr["HairEngineerHits"].ToString()); hairEngineer.HairEngineerDescription = sdr["HairEngineerDescription"].ToString(); //hairEngineer.HairEngineerOrderNum = int.Parse(sdr["HairEngineerOrderNum"].ToString()); //hairEngineer.HairEngineerRecommandNum = int.Parse(sdr["HairEngineerRecommandNum"].ToString()); hairEngineer.HairEngineerRawPrice = sdr["HairEngineerRawPrice"].ToString(); hairEngineer.HairEngineerTel = sdr["HairEngineerTel"].ToString(); hairEngineer.HairEngineerGood = int.Parse(sdr["HairEngineerGood"].ToString()); hairEngineer.HairEngineerBad = int.Parse(sdr["HairEngineerBad"].ToString()); hairEngineer.HairEngineerClassID = sdr["HairEngineerClassID"].ToString(); hairEngineer.HairEngineerClassName = sdr["HairEngineerClassID"].ToString(); hairEngineer.HairEngineerConstellation = sdr["HairEngineerConstellation"].ToString(); hairEngineer.IsImportant = bool.Parse(sdr["IsImportant"].ToString()); hairEngineer.HairEngineerPhotoIDs = sdr["HairEngineerPhotoIDs"].ToString(); } } return hairEngineer; }
/// <summary> /// /// </summary> /// <param name="count"></param> /// <param name="ok"></param> /// <param name="hairEngineerName"></param> /// <returns></returns> public List<HairEngineer> GetHairEngineers(int count, OrderKey ok,string hairEngineerName) { List<HairEngineer> list = new List<HairEngineer>(); string orderKey = " order by "; switch (ok) { case OrderKey.ID: orderKey += "he.HairEngineerID desc"; break; case OrderKey.CommentNum: orderKey += "he.HairEngineerGood+he.HairEngineerBad desc"; break; case OrderKey.RecommandNum: orderKey += "he.HairEngineerRecommandNum desc"; break; case OrderKey.HitNum: orderKey += "he.HairEngineerHits desc"; break; case OrderKey.OrderNum: orderKey += "he.HairEngineerOrderNum desc"; break; default: orderKey += "he.HairEngineerID desc"; break; } string commText = ""; switch (count) { case 0: commText = "select * from HairEngineer he left join HairShop hs on hs.HairShopID = he.HairShopID where he.HairEngineerName like '%"+hairEngineerName.ToString()+"%'" + orderKey; break; default: commText = "select top " + count.ToString() + " * from HairEngineer he left join HairShop hs on hs.HairShopID = he.HairShopID where he.HairEngineerName like '%" + hairEngineerName.ToString() + "%'" + orderKey; break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { { using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commText; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { while (sdr.Read()) { HairEngineer hairEngineer = new HairEngineer(); hairEngineer.HairEngineerID = int.Parse(sdr["HairEngineerID"].ToString()); hairEngineer.HairEngineerAge = sdr["HairEngineerAge"].ToString(); hairEngineer.HairEngineerName = sdr["HairEngineerName"].ToString(); hairEngineer.HairEngineerSex = int.Parse(sdr["HairEngineerSex"].ToString()); //hairEngineer.HairEngineerPhoto = sdr["HairEngineerPhoto"].ToString(); hairEngineer.HairShopID = int.Parse(sdr["HairShopID"].ToString()); hairEngineer.HairShopName = sdr["HairShopName"].ToString(); hairEngineer.HairEngineerYear = sdr["HairEngineerYear"].ToString(); hairEngineer.HairEngineerSkill = sdr["HairEngineerSkill"].ToString(); hairEngineer.HairEngineerTagIDs = sdr["HairEngineerTagIDs"].ToString(); hairEngineer.HairEngineerPictureStoreIDs = sdr["HairEngineerPictureStoreIDs"].ToString(); hairEngineer.HairEngineerHits = int.Parse(sdr["HairEngineerHits"].ToString()); hairEngineer.HairEngineerDescription = sdr["HairEngineerDescription"].ToString(); //hairEngineer.HairEngineerOrderNum = int.Parse(sdr["HairEngineerOrderNum"].ToString()); //hairEngineer.HairEngineerRecommandNum = int.Parse(sdr["HairEngineerRecommandNum"].ToString()); hairEngineer.HairEngineerRawPrice = sdr["HairEngineerRawPrice"].ToString(); hairEngineer.HairEngineerTel = sdr["HairEngineerTel"].ToString(); hairEngineer.HairEngineerGood = int.Parse(sdr["HairEngineerGood"].ToString()); hairEngineer.HairEngineerBad = int.Parse(sdr["HairEngineerBad"].ToString()); hairEngineer.HairEngineerClassID = sdr["HairEngineerClassID"].ToString(); hairEngineer.HairEngineerClassName = sdr["HairEngineerClassID"].ToString(); hairEngineer.HairEngineerConstellation = sdr["HairEngineerConstellation"].ToString(); list.Add(hairEngineer); } } } } } return list; }
/// <summary> /// ����ʦ /// </summary> /// <param name="hairEngineer"></param> /// <param name="ua"></param> /// <returns></returns> public bool HairEngineerCreateDeleteUpdate(HairEngineer hairEngineer, UserAction ua,out int hairEngineerID) { bool result = false; string commandText = string.Empty; switch (ua) { case UserAction.Create: commandText = "insert into HairEngineer(HairEngineerAge,HairEngineerName,HairEngineerSex,HairShopID,HairEngineerYear,HairEngineerSkill,HairEngineerTagIDs,HairEngineerPictureStoreIDs,HairEngineerDescription,HairEngineerRawPrice,HairEngineerTel,HairEngineerClassID,HairEngineerConstellation,isimportant,hairengineerphotoids,HairEngineerNormal,postid) values('" + hairEngineer.HairEngineerAge + "','" + hairEngineer.HairEngineerName + "'," + hairEngineer.HairEngineerSex.ToString() + "," + hairEngineer.HairShopID.ToString() + ",'" + hairEngineer.HairEngineerYear + "','" + hairEngineer.HairEngineerSkill + "','" + hairEngineer.HairEngineerTagIDs + "','" + hairEngineer.HairEngineerPictureStoreIDs + "','" + hairEngineer.HairEngineerDescription + "','" + hairEngineer.HairEngineerRawPrice + "','" + hairEngineer.HairEngineerTel + "','" + hairEngineer.HairEngineerClassID.ToString() + "','" + hairEngineer.HairEngineerConstellation + "','" + hairEngineer.IsImportant.CompareTo(false).ToString() + "','" + hairEngineer.HairEngineerPhotoIDs + "',"+hairEngineer.HairEngineerNormal+","+hairEngineer.PostId+")"; commandText += ";select @@identity;"; break; case UserAction.Delete: commandText = "delete from HairEngineer where HairEngineerID="+hairEngineer.HairEngineerID.ToString(); break; case UserAction.Update: commandText = "update HairEngineer set HairEngineerAge='" + hairEngineer.HairEngineerAge + "',HairEngineerName='" + hairEngineer.HairEngineerName + "',HairEngineerSex=" + hairEngineer.HairEngineerSex.ToString() + ",HairShopID=" + hairEngineer.HairShopID.ToString() + ",HairEngineerYear='" + hairEngineer.HairEngineerYear + "',HairEngineerSkill='" + hairEngineer.HairEngineerSkill + "',HairEngineerTagIDs='" + hairEngineer.HairEngineerTagIDs + "',HairEngineerPictureStoreIDs='" + hairEngineer.HairEngineerPictureStoreIDs + "',HairEngineerDescription='" + hairEngineer.HairEngineerDescription + "',HairEngineerRawPrice='" + hairEngineer.HairEngineerRawPrice + "',HairEngineerTel='" + hairEngineer.HairEngineerTel + "',HairEngineerClassID='" + hairEngineer.HairEngineerClassID.ToString() + "',HairEngineerConstellation ='" + hairEngineer.HairEngineerConstellation + "',IsImportant='" + hairEngineer.IsImportant.CompareTo(false).ToString() + "',HairEngineerPhotoIDs='" + hairEngineer.HairEngineerPhotoIDs + "',HairEngineerNormal=" + hairEngineer.HairEngineerNormal+ " where HairEngineerID = " + hairEngineer.HairEngineerID.ToString(); break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commandText; comm.Connection = conn; conn.Open(); try { try { hairEngineerID = Convert.ToInt32(comm.ExecuteScalar()); } catch (InvalidCastException) { hairEngineerID = 0; } result = true; } catch (Exception ex) { throw new Exception(ex.Message); } } } if (ua == UserAction.Delete) { using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { result = false; commandText = "delete from HairEngineerRecommand where HairEngineerRawID=" + hairEngineer.HairEngineerID.ToString(); using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commandText; comm.Connection = conn; conn.Open(); try { comm.ExecuteNonQuery(); result = true; } catch (Exception ex) { throw new Exception(ex.Message); } } } } return result; }
protected void btnHairEngineerAdd_Click(object sender, EventArgs e) { if (this.txtHairEngineerTag.Text.Trim() != string.Empty) { string[] tagCondition = this.txtHairEngineerTag.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; } } } HairEngineer he = new HairEngineer(); he.HairEngineerName = txtHairEngineerName.Text.Trim(); //he.HairEngineerAge = txtHairEngineerAge.Text.Trim(); he.HairEngineerSex = int.Parse(rBtnListHairEngineerSex.SelectedValue); he.HairEngineerTel = txtHairEngineerTel.Text.Trim(); he.HairEngineerRawPrice = txtHairEngineerRawPrice.Text.Trim(); he.HairEngineerYear = txtHairEngineerYear.Text.Trim(); he.HairEngineerSkill = txtHairEngineerSkill.Text.Trim(); he.HairEngineerDescription = txtHairEngineerDescription.Text.Trim(); he.HairEngineerConstellation = this.ddlConstellation.SelectedItem.Text; he.HairEngineerClassID = txtHairEngineerClass.Text.Trim(); he.HairEngineerClassName = txtHairEngineerClass.Text.Trim(); he.HairShopID = int.Parse(ddlHairShop.SelectedValue); he.HairShopName = ddlHairShop.SelectedItem.Text; he.IsImportant = this.chkIsImportant.Checked; UpLoadClass upload = new UpLoadClass(); //he.HairEngineerPhoto = upload.UpLoadImg(fileLogo, "/uploadfiles/pictures/"); he.HairEngineerTagIDs = ""; int id = InfoAdmin.AddHairEngineer(he); he.HairEngineerID = id; string content=buildBBSContent(he); int postId = 0; BBSPost post = new BBSPost(); bool bSuc = post.AddPost(he.HairEngineerName, content, BBSPost.Category.HairEngineer, out postId); he.PostId = postId; if (bSuc) { //update postid using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairEngineer set postid=" + he.PostId.ToString() + " where HairEngineerID=" + he.HairEngineerID.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); } } } } Session["HairEngineerInfo"] = he; if (txtHairEngineerTag.Text.Trim() != string.Empty) { //TAG逻辑 string tagIDs = ""; string[] tagCollection = txtHairEngineerTag.Text.Split(",".ToCharArray()); for (int k = 0; k < tagCollection.Length; k++) { string tagID = ""; bool isExist = false; HairEngineerTag hst = new HairEngineerTag(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "select * from HairEngineerTag where HairEngineerTagName='" + 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["HairEngineerTagID"].ToString()); hst.TagName = sdr["HairEngineerTagName"].ToString(); hst.HairEngineerIDs = sdr["HairEngineerIDs"].ToString(); } catch { } } } } } if (hst.TagID == 0) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "insert HairEngineerTag(HairEngineerTagName,HairEngineerIDs) 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.HairEngineerIDs == string.Empty) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairEngineerTag set HairEngineerIDs='" + id.ToString() + "' where HairEngineerTagID=" + 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 HairEngineerTag set HairEngineerIDs=HairEngineerIDs+'," + id.ToString() + "' where HairEngineerTagID=" + 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; } } he.HairEngineerTagIDs = tagIDs; he.HairEngineerID = id; ProviderFactory.GetHairEngineerDataProviderInstance().HairEngineerCreateDeleteUpdate(he, UserAction.Update, out id); } id = he.HairEngineerID; //个人图片逻辑 string photoIDs = ""; string[] photoSmallString = lblpicsmallString.Text.Split(";".ToCharArray()); string[] photoString = lblpicSring.Text.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for(int k=0;k<photoString.Length;k++) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "insert into enginpics(picurl,picsmallurl,ownerid,classid) values('" + photoString[k] + "','"+photoSmallString[k]+"'," + id.ToString() + ",1);select @@identity;"; using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commString; comm.Connection = conn; conn.Open(); try { photoIDs += "," + comm.ExecuteScalar().ToString(); } catch (Exception ex) { throw new Exception(ex.Message); } } } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairEngineer set HairEngineerPhotoIDs = '"+photoIDs+"' where HairEngineerID=" + 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); } } } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSqlServer"].ConnectionString)) { string commString = "update HairShop set HairShopEngineerNum = HairShopEngineerNum+1 where HairShopID="+he.HairShopID.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); } } } ResetControlState(); this.Response.Redirect("HairEngineerAddSwitch.aspx?id="+id.ToString()+"&shopid="+this.ddlHairShop.SelectedItem.Value); }