public ActionResult Delete(int salesOrderStatusId) { SalesOrderStatus deletedSalesOrderStatus = shoeStoreRepository.DeleteSalesOrderStatus(salesOrderStatusId); if (deletedSalesOrderStatus != null) { TempData["message"] = MessageHelper.BuildMessage(EnumSevereLevel.Success, string.Format("{0} was deleted!", deletedSalesOrderStatus.SalesOrderStatusName)); } return(RedirectToAction("List")); }
public SalesOrderStatus DeleteSalesOrderStatus(int salesOrderStatusId) { SalesOrderStatus dbEntry = context.SalesOrderStatuss.Find(salesOrderStatusId); if (dbEntry != null) { context.SalesOrderStatuss.Remove(dbEntry); context.SaveChanges(); } return(dbEntry); }
public string GetOrderDetailsReasonInSOStatus(Stream Parameterdetails) { string JsonStringForSerialized = ""; try { SalesOrderStatus objSalesOrderStatus = new SalesOrderStatus(); JsonStringForSerialized = objSalesOrderStatus.GetOrderDetailsReasonInSOStatus(Parameterdetails); } catch { } return(JsonStringForSerialized); }
public SalesorderChangeInfo(string orderType, SalesOrderStatus status, bool isSuccessed) { this.SalesorderType = orderType; this.ChangeToStatus = status; this.IsSuccessed = isSuccessed; ChangeInfo = new Dictionary <string, object>(); ChangeInfo.Add("opTypeId", ""); ChangeInfo.Add("opDesc", ""); ChangeInfo.Add("opType", ""); }
/// <summary> /// Convert SalesOrderStatus to SalesStatus /// </summary> /// <param name="salesOrderStatus">SalesOrderStatus</param> /// <returns>SalesStatus</returns> internal static DE.SalesStatus GetSalesStatus(SalesOrderStatus salesOrderStatus) { switch (salesOrderStatus) { case SalesOrderStatus.Backorder: return(DE.SalesStatus.Created); case SalesOrderStatus.Delivered: return(DE.SalesStatus.Delivered); case SalesOrderStatus.Invoiced: return(DE.SalesStatus.Invoiced); case SalesOrderStatus.Canceled: return(DE.SalesStatus.Canceled); default: return(DE.SalesStatus.Unknown); } }
public ActionResult Edit(SalesOrderStatus salesOrderStatus) { if (ModelState.IsValid) { shoeStoreRepository.SaveSalesOrderStatus(salesOrderStatus); TempData["message"] = MessageHelper.BuildMessage(EnumSevereLevel.Success, string.Format("{0} has been created!", salesOrderStatus.SalesOrderStatusName)); return(RedirectToAction("List")); } else { //There is something wrong with the data values TempData["message"] = MessageHelper.BuildMessage(EnumSevereLevel.Error, "There is something wrong with the data values, please check!"); return(View(salesOrderStatus)); } }
protected override void ExecuteWorkflowLogic() { var fulfillSalesOrderRequest = new FulfillSalesOrderRequest() { Status = SalesOrderStatus.Get(Context.ExecutionContext), OrderClose = new Entity("orderclose") { ["subject"] = Subject.Get(Context.ExecutionContext), ["salesorderid"] = SalesOrder.Get(Context.ExecutionContext), ["actualend"] = CloseDate.Get(Context.ExecutionContext), ["description"] = Description.Get(Context.ExecutionContext) } }; Context.UserService.Execute(fulfillSalesOrderRequest); }
public void SaveSalesOrderStatus(SalesOrderStatus salesOrderStatus) { if (salesOrderStatus.SalesOrderStatusId == 0) { context.SalesOrderStatuss.Add(salesOrderStatus); } else { SalesOrderStatus dbEntry = context.SalesOrderStatuss.Find(salesOrderStatus.SalesOrderStatusId); if (dbEntry != null) { dbEntry.SalesOrderStatusName = salesOrderStatus.SalesOrderStatusName; dbEntry.IsActivated = salesOrderStatus.IsActivated; dbEntry.Sequence = salesOrderStatus.Sequence; } } context.SaveChanges(); }
/// <summary> /// 获取对应销售单下相应状态的行项信息 /// </summary> /// <param name="SOID"></param> /// <param name="Status"></param> /// <returns></returns> public List <ConSalesOrderRowInputDto> GetOrderRowsByStatus(string SOID, SalesOrderStatus Status) { var Rows = _ConSalesOrderRowReposity.GetOrderRowsByStatus(SOID, (int)Status).AsNoTracking(); var result = from Row in Rows join Cons in _SMOWMSDbContext.Consumableses on Row.CID equals Cons.CID select new ConSalesOrderRowInputDto() { CID = Row.CID, NAME = Cons.NAME, IMAGE = Cons.IMAGE, SPECIFICATION = Cons.SPECIFICATION, REALPRICE = Row.REALPRICE, QUANTSALED = Row.QUANTSALED, QUANTOUT = Row.QUANTOUT, QUANTRETREATED = Row.QUANTRETREATED }; return(result.AsNoTracking().ToList()); }
Color GetStatusColor(SalesOrderStatus status) { switch (status.description) { case "Pending" : return Color.Orange; case "In Process" : return Color.Yellow; case "Shipped" : return Color.Cyan; case "Closed" : return Color.Green; case "Canceled": return Color.Red; default : return Color.White; } }
/// <summary> /// Gets the SalesStatus from SalesOrderStatus and DocumentStatus /// </summary> /// <param name="docStatus"></param> /// <param name="salesOrderStatus"></param> /// <returns></returns> internal static SalesStatus GetSalesStatus(SalesOrderStatus salesOrderStatus, DocumentStatus docStatus) { SalesStatus salesStatus = GetSalesStatus(salesOrderStatus); switch (salesStatus) { case SalesStatus.Unknown: case SalesStatus.Created: SalesStatus documentStatus = GetSalesStatus(docStatus); if (documentStatus == SalesStatus.Unknown) { return(salesStatus); } return(documentStatus); default: return(salesStatus); } }
/// <summary> /// 初始化一个<c>SalesOrder</c>类型实例。 /// </summary> public SalesOrder() { dateCreated = DateTime.Now; status = SalesOrderStatus.Created; }
/// <summary> /// 初始化一个<c>SalesOrder</c>类型实例。 /// </summary> public SalesOrder() { dateCreated = DateTime.Now; status = SalesOrderStatus.Created; }
public SalesOrderBuilder Status(SalesOrderStatus status) { salesOrder.Status = status; return(this); }
public DataTable GetDataTable(bool isCreatedBy, SalesOrderStatus orderStatus, string incomePhoneNumber, string selectedPhoneNumber, Dictionary <string, QueryItemDomainModel> queryCollection) { #region MyRegion DataTable dt = new DataTable(); StringBuilder sqlBuilder = new StringBuilder(); ParameterCollection pc = new ParameterCollection(); sqlBuilder.Append(@" customer_basic_info.created_on as customer_create_on,pay_card_number,pay_card_period,pay_card_securitycode ,order_source=(SELECT data_value FROM custom_data_value WHERE value_id=order_source),pay_card_bank_id=(SELECT data_value FROM custom_data_value where value_id=pay_card_bank_id) ,opening_time,collection_card_number,collection_customer_name,mobile_phone,home_phone,other_phone ,collection_bank_id =(SELECT data_value FROM custom_data_value where value_id=package.collection_bank_id) ,package.idcard_number,package.owner_customer_name,charge_user_id=(select created_user_info.cn_name from user_info where user_id=charge_user_id) ,recover_time,sign_time,salesorder_basic_info.remark,need_invoice= case when pay_type='0' then '是' when pay_type='1' then '否' end ,delivery_address,delivery_receive_phonenumber,delivery_receive_customer_name,charge_time, package.bind_main_phonenumber ,package.bind_subsidiary_phonenumber,category_name, sex= case when pay_type='0' then '男' when pay_type='1' then '女' end ,salesorder_basic_info.delivery_time,salesorder_basic_info.approval_time,salesorder_basic_info.salesorder_code, customer_basic_info.customer_name ,custom_data_value.data_value,salesorder_basic_info.pay_price,pay_type= case when pay_type='0' then '分期' when pay_type='1' then '全额' when pay_type='2' then '到付' when pay_type='3' then '在线支付' end ,created_user_info.cn_name,salesorder_basic_info.created_on FROM salesorder_basic_info LEFT JOIN customer_basic_info ON salesorder_basic_info.customer_id = customer_basic_info.customer_id LEFT JOIN custom_data_value ON salesorder_basic_info.pay_idcard_type_id=custom_data_value.value_id LEFT JOIN user_info as created_user_info ON salesorder_basic_info.created_by = created_user_info.user_id LEFT JOIN salesorder_communiationpackage_info as package ON salesorder_basic_info.salesorder_id = package.salesorder_id LEFT JOIN product_category_info as product ON package.bind_communiationpackage_id = product.product_category_id WHERE 1 = 1 "); if (orderStatus != SalesOrderStatus.All) { if (orderStatus == SalesOrderStatus.Exception) { sqlBuilder.Append(@" AND is_exception = 0 "); } else { sqlBuilder.Append(@" AND now_order_status_id = $orderStatus$ and is_exception<>0"); pc.Add("orderStatus", Convert.ToInt32(orderStatus)); } } #region 根据用户名查询 if (isCreatedBy == true) { sqlBuilder.Append(@" AND salesorder_basic_info.created_by = $created_by$ "); pc.Add("created_by", SessionUtil.Current.UserId); } #endregion #region 所选号码查询条件 if (!string.IsNullOrEmpty(selectedPhoneNumber)) { sqlBuilder.Append(@" AND salesorder_basic_info.salesorder_id IN (SELECT salesorder_basic_info.salesorder_id FROM salesorder_communiationpackage_info WHERE bind_main_phonenumber = $selectedPhoneNumber$ or bind_subsidiary_phonenumber = $selectedPhoneNumber$ ) "); pc.Add("selectedPhoneNumber", selectedPhoneNumber); } #endregion #region 来电号码查询条件 if (string.IsNullOrEmpty(incomePhoneNumber) == false) { sqlBuilder.Append(@" AND customer_basic_info.customer_id IN (SELECT customer_basic_info.customer_id FROM customer_phone_info WHERE phone_number LIKE $incomePhoneNumber$)"); pc.Add("incomePhoneNumber", string.Format("%{0}%", incomePhoneNumber)); } #endregion #region 构造查询条件 int count = 0; foreach (QueryItemDomainModel item in queryCollection.Values) { switch (item.Operation) { case "equal": sqlBuilder.AppendFormat(@" AND {0} = $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "notequal": sqlBuilder.AppendFormat(@" AND {0} <> $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "contain": sqlBuilder.AppendFormat(@" AND {0} LIKE $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), "%" + item.SearchValue + "%"); break; case "greater": sqlBuilder.AppendFormat(@" AND {0} > $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "greaterequal": sqlBuilder.AppendFormat(@" AND {0} >= $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "less": sqlBuilder.AppendFormat(@" AND {0} < $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "lessequal": sqlBuilder.AppendFormat(@" AND {0} <= $value{1}$", item.FieldType, count); pc.Add("value" + count.ToString(), item.SearchValue); break; case "between": sqlBuilder.AppendFormat(@" AND {0} BETWEEN $begin{1}$ AND $end{1}$", item.FieldType, count); pc.Add("begin" + count.ToString(), item.BeginTime); pc.Add("end" + count.ToString(), item.EndTime); break; case "today": sqlBuilder.AppendFormat(@" AND DATEDIFF(DAY,{0},GETDATE()) = 0", item.FieldType); break; case "week": sqlBuilder.AppendFormat(@" AND DATEDIFF(WEEK,{0},GETDATE()) = 0", item.FieldType); break; case "month": sqlBuilder.AppendFormat(@" AND DATEDIFF(MONTH,{0},GETDATE()) = 0", item.FieldType); break; case "quarter": sqlBuilder.AppendFormat(@" AND DATEDIFF(QUARTER,{0},GETDATE()) = 0", item.FieldType); break; case "year": sqlBuilder.AppendFormat(@" AND DATEDIFF(YEAR,{0},GETDATE()) = 0", item.FieldType); break; default: break; } count++; } #endregion dt = ExecuteDataTable("SELECT " + sqlBuilder.ToString(), pc); return(dt); #endregion }
/// <summary> /// 当客户完成收货后,对销售订单进行确认。 /// </summary> public void Confirm() { this.status = SalesOrderStatus.Delivered; this.dateDelivered = DateTime.Now; }
public void Complete() { Status = SalesOrderStatus.Completed; }
internal static Expression <Func <SalesOrder, bool> > ByCustomerOrderStatus(SalesOrderStatus status) { return(o => o.OrderStatus == status); }
public void ChangeStatus(SalesOrderStatus status) { Status = status; }
public void ApprovedSalesOrderLine() { if (OrderStatus == SalesOrderStatus.Waiting) { _ApprovedBy = CurrentUser; OnChanged("ApprovedBy"); _ApprovedDate = ServerHelper.GetCurrentDateTime(); OnChanged("ApprovedDate"); _OrderStatus = SalesOrderStatus.Active; OnChanged("OrderStatus"); AddHistory("核准销售单"); SalesOrder.UpdateOrderStatus(); SalesOrder.Save(); Save(); } }
public void CancelApprovedSalesOrderLine() { if (OrderStatus == SalesOrderStatus.Active) { _ApprovedBy = ""; OnChanged("ApprovedBy"); _ApprovedDate = Convert.ToDateTime(null); OnChanged("ApprovedDate"); AddHistory("取消核准"); _OrderStatus = SalesOrderStatus.Waiting; OnChanged("OrderStatus"); SalesOrder.UpdateOrderStatus(); SalesOrder.Save(); Save(); } }
public ViewResult Edit(int salesOrderStatusId) { SalesOrderStatus SalesOrderStatus = shoeStoreRepository.SalesOrderStatuss.FirstOrDefault(p => p.SalesOrderStatusId == salesOrderStatusId); return(View(SalesOrderStatus)); }
public void UpdateBalQty() { if (IsLoading) return; _BalQty = _NeedQty - _ShipQty - _CancelQty; OnChanged("BalQty"); if (_BalQty < 0) { throw new Exception(String.Format("销售单({0}), 产品({1}) 余数不能小于0.", SalesOrder.OrderNo, Item.ItemNo)); } if (BalQty == 0 && OrderStatus != SalesOrderStatus.Complete) { _OrderStatus = SalesOrderStatus.Complete; OnChanged("OrderStatus"); SalesOrder.UpdateOrderStatus(); SalesOrder.Save(); } if (BalQty > 0 && _OrderStatus == SalesOrderStatus.Complete) { _OrderStatus = SalesOrderStatus.Active; OnChanged("OrderStatus"); SalesOrder.UpdateOrderStatus(); SalesOrder.Save(); } }