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