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