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