/// <summary> /// ͨ������ʦ�Ƽ�ID����ȡ����ʦ�Ƽ�ʵ�� /// </summary> /// <param name="hairEngineerID"></param> /// <returns></returns> public HairEngineerRecommand GetHairEngineerRecommandByHairEngineerRecommandID(int hairEngineerRecommandID) { HairEngineerRecommand hairEngineerRecommand = new HairEngineerRecommand(); using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { string commText = "select * from HairEngineerRecommand her left join HairEngineer he on her.HairEngineerRawID = he.HairEngineerID left join HairShop hs on her.HairShopID = hs.HairShopID where her.HairEngineerRecommandID =" + hairEngineerRecommandID.ToString() + " order by her.HairEngineerRecommandID desc"; using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commText; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { if (sdr.Read()) { hairEngineerRecommand.HairEngineerRecommandID = int.Parse(sdr["HairEngineerRecommandID"].ToString()); hairEngineerRecommand.HairEngineerRawID = int.Parse(sdr["HairEngineerRawID"].ToString()); hairEngineerRecommand.HairEngineerAge = sdr["HairEngineerAge"].ToString(); hairEngineerRecommand.HairEngineerName = sdr["HairEngineerName"].ToString(); //hairEngineerRecommand.HairEngineerSex = int.Parse(sdr["HairEngineerSex"].ToString()); //hairEngineerRecommand.HairEngineerPhoto = sdr["HairEngineerPhoto"].ToString(); //hairEngineerRecommand.HairShopID = int.Parse(sdr["HairShopID"].ToString()); //hairEngineerRecommand.HairShopName = sdr["HairShopName"].ToString(); //hairEngineerRecommand.HairEngineerYear = sdr["HairEngineerYear"].ToString(); //hairEngineerRecommand.HairEngineerSkill = sdr["HairEngineerSkill"].ToString(); //hairEngineerRecommand.HairEngineerTagIDs = sdr["HairEngineerTagIDs"].ToString(); //hairEngineerRecommand.HairEngineerPictureStoreIDs = sdr["HairEngineerPictureStoreIDs"].ToString(); //hairEngineerRecommand.HairEngineerHits = int.Parse(sdr["HairEngineerHits"].ToString()); //hairEngineerRecommand.HairEngineerDescription = sdr["HairEngineerDescription"].ToString(); //hairEngineerRecommand.HairEngineerOrderNum = int.Parse(sdr["HairEngineerOrderNum"].ToString()); //hairEngineerRecommand.HairEngineerRecommandNum = int.Parse(sdr["HairEngineerRecommandNum"].ToString()); //hairEngineerRecommand.HairEngineerRawPrice = sdr["HairEngineerRawPrice"].ToString(); //hairEngineerRecommand.HairEngineerPrice = sdr["HairEngineerPrice"].ToString(); //hairEngineerRecommand.HairEngineerGood = int.Parse(sdr["HairEngineerGood"].ToString()); //hairEngineerRecommand.HairEngineerBad = int.Parse(sdr["HairEngineerBad"].ToString()); //hairEngineerRecommand.HairEngineerClassID = sdr["HairEngineerClassID"].ToString(); //hairEngineerRecommand.HairEngineerClassName = sdr["HairEngineerClassID"].ToString(); hairEngineerRecommand.HairEngineerRecommandEx = sdr["HairEngineerRecommandEx"].ToString(); hairEngineerRecommand.HairEngineerRecommandInfo = sdr["HairEngineerRecommandInfo"].ToString(); } } } } return hairEngineerRecommand; }
/// <summary> /// ��ȡ����ʦ�Ƽ� /// </summary> /// <param name="count">0 ����</param> /// <returns></returns> public List<HairEngineerRecommand> GetHairEngineerRecommands(int count) { List<HairEngineerRecommand> list = new List<HairEngineerRecommand>(); string commText = ""; switch (count) { case 0: commText = "select * from HairEngineerRecommand her left join HairEngineer he on her.HairEngineerRawID = he.HairEngineerID left join HairShop hs on her.HairShopID = hs.HairShopID order by her.HairEngineerRecommandID desc"; break; default: commText = "select top " + count.ToString() + " * from HairEngineerRecommand her left join HairEngineer he on her.HairEngineerRawID = he.HairEngineerID left join HairShop hs on her.HairShopID = hs.HairShopID order by her.HairEngineerRecommandID desc"; 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()) { HairEngineerRecommand hairEngineerRecommand = new HairEngineerRecommand(); hairEngineerRecommand.HairEngineerRecommandID = int.Parse(sdr["HairEngineerRecommandID"].ToString()); hairEngineerRecommand.HairEngineerRawID = int.Parse(sdr["HairEngineerRawID"].ToString()); //hairEngineerRecommand.HairEngineerAge = sdr["HairEngineerAge"].ToString(); hairEngineerRecommand.HairEngineerName = sdr["HairEngineerName"].ToString(); //hairEngineerRecommand.HairEngineerSex = int.Parse(sdr["HairEngineerSex"].ToString()); //hairEngineerRecommand.HairEngineerPhoto = sdr["HairEngineerPhoto"].ToString(); //hairEngineerRecommand.HairShopID = int.Parse(sdr["HairShopID"].ToString()); //hairEngineerRecommand.HairShopName = sdr["HairShopName"].ToString(); //hairEngineerRecommand.HairEngineerYear = sdr["HairEngineerYear"].ToString(); //hairEngineerRecommand.HairEngineerSkill = sdr["HairEngineerSkill"].ToString(); //hairEngineerRecommand.HairEngineerTagIDs = sdr["HairEngineerTagIDs"].ToString(); //hairEngineerRecommand.HairEngineerPictureStoreIDs = sdr["HairEngineerPictureStoreIDs"].ToString(); //hairEngineerRecommand.HairEngineerHits = int.Parse(sdr["HairEngineerHits"].ToString()); //hairEngineerRecommand.HairEngineerDescription = sdr["HairEngineerDescription"].ToString(); //hairEngineerRecommand.HairEngineerOrderNum = int.Parse(sdr["HairEngineerOrderNum"].ToString()); //hairEngineerRecommand.HairEngineerRecommandNum = int.Parse(sdr["HairEngineerRecommandNum"].ToString()); //hairEngineerRecommand.HairEngineerRawPrice = sdr["HairEngineerRawPrice"].ToString(); //hairEngineerRecommand.HairEngineerPrice = sdr["HairEngineerPrice"].ToString(); //hairEngineerRecommand.HairEngineerGood = int.Parse(sdr["HairEngineerGood"].ToString()); //hairEngineerRecommand.HairEngineerBad = int.Parse(sdr["HairEngineerBad"].ToString()); //hairEngineerRecommand.HairEngineerClassID = sdr["HairEngineerClassID"].ToString(); //hairEngineerRecommand.HairEngineerClassName = sdr["HairEngineerClassID"].ToString(); hairEngineerRecommand.HairEngineerRecommandEx = sdr["HairEngineerRecommandEx"].ToString(); hairEngineerRecommand.HairEngineerRecommandInfo = sdr["HairEngineerRecommandInfo"].ToString(); list.Add(hairEngineerRecommand); } } } } } return list; }
/// <summary> /// ����ʦ�Ƽ� /// </summary> /// <param name="hairEngineerRecommand"></param> /// <param name="ua"></param> /// <returns></returns> public bool HairEngineerRecommandCreateDeleteUpdate(HairEngineerRecommand hairEngineerRecommand, UserAction ua) { bool result = false; string commandText = string.Empty; switch (ua) { case UserAction.Create: commandText = "insert into HairEngineerRecommand(HairEngineerRawID,HairEngineerAge,HairEngineerName,HairEngineerSex,HairEngineerPhoto,HairShopID,HairEngineerYear,HairEngineerSkill,HairEngineerTagIDs,HairEngineerPictureStoreIDs,HairEngineerDescription,HairEngineerRawPrice,HairEngineerPrice,HairEngineerClassID,HairEngineerRecommandEx,HairEngineerRecommandInfo) values(" + hairEngineerRecommand.HairEngineerRawID.ToString() + ",'" + hairEngineerRecommand.HairEngineerAge + "','" + hairEngineerRecommand.HairEngineerName + "'," + hairEngineerRecommand.HairEngineerSex.ToString() + ",'" + hairEngineerRecommand.HairEngineerPhoto + "'," + hairEngineerRecommand.HairShopID.ToString() + ",'" + hairEngineerRecommand.HairEngineerYear + "','" + hairEngineerRecommand.HairEngineerSkill + "','" + hairEngineerRecommand.HairEngineerTagIDs + "','" + hairEngineerRecommand.HairEngineerPictureStoreIDs + "','" + hairEngineerRecommand.HairEngineerDescription + "','" + hairEngineerRecommand.HairEngineerRawPrice + "','" + hairEngineerRecommand.HairEngineerPrice + "','" + hairEngineerRecommand.HairEngineerClassID.ToString() + "','"+hairEngineerRecommand.HairEngineerRecommandEx+"','"+hairEngineerRecommand.HairEngineerRecommandInfo+"')"; break; case UserAction.Delete: commandText = "delete from HairEngineerRecommand where HairEngineerRecommandID=" + hairEngineerRecommand.HairEngineerRecommandID.ToString(); break; case UserAction.Update: commandText = "update HairEngineerRecommand set HairEngineerRawID=" + hairEngineerRecommand.HairEngineerRawID.ToString() + ",HairEngineerAge='" + hairEngineerRecommand.HairEngineerAge + "',HairEngineerName='" + hairEngineerRecommand.HairEngineerName + "',HairEngineerSex=" + hairEngineerRecommand.HairEngineerSex.ToString() + ",HairEngineerPhoto='" + hairEngineerRecommand.HairEngineerPhoto + "',HairShopID=" + hairEngineerRecommand.HairShopID.ToString() + ",HairEngineerYear='" + hairEngineerRecommand.HairEngineerYear + "',HairEngineerSkill='" + hairEngineerRecommand.HairEngineerSkill + "',HairEngineerTagIDs='" + hairEngineerRecommand.HairEngineerTagIDs + "',HairEngineerPictureStoreIDs='" + hairEngineerRecommand.HairEngineerPictureStoreIDs + "',HairEngineerDescription='" + hairEngineerRecommand.HairEngineerDescription + "',HairEngineerRawPrice='" + hairEngineerRecommand.HairEngineerRawPrice + "',HairEngineerPrice='" + hairEngineerRecommand.HairEngineerPrice + "',HairEngineerClassID='" + hairEngineerRecommand.HairEngineerClassID.ToString() + "',HairEngineerRecommandEx='"+hairEngineerRecommand.HairEngineerRecommandEx+"',HairEngineerRecommandInfo='"+hairEngineerRecommand.HairEngineerRecommandInfo+"' where HairEngineerRecommandID = " + hairEngineerRecommand.HairEngineerRecommandID.ToString(); break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { 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; }