/// <summary>
/// ����ʦ��� ��ӣ�ɾ������
/// </summary>
/// <param name="hairEngineerClass"></param>
/// <param name="ua"></param>
/// <returns></returns>
public bool HairEngineerClassCreateDeleteUpdate(HairEngineerClass hairEngineerClass, UserAction ua)
{
bool result = false;
string commandText = string.Empty;
switch (ua)
{
case UserAction.Create:
commandText = "insert into HairEngineerClass(HairEngineerClassName,HairEngineerClassVisible) values('"+hairEngineerClass.Name+"','"+hairEngineerClass.IsVisible.CompareTo(false).ToString()+"')";
break;
case UserAction.Delete:
commandText = "delete from HairEngineerClass where HairEngineerClassID="+hairEngineerClass.ID.ToString();
break;
case UserAction.Update:
commandText = "update HairEngineerClass set HairEngineerClassName='"+hairEngineerClass.Name+"',HairEngineerClassVisible='"+hairEngineerClass.IsVisible.CompareTo(false).ToString()+"' where HairEngineerClassID="+hairEngineerClass.ID.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;
}
/// <summary>
/// �������ʦ����б�
/// </summary>
/// <returns></returns>
public List<HairEngineerClass> GetHairEngineerClasses()
{
List<HairEngineerClass> list = new List<HairEngineerClass>();
string commText = "select * from HairEngineerClass order by HairEngineerClassID ASC";
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())
{
HairEngineerClass hairEngineerClass = new HairEngineerClass();
hairEngineerClass.ID = int.Parse(sdr["HairEngineerClassID"].ToString());
hairEngineerClass.IsVisible = Convert.ToBoolean(sdr["HairEngineerClassVisible"].ToString());
hairEngineerClass.Name = sdr["HairEngineerClassName"].ToString();
list.Add(hairEngineerClass);
}
}
}
}
}
return list;
}
