/// <summary>
/// ����Ƶ���ؼ��� ��ӣ�ɾ������
/// </summary>
/// <param name="hairNetTag"></param>
/// <param name="ua"></param>
/// <returns></returns>
public bool HairNetTagCreateDeleteUpdate(HairNetTag hairNetTag, UserAction ua)
{
bool result = false;
string commandText = string.Empty;
switch (ua)
{
case UserAction.Create:
commandText = "INSERT INTO HairNetTag (HairNetTagID, HairNetTagName, HairNetTagGroupID) VALUES (" + hairNetTag.TagID + ", '" + hairNetTag.TagName + "', '" + hairNetTag.HairNetTagGroupID + "')";
break;
case UserAction.Delete:
commandText = "DELETE FROM HairNetTag WHERE (HairNetTagID = " + hairNetTag.TagID + ")";
break;
case UserAction.Update:
commandText = "UPDATE HairNetTag SET HairNetTagName ='" + hairNetTag.TagName + "', HairNetTagGroupID =" + hairNetTag.HairNetTagGroupID + " WHERE (HairNetTagID = " + hairNetTag.TagID + ")";
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;
}
//����ʽ�������ݲ���д�����Ǹ��������ͼ��Ƶ������ǣ��۲��ʺ�
/// <summary>
/// ͨ��GROUPID��ȡ����Ƶ���ؼ����б�
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List<HairNetTag> GetHairNetTagsByHairNetTagGroupID(int hairNetTagGroupID)
{
List<HairNetTag> list = new List<HairNetTag>();
string commText = "SELECT * FROM HairNetTag where HairNetTagGroupID=" + hairNetTagGroupID;
using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString))
{
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = commText;
conn.Open();
using (SqlDataReader reader = comm.ExecuteReader())
{
while (reader.Read())
{
HairNetTag tag = new HairNetTag();
tag.TagID = int.Parse(reader["HairNetTagID"].ToString());
tag.TagName = reader["HairNetTagName"].ToString();
tag.HairNetTagGroupID = int.Parse (reader["HairNetTagGroupID"].ToString());
// there is no ids?
list.Add(tag);
}
}
}
}
}
return list;
}
