public virtual void UpdateOrderCheckItem(OrderCheckItem entity) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateOrderCheckItem"); cmd.SetParameterValue <OrderCheckItem>(entity); cmd.ExecuteNonQuery(); }
public void UpdateOrderCheckItem(OrderCheckItemVM data, EventHandler <RestClientEventArgs <OrderCheckItemVM> > callback) { string relativeUrl = "/CustomerService/OrderCheckItem/Update"; OrderCheckItem msg = data.ConvertVM <OrderCheckItemVM, OrderCheckItem>(); restClient.Update(relativeUrl, msg, callback); }
public virtual List <OrderCheckItem> GetOrderCheckItemByQuery(OrderCheckItem queryEntity) { if (queryEntity == null) { return(null); } CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetOrderCheckItem"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder( cmd.CommandText, cmd, new PagingInfoEntity { StartRowIndex = 0, MaximumRows = int.MaxValue }, "a.SysNo DESC")) { if (!string.IsNullOrEmpty(queryEntity.ReferenceTypeIn) && string.Compare(queryEntity.ReferenceTypeIn, "'DT11','DT12'") == 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.sysno", DbType.Int32, "@sysno", QueryConditionOperatorType.Equal, queryEntity.SysNo); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ReferenceType", DbType.String, "@ReferenceType", QueryConditionOperatorType.Equal, queryEntity.ReferenceType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ReferenceContent", DbType.String, "@ReferenceContent", QueryConditionOperatorType.Equal, queryEntity.ReferenceContent); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryEntity.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Description", DbType.String, "@Description", QueryConditionOperatorType.Equal, queryEntity.Description); sqlBuilder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.ReferenceType", QueryConditionOperatorType.In, queryEntity.ReferenceTypeIn); cmd.CommandText = sqlBuilder.BuildQuerySql(); return(cmd.ExecuteEntityList <OrderCheckItem>()); } }
public virtual int DeleteOrderCheckItem(OrderCheckItem entity) { DataCommand cmd = DataCommandManager.GetDataCommand("DeleteOrderCheckItemByType"); cmd.SetParameterValue("@ReferenceType", entity.ReferenceType); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); return(cmd.ExecuteNonQuery()); }
public virtual OrderCheckItem Creat(OrderCheckItem entity) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertOrderCheckItem"); cmd.SetParameterValue <OrderCheckItem>(entity); cmd.ExecuteNonQuery(); entity.SysNo = Convert.ToInt32(cmd.GetParameterValue("@SysNo")); return(entity); }
private void CheckDeliverDateV2(SOInfo entity, OrderCheckItem csItem) { //配送信息 bool isInvalid = SOAudit.IsInValidDeliveryTime(entity, csItem.Description, m_holidays, false); if (isInvalid) { ThrowException(entity, ResourceHelper.Get("SO_Audit_InvalidDeliveryDate")); } }
public virtual int GetSACount(OrderCheckItem entity) { DataCommand cmd = DataCommandManager.GetDataCommand("GetSACount"); cmd.SetParameterValue("@BeginDate", DateTime.Parse(entity.ReferenceContent)); cmd.SetParameterValue("@EndDate", DateTime.Parse(entity.Description)); object o = cmd.ExecuteScalar(); if (o != null && o != DBNull.Value) { return(Convert.ToInt32(o)); } return(1); }
/// <summary> /// 批量创建OrderCheckItem /// </summary> /// <param name="msg"></param> /// <returns></returns> public virtual List <OrderCheckItem> BatchCreateOrderCheckItem(List <OrderCheckItem> msgs, string ReferenceType) { List <OrderCheckItem> list = new List <OrderCheckItem>(); if (msgs.Count > 0) { if (NeedDeleteKeys.IndexOf(ReferenceType) != -1) { OrderCheckItemDA.DeleteOrderCheckItem(msgs[0]); } foreach (OrderCheckItem item in msgs) { OrderCheckItem orderCheckItem = CreateOrderCheckItem(item); list.Add(orderCheckItem); } } return(list); }
public virtual void CheckOrderMaster(OrderCheckItem entity, bool status) { List <OrderCheckMaster> result = new List <OrderCheckMaster>(); result = OrderCheckMasterDA.GetCurrentOrderCheckMasterList(entity.CompanyCode); if (status) { foreach (OrderCheckMaster master in result) { if (master.CheckType.Trim() == entity.ReferenceType && master.Status == OrderCheckStatus.Invalid) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "SavePCItemError")); } } } //else //{ // if (!result.Exists(x => x.CheckType == entity.ReferenceType && x.Status == 1)) // { // throw new BusinessException("只有取消勾选“订单中使用优惠券、积分、余额和礼品卡”并保存后再全部取消勾选这一级选项,才能生效。"); // } //} }
public void UpdateOrderCheckItem(OrderCheckItem msg) { ObjectFactory <CSToolAppService> .Instance.UpdateOrderCheckItem(msg); }
public OrderCheckItem CreateOrderCheckItem(OrderCheckItem msg) { return(ObjectFactory <CSToolAppService> .Instance.CreateOrderCheckItem(msg)); }
/// <summary> /// 更新OrderCheckItem状态 /// </summary> /// <param name="msg"></param> public virtual void UpdateOrderCheckItem(OrderCheckItem msg) { ObjectFactory <OrderCheckItemProcessor> .Instance.UpdateOrderCheckItem(msg); }
/// <summary> /// 创建OrderCheckItem /// </summary> /// <param name="msg"></param> /// <returns></returns> public virtual OrderCheckItem CreateOrderCheckItem(OrderCheckItem msg) { return(ObjectFactory <OrderCheckItemProcessor> .Instance.CreateOrderCheckItem(msg)); }
private static string AMTKeys = "'1AL','2AL','3AL','4AL','5AL'"; //订单金额KEY /// <summary> /// 创建OrderCheckItem /// </summary> /// <param name="msg"></param> /// <returns></returns> public virtual OrderCheckItem CreateOrderCheckItem(OrderCheckItem msg) { if (msg.ReferenceType == "SA") { DateTime start = DateTime.Parse(msg.ReferenceContent); DateTime end = DateTime.Parse(msg.Description); if (end < start) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "DateTimeCheck")); } int i = OrderCheckItemDA.GetSACount(msg); if (i > 0) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "TimeIntervalCheck")); } } else { OrderCheckItem queryCriteriaEntity = new OrderCheckItem(); queryCriteriaEntity.ReferenceType = msg.ReferenceType; queryCriteriaEntity.ReferenceContent = msg.ReferenceContent; queryCriteriaEntity.CompanyCode = msg.CompanyCode; if (msg.ReferenceType == "PC3") { queryCriteriaEntity.Description = msg.Description; } if (msg.ReferenceType.EndsWith("AL")) { queryCriteriaEntity.ReferenceContent = null; queryCriteriaEntity.Status = msg.Status; } else if (msg.ReferenceType.StartsWith("DT")) { queryCriteriaEntity.ReferenceType = null; queryCriteriaEntity.ReferenceTypeIn = DeliveryTimeKeys; } List <OrderCheckItem> result = OrderCheckItemDA.GetOrderCheckItemByQuery(queryCriteriaEntity); if (result != null && result.Count > 0) { if (KeywordKeys.IndexOf(msg.ReferenceType) != -1) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "ExistsKeyword")); } else if (msg.ReferenceType.StartsWith("DT")) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "ExistsServiceObject")); } else if (msg.ReferenceType == "PC3") { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "ExistsProductType")); } else if (msg.ReferenceType == "PID") { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "ExistsProductSysNo")); } else if (AMTKeys.IndexOf(msg.ReferenceType) != -1 && msg.Status == OrderCheckStatus.Valid) { foreach (var item in result) { item.Status = OrderCheckStatus.Invalid; OrderCheckItemDA.UpdateOrderCheckItem(item); } } } } return(OrderCheckItemDA.Creat(msg)); }
/// <summary> /// 更新OrderCheckItem状态 /// </summary> public virtual void UpdateOrderCheckItem(OrderCheckItem msg) { if (!string.IsNullOrEmpty(msg.ReferenceType) && msg.ReferenceType.StartsWith("DT")) { OrderCheckItem queryCriteriaEntity = new OrderCheckItem(); queryCriteriaEntity.ReferenceContent = msg.ReferenceContent; queryCriteriaEntity.ReferenceType = msg.ReferenceType; List <OrderCheckItem> result = OrderCheckItemDA.GetOrderCheckItemByQuery(queryCriteriaEntity); if (result != null && result.Count > 0 && result[0].SysNo != msg.SysNo) { throw new BizException(ResouceManager.GetMessageString("Customer.OrderCheck", "ExistsOrderCheckItem")); } OrderCheckItemDA.UpdateOrderCheckItem(msg); } else if (!string.IsNullOrEmpty(msg.ReferenceType) && msg.ReferenceType == "PC") { OrderCheckItem queryCriteriaEntity = new OrderCheckItem(); queryCriteriaEntity.ReferenceType = msg.ReferenceType; List <OrderCheckItem> oldList = OrderCheckItemDA.GetOrderCheckItemByQuery(queryCriteriaEntity); if (string.IsNullOrEmpty(msg.SysNos)) //disable all { CheckOrderMaster(msg, false); foreach (var oldEntity in oldList) { if (oldEntity.Status != OrderCheckStatus.Invalid) { oldEntity.SysNo = oldEntity.SysNo; oldEntity.Status = OrderCheckStatus.Invalid; OrderCheckItemDA.UpdateOrderCheckItem(oldEntity); } } } else { CheckOrderMaster(msg, true); string[] sysNoArray = msg.SysNos.Split(','); List <int> sysNoList = new List <int>(); foreach (var item in sysNoArray) { sysNoList.Add(int.Parse(item)); } foreach (var oldEntity in oldList) { if (sysNoList.Exists(x => x == oldEntity.SysNo))//active { if (oldEntity.Status != OrderCheckStatus.Valid) { oldEntity.SysNo = oldEntity.SysNo; oldEntity.Status = OrderCheckStatus.Valid; OrderCheckItemDA.UpdateOrderCheckItem(oldEntity); } } else//disable { if (oldEntity.Status != OrderCheckStatus.Invalid) { oldEntity.SysNo = oldEntity.SysNo; oldEntity.Status = OrderCheckStatus.Invalid; OrderCheckItemDA.UpdateOrderCheckItem(oldEntity); } } } } } else { if (!string.IsNullOrEmpty(msg.ReferenceType) && AMTKeys.IndexOf(msg.ReferenceType) != -1) { OrderCheckItem queryCriteriaEntity = new OrderCheckItem(); queryCriteriaEntity.ReferenceType = msg.ReferenceType; queryCriteriaEntity.Status = msg.Status; List <OrderCheckItem> result = OrderCheckItemDA.GetOrderCheckItemByQuery(queryCriteriaEntity); if (result != null && result.Count > 0 && msg.Status == OrderCheckStatus.Valid) { foreach (var item in result) { item.Status = OrderCheckStatus.Invalid; OrderCheckItemDA.UpdateOrderCheckItem(item); } } } OrderCheckItemDA.UpdateOrderCheckItem(msg); } }