protected void BindTrfficList()
{
PageIndex = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("Page"), 0);
EyouSoft.Model.PlanStructure.TrafficSearch searchModel = new EyouSoft.Model.PlanStructure.TrafficSearch();
string trfficName = EyouSoft.Common.Utils.GetQueryStringValue("trfficName");
if (!string.IsNullOrEmpty(trfficName))
{
searchModel.TrafficName = trfficName;
}
IList <EyouSoft.Model.PlanStructure.TrafficInfo> List = new EyouSoft.BLL.PlanStruture.PlanTrffic(SiteUserInfo).GetTrafficList(searchModel, PageSize, PageIndex, this.SiteUserInfo.CompanyID, ref RecordCount);
if (List != null && List.Count > 0)
{
this.labMsg.Visible = false;
this.repTrfficList.DataSource = List;
this.repTrfficList.DataBind();
bindPage();
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.labMsg.Visible = true;
this.labMsg.Text = "暂无数据!";
}
}
/// <summary>
/// 关联交通
/// </summary>
/// <param name="selTrafficId">选择的交通编号</param>
/// <returns></returns>
protected string GetSelectTraffic(int selTrafficId)
{
EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic();
EyouSoft.Model.PlanStructure.TrafficSearch searchmodel = new EyouSoft.Model.PlanStructure.TrafficSearch();
searchmodel.TourId = Utils.GetQueryStringValue("tourId");
IList <EyouSoft.Model.PlanStructure.TrafficInfo> list = BLL.GetTrafficList(searchmodel, SiteUserInfo.CompanyID);
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<option value='' data-price='' data-shengyu='0'>请选择</option>");
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
if (item.TrafficId == selTrafficId)
{
sb.AppendFormat("<option value='{0}' selected='selected' data-price='' data-shengyu='0'>{1}</option>", item.TrafficId, item.TrafficName);
}
else
{
sb.AppendFormat("<option value='{0}' data-price='' data-shengyu='0'>{1}</option>", item.TrafficId, item.TrafficName);
}
}
}
return(sb.ToString());
}
/// <summary>
/// 获取交通集合列表
/// </summary>
/// <param name="trffIcName">交通名称</param>
/// <param name="PageSize">每页记录数</param>
/// <param name="PageIndex">当前页</param>
/// <param name="CompanyID">公司编号</param>
/// <param name="RecordCount">总记录数</param>
/// <returns>所有交通集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficInfo> GetTrafficList(EyouSoft.Model.PlanStructure.TrafficSearch SearchModel, int PageSize, int PageIndex, int CompanyID, ref int RecordCount)
{
IList <EyouSoft.Model.PlanStructure.TrafficInfo> trafficList = new List <EyouSoft.Model.PlanStructure.TrafficInfo>();
#region 过程分页参数设置
string tabName = "tbl_Traffic";
string fields = " TrafficId,TrafficName,[TrafficDays],ChildPrices,[Status],CompanyId,Operater,OperaterId,InsueTime,IsDelete";
string primaryKey = "TrafficId";
string orderStrBy = "InsueTime desc";
StringBuilder strwhere = new StringBuilder();
strwhere.AppendFormat(" IsDelete='0' AND CompanyId={0} ", CompanyID);
if (SearchModel != null && !string.IsNullOrEmpty(SearchModel.TrafficName))
{
strwhere.AppendFormat(" and TrafficName like '%{0}%' ", SearchModel.TrafficName);
}
using (IDataReader dr = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tabName, primaryKey, fields, strwhere.ToString(), orderStrBy))
{
while (dr.Read())
{
EyouSoft.Model.PlanStructure.TrafficInfo trfficModel = new EyouSoft.Model.PlanStructure.TrafficInfo();
trfficModel.ChildPrices = !dr.IsDBNull(dr.GetOrdinal("ChildPrices")) ? dr.GetDecimal(dr.GetOrdinal("ChildPrices")) : 0;
trfficModel.CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId"));
trfficModel.InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime"));
trfficModel.IsDelete = dr.GetString(dr.GetOrdinal("IsDelete")) == "0" ? true : false;
trfficModel.Operater = dr.GetString(dr.GetOrdinal("Operater"));
trfficModel.OperaterId = dr.GetInt32(dr.GetOrdinal("OperaterId"));
trfficModel.Status = (EyouSoft.Model.EnumType.PlanStructure.TrafficStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString());
trfficModel.TrafficDays = !dr.IsDBNull(dr.GetOrdinal("TrafficDays")) ? dr.GetInt32(dr.GetOrdinal("TrafficDays")) : 0;
trfficModel.TrafficId = dr.IsDBNull(dr.GetOrdinal("TrafficId")) ? 0 : dr.GetInt32(dr.GetOrdinal("TrafficId"));
trfficModel.TrafficName = dr["TrafficName"].ToString();
trafficList.Add(trfficModel);
}
}
#endregion
return(trafficList);
}
/// <summary>
/// 获取交通集合列表
/// </summary>
/// <param name="SearchModel">查询实体</param>
/// <param name="CompanyID">公司编号</param>
/// <returns>所有交通集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficInfo> GetTrafficList(EyouSoft.Model.PlanStructure.TrafficSearch SearchModel, int CompanyID)
{
IList <EyouSoft.Model.PlanStructure.TrafficInfo> trafficList = new List <EyouSoft.Model.PlanStructure.TrafficInfo>();
#region 过程分页参数设置
var strSql = new StringBuilder();
strSql.Append(" SELECT TrafficId,TrafficName,ChildPrices,[Status],CompanyId,Operater,OperaterId,InsueTime,IsDelete ");
strSql.Append(
" ,(SELECT tbl_Travel.TravelId,tbl_Travel.TrafficId,tbl_Travel.SerialNum, tbl_Travel.FilghtNum ");
strSql.Append(
" , tbl_Travel.FlightCompany, tbl_Travel.AirPlaneType, tbl_Travel.IntervalDays, tbl_Travel.TrafficType ");
strSql.Append(" , tbl_Travel.[Space],(SELECT ProvinceName FROM tbl_CompanyProvince ");
strSql.Append(" WHERE tbl_CompanyProvince.Id=tbl_Travel.LProvince) AS LProvinceName ");
strSql.Append(" ,(SELECT CityName FROM tbl_CompanyCity WHERE tbl_CompanyCity.Id=tbl_Travel.LCity ");
strSql.Append(" AND tbl_CompanyCity.ProvinceId=tbl_Travel.LProvince) AS LCityName ");
strSql.Append(
" ,(SELECT ProvinceName FROM tbl_CompanyProvince WHERE tbl_CompanyProvince.Id=tbl_Travel.RProvince) AS RProvinceName ");
strSql.Append(" ,(SELECT CityName FROM tbl_CompanyCity WHERE tbl_CompanyCity.Id=tbl_Travel.RCity ");
strSql.Append(" AND tbl_CompanyCity.ProvinceId=tbl_Travel.RProvince) AS RCityName ");
strSql.Append(
" FROM tbl_Travel WHERE tbl_Travel.TrafficId=tbl_Traffic.TrafficId FOR XML RAW,ROOT ) AS travelList ");
strSql.Append(" FROM tbl_Traffic WHERE IsDelete='0' and CompanyId = @CompanyId and Status='0' ");
if (SearchModel != null)
{
if (!string.IsNullOrEmpty(SearchModel.TrafficName))
{
strSql.AppendFormat(" and TrafficName like '%{0}%' ", SearchModel.TrafficName);
}
if (!string.IsNullOrEmpty(SearchModel.TourId))
{
strSql.AppendFormat(
" and EXISTS (SELECT 1 FROM tbl_TourTraffic tt WHERE tt.TrafficId = tbl_Traffic.TrafficId AND tt.TourId = '{0}') ",
SearchModel.TourId);
}
}
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, CompanyID);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
EyouSoft.Model.PlanStructure.TrafficInfo trfficModel = new EyouSoft.Model.PlanStructure.TrafficInfo();
trfficModel.ChildPrices = !dr.IsDBNull(dr.GetOrdinal("ChildPrices")) ? dr.GetDecimal(dr.GetOrdinal("ChildPrices")) : 0;
trfficModel.CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId"));
trfficModel.InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime"));
trfficModel.IsDelete = dr.GetString(dr.GetOrdinal("IsDelete")) == "0" ? true : false;
trfficModel.Operater = dr.GetString(dr.GetOrdinal("Operater"));
trfficModel.OperaterId = dr.GetInt32(dr.GetOrdinal("OperaterId"));
trfficModel.Status = (EyouSoft.Model.EnumType.PlanStructure.TrafficStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString());
trfficModel.TrafficId = dr.IsDBNull(dr.GetOrdinal("TrafficId")) ? 0 : dr.GetInt32(dr.GetOrdinal("TrafficId"));
trfficModel.TrafficName = dr["TrafficName"].ToString();
trfficModel.travelList = dr.IsDBNull(dr.GetOrdinal("travelList")) ? null : GetTravelListForXML(dr.GetString(dr.GetOrdinal("travelList")));
trafficList.Add(trfficModel);
}
}
#endregion
return(trafficList);
}
/// <summary>
/// 获取交通集合列表
/// </summary>
/// <param name="SearchModel">查询实体</param>
/// <param name="CompanyID">公司编号</param>
/// <param name="us">用户信息集合</param>
/// <returns>所有交通集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficInfo> GetTrafficList(EyouSoft.Model.PlanStructure.TrafficSearch SearchModel, int CompanyID)
{
return(Idal.GetTrafficList(SearchModel, CompanyID));
}
/// <summary>
/// 获取交通集合列表
/// </summary>
/// <param name="trffIcName">交通名称</param>
/// <param name="PageSize">每页记录数</param>
/// <param name="PageIndex">当前页</param>
/// <param name="CompanyID">公司编号</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="us">用户信息集合</param>
/// <returns>所有交通集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficInfo> GetTrafficList(EyouSoft.Model.PlanStructure.TrafficSearch SearchModel, int PageSize, int PageIndex, int CompanyID, ref int RecordCount)
{
return(Idal.GetTrafficList(SearchModel, PageSize, PageIndex, CompanyID, ref RecordCount));
}
