/// <summary>
/// 团款支出-应付账款-支付项目-明细
/// </summary>
/// <param name="tourId">计划编号</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <PaymentList> GetSettleList(string tourId, MExpendSearchInfo searchInfo)
{
return(dal.GetSettleList(tourId, searchInfo));
}
/// <summary>
/// 根据团号列出机票地接社支付信息 ---供应商类型地接(1) 或机票(2)
/// </summary>
/// <param name="TourId">团队编号</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <PaymentList> GetSettleList(string TourId, MExpendSearchInfo searchInfo)
{
IList <PaymentList> payMentList = new List <PaymentList>();
PaymentList model = null;
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT [ID],[TourId] ,[AddAmount],[ReduceAmount],[TotalAmount],[FRemark],[Settlement] as PayAmount,PayAmount as PayedAmount ,1 as SupplierType,LocalTravelAgency as SuplierName,TravelAgencyID AS SupplierId ");
sql.Append(" FROM [tbl_PlanLocalAgency] where TourId=@TourId {0}");
sql.Append(" union");
sql.Append(" SELECT [ID],[TourId] ,[AddAmount],[ReduceAmount],[TotalAmount],[FRemark],[Total] as PayAmount,PayAmount as PayedAmount,2 as SupplierType,TicketOffice as SuplierName,TicketOfficeId AS SupplierId ");
sql.Append(" FROM [tbl_PlanTicketOut] where state=3 and TourId=@TourId {1}");
string cmdText = sql.ToString();
string sdijie = string.Empty;
string sjipiao = string.Empty;
if (searchInfo != null)
{
if (!string.IsNullOrEmpty(searchInfo.SupplierName))
{
sdijie += string.Format(" AND LocalTravelAgency LIKE '%{0}%' ", searchInfo.SupplierName);
sjipiao += string.Format(" AND TicketOffice LIKE '%{0}%' ", searchInfo.SupplierName);
}
if (searchInfo.SupplierType.HasValue)
{
if (searchInfo.SupplierType.Value == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接)
{
sjipiao += " AND 1=0 ";
}
if (searchInfo.SupplierType.Value == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务)
{
sdijie += " AND 1=0 ";
}
}
}
cmdText = string.Format(cmdText, sdijie, sjipiao);
DbCommand cmd = this._db.GetSqlStringCommand(cmdText);
this._db.AddInParameter(cmd, "TourId", DbType.StringFixedLength, TourId);
using (IDataReader rd = DbHelper.ExecuteReader(cmd, this._db))
{
while (rd.Read())
{
model = new PaymentList();
model.AddAmount = rd.IsDBNull(rd.GetOrdinal("AddAmount")) ? 0 : rd.GetDecimal(rd.GetOrdinal("AddAmount"));
model.FRemark = rd.IsDBNull(rd.GetOrdinal("FRemark")) ? "" : rd.GetString(rd.GetOrdinal("FRemark"));
model.Id = rd.IsDBNull(rd.GetOrdinal("Id")) ? "0" : rd.GetString(rd.GetOrdinal("Id"));
model.PayAmount = rd.IsDBNull(rd.GetOrdinal("PayAmount")) ? 0 : rd.GetDecimal(rd.GetOrdinal("PayAmount"));
model.ReduceAmount = rd.IsDBNull(rd.GetOrdinal("ReduceAmount")) ? 0 : rd.GetDecimal(rd.GetOrdinal("ReduceAmount"));
model.SuplierName = rd.IsDBNull(rd.GetOrdinal("SuplierName")) ? "" : rd.GetString(rd.GetOrdinal("SuplierName"));
model.SupplierType = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.SupplierType), rd.GetInt32(rd.GetOrdinal("SupplierType")).ToString());
model.TotalAmount = rd.IsDBNull(rd.GetOrdinal("TotalAmount")) ? 0 : rd.GetDecimal(rd.GetOrdinal("TotalAmount"));
model.PayedAmount = rd.IsDBNull(rd.GetOrdinal("PayedAmount")) ? 0 : rd.GetDecimal(rd.GetOrdinal("PayedAmount"));
model.SupplierId = rd.IsDBNull(rd.GetOrdinal("SupplierId")) ? 0 : rd.GetInt32(rd.GetOrdinal("SupplierId"));
payMentList.Add(model);
}
}
return(payMentList);
}
