public CommandResult DeleteAllWorkStations()
{
try
{
using (SqlConnection con = new SqlConnection(base.ConnectStr))
{
using (SqlCommand cmd = new SqlCommand("delete from WorkStation", con))
{
con.Open();
cmd.ExecuteNonQuery();
return(new CommandResult(ResultCode.Successful, string.Empty));
}
}
}
catch (SqlException ex)
{
Ralid.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
return(new CommandResult(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message));
}
catch (Exception ex)
{
Ralid.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
return(new CommandResult(ResultCode.Fail, ex.Message));
}
}
public QueryResultList <TInfo> GetAll()
{
QueryResultList <TInfo> result;
try
{
ParkDataContext parking = ParkDataContextFactory.CreateParking(ConnectStr);
List <TInfo> infoes = GetingAllItems(parking);
result = new QueryResultList <TInfo>(ResultCode.Successful, successMsg, infoes);
}
catch (SqlException ex)
{
result = new QueryResultList <TInfo>(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetAll()");
}
catch (Exception ex)
{
result = new QueryResultList <TInfo>(ResultCode.Fail, ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetAll()");
}
return(result);
}
public CommandResult Delete(TInfo info)
{
CommandResult result;
try
{
ParkDataContext parking = ParkDataContextFactory.CreateParking(ConnectStr);
DeletingItem(info, parking);
parking.SubmitChanges();
result = new CommandResult(ResultCode.Successful, successMsg);
}
catch (SqlException ex)
{
result = new CommandResult(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message);
ExceptionPolicy.HandleException(ex, this.GetType().FullName + "." + "Delete()");
}
catch (Exception ex)
{
result = new CommandResult(ResultCode.Fail, ex.Message);
ExceptionPolicy.HandleException(ex, this.GetType().FullName + "." + "Delete()");
}
return(result);
}
public QueryResultList <TInfo> GetItems(SearchCondition search)
{
QueryResultList <TInfo> result;
try
{
ParkDataContext parking = ParkDataContextFactory.CreateParking(ConnectStr);
if (parking == null)
{
result = new QueryResultList <TInfo>(ResultCode.CannotConnectServer, ResultCodeDecription.GetDescription(ResultCode.CannotConnectServer), new List <TInfo>());
}
else
{
List <TInfo> infoes;
if (search != null)
{
infoes = GetingItems(parking, search);
}
else
{
infoes = GetingAllItems(parking);
}
result = new QueryResultList <TInfo>(ResultCode.Successful, successMsg, infoes);
}
}
catch (SqlException ex)
{
result = new QueryResultList <TInfo>(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetItems()");
}
catch (Exception ex)
{
result = new QueryResultList <TInfo>(ResultCode.Fail, ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetItems()");
}
return(result);
}
/// <summary>
/// 获取服务器时间，如果执行失败，serverDT 返回null
/// </summary>
/// <param name="serverDT"></param>
/// <returns></returns>
public CommandResult GetServerDateTime(out DateTime?serverDT)
{
try
{
if (!string.IsNullOrEmpty(_ConnStr))
{
using (SqlConnection con = new SqlConnection(_ConnStr))
{
using (SqlCommand cmd = new SqlCommand("select getdate() ", con))
{
con.Open();
object o = cmd.ExecuteScalar();
serverDT = Convert.ToDateTime(o);
return(new CommandResult(ResultCode.Successful, string.Empty));
}
}
}
else
{
serverDT = null;
return(new CommandResult(ResultCode.Fail));
}
}
catch (SqlException ex)
{
serverDT = null;
Ralid.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
return(new CommandResult(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message));
}
catch (Exception ex)
{
serverDT = null;
Ralid.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
return(new CommandResult(ResultCode.Fail, ex.Message));
}
}
public QueryResult <TInfo> GetByID(TID id)
{
QueryResult <TInfo> result;
try
{
ParkDataContext parking = ParkDataContextFactory.CreateParking(ConnectStr);
if (parking == null)
{
result = new QueryResult <TInfo>(ResultCode.CannotConnectServer, ResultCodeDecription.GetDescription(ResultCode.CannotConnectServer), null);
}
else
{
TInfo info = GetingItemByID(id, parking);
if (info != null)
{
result = new QueryResult <TInfo>(ResultCode.Successful, successMsg, info);
}
else
{
result = new QueryResult <TInfo>(ResultCode.Fail, ResultCodeDecription.GetDescription(ResultCode.Fail), info);
}
}
}
catch (SqlException ex)
{
result = new QueryResult <TInfo>(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message, null);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetByID()");
}
catch (Exception ex)
{
result = new QueryResult <TInfo>(ResultCode.Fail, ex.Message, null);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetByID()");
}
return(result);
}
