/// <summary> /// ������Ӫҵ��Χ ��ӣ�ɾ������ /// </summary> /// <param name="workRange"></param> /// <param name="ua"></param> /// <returns></returns> public bool WorkRangeCreateDeleteUpdate(WorkRange workRange, UserAction ua) { bool result = false; string commandText = string.Empty; switch (ua) { case UserAction.Create: commandText = "insert into WorkRange(WorkRangeName,WorkRangeVisible) values('" + workRange.Name + "'," + workRange.IsVisible.CompareTo(false).ToString() + ")"; break; case UserAction.Delete: commandText = "delete from WorkRange where WorkRangeID=" + workRange.ID.ToString(); break; case UserAction.Update: commandText = "update WorkRange set WorkRangeName='" + workRange.Name + "',WorkRangeVisible=" + workRange.IsVisible.CompareTo(false).ToString() + " where WorkRangeID=" + workRange.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<WorkRange> GetWorkRanges() { List<WorkRange> list = new List<WorkRange>(); string commText = "select * from WorkRange order by WorkRangeID desc"; 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()) { WorkRange workRange = new WorkRange(); workRange.ID = int.Parse(sdr["WorkRangeID"].ToString()); workRange.IsVisible = Convert.ToBoolean(sdr["WorkRangeVisible"].ToString()); workRange.Name = sdr["WorkRangeName"].ToString(); list.Add(workRange); } } } } } return list; }