/// <summary> /// 修改团款结算单(确认确认金额) /// </summary> /// <param name="order">团队确认单</param> /// <param name="orderChange">订单变更</param> /// <returns> 0:修改失败 1:修改成功</returns> public bool UpdateOrderSettlement(MOrderSaleBase order, MTourOrderChange orderChange) { if (!CheckTourOrderChange(orderChange)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } else if (string.IsNullOrEmpty(order.ConfirmPeopleId) || string.IsNullOrEmpty(order.CompanyId)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } else { //order.ConfirmMoneyStatus = true; int flg = dal.UpdateOrderSettlement(order, orderChange); if (flg == 1) { //添加操作日志 StringBuilder str = new StringBuilder(); str.AppendFormat((order.ConfirmMoneyStatus ? "确认" : "保存") + "订单的确认金额,订单编号:{0},确认金额:{1}", order.OrderId, order.ConfirmMoney); EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString()); return(true); } } return(false); }
/// <summary> /// 退团事件 /// </summary> /// <returns></returns> private string PageSave() { string msg = string.Empty; #region 获取表单 string travellerId = Utils.GetQueryStringValue("id"); string travellerName = Utils.GetFormValue(this.txt_reBackName.UniqueID); EyouSoft.Model.EnumType.GovStructure.Gender travellerSex = Utils.GetFormValue(this.rad_Man.UniqueID) == "0" ? EyouSoft.Model.EnumType.GovStructure.Gender.男 : EyouSoft.Model.EnumType.GovStructure.Gender.女; DateTime leaveDate = Utils.GetDateTime(Utils.GetFormValue(this.txt_reBackDate.UniqueID)); decimal reBackMoney = Utils.GetDecimal(Utils.GetFormValue(this.txt_reBackMoney.UniqueID)); string reMarkMoney = Utils.GetFormValue(this.txt_reMarkMoney.UniqueID); string reBackResion = Utils.GetFormValue(this.txt_ReBackResion.UniqueID); string tourId = Utils.GetQueryStringValue("tourId"); string orderId = Utils.GetQueryStringValue("orderId"); #endregion #region 游客实体类 BTourOrder bll = new BTourOrder(); MTourOrderTraveller travellerModel = bll.GetTourOrderTravellerById(travellerId); travellerModel.TravellerId = travellerId; travellerModel.TravellerStatus = EyouSoft.Model.EnumType.TourStructure.TravellerStatus.退团; travellerModel.RTime = leaveDate; travellerModel.RAmountRemark = reMarkMoney; travellerModel.RAmount = reBackMoney; travellerModel.OrderId = orderId; travellerModel.CnName = travellerName; travellerModel.TravellerId = travellerId; travellerModel.RRemark = reBackResion; #endregion #region 订单变更表实体类 MTourOrderChange Model_Chang = new MTourOrderChange(); Model_Chang.CompanyId = SiteUserInfo.CompanyId; Model_Chang.TourId = tourId; Model_Chang.ChangePerson = 1; Model_Chang.ChangePrice = reBackMoney; Model_Chang.IssueTime = DateTime.Now; Model_Chang.Operator = SiteUserInfo.Name; Model_Chang.OrderId = travellerModel.OrderId; Model_Chang.Content = "申请退团"; #endregion #region 执行更改 bool result = bll.UpdateTourOrderTraveller(travellerModel, Model_Chang); if (result) { msg = UtilsCommons.AjaxReturnJson("1", "退团成功!"); } else { msg = UtilsCommons.AjaxReturnJson("0", "退团失败!"); } return(msg); #endregion }
/// <summary> /// 判断MTourOrderChange记录的实体 /// </summary> /// <param name="change"></param> /// <returns></returns> private bool CheckTourOrderChange(MTourOrderChange change) { if (change != null) { if (string.IsNullOrEmpty(change.CompanyId) || string.IsNullOrEmpty(change.TourId) || string.IsNullOrEmpty(change.OrderId)) { return(false); } } return(true); }
/// <summary> /// 游客退团 /// </summary> /// <param name="traveller">游客实体</param> /// <param name="change">订单修改、变更实体</param> /// <returns></returns> public bool UpdateTourOrderTraveller(MTourOrderTraveller traveller, MTourOrderChange change) { if (string.IsNullOrEmpty(traveller.TravellerId) || string.IsNullOrEmpty(traveller.OrderId)) { throw new System.Exception("bll error:id为null或string.IsNullOrEmpty(id)==true。"); } if (!CheckTourOrderChange(change)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } return(dal.UpdateTourOrderTraveller(traveller, change) == 1 ? true : false); }
private void SaveData() { #region 表单取值 string msg = ""; bool result = false; Response.Clear(); decimal addCost = Utils.GetDecimal(Utils.GetFormValue(txtAddCost.UniqueID)); decimal reduceCost = Utils.GetDecimal(Utils.GetFormValue(txtReduceCost.UniqueID)); decimal confirmSettlementMoney = Utils.GetDecimal(Utils.GetFormValue(txtSettlementMoney.UniqueID)); decimal profit = Utils.GetDecimal(Utils.GetFormValue(txtProfit.UniqueID)); #endregion #region 提交回应 //订单的结算费用信息 MOrderSettlement orderModel = new MOrderSettlement(); orderModel.OrderId = Utils.GetFormValue(hidorderID.UniqueID); orderModel.SettlementPeople = this.SiteUserInfo.Name; orderModel.SettlementPeopleId = this.SiteUserInfo.UserId; orderModel.PeerAddCost = addCost; orderModel.PeerReduceCost = reduceCost; orderModel.PeerAddCostRemark = Utils.GetFormValue(txtAddCostRemark.UniqueID); orderModel.PeerReduceCostRemark = Utils.GetFormValue(txtReduceCostRemark.UniqueID); orderModel.ConfirmSettlementMoney = confirmSettlementMoney; orderModel.ConfirmMoneyStatus = Utils.GetFormValue(hidConfirmMoneyStatus.UniqueID) == "T" ? true : false; orderModel.ConfirmMoney = Utils.GetDecimal(Utils.GetFormValue(hidConfirmMoney.UniqueID)); orderModel.Profit = profit; //订单变更 MTourOrderChange orderChangeModel = null; if (new EyouSoft.BLL.TourStructure.BTourOrder().UpdateOrderSettlement(orderModel, orderChangeModel)) { result = true; msg = "成功!"; } else { result = false; msg = "失败!"; } Response.Clear(); Response.Write("{\"result\":\"" + result + "\",\"msg\":\"" + msg + "\"}"); Response.End(); #endregion }
/// <summary> /// 修改订单的结算单(确认结算金额) /// </summary> /// <param name="order"></param> /// <param name="orderChange"></param> /// <returns> 1:成功 0:失败</returns> public bool UpdateOrderSettlement(MOrderSettlement order, MTourOrderChange orderChange) { if (!CheckTourOrderChange(orderChange)) { throw new System.Exception("bll error:id为null或string.IsNullOrEmpty(id)==true。"); } /*else if (order.ConfirmSettlementMoney == 0 || order.ConfirmMoney == 0 || string.IsNullOrEmpty(order.SettlementPeopleId)) * { * throw new System.Exception("bll error:查询Money为0或SettlementPeopleId为null或string.IsNullOrEmpty(SettlementPeopleId)==true。"); * }*/ else if (string.IsNullOrEmpty(order.SettlementPeopleId)) { throw new System.Exception("bll error:string.IsNullOrEmpty(SettlementPeopleId)==true。"); } else { if (order.ConfirmMoneyStatus == false) { return(false); } else { order.Profit = order.ConfirmMoney - order.ConfirmSettlementMoney; int flg = dal.UpdateOrderSettlement(order, orderChange); if (flg == 1) { //添加操作日志 StringBuilder str = new StringBuilder(); str.AppendFormat("修改订单的结算金额:{0},订单编号:{1}", order.ConfirmSettlementMoney, order.OrderId); EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString()); return(true); } } } return(false); }
/// <summary> /// 修改订单状态 /// </summary> /// <param name="orderId">订单编号</param> /// <param name="orderStatus">订单状态</param> /// <param name="change">变更修改的实体</param> /// <returns>失败 成功</returns> public int UpdateTourOrderExpand(string orderId, OrderStatus orderStatus, MTourOrderChange change) { if (string.IsNullOrEmpty(orderId)) { return(0); } if (!CheckTourOrderChange(change)) { return(-1); } int dalRetCode = dal.UpdateTourOrderExpand(orderId, orderStatus, change); if (dalRetCode == 1) { //添加操作日志 StringBuilder str = new StringBuilder(); str.AppendFormat("修改订单的状态为:{0},订单编号:{1}", orderStatus, orderId); EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString()); } return(dalRetCode); }
/// <summary> /// 根据订单的编号、(修改或变更)获取订单变更列表 /// </summary> /// <param name="OrderId">订单编号</param> /// <param name="changeType">变更或修改</param> /// <returns></returns> public IList <MTourOrderChange> GetTourOrderChangeList(string OrderId, ChangeType?changeType) { IList <MTourOrderChange> list = null; StringBuilder query = new StringBuilder(); query.Append(" SELECT "); query.Append("Id,CompanyId,TourId,RouteId,RouteName,TourSaleId,TourSale,OrderId,OrderCode"); query.Append(",ChangePerson,ChangePrice,OrderSaleId,OrderSale,Content,OperatorId"); query.Append(",Operator,IssueTime,ChangeType,IsSure,SurePersonId,SurePerson,SureTime"); query.Append(" FROM "); query.Append("tbl_TourOrderChange"); query.Append(" Where "); query.AppendFormat("OrderId='{0}'", OrderId); if (changeType.HasValue) { query.AppendFormat(" and ChangeType={0}", (int)changeType.Value); } DbCommand cmd = _db.GetSqlStringCommand(query.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, _db)) { if (dr != null) { list = new List <MTourOrderChange>(); while (dr.Read()) { MTourOrderChange change = new MTourOrderChange(); change.Id = dr.GetString(dr.GetOrdinal("Id")); change.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); change.TourId = dr.GetString(dr.GetOrdinal("TourId")); change.RouteId = !dr.IsDBNull(dr.GetOrdinal("RouteId")) ? dr.GetString(dr.GetOrdinal("RouteId")) : string.Empty; change.RouteName = !dr.IsDBNull(dr.GetOrdinal("RouteName")) ? dr["RouteName"].ToString() : string.Empty; change.TourSaleId = dr.GetString(dr.GetOrdinal("TourSaleId")); change.TourSale = !dr.IsDBNull(dr.GetOrdinal("TourSale")) ? dr["TourSale"].ToString() : string.Empty; change.OrderId = dr.GetString(dr.GetOrdinal("OrderId")); change.OrderCode = !dr.IsDBNull(dr.GetOrdinal("OrderCode")) ? dr.GetString(dr.GetOrdinal("OrderCode")) : string.Empty; change.ChangePerson = dr.GetInt32(dr.GetOrdinal("ChangePerson")); change.ChangePrice = dr.GetDecimal(dr.GetOrdinal("ChangePrice")); change.OrderSaleId = dr.GetString(dr.GetOrdinal("OrderSaleId")); change.OrderSale = !dr.IsDBNull(dr.GetOrdinal("OrderSale")) ? dr["OrderSale"].ToString() : string.Empty; change.Content = !dr.IsDBNull(dr.GetOrdinal("Content")) ? dr["Content"].ToString() : string.Empty; change.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")); change.Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr["Operator"].ToString() : string.Empty; change.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); change.ChangeType = (ChangeType)dr.GetByte(dr.GetOrdinal("ChangeType")); change.IsSure = dr.GetString(dr.GetOrdinal("IsSure")) == "1" ? true : false; change.SurePersonId = !dr.IsDBNull(dr.GetOrdinal("SurePersonId")) ? dr.GetString(dr.GetOrdinal("SurePersonId")) : string.Empty; change.SurePerson = !dr.IsDBNull(dr.GetOrdinal("SurePerson")) ? dr.GetString(dr.GetOrdinal("SurePerson")) : string.Empty;; change.SureTime = !dr.IsDBNull(dr.GetOrdinal("SureTime")) ? dr.GetDateTime(dr.GetOrdinal("SureTime")) : (DateTime?)null; list.Add(change); } } } return(list); }
/// <summary> /// 查询获取订单变更列表 分页 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="changeType">变更 OR 修改</param> /// <param name="pageSize">每页显示的条数</param> /// <param name="pageindex">当前页</param> /// <param name="recordCount">总记录数</param> /// <param name="DetpIds">部门</param> /// <param name="isOnlySeft"></param> /// <param name="LoginUserId">当前登录员编号</param> /// <returns></returns> public IList <MTourOrderChange> GetTourOrderChangeList(string CompanyId , ChangeType?changeType , int pageSize , int pageindex , ref int recordCount , int[] DetpIds , bool isOnlySeft , string LoginUserId) { IList <MTourOrderChange> list = null; StringBuilder query = new StringBuilder(); query.AppendFormat(" CompanyId='{0}' ", CompanyId); if (changeType.HasValue) { query.AppendFormat(" and ChangeType={0}", (int)changeType.Value); } StringBuilder field = new StringBuilder(); field.Append("Id,CompanyId,TourId,RouteId,RouteName,TourSaleId"); field.Append(",TourSale,OrderId,OrderCode,ChangePerson,ChangePrice"); field.Append(",OrderSaleId,OrderSale,Content,OperatorId,Operator,IssueTime"); field.Append(",ChangeType,IsSure,SurePersonId,SurePerson,SureTime"); //权限控制 控制派团给计调时指定的计调员 if (isOnlySeft) { query.AppendFormat(" and exists(select 1 from tbl_TourPlaner where PlanerId='{0}' and TourId=tbl_TourOrderChange.TourId)", LoginUserId); } else { if (DetpIds != null) { query.AppendFormat(" and exists(select 1 from tbl_TourPlaner where DeptId in ({0}) and TourId=tbl_TourOrderChange.TourId)", GetIdsByArr(DetpIds)); } } using (IDataReader dr = DbHelper.ExecuteReader(_db, pageSize, pageindex, ref recordCount , "tbl_TourOrderChange" , "TourId" , field.ToString() , query.ToString() , "IssueTime desc")) if (dr != null) { list = new List <MTourOrderChange>(); while (dr.Read()) { MTourOrderChange change = new MTourOrderChange(); change.Id = dr.GetString(dr.GetOrdinal("Id")); change.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); change.TourId = dr.GetString(dr.GetOrdinal("TourId")); change.RouteId = !dr.IsDBNull(dr.GetOrdinal("RouteId")) ? dr.GetString(dr.GetOrdinal("RouteId")) : string.Empty; change.RouteName = !dr.IsDBNull(dr.GetOrdinal("RouteName")) ? dr["RouteName"].ToString() : string.Empty; change.TourSaleId = dr.GetString(dr.GetOrdinal("TourSaleId")); change.TourSale = !dr.IsDBNull(dr.GetOrdinal("TourSale")) ? dr["TourSale"].ToString() : string.Empty; change.OrderId = dr.GetString(dr.GetOrdinal("OrderId")); change.OrderCode = !dr.IsDBNull(dr.GetOrdinal("OrderCode")) ? dr.GetString(dr.GetOrdinal("OrderCode")) : string.Empty; change.ChangePerson = dr.GetInt32(dr.GetOrdinal("ChangePerson")); change.ChangePrice = dr.GetDecimal(dr.GetOrdinal("ChangePrice")); change.OrderSaleId = dr.GetString(dr.GetOrdinal("OrderSaleId")); change.OrderSale = !dr.IsDBNull(dr.GetOrdinal("OrderSale")) ? dr["OrderSale"].ToString() : string.Empty; change.Content = !dr.IsDBNull(dr.GetOrdinal("Content")) ? dr["Content"].ToString() : string.Empty; change.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")); change.Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr["Operator"].ToString() : string.Empty; change.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); change.ChangeType = (ChangeType)dr.GetByte(dr.GetOrdinal("ChangeType")); change.IsSure = dr.GetString(dr.GetOrdinal("IsSure")) == "1" ? true : false; change.SurePersonId = !dr.IsDBNull(dr.GetOrdinal("SurePersonId")) ? dr.GetString(dr.GetOrdinal("SurePersonId")) : string.Empty; change.SurePerson = !dr.IsDBNull(dr.GetOrdinal("SurePerson")) ? dr.GetString(dr.GetOrdinal("SurePerson")) : string.Empty;; change.SureTime = !dr.IsDBNull(dr.GetOrdinal("SureTime")) ? dr.GetDateTime(dr.GetOrdinal("SureTime")) : (DateTime?)null; list.Add(change); } } return(list); }
/* #region 修改订单合同号 * /// <summary> * /// 修改订单合同号 * /// </summary> * /// <param name="orderId">订单编号</param> * /// <param name="contractCode">合同号</param> * /// <param name="contractCodeId">合同号编号</param> * /// <returns>0:失败 1:成功</returns> * public int UpdateTourOrderContaract(string orderId, string contractCode, string contractCodeId) * { * if (string.IsNullOrEmpty(orderId)) return 0; * * bool dalRetCode = dal.UpdateTourOrderContaract(orderId, contractCode, contractCodeId); * if (dalRetCode) * { * //添加操作日志 * StringBuilder str = new StringBuilder(); * str.AppendFormat("修改订单的合同号为:{0},订单编号:{1}", contractCode, orderId); * EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString()); * } * * return dalRetCode?1:0; * } #endregion*/ #region 修改订单状态(用于供应商处理订单) /// <summary> /// 修改订单状态 /// </summary> /// <param name="orderId">订单编号</param> /// <param name="orderStatus">订单状态</param> /// <param name="saveSeatDate">继续留位时间</param> /// <param name="change">订单变更的实体</param> /// <param name="plan">计调信息</param> /// <returns>0:失败 1:成功</returns> public bool UpdateTourOrderExpand(string orderId, OrderStatus orderStatus, DateTime?saveSeatDate, MTourOrderChange change, EyouSoft.Model.PlanStructure.MPlanBaseInfo plan) { if (string.IsNullOrEmpty(orderId)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } if (!CheckTourOrderChange(change)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } if (orderStatus == OrderStatus.已留位) { if (!saveSeatDate.HasValue) { throw new System.Exception("bll error:留位时间不能为空!"); } } if (orderStatus == OrderStatus.已成交) { if (plan == null || string.IsNullOrEmpty(plan.CompanyId) || string.IsNullOrEmpty(plan.TourId) || string.IsNullOrEmpty(plan.SourceName)) { throw new System.Exception("bll error:查询id为null或string.IsNullOrEmpty(id)==true。"); } } int flg = dal.UpdateTourOrderExpand(orderId, orderStatus, saveSeatDate, change, plan); if (flg == 1) { //添加操作日志 StringBuilder str = new StringBuilder(); str.AppendFormat("供应商修改订单的状态为:{0},订单编号:{1}", orderStatus, orderId); EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString()); if (plan != null) { SysStructure.BSysLogHandle.Insert(string.Format("新增计调编号:{0}、计调类型:{1}的计调项目。", plan.PlanId, plan.Type)); } return(true); } return(false); }