/// <summary>
/// 获取交通行程
/// </summary>
/// <returns></returns>
private IList <EyouSoft.Model.PlanStructure.TravelInfo> GetTravelListForXML(string xml)
{
if (string.IsNullOrEmpty(xml))
{
return(null);
}
IList <EyouSoft.Model.PlanStructure.TravelInfo> list = new List <EyouSoft.Model.PlanStructure.TravelInfo>();
EyouSoft.Model.PlanStructure.TravelInfo item = null;
System.Xml.Linq.XElement xRoot = System.Xml.Linq.XElement.Parse(xml);
var xRows = Utils.GetXElements(xRoot, "row");
foreach (var xRow in xRows)
{
item = new EyouSoft.Model.PlanStructure.TravelInfo
{
FilghtNum = Utils.GetXAttributeValue(xRow, "FilghtNum"),
FlightCompany = (EyouSoft.Model.EnumType.PlanStructure.FlightCompany)Convert.ToInt32(Utils.GetXAttributeValue(xRow, "FlightCompany")),
AirPlaneType = Utils.GetXAttributeValue(xRow, "AirPlaneType"),
IntervalDays = Convert.ToInt32(Utils.GetXAttributeValue(xRow, "IntervalDays")),
TravelId = Utils.GetInt(Utils.GetXAttributeValue(xRow, "TravelId")),
TrafficId = Utils.GetInt(Utils.GetXAttributeValue(xRow, "TrafficId")),
TrafficType = (EyouSoft.Model.EnumType.PlanStructure.TrafficType)Convert.ToInt32(Utils.GetXAttributeValue(xRow, "TrafficType")),
Space = (EyouSoft.Model.EnumType.PlanStructure.Space)Convert.ToInt32(Utils.GetXAttributeValue(xRow, "Space")),
SerialNum = Convert.ToInt32(Utils.GetXAttributeValue(xRow, "SerialNum")),
LProvinceName = Utils.GetXAttributeValue(xRow, "LProvinceName"),
LCityName = Utils.GetXAttributeValue(xRow, "LCityName"),
RProvinceName = Utils.GetXAttributeValue(xRow, "RProvinceName"),
RCityName = Utils.GetXAttributeValue(xRow, "RCityName")
};
list.Add(item);
}
return(list);
}
/// <summary>
/// 获取行程实体
/// </summary>
/// <param name="travelID">行程编号</param>
/// <returns></returns>
public EyouSoft.Model.PlanStructure.TravelInfo GettravelModel(int travelID)
{
EyouSoft.Model.PlanStructure.TravelInfo travelModel = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_TRAVEL_GETTRAVELINFO);
this._db.AddInParameter(cmd, "TravelId", DbType.Int32, travelID);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
travelModel = new EyouSoft.Model.PlanStructure.TravelInfo();
travelModel.TravelId = dr.GetInt32(dr.GetOrdinal("TravelId"));
travelModel.TrafficId = dr.GetInt32(dr.GetOrdinal("TrafficId"));
travelModel.SerialNum = !dr.IsDBNull(dr.GetInt32(dr.GetOrdinal("SerialNum"))) ? dr.GetInt32(dr.GetOrdinal("SerialNum")) : 0;
travelModel.TrafficType = (EyouSoft.Model.EnumType.PlanStructure.TrafficType)Convert.ToInt32(dr[dr.GetOrdinal("TrafficType")].ToString());
travelModel.LProvince = !dr.IsDBNull(dr.GetOrdinal("LProvince")) ? dr.GetInt32(dr.GetOrdinal("LProvince")) : 0;
travelModel.LCity = !dr.IsDBNull(dr.GetOrdinal("LCity")) ? dr.GetInt32(dr.GetOrdinal("LCity")) : 0;
travelModel.RProvince = dr.IsDBNull(dr.GetOrdinal("RProvince")) ? 0 : dr.GetInt32(dr.GetOrdinal("RProvince"));
travelModel.RCity = !dr.IsDBNull(dr.GetOrdinal("RCity")) ? dr.GetInt32(dr.GetOrdinal("RCity")) : 0;
travelModel.FilghtNum = !dr.IsDBNull(dr.GetOrdinal("FilghtNum")) ? dr.GetString(dr.GetOrdinal("FilghtNum")) : string.Empty;
travelModel.FlightCompany = (EyouSoft.Model.EnumType.PlanStructure.FlightCompany)Convert.ToInt32(dr[dr.GetOrdinal("FlightCompany")].ToString());
travelModel.LTime = !dr.IsDBNull(dr.GetOrdinal("LTime")) ? dr.GetString(dr.GetOrdinal("LTime")) : string.Empty;
travelModel.RTime = !dr.IsDBNull(dr.GetOrdinal("RTime")) ? dr.GetString(dr.GetOrdinal("RTime")) : string.Empty;
travelModel.IsStop = dr.GetString(dr.GetOrdinal("IsStop")) == "1" ? false : true;
travelModel.AirPlaneType = !dr.IsDBNull(dr.GetOrdinal("AirPlaneType")) ? dr.GetString(dr.GetOrdinal("AirPlaneType")) : string.Empty;
travelModel.IntervalDays = !dr.IsDBNull(dr.GetInt32(dr.GetOrdinal("IntervalDays"))) ? dr.GetInt32(dr.GetOrdinal("IntervalDays")) : 0;
travelModel.CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId"));
travelModel.Operater = dr.GetString(dr.GetOrdinal("Operater"));
travelModel.OperaterID = dr.GetInt32(dr.GetOrdinal("OperaterID"));
travelModel.InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime"));
travelModel.Space = (EyouSoft.Model.EnumType.PlanStructure.Space)Convert.ToInt32(dr[dr.GetOrdinal("Space")].ToString());
}
}
return(travelModel);
}
/// <summary>
/// 修改交通行程
/// </summary>
/// <param name="travelModel">行程实体</param>
/// <returns>true:成功 false:失败</returns>
public bool UpdatePlanTravel(EyouSoft.Model.PlanStructure.TravelInfo travelModel)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Travel_Update");
this._db.AddInParameter(cmd, "TravelId", DbType.Int32, travelModel.TravelId);
this._db.AddInParameter(cmd, "TrafficId", DbType.Int32, travelModel.TrafficId);
this._db.AddInParameter(cmd, "SerialNum", DbType.Int32, travelModel.SerialNum);
this._db.AddInParameter(cmd, "TrafficType", DbType.Byte, Convert.ToInt32(travelModel.TrafficType));
this._db.AddInParameter(cmd, "LProvince", DbType.Int32, travelModel.LProvince);
this._db.AddInParameter(cmd, "LCity", DbType.Int32, travelModel.LCity);
this._db.AddInParameter(cmd, "RProvince", DbType.Int32, travelModel.RProvince);
this._db.AddInParameter(cmd, "RCity", DbType.Int32, travelModel.RCity);
this._db.AddInParameter(cmd, "FilghtNum", DbType.String, travelModel.FilghtNum);
this._db.AddInParameter(cmd, "FlightCompany", DbType.Byte, Convert.ToInt32(travelModel.FlightCompany));
this._db.AddInParameter(cmd, "LTime", DbType.String, travelModel.LTime);
this._db.AddInParameter(cmd, "RTime", DbType.String, travelModel.RTime);
this._db.AddInParameter(cmd, "IsStop", DbType.Boolean, travelModel.IsStop == true ? 0 : 1);
this._db.AddInParameter(cmd, "Space", DbType.Byte, Convert.ToInt32(travelModel.Space));
this._db.AddInParameter(cmd, "AirPlaneType", DbType.String, travelModel.AirPlaneType);
this._db.AddInParameter(cmd, "IntervalDays", DbType.Int32, travelModel.IntervalDays);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, travelModel.CompanyId);
this._db.AddInParameter(cmd, "Operater", DbType.String, travelModel.Operater);
this._db.AddInParameter(cmd, "OperaterID", DbType.Int32, travelModel.OperaterID);
this._db.AddInParameter(cmd, "InsueTime", DbType.DateTime, travelModel.InsueTime);
this._db.AddOutParameter(cmd, "result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "result")) > 0 ? true : false);
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
protected string PageSave()
{
string ret = string.Empty;
EyouSoft.Model.PlanStructure.TravelInfo travelModel = new EyouSoft.Model.PlanStructure.TravelInfo();
travelModel.TrafficId = Utils.GetInt(Utils.GetQueryStringValue("tfID"));
travelModel.AirPlaneType = Utils.GetFormValue(this.txtAirPlaneType.UniqueID);
travelModel.CompanyId = this.SiteUserInfo.CompanyID;
travelModel.FilghtNum = Utils.GetFormValue(this.txtFlightNum.UniqueID);
travelModel.FlightCompany = (EyouSoft.Model.EnumType.PlanStructure.FlightCompany)Utils.GetInt(Utils.GetFormValue(this.seleLineCompanyNamev.UniqueID));
travelModel.InsueTime = DateTime.Now;
travelModel.IntervalDays = Utils.GetInt(Utils.GetFormValue(this.txtIntervalDays.UniqueID));
travelModel.IsStop = Utils.GetFormValue("IsStop") == "0" ? true : false;
travelModel.LCity = ucLCity.CityId;
travelModel.LProvince = ucLProvince.ProvinceId;
travelModel.LTime = Utils.GetFormValue(this.txtLTime.UniqueID);
travelModel.RTime = Utils.GetFormValue(this.txtRTime.UniqueID);
travelModel.Operater = this.SiteUserInfo.UserName;
travelModel.OperaterID = this.SiteUserInfo.ID;
travelModel.RCity = ucRcity.CityId;
travelModel.RProvince = ucRprovince.ProvinceId;
travelModel.SerialNum = Utils.GetInt(Utils.GetFormValue(this.txtSerialNum.UniqueID));
travelModel.TrafficType = (EyouSoft.Model.EnumType.PlanStructure.TrafficType)Utils.GetInt(Utils.GetFormValue(this.seleTfrricType.UniqueID));
travelModel.Space = (EyouSoft.Model.EnumType.PlanStructure.Space)Utils.GetInt(Utils.GetFormValue(this.ddlSpace.UniqueID));
string type = Utils.GetQueryStringValue("type");
if (!string.IsNullOrEmpty(type))
{
bool retult = false;
if (type == "add")
{
retult = new EyouSoft.BLL.PlanStruture.PlanTrffic().AddPlanTravel(travelModel);
if (retult)
{
ret = "{\"ret\":\"1\",\"msg\":\"添加成功!\"}";
}
else
{
ret = "{\"ret\":\"0\",\"msg\":\"添加失败!\"}";
}
}
else
{
travelModel.TravelId = Utils.GetInt(Utils.GetQueryStringValue("trID"));
retult = new EyouSoft.BLL.PlanStruture.PlanTrffic().UpdatePlanTravel(travelModel);
if (retult)
{
ret = "{\"ret\":\"1\",\"msg\":\"修改成功!\"}";
}
else
{
ret = "{\"ret\":\"0\",\"msg\":\"修改失败!\"}";
}
}
}
return(ret);
}
/// <summary>
/// 获取交通行程
/// </summary>
/// <param name="PageSize">每页记录数</param>
/// <param name="PageIndex">总页数</param>
/// <param name="CompanyID">公司编号</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="trfficID">交通编号</param>
/// <returns>交通行程</returns>
public IList <EyouSoft.Model.PlanStructure.TravelInfo> GetTravelList(int PageSize, int PageIndex, int CompanyID, ref int RecordCount, int trafficID)
{
IList <EyouSoft.Model.PlanStructure.TravelInfo> list = new List <EyouSoft.Model.PlanStructure.TravelInfo>();
string tabName = "tbl_Travel";
string fields = "tbl_Travel.TravelId,tbl_Travel.TrafficId,tbl_Travel.SerialNum,tbl_Travel.TrafficType,tbl_Travel.LProvince,tbl_Travel.LCity,tbl_Travel.RProvince,tbl_Travel.RCity,tbl_Travel.FilghtNum,tbl_Travel.FlightCompany,tbl_Travel.LTime,tbl_Travel.RTime,tbl_Travel.IsStop,tbl_Travel.[Space],tbl_Travel.AirPlaneType,tbl_Travel.IntervalDays,tbl_Travel.CompanyId,tbl_Travel.InsueTime,tbl_Travel.Operater,tbl_Travel.OperaterID,(SELECT CityName FROM tbl_CompanyCity WHERE tbl_CompanyCity.Id=tbl_Travel.LCity AND tbl_CompanyCity.ProvinceId=tbl_Travel.LProvince) AS LCityName,(SELECT CityName FROM tbl_CompanyCity WHERE tbl_CompanyCity.Id=tbl_Travel.RCity AND tbl_CompanyCity.ProvinceId=tbl_Travel.RProvince) AS RCityName";
string primaryKey = " TravelId ";
string orderByStr = " InsueTime DESC ";
StringBuilder sqlWhere = new StringBuilder();
sqlWhere.AppendFormat(" tbl_Travel.TrafficId={0} ", trafficID);
using (IDataReader dr = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tabName, primaryKey, fields, sqlWhere.ToString(), orderByStr))
{
EyouSoft.Model.PlanStructure.TravelInfo model = null;
while (dr.Read())
{
model = new EyouSoft.Model.PlanStructure.TravelInfo()
{
AirPlaneType = !dr.IsDBNull(dr.GetOrdinal("AirPlaneType")) ? dr.GetString(dr.GetOrdinal("AirPlaneType")) : string.Empty,
CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId")),
FilghtNum = !dr.IsDBNull(dr.GetOrdinal("FilghtNum")) ? dr.GetString(dr.GetOrdinal("FilghtNum")) : string.Empty,
FlightCompany = (EyouSoft.Model.EnumType.PlanStructure.FlightCompany)Convert.ToInt32(dr[dr.GetOrdinal("FlightCompany")].ToString()),
InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")),
IntervalDays = !dr.IsDBNull(dr.GetOrdinal("IntervalDays")) ? dr.GetInt32(dr.GetOrdinal("IntervalDays")) : 0,
IsStop = dr.IsDBNull(dr.GetOrdinal("IsStop")) ? false : dr.GetString(dr.GetOrdinal("IsStop")) == "0" ? true : false,
TravelId = dr.GetInt32(dr.GetOrdinal("TravelId")),
TrafficType = (EyouSoft.Model.EnumType.PlanStructure.TrafficType)Convert.ToInt32(dr[dr.GetOrdinal("TrafficType")].ToString()),
TrafficId = Convert.ToInt32(dr["TrafficId"].ToString()),
LCity = dr.GetInt32(dr.GetOrdinal("LCity")),
LCityName = !dr.IsDBNull(dr.GetOrdinal("LCityName")) ? dr.GetString(dr.GetOrdinal("LCityName")) : string.Empty,
LProvince = dr.GetInt32(dr.GetOrdinal("LProvince")),
LTime = !dr.IsDBNull(dr.GetOrdinal("LTime")) ? dr.GetString(dr.GetOrdinal("LTime")) : string.Empty,
Operater = dr.GetString(dr.GetOrdinal("Operater")),
OperaterID = dr.GetInt32(dr.GetOrdinal("OperaterID")),
RCity = dr.GetInt32(dr.GetOrdinal("RCity")),
RCityName = !dr.IsDBNull(dr.GetOrdinal("RCityName")) ? dr.GetString(dr.GetOrdinal("RCityName")) : string.Empty,
RProvince = dr.GetInt32(dr.GetOrdinal("RProvince")),
RTime = !dr.IsDBNull(dr.GetOrdinal("RTime")) ? dr.GetString(dr.GetOrdinal("RTime")) : string.Empty,
SerialNum = dr.GetInt32(dr.GetOrdinal("SerialNum")),
Space = (EyouSoft.Model.EnumType.PlanStructure.Space)Convert.ToInt32(dr[dr.GetOrdinal("Space")].ToString())
};
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 修改交通行程
/// </summary>
/// <param name="travelModel">行程实体</param>
/// <returns>true:成功 false:失败</returns>
public bool UpdatePlanTravel(EyouSoft.Model.PlanStructure.TravelInfo travelModel)
{
if (travelModel == null)
{
return(false);
}
bool result = Idal.UpdatePlanTravel(travelModel);
if (result)
{
HandleLogsBll.Add(
new EyouSoft.Model.CompanyStructure.SysHandleLogs()
{
ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理,
EventCode = Model.CompanyStructure.SysHandleLogsNO.EventCode,
EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理.ToString() + "修改行程！编号为：" + travelModel.TravelId,
EventTitle = "修改" + Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理.ToString() + "数据"
});
}
return(result);
}