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