/// <summary>
/// 根据团队编号获取酒店列表
/// </summary>
/// <param name="TourId">团队编号</param>
/// <param name="CompanyId">公司ID</param>
/// <param name="isAll">是否显示所有计调项目(注意:在报帐的页面根据,系统配置是否显示全部[true],否则只显示导游现付[false])</param>
/// <returns></returns>
public IList <EyouSoft.Model.PlanStructure.MPlanHotel> GetHotelList(string TourId, string CompanyId, bool isAll)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" select a.PlanId,TourId,SourceId,[Type],SalePlus,SaleCut,GuidePlus,GuideCut,PlanerPlus,PlanerCut,TotalCosts,(select * from tbl_PlanHotelTime where a.PlanId=PlanId for xml path,root('root')) as HotelTimeXml, ");
strSQL.Append(" SourceName,(select * from tbl_PlanHotelRoom where a.PlanId=PlanId for xml path,root('root')) as HotelRoomXml,FreeAmount,IsMeal,");
strSQL.Append(" PlanCost,PaymentType,Status ");
strSQL.Append(" from tbl_Plan as a,tbl_PlanHotel as b ");
strSQL.Append(" where a.PlanId=b.PlanId and [Type]=1 and TourId='@TourId' and CompanyId='@CompanyId'");
if (!isAll)
{
strSQL.Append(" and PaymentType=3 ");
}
DbCommand cmd = db.GetSqlStringCommand(strSQL.ToString());
db.AddInParameter(cmd, "TourId", DbType.String, TourId);
db.AddInParameter(cmd, "CompanyId", DbType.String, CompanyId);
IList <EyouSoft.Model.PlanStructure.MPlanHotel> list = new List <EyouSoft.Model.PlanStructure.MPlanHotel>();
EyouSoft.Model.PlanStructure.MPlanHotel model = null;
using (IDataReader reader = DbHelper.ExecuteReader(cmd, db))
{
while (reader.Read())
{
model = new EyouSoft.Model.PlanStructure.MPlanHotel()
{
PlanId = reader["PlanId"].ToString(),
TourId = reader["TourId"].ToString(),
SourceId = reader["SourceId"].ToString(),
Type = (EyouSoft.Model.EnumType.PlanStructure.PlanProject)reader.GetByte(reader.GetOrdinal("Type")),
PlanHotelTimeList = GetHotelTimeList(reader.IsDBNull(reader.GetOrdinal("HotelTimeXml")) ? string.Empty : reader["HotelTimeXml"].ToString()),
SourceName = reader.IsDBNull(reader.GetOrdinal("SourceName")) ? string.Empty : reader["SourceName"].ToString(),
PlanHotelRoomList = GetHotelRoomList(reader.IsDBNull(reader.GetOrdinal("HotelRoomXml")) ? string.Empty : reader["HotelRoomXml"].ToString()),
FreeAmount = reader.GetDecimal(reader.GetOrdinal("FreeAmount")),
IsMeal = (EyouSoft.Model.EnumType.PlanStructure.PlanHotelIsMeal)reader.GetByte(reader.GetOrdinal("IsMeal")),
PlanCost = reader.GetDecimal(reader.GetOrdinal("PlanCost")),
SalePlus = reader.GetDecimal(reader.GetOrdinal("SalePlus")),
SaleCut = reader.GetDecimal(reader.GetOrdinal("SaleCut")),
GuidePlus = reader.GetDecimal(reader.GetOrdinal("GuidePlus")),
GuideCut = reader.GetDecimal(reader.GetOrdinal("GuideCut")),
PlanerPlus = reader.GetDecimal(reader.GetOrdinal("PlanerPlus")),
PlanerCut = reader.GetDecimal(reader.GetOrdinal("PlanerCut")),
TotalCosts = reader.GetDecimal(reader.GetOrdinal("TotalCosts")),
PaymentType = (EyouSoft.Model.EnumType.PlanStructure.Payment)reader.GetByte(reader.GetOrdinal("PaymentType")),
Status = (EyouSoft.Model.EnumType.PlanStructure.PlanState)reader.GetByte(reader.GetOrdinal("Status"))
};
list.Add(model); model = null;
}
reader.Close();
};
return(list);
}
/// <summary>
/// 添加或更新数据处理
/// </summary>
/// <param name="model">信息实体</param>
/// <param name="isAdd">true:添加，false:更新</param>
/// <returns>true:成功，false:失败</returns>
private bool HotelAddOrUpdate(EyouSoft.Model.PlanStructure.MPlanHotel model, bool isAdd)
{
bool IsResult = false;
if (model != null)
{
DbCommand cmd = null;
if (isAdd)
{
cmd = db.GetStoredProcCommand("proc_PlanHotel_Add");
db.AddInParameter(cmd, "PlanId", DbType.String, model.PlanId);
db.AddInParameter(cmd, "CompanyId", DbType.String, model.CompanyId);
db.AddInParameter(cmd, "TourId", DbType.String, model.TourId);
db.AddInParameter(cmd, "AddStatus", DbType.AnsiStringFixedLength, (int)model.AddStatus);
}
else
{
cmd = db.GetStoredProcCommand("proc_PlanHotel_Update");
db.AddInParameter(cmd, "PlanId", DbType.String, model.PlanId);
}
db.AddInParameter(cmd, "SourceId", DbType.String, model.SourceId);
db.AddInParameter(cmd, "SourceName", DbType.String, model.SourceName);
db.AddInParameter(cmd, "PlanCost", DbType.Decimal, model.PlanCost);
db.AddInParameter(cmd, "PaymentType", DbType.AnsiStringFixedLength, (int)model.PaymentType);
db.AddInParameter(cmd, "Status", DbType.AnsiStringFixedLength, (int)model.Status);
db.AddInParameter(cmd, "GuideNotes", DbType.String, model.GuideNotes);
db.AddInParameter(cmd, "Remarks", DbType.String, model.Remarks);
db.AddInParameter(cmd, "OperatorId", DbType.String, model.OperatorID);
db.AddInParameter(cmd, "OperatorName", DbType.String, model.OperatorName);
db.AddInParameter(cmd, "IsRebate", DbType.String, model.IsRebate == true ? 1 : 0);
db.AddInParameter(cmd, "SueId", DbType.String, model.SueId);
db.AddInParameter(cmd, "TotalCosts", DbType.Decimal, model.TotalCosts);
db.AddInParameter(cmd, "Days", DbType.Int32, model.Days);
db.AddInParameter(cmd, "Star", DbType.AnsiStringFixedLength, (int)model.Star);
db.AddInParameter(cmd, "FreeNumber", DbType.Int32, model.FreeNumber);
db.AddInParameter(cmd, "FreeAmount", DbType.Decimal, model.FreeAmount);
db.AddInParameter(cmd, "IsMeal", DbType.AnsiStringFixedLength, (int)model.IsMeal);
db.AddInParameter(cmd, "MealPrice", DbType.Decimal, model.MealPrice);
db.AddInParameter(cmd, "MealNumber", DbType.Int32, model.MealNumber);
db.AddInParameter(cmd, "MealFrequency", DbType.Int32, model.MealFrequency);
db.AddInParameter(cmd, "HotelRoom", DbType.String, GetHotelRoom(model.PlanHotelRoomList));
db.AddInParameter(cmd, "HotelTime", DbType.String, GetHotelTime(model.PlanHotelTimeList));
db.AddOutParameter(cmd, "IsResult", DbType.Int32, 4);
DbHelper.RunProcedure(cmd, db);
IsResult = Convert.ToInt32(db.GetParameterValue(cmd, "IsResult")) == 1 ? true : false;
}
return(IsResult);
}
/// <summary>
/// 修改酒店信息
/// </summary>
/// <param name="model">信息实体</param>
/// <returns>true:成功，false:失败</returns>
public bool UpdateHotel(EyouSoft.Model.PlanStructure.MPlanHotel model)
{
if (model != null)
{
if (string.IsNullOrEmpty(model.TourId))
{
return(false);
}
if (dal.UpdateHotel(model))
{
new EyouSoft.BLL.PlanStructure.BPlan().UpdatePlanStatus(EyouSoft.Security.Membership.UserProvider.GetUserInfo().CompanyId, model.TourId, EyouSoft.Model.EnumType.PlanStructure.PlanProject.酒店);
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("修改酒店安排，酒店名称:{0}，支出金额:{1}，计调编号:{2}", model.SourceName, model.PlanCost, model.PlanId);
BSysLogHandle.Insert(strLog.ToString());
return(true);
}
}
return(false);
}
/// <summary>
/// 添加酒店信息
/// </summary>
/// <param name="model">信息实体</param>
/// <returns>true:成功，false:失败</returns>
public bool AddHotel(EyouSoft.Model.PlanStructure.MPlanHotel model)
{
if (model != null)
{
if (string.IsNullOrEmpty(model.TourId))
{
return(false);
}
model.PlanId = System.Guid.NewGuid().ToString();
if (dal.AddHotel(model))
{
new EyouSoft.BLL.PlanStructure.BPlan().UpdatePlanStatus(model.CompanyId, model.TourId, EyouSoft.Model.EnumType.PlanStructure.PlanProject.酒店);
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("新增酒店安排，酒店名称:{0}，支出金额:{1}，计调编号:{2}", model.SourceName, model.PlanCost, model.PlanId);
BSysLogHandle.Insert(strLog.ToString());
return(true);
}
}
return(false);
}
/// <summary>
/// 根据计调ID获取酒店实体
/// </summary>
/// <param name="PlanID">计调ID</param>
/// <returns>返回model</returns>
public EyouSoft.Model.PlanStructure.MPlanHotel GetHotelModel(string PlanID)
{
string strHotel = "select a." + strPlan + ",Days,Star,FreeNumber,FreeAmount,IsMeal,MealPrice,MealNumber,MealFrequency ,(select RoomId,RoomType,UnitPrice,Quantity from tbl_PlanHotelRoom as row where PlanId=a.PlanId for xml path,root('root')) as HotelRoomXml ,(select CheckTime,LeaveTime,Days from tbl_PlanHotelTime as row where PlanId=a.PlanId for xml path,root('root')) as HotelTimeXml from tbl_Plan as a,tbl_PlanHotel as b where a.PlanId=b.PlanId and a.PlanId='@PlanId'";
EyouSoft.Model.PlanStructure.MPlanHotel model = null;
DbCommand cmd = db.GetSqlStringCommand(strHotel);
db.AddInParameter(cmd, "PlanID", DbType.String, PlanID);
using (IDataReader reader = DbHelper.ExecuteReader(cmd, db))
{
while (reader.Read())
{
model = new EyouSoft.Model.PlanStructure.MPlanHotel()
{
CompanyId = reader["CompanyId"].ToString(),
Confirmation = reader.GetDecimal(reader.GetOrdinal("Confirmation")),
CostId = reader.IsDBNull(reader.GetOrdinal("CostId")) ? string.Empty : reader["CostId"].ToString(),
CostRemarks = reader.IsDBNull(reader.GetOrdinal("CostRemarks")) ? string.Empty : reader["CostRemarks"].ToString(),
CostTime = reader.IsDBNull(reader.GetOrdinal("CostTime")) ? DateTime.MinValue : reader.GetDateTime(reader.GetOrdinal("CostTime")),
Days = (int)reader["Days"],
FinRemark = reader.IsDBNull(reader.GetOrdinal("FinRemark")) ? string.Empty : reader["FinRemark"].ToString(),
FreeAmount = reader.GetDecimal(reader.GetOrdinal("FreeAmount")),
FreeNumber = (int)reader["FreeNumber"],
GuideCut = reader.GetDecimal(reader.GetOrdinal("GuideCut")),
GuideNotes = reader.IsDBNull(reader.GetOrdinal("GuideNotes")) ? string.Empty : reader["GuideNotes"].ToString(),
GuidePlus = reader.GetDecimal(reader.GetOrdinal("GuidePlus")),
IsMeal = (EyouSoft.Model.EnumType.PlanStructure.PlanHotelIsMeal)reader.GetByte(reader.GetOrdinal("IsMeal")),
IsOut = reader["IsOut"].ToString() == "1" ? true : false,
IsRebate = reader["IsRebate"].ToString() == "1" ? true : false,
MealFrequency = (int)reader["MealFrequency"],
MealNumber = (int)reader["MealNumber"],
MealPrice = reader.GetDecimal(reader.GetOrdinal("MealPrice")),
OperatorID = reader.IsDBNull(reader.GetOrdinal("OperatorID")) ? string.Empty : reader["OperatorID"].ToString(),
OperatorName = reader.IsDBNull(reader.GetOrdinal("OperatorName")) ? string.Empty : reader["OperatorName"].ToString(),
PaymentType = (EyouSoft.Model.EnumType.PlanStructure.Payment)reader.GetByte(reader.GetOrdinal("PaymentType")),
PlanCost = reader.GetDecimal(reader.GetOrdinal("PlanCost")),
PlanerCut = reader.GetDecimal(reader.GetOrdinal("PlanerCut")),
PlanerPlus = reader.GetDecimal(reader.GetOrdinal("PlanerPlus")),
PlanId = reader["PlanId"].ToString(),
Prepaid = reader.GetDecimal(reader.GetOrdinal("Prepaid")),
Remarks = reader.IsDBNull(reader.GetOrdinal("Remarks")) ? string.Empty : reader["Remarks"].ToString(),
SaleCut = reader.GetDecimal(reader.GetOrdinal("SaleCut")),
SalePlus = reader.GetDecimal(reader.GetOrdinal("SalePlus")),
SourceId = reader.IsDBNull(reader.GetOrdinal("SourceId")) ? string.Empty : reader["SourceId"].ToString(),
SourceName = reader.IsDBNull(reader.GetOrdinal("SourceName")) ? string.Empty : reader["SourceName"].ToString(),
Star = (EyouSoft.Model.EnumType.PlanStructure.PlanHotelStar)reader.GetByte(reader.GetOrdinal("Star")),
Status = (EyouSoft.Model.EnumType.PlanStructure.PlanState)reader.GetByte(reader.GetOrdinal("Status")),
SueId = reader.IsDBNull(reader.GetOrdinal("SueId")) ? string.Empty : reader["SueId"].ToString(),
TotalCosts = reader.GetDecimal(reader.GetOrdinal("TotalCosts")),
TourId = reader.IsDBNull(reader.GetOrdinal("TourId")) ? string.Empty : reader["TourId"].ToString(),
Type = (EyouSoft.Model.EnumType.PlanStructure.PlanProject)reader.GetByte(reader.GetOrdinal("Type")),
IssueTime = reader.GetDateTime(reader.GetOrdinal("IssueTime")),
AddStatus = (EyouSoft.Model.EnumType.PlanStructure.PlanAddStatus)reader.GetByte(reader.GetOrdinal("AddStatus")),
PlanHotelRoomList = GetHotelRoomList(reader.IsDBNull(reader.GetOrdinal("HotelRoomXml")) ? string.Empty : reader["HotelRoomXml"].ToString()),
PlanHotelTimeList = GetHotelTimeList(reader.IsDBNull(reader.GetOrdinal("HotelTimeXml")) ? string.Empty : reader["HotelTimeXml"].ToString())
};
}
reader.Close();
}
return(model);
}
/// <summary>
/// 修改酒店信息
/// </summary>
/// <param name="model">信息实体</param>
/// <returns>true:成功，false:失败</returns>
public bool UpdateHotel(EyouSoft.Model.PlanStructure.MPlanHotel model)
{
return(HotelAddOrUpdate(model, false));
}
