/// <summary>
/// 根据输入的查询条件，从数据库中查询相应的数据。
/// </summary>
/// <param name="scCondition"></param>
/// <returns>List<rasterTable/></returns>
public static List <rasterTable> GetData(SearchCondition scCondition)
{
rasterDBEntities rsDbEntities = new rasterDBEntities();
List <rasterTable> queryReaulTables = new List <rasterTable>();
try
{
//查询条件使用三目运算符，如果用户输入的不为空，则进行查询，否则为true，不进行查询
var resultQuery = from n in rsDbEntities.rasterTable
where
((scCondition.SensorType != null) ? scCondition.SensorType == n.sensor : true) &&
(DateTime.Compare(scCondition.RsStarTime, n.rstime) <= 0) &&
(DateTime.Compare(scCondition.RsEndTime, n.rstime) >= 0) &&
((scCondition.StartRowId != null) ? scCondition.StartRowId <= n.rowID : true) &&
((scCondition.EndRowId != null) ? scCondition.EndRowId >= n.rowID : true) &&
((scCondition.StartColId != null) ? scCondition.StartColId <= n.colID : true) &&
((scCondition.EndColId != null) ? scCondition.EndColId >= n.colID : true) &&
((scCondition.CloudAge != null) ? n.cloudage < scCondition.CloudAge / 100 : true)
select n;
queryReaulTables = resultQuery.ToList();
return(queryReaulTables);
}
catch (Exception e)
{
MessageBox.Show("查询出现错误:" + e.Message);
return(queryReaulTables);
}
finally
{
rsDbEntities.Dispose();
}
}
//查询所有数据
public static List <rasterTable> GetAllData()
{
rasterDBEntities rsDbEntities = new rasterDBEntities();
List <rasterTable> queryTables = new List <rasterTable>();
try
{
queryTables = (from n in rsDbEntities.rasterTable select n).ToList();
return(queryTables);
}
catch (Exception e)
{
MessageBox.Show("查询出现错误:" + e.Message);
return(queryTables);
}
finally
{
rsDbEntities.Dispose();
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="imginfo"></param>
/// <returns></returns>
public static int AddImgData(rasterTable imginfo)
{
rasterDBEntities rsDbEntities = new rasterDBEntities();
int resultState = 0;
try
{
rsDbEntities.rasterTable.Add(imginfo);
resultState = rsDbEntities.SaveChanges();
return(resultState);
}
catch (Exception e)
{
MessageBox.Show("添加数据发生异常:" + e.Message);
return(resultState);
}
finally
{
rsDbEntities.Dispose();
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="imgTable"></param>
/// <returns></returns>
public static int DeletData(rasterTable imgTable)
{
rasterDBEntities rsEntities = new rasterDBEntities();
int resultState = 0;
try
{
rsEntities.rasterTable.Attach(imgTable);
rsEntities.rasterTable.Remove(imgTable);
resultState = rsEntities.SaveChanges();
return(resultState);
}
catch (Exception e)
{
MessageBox.Show("删除出现错误:" + e.Message);
return(resultState);
}
finally
{
rsEntities.Dispose();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="imgInfoTable"></param>
/// <returns></returns>
public static int ModifyData(rasterTable imgInfoTable)
{
rasterDBEntities rsDbEntities = new rasterDBEntities();
int resultState = 0;
try
{
//将实体附加到对象管理器中
rsDbEntities.rasterTable.Attach(imgInfoTable);
//把当前实体的状态改为Modified
rsDbEntities.Entry(imgInfoTable).State = EntityState.Modified;
resultState = rsDbEntities.SaveChanges();
return(resultState);
}
catch (Exception e)
{
MessageBox.Show("修改数据发生异常:" + e.Message);
return(resultState);
}
finally
{
rsDbEntities.Dispose();
}
}