/// <summary> /// 添加记录操作 /// </summary> protected void AddRecord() { HttpContext context = HttpContext.Current; HttpRequest request = context.Request; HttpResponse response = context.Response; ConsumptionLog consumptionLog= new ConsumptionLog(); string addTime=request.Params["textAddTime"]; string cardId=request.Params["textCardId"]; string conComId=request.Params["textConComId"]; string consumerId=request.Params["textConsumerId"]; string itemId=request.Params["textItemId"]; consumptionLog.AddTime=DateTime.Now; if(!String.IsNullOrEmpty(cardId)) consumptionLog.CardId=cardId; if(!String.IsNullOrEmpty(conComId)) consumptionLog.ConComId=conComId; if(!String.IsNullOrEmpty(consumerId)) consumptionLog.ConsumerId=consumerId; if(!String.IsNullOrEmpty(itemId)) consumptionLog.ItemId=itemId; consumptionLog.LogId=Guid.NewGuid().ToString("N"); ResultModel result = ConsumptionLogBll.Insert(consumptionLog); string jsonString = JsonConvert.SerializeObject(result); response.Write(result); }
/// <summary> /// 插入一条新记录 /// </summary> /// <param name="consumptionLog">ConsumptionLog实体</param> /// <returns>插入记录的主键</returns> public static object Insert(ConsumptionLog consumptionLog) { Object id = DataAccessUtility.Insert<ConsumptionLog>(consumptionLog); return id; }
/// <summary> /// 修改ConsumptionLog表中的某条记录 /// </summary> /// <param name="user">要修改记录对应的实体</param> public static void Update(ConsumptionLog consumptionLog) { DataAccessUtility.Update<ConsumptionLog>(consumptionLog); }
/// <summary> /// 删除ConsumptionLog表中的某条记录 /// </summary> /// <param name="user">要删除记录的对应的实体</param> public static void Delete(ConsumptionLog consumptionLog) { DataAccessUtility.Delete<ConsumptionLog>(consumptionLog); }
/// <summary> /// 修改某条记录 /// </summary> /// <param name="user">要修改记录对应的实体</param> /// <param name="isLog">是否写入日志</param> /// <returns>修改结果,包括是否修改成功、记录主键等信息</returns> public static ResultModel Update(ConsumptionLog consumptionLog, bool isLog) { if (isLog) return Update(consumptionLog); ResultModel result = new ResultModel(); try { ConsumptionLogDal.Update(consumptionLog); result.IsSuccess = true; result.ObjectRecordId = consumptionLog.LogId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_UPDATE_SUCCESS; return result; } catch (Exception exception) { result.IsSuccess = false; result.ObjectRecordId =consumptionLog.LogId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_ERROR; result.ResultMessage = exception.Message; return result; } }
/// <summary> /// 修改某条记录 /// </summary> /// <param name="user">要修改记录对应的实体</param> /// <returns>修改结果,包括是否修改成功、记录主键等信息</returns> public static ResultModel Update(ConsumptionLog consumptionLog) { 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(ConsumptionLog).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 = consumptionLog.LogId; ConsumptionLogDal.Update(consumptionLog); result.IsSuccess = true; result.ObjectRecordId = consumptionLog.LogId; 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 =consumptionLog.LogId; result.ResultCode = SymbolicConstant.RESULTCODE_UPDATE_ERROR; result.ResultMessage = exception.Message; return result; } finally { OperationLogBll.Insert(log); } }
/// <summary> /// 添加一条新记录 /// </summary> /// <param name="consumptionLog">ConsumptionLog实体</param> /// <param name="isLog">是否写入日志</param> /// <returns>添加结果,包括是否插入成功、记录主键等信息</returns> public static ResultModel Insert(ConsumptionLog consumptionLog, bool isLog) { if (isLog) return Insert(consumptionLog); ResultModel result = new ResultModel(); object id = ""; try { id = ConsumptionLogDal.Insert(consumptionLog); result.IsSuccess = true; result.ObjectRecordId = id.ToString(); result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_SUCCESS; result.ResultMessage = SymbolicConstant.RESULTMESSAGE_INSERT_SUCCESS; return result; } catch (Exception exception) { result.IsSuccess = false; result.ObjectRecordId = id.ToString(); result.ResultCode = SymbolicConstant.RESULTCODE_INSERT_ERROR; result.ResultMessage = exception.Message; return result; } }
/// <summary> /// 根据主键查询指定记录 /// </summary> /// <param name="consumptionLogId">主键</param> /// <param name="isLog">是否写入日志</param> /// <returns>查询结果,封装了查询出的实体</returns> public static ResultModel GetConsumptionLogById(string consumptionLogId, bool isLog) { if (isLog) return GetConsumptionLogById(consumptionLogId); ConsumptionLog consumptionLog = new ConsumptionLog(); ResultModel result = new ResultModel(); try { consumptionLog= ConsumptionLogDal.GetModel(consumptionLogId); result.Data = consumptionLog; result.IsSuccess = true; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_SUCCESS; result.ResultMessage=SymbolicConstant.RESULTMESSAGE_GETMODEL_SUCCESS; return result; } catch (Exception exception) { result.IsSuccess = false; result.ResultCode = SymbolicConstant.RESULTCODE_GETMODEL_ERROR; result.ResultMessage = exception.Message; return result; } }