/// <summary> /// 添加记录操作 /// </summary> protected void AddRecord() { HttpContext context = HttpContext.Current; HttpRequest request = context.Request; HttpResponse response = context.Response; OperationLog operationLog = new OperationLog(); string addTime = request.Params["textAddTime"]; string conLogId = request.Params["textConLogId"]; string isSuccessId = request.Params["textIsSuccessId"]; string objectRecordId = request.Params["textObjectRecordId"]; string operationContent = request.Params["textOperationContent"]; string operationTable = request.Params["textOperationTable"]; string operationType = request.Params["textOperationType"]; string resultCode = request.Params["textResultCode"]; string resultMessage = request.Params["textResultMessage"]; string userId = request.Params["textUserId"]; string totalCount = request.Params["textTotalCount"]; operationLog.AddTime = DateTime.Now; if (!String.IsNullOrEmpty(conLogId)) operationLog.ConLogId = conLogId; if (!String.IsNullOrEmpty(isSuccessId)) operationLog.IsSuccessId = isSuccessId; operationLog.OperationLogId = Guid.NewGuid().ToString("N"); if (!String.IsNullOrEmpty(objectRecordId)) operationLog.ObjectRecordId = objectRecordId; if (!String.IsNullOrEmpty(operationContent)) operationLog.OperationContent = operationContent; if (!String.IsNullOrEmpty(operationTable)) operationLog.OperationTable = operationTable; if (!String.IsNullOrEmpty(operationType)) operationLog.OperationTypeCode = operationType; if (!String.IsNullOrEmpty(resultCode)) operationLog.ResultCode = Convert.ToInt32(resultCode); if (!String.IsNullOrEmpty(resultMessage)) operationLog.ResultMessage = resultMessage; if (!String.IsNullOrEmpty(userId)) operationLog.UserId = userId; if (!String.IsNullOrEmpty(totalCount)) operationLog.TotalCount = Convert.ToInt32(totalCount); ResultModel result = OperationLogBll.Insert(operationLog); string jsonString = JsonConvert.SerializeObject(result); response.Write(result); }
/// <summary> /// 根据记录主键,删除指定记录。 /// </summary> /// <param name="cardUserId">记录主键</param> /// <returns>删除结果,包括是否删除成功、记录主键等信息</returns> public static ResultModel Delete(string cardUserId) { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); try { log.OperationLogId = System.Guid.NewGuid().ToString("N"); log.UserId = CurrentSession.getUser().UserId; log.OperationTypeCode = SymbolicConstant.OPERATIONTYPE_DELETE; log.OperationContent = SymbolicConstant.OPERATIONCONTENT_DELETE; log.AddTime = DateTime.Now; log.ObjectRecordId = cardUserId; log.OperationTable = typeof(CardUser).Name; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; log.ResultCode = SymbolicConstant.RESULTCODE_DELETE_SUCCESS; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_DELETE_SUCCESS; CardUser cardUser =(CardUser)GetCardUserById(cardUserId).Data; CardUserDal.Delete(cardUser); result.IsSuccess = true; result.ObjectRecordId = cardUserId; result.ResultCode = SymbolicConstant.RESULTCODE_DELETE_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_DELETE_SUCCESS; return result; } catch (Exception exception) { log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ResultCode = SymbolicConstant.RESULTCODE_DELETE_ERROR; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ObjectRecordId = cardUserId; result.ResultCode = SymbolicConstant.RESULTCODE_DELETE_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
public static ResultModel Delete(string operationLogId) { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); try { log = (OperationLog)GetOperationLogById(operationLogId).Data; OperationLogDal.Delete(log); result.IsSuccess = true; result.ObjectRecordId = log.OperationLogId; result.ResultCode = SymbolicConstant.RESULTCODE_DELETE_SUCCESS; return result; } catch (Exception e) { System.Console.Write(e.Message); result.ResultCode = SymbolicConstant.RESULTCODE_DELETE_ERROR; result.IsSuccess = false; return result; } }
public static ResultModel GetOperationLogById(string operationLogId) { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); try { log = OperationLogDal.GetModel(operationLogId); result.Data = log; result.DataSize = 1; result.IsSuccess = true; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_SUCCESS; return result; } catch (Exception exception) { result.Data = log; result.DataSize = 1; result.IsSuccess = false; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_ERROR; result.ResultMessage = exception.Message; return result; } }
/// <summary> /// 添加一条新记录 /// </summary> /// <param name="cardUser">CardUser实体</param> /// <returns>添加结果,包括是否插入成功、记录主键等信息</returns> public static ResultModel Insert(CardUser cardUser) { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); object id = ""; try { log.OperationLogId = Guid.NewGuid().ToString("N"); log.UserId = CurrentSession.getUser().UserId; log.OperationTypeCode = SymbolicConstant.OPERATIONTYPE_INSERT; log.OperationContent = SymbolicConstant.OPERATIONCONTENT_INSERT; log.AddTime = DateTime.Now; log.OperationTable = typeof(CardUser).Name; id = CardUserDal.Insert(cardUser); log.ObjectRecordId = Convert.ToString(id); log.ResultCode = SymbolicConstant.RESULTCODE_INSERT_SUCCESS; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_INSERT_SUCCESS; result.IsSuccess = true; result.ObjectRecordId = id.ToString(); result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_INSERT_SUCCESS; return result; } catch (Exception exception) { log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ObjectRecordId = Convert.ToString(id); log.ResultCode = SymbolicConstant.RESULTCODE_INSERT_ERROR; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ObjectRecordId = id.ToString(); result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
/// <summary> /// 根据查询条件获取CardUser表中符合查询条件的记录 /// </summary> /// <param name="queryTerms">自定义查询条件</param> /// <returns>查询结果,封装了查询的数据信息</returns> public static ResultModel GetCardUserList(QueryTerms queryTerms) { List<CardUser> cardUserList = new List<CardUser>(); OperationLog log = new OperationLog(); int totalCount = 0; ResultModel result = new ResultModel(); try { log.AddTime = DateTime.Now; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; log.OperationLogId = System.Guid.NewGuid().ToString("N"); log.OperationContent = SymbolicConstant.OPERATIONCONTENT_GETLIST; log.OperationTable = typeof(CardUser).Name; log.OperationTypeCode =SymbolicConstant.OPERATIONTYPE_GETLIST; log.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_GETLIST_SUCCESS; log.UserId = CurrentSession.getUser().UserId; cardUserList = (List<CardUser>)(CardUserDal.GetList(queryTerms)); totalCount=Convert.ToInt32(SystemUserDal.GetTotalCount(queryTerms)); log.TotalCount = totalCount; result.Data = cardUserList; result.DataSize = totalCount; result.IsSuccess = true; result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_GETLIST_SUCCESS; return result; } catch (Exception exception) { log.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR; log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
/// <summary> /// 删除数据库CardUser表中的所有记录 /// </summary> /// <returns>删除结果,包括是删除成功、删除的记录数等信息</returns> public static ResultModel DeleteAll() { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); try { log.AddTime = DateTime.Now; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; log.OperationLogId = System.Guid.NewGuid().ToString("N"); log.OperationContent = SymbolicConstant.OPERATIONCONTENT_DELETEALL; log.OperationTable = typeof(CardUser).Name; log.OperationTypeCode = SymbolicConstant.OPERATIONTYPE_DELETEALL; log.ResultCode = SymbolicConstant.RESULTCODE_DELETEALL_SUCCESS; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_DELETEALL_SUCCESS; log.UserId = CurrentSession.getUser().UserId; //删除的记录数 int count=(int)WebPageDal.DeleteAll(); log.TotalCount = count; result.DataSize = count; result.IsSuccess = true; result.ResultCode = SymbolicConstant.RESULTCODE_DELETEALL_SUCCESS; result.ResultMessage=SymbolicConstant.RESULTMESSAGE_DELETEALL_SUCCESS; return result; } catch (Exception exception) { log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ResultCode = SymbolicConstant.RESULTCODE_DELETEALL_ERROR; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ResultCode = SymbolicConstant.RESULTCODE_DELETEALL_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
/// <summary> /// 修改某条记录 /// </summary> /// <param name="user">要修改记录对应的实体</param> /// <returns>修改结果,包括是否修改成功、记录主键等信息</returns> public static ResultModel Update(ServiceItem serviceItem) { OperationLog log = new OperationLog(); ResultModel result = new ResultModel(); try { log.AddTime = DateTime.Now; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; log.OperationLogId = System.Guid.NewGuid().ToString("N"); log.OperationContent = SymbolicConstant.OPERATIONCONTENT_UPDATE; log.OperationTable = typeof(ServiceItem).Name; log.OperationTypeCode = SymbolicConstant.OPERATIONTYPE_UPDATE; log.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_SUCCESS; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_UPDATE_SUCCESS; log.UserId = CurrentSession.getUser().UserId; log.ObjectRecordId = serviceItem.ItemId; ServiceItemDal.Update(serviceItem); result.IsSuccess = true; result.ObjectRecordId = serviceItem.ItemId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_UPDATE_SUCCESS; return result; } catch (Exception exception) { log.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_ERROR; log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ObjectRecordId =serviceItem.ItemId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
public static ResultModel Insert(OperationLog log) { ResultModel result = new ResultModel(); object id = ""; try { OperationLogDal.Insert(log); result.IsSuccess = true; result.ObjectRecordId = id.ToString(); result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_SUCCESS; return result; } catch (Exception exception) { result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_ERROR; result.IsSuccess = false; result.ResultMessage = exception.Message; return result; } }
public static ResultModel Update(OperationLog log) { ResultModel result = new ResultModel(); object id = new object(); try { OperationLogDal.Update(log); result.IsSuccess = true; result.ObjectRecordId = log.OperationLogId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_SUCCESS; return result; } catch (Exception exception) { result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_ERROR; result.IsSuccess = false; result.ResultMessage = exception.Message; return result; } }
/// <summary> /// 根据主键查询指定记录 /// </summary> /// <param name="userId">主键</param> /// <returns>查询结果,封装了查询出的实体</returns> public static ResultModel GetConsultationById(string consultationId) { OperationLog log = new OperationLog(); Consultation consultation = new Consultation(); ResultModel result = new ResultModel(); try { consultation = ConsultationDal.GetModel(consultationId); log.AddTime = DateTime.Now; log.OperationLogId = System.Guid.NewGuid().ToString("N"); log.OperationTypeCode = SymbolicConstant.OPERATIONTYPE_GETMODEL; log.OperationContent = SymbolicConstant.OPERATIONCONTENT_GETMODEL; log.OperationTable = typeof(Consultation).Name; log.ObjectRecordId = consultationId; log.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_SUCCESS; log.ResultMessage=SymbolicConstant.RESULTMESSAGE_GETMODEL_SUCCESS; log.UserId = CurrentSession.getUser().UserId; log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE; result.Data = consultation; result.IsSuccess = true; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_SUCCESS; result.ResultMessage=SymbolicConstant.RESULTMESSAGE_GETMODEL_SUCCESS; return result; } catch (Exception exception) { log.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_ERROR; log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE; log.ResultMessage=exception.Message; result.IsSuccess = false; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
/// <summary> /// 修改OperationLog表中的某条记录 /// </summary> /// <param name="user">要修改记录对应的实体</param> public static void Update(OperationLog operationLog) { DataAccessUtility.Update<OperationLog>(operationLog); }
/// <summary> /// 插入一条新记录 /// </summary> /// <param name="operationLog">OperationLog实体</param> /// <returns>插入记录的主键</returns> public static object Insert(OperationLog operationLog) { Object id = DataAccessUtility.Insert<OperationLog>(operationLog); return id; }
/// <summary> /// 删除OperationLog表中的某条记录 /// </summary> /// <param name="user">要删除记录的对应的实体</param> public static void Delete(OperationLog operationLog) { DataAccessUtility.Delete<OperationLog>(operationLog); }