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