/// <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);
}
