/// <summary>
/// 初始化信息
/// </summary>
private void GetTicketApplyInfo()
{
EyouSoft.Model.TicketStructure.TicketApply ApplyModel = EyouSoft.BLL.TicketStructure.TicketApply.CreateInstance().GetModel(EditApplyId);
if (ApplyModel != null)
{
this.literTicketArticleTitle.Text = Utils.InputText(ApplyModel.TicketArticleTitle);
this.literVoyageSet.Text = ApplyModel.TicketFlight.VoyageSet.ToString();
this.leterSumPeople.Text = ApplyModel.TicketFlight.PeopleNumber.ToString() + "人";
this.literPeopleCountryType.Text = ApplyModel.TicketFlight.PeopleCountryType == EyouSoft.Model.TicketStructure.PeopleCountryType.Foreign ? "外宾 " : "内宾 ";
this.txtTakeOffDate.Text = ApplyModel.TicketFlight.TakeOffDate.Value.ToShortDateString();
if (ApplyModel.TicketFlight.VoyageSet != EyouSoft.Model.TicketStructure.VoyageType.单程)
{
this.txtReturnDate.Text = ApplyModel.TicketFlight.ReturnDate.Value.ToShortDateString();
}
this.txtRemark.Value = ApplyModel.Remark;
//采购商资料
this.txtCompanyName.Text = ApplyModel.CompanyName;
this.txtContactName.Text = ApplyModel.ContactName;
this.txtContactTel.Text = ApplyModel.CompanyTel;
this.txtContactAddress.Text = ApplyModel.CompanyAddress;
}
else
{
EyouSoft.Common.Function.MessageBox.ShowAndRedirect(this.Page, "暂无该信息记录!", strReturnUrl);
return;
}
ApplyModel = null;
}
/// <summary>
/// 添加机票折扣申请
/// </summary>
/// <param name="model">机票折扣信息实体</param>
/// <returns></returns>
public virtual bool Add(EyouSoft.Model.TicketStructure.TicketApply model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_Ticket_Apply_INSERT);
this._database.AddInParameter(dc, "TicketArticleID", DbType.AnsiString, model.TicketArticleID);
this._database.AddInParameter(dc, "TicketArticleTitle", DbType.String, model.TicketArticleTitle);
this._database.AddInParameter(dc, "VoyageType", DbType.Byte, Convert.ToByte(model.TicketFlight.VoyageSet));
this._database.AddInParameter(dc, "PeopleNum", DbType.Int32, model.TicketFlight.PeopleNumber);
this._database.AddInParameter(dc, "TakeOffDate", DbType.DateTime, model.TicketFlight.TakeOffDate);
this._database.AddInParameter(dc, "ReturnDate", DbType.DateTime, model.TicketFlight.ReturnDate);
this._database.AddInParameter(dc, "CountryType", DbType.Byte, Convert.ToByte(model.TicketFlight.PeopleCountryType));
this._database.AddInParameter(dc, "Remark", DbType.String, model.Remark);
this._database.AddInParameter(dc, "CompanyName", DbType.String, model.CompanyName);
this._database.AddInParameter(dc, "ContactName", DbType.String, model.ContactName);
this._database.AddInParameter(dc, "CompanyTel", DbType.String, model.CompanyTel);
this._database.AddInParameter(dc, "CompanyAddress", DbType.String, model.CompanyAddress);
if (DbHelper.ExecuteSql(dc, this._database) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得机票折扣申请实体
/// </summary>
/// <param name="id">申请ID</param>
/// <returns></returns>
public virtual EyouSoft.Model.TicketStructure.TicketApply GetModel(string id)
{
EyouSoft.Model.TicketStructure.TicketApply model = new EyouSoft.Model.TicketStructure.TicketApply();
DbCommand dc = this._database.GetSqlStringCommand(SQL_Ticket_Apply_SELECT);
this._database.AddInParameter(dc, "ID", DbType.AnsiString, id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model.ApplyId = dr.GetString(dr.GetOrdinal("ID"));
model.TicketArticleID = dr.IsDBNull(dr.GetOrdinal("TicketArticleID")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleID"));
model.TicketArticleTitle = dr.IsDBNull(dr.GetOrdinal("TicketArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleTitle"));
model.TicketFlight.VoyageSet = (EyouSoft.Model.TicketStructure.VoyageType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.VoyageType), dr.GetByte(dr.GetOrdinal("VoyageType")).ToString());
model.TicketFlight.PeopleNumber = dr.GetInt32(dr.GetOrdinal("PeopleNum"));
if (!dr.IsDBNull(dr.GetOrdinal("TakeOffDate")))
{
model.TicketFlight.TakeOffDate = dr.GetDateTime(dr.GetOrdinal("TakeOffDate"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ReturnDate")))
{
model.TicketFlight.ReturnDate = dr.GetDateTime(dr.GetOrdinal("ReturnDate"));
}
model.TicketFlight.PeopleCountryType = (EyouSoft.Model.TicketStructure.PeopleCountryType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.PeopleCountryType), dr.GetByte(dr.GetOrdinal("CountryType")).ToString());
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? "" : dr.GetString(dr.GetOrdinal("CompanyName"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.CompanyTel = dr.IsDBNull(dr.GetOrdinal("CompanyTel")) ? "" : dr.GetString(dr.GetOrdinal("CompanyTel"));
model.CompanyAddress = dr.IsDBNull(dr.GetOrdinal("CompanyAddress")) ? "" : dr.GetString(dr.GetOrdinal("CompanyAddress"));
}
}
return(model);
}
/// <summary>
/// 修改
/// </summary>
protected bool UpdateApply()
{
bool Result = false;
EyouSoft.Model.TicketStructure.TicketApply UpdateModel = new EyouSoft.Model.TicketStructure.TicketApply();
UpdateModel.ApplyId = Utils.InputText(Request.Form["hidEditId"]);
UpdateModel.TicketFlight.TakeOffDate = Utils.GetDateTimeNullable(Request.Form["txtTakeOffDate$dateTextBox"]);
UpdateModel.TicketFlight.ReturnDate = Utils.GetDateTimeNullable(Request.Form["txtReturnDate$dateTextBox"]);
UpdateModel.Remark = Utils.InputText(Request.Form["txtRemark"]);
UpdateModel.CompanyName = Utils.InputText(Request.Form["txtCompanyName"]);
UpdateModel.ContactName = Utils.InputText(Request.Form["txtContactName"]);
UpdateModel.CompanyTel = Utils.InputText(Request.Form["txtContactTel"]);
UpdateModel.CompanyAddress = Utils.InputText(Request.Form["txtContactAddress"]);
Result = EyouSoft.BLL.TicketStructure.TicketApply.CreateInstance().Update(UpdateModel);
UpdateModel = null;
return(Result);
}
/// <summary>
/// 修改机票折扣申请
/// </summary>
/// <param name="model">机票折扣信息实体</param>
/// <returns></returns>
public virtual bool Update(EyouSoft.Model.TicketStructure.TicketApply model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_Ticket_Apply_UPDATE);
this._database.AddInParameter(dc, "ID", DbType.StringFixedLength, model.ApplyId);
this._database.AddInParameter(dc, "TakeOffDate", DbType.DateTime, model.TicketFlight.TakeOffDate);
this._database.AddInParameter(dc, "ReturnDate", DbType.DateTime, model.TicketFlight.ReturnDate);
this._database.AddInParameter(dc, "Remark", DbType.String, model.Remark);
this._database.AddInParameter(dc, "CompanyName", DbType.String, model.CompanyName);
this._database.AddInParameter(dc, "ContactName", DbType.String, model.ContactName);
this._database.AddInParameter(dc, "CompanyTel", DbType.String, model.CompanyTel);
this._database.AddInParameter(dc, "CompanyAddress", DbType.String, model.CompanyAddress);
if (DbHelper.ExecuteSql(dc, this._database) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void SavePlaneInfo()
{
string voyageType = Utils.GetFormValue(rdoType.UniqueID);
string peopleCountType = Utils.GetFormValue(rdoPassengerType.UniqueID);
int personCount = Utils.GetInt(Utils.GetFormValue(txtPersonCount.UniqueID), 0);
string begionTime = Utils.GetFormValue(DatePicker1.UniqueID);
string endTime = Utils.GetFormValue(DatePicker2.UniqueID);
string companyName = Utils.GetFormValue(txtStockCompanyName.UniqueID);
string linkName = Utils.GetFormValue(txtStockLinkName.UniqueID);
string phone = Utils.GetFormValue(txtStockPhone.UniqueID);
string address = Utils.GetFormValue(txtStockAddress.UniqueID);
string remark = Utils.GetFormValue(txarRemark.UniqueID);
if (personCount < 1)
{
Response.Write("{success:'3',message:'乘机人数填写错误'}");
Response.End();
return;
}
//时间判断
DateTime?begionTime1 = null;
DateTime?endTime1 = null;
if ((EyouSoft.Model.TicketStructure.VoyageType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.VoyageType), voyageType) != EyouSoft.Model.TicketStructure.VoyageType.单程)
{
if (!StringValidate.IsDateTime(begionTime) && StringValidate.IsDateTime(endTime))
{
Response.Write("{success:'3',message:'往返时间格式填写错误'}");
Response.End();
return;
}
begionTime1 = Convert.ToDateTime(begionTime);
endTime1 = Convert.ToDateTime(endTime);
if (begionTime1 > endTime1)
{
Response.Write("{success:'3',message:'出发时间不能大于返程时间'}");
Response.End();
return;
}
}
else
{
;
if (!StringValidate.IsDateTime(begionTime))
{
Response.Write("{success:'3',message:'出发时间格式填写错误'}");
Response.End();
return;
}
begionTime1 = Convert.ToDateTime(begionTime);
}
if (!Utils.IsPhone(phone))
{
Response.Write("{success:'3',message:'采购商电话号码填写错误'}");
Response.End();
return;
}
//航班信息
EyouSoft.Model.TicketStructure.TicketFlight flight = new EyouSoft.Model.TicketStructure.TicketFlight();
flight.PeopleNumber = personCount;
flight.ReturnDate = endTime1;
flight.TakeOffDate = begionTime1;
flight.VoyageSet = (EyouSoft.Model.TicketStructure.VoyageType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.VoyageType), voyageType);
flight.PeopleCountryType = (EyouSoft.Model.TicketStructure.PeopleCountryType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.PeopleCountryType), peopleCountType);
//航班折扣申请
EyouSoft.Model.TicketStructure.TicketApply ticketapply = new EyouSoft.Model.TicketStructure.TicketApply();
ticketapply.CompanyAddress = address;
ticketapply.CompanyName = companyName;
ticketapply.CompanyTel = phone;
ticketapply.ContactName = linkName;
ticketapply.Remark = remark;
ticketapply.TicketArticleID = Utils.GetFormValue(hidNewId.UniqueID);
ticketapply.TicketFlight = flight;
ticketapply.TicketArticleTitle = Utils.GetFormValue(hidTitle.UniqueID);
if (EyouSoft.BLL.TicketStructure.TicketApply.CreateInstance().Add(ticketapply))
{
Utils.ResponseMeg(true, "保存成功");
}
else
{
Utils.ResponseMeg(false, "保存失败");
}
}
/// <summary>
/// 修改机票折扣申请
/// </summary>
/// <param name="model">机票折扣信息实体</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.TicketStructure.TicketApply model)
{
return(idal.Update(model));
}
/// <summary>
/// 添加机票折扣申请
/// </summary>
/// <param name="model">机票折扣信息实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.TicketStructure.TicketApply model)
{
return(idal.Add(model));
}
/// <summary>
/// 获得申请的列表
/// </summary>
/// <param name="query">查询条件实体</param>
/// <param name="pageSize">分页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总的记录数</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.TicketStructure.TicketApply> GetList(EyouSoft.Model.TicketStructure.QueryTicketApply query, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.TicketStructure.TicketApply> list = new List <EyouSoft.Model.TicketStructure.TicketApply>();
string tableName = "Ticket_Apply";
string fields = "ID,TicketArticleID,TicketArticleTitle,VoyageType,PeopleNum,TakeOffDate,ReturnDate,CountryType,Remark,CompanyName,ContactName,CompanyTel,CompanyAddress,IssueTime,UpdateTime,State";
string primaryKey = "ID";
string orderByString = "IssueTime desc";
StringBuilder strWhere = new StringBuilder("1=1");
#region 查询拼接
if (query != null)
{
if (!string.IsNullOrEmpty(query.Title))
{
strWhere.AppendFormat(" AND TicketArticleTitle like '%{0}%' ", query.Title);
}
if (!string.IsNullOrEmpty(query.ContactName))
{
strWhere.AppendFormat(" AND ContactName like '%{0}%' ", query.ContactName);
}
if (query.TakeOffDateStart.HasValue)
{
strWhere.AppendFormat(" AND DATEDIFF(dd, TakeOffDate, '{0}')=0", query.TakeOffDateStart.Value.ToString("yyyy-MM-dd"));
}
/*
* if (query.TakeOffDateStart.HasValue)
* strWhere.AppendFormat(" AND TakeOffDate>='{0}'", query.TakeOffDateStart.Value.ToString("yyyy-MM-dd"));
*
* if (query.TakeOffDateEnd.HasValue)
* strWhere.AppendFormat(" AND TakeOffDate<='{0}'", query.TakeOffDateEnd.Value.AddDays(1).AddMilliseconds(-1));
*/
if (query.VoyageType != EyouSoft.Model.TicketStructure.VoyageType.所有)
{
strWhere.AppendFormat(" AND VoyageType={0}", Convert.ToByte(query.VoyageType));
}
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
EyouSoft.Model.TicketStructure.TicketApply model = new EyouSoft.Model.TicketStructure.TicketApply();
model.ApplyId = dr.GetString(dr.GetOrdinal("ID"));
model.TicketArticleID = dr.IsDBNull(dr.GetOrdinal("TicketArticleID")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleID"));
model.TicketArticleTitle = dr.IsDBNull(dr.GetOrdinal("TicketArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleTitle"));
model.TicketFlight.VoyageSet = (EyouSoft.Model.TicketStructure.VoyageType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.VoyageType), dr.GetByte(dr.GetOrdinal("VoyageType")).ToString());
model.TicketFlight.PeopleNumber = dr.GetInt32(dr.GetOrdinal("PeopleNum"));
if (!dr.IsDBNull(dr.GetOrdinal("TakeOffDate")))
{
model.TicketFlight.TakeOffDate = dr.GetDateTime(dr.GetOrdinal("TakeOffDate"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ReturnDate")))
{
model.TicketFlight.ReturnDate = dr.GetDateTime(dr.GetOrdinal("ReturnDate"));
}
model.TicketFlight.PeopleCountryType = (EyouSoft.Model.TicketStructure.PeopleCountryType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.PeopleCountryType), dr.GetByte(dr.GetOrdinal("CountryType")).ToString());
//model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? "" : dr.GetString(dr.GetOrdinal("CompanyName"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.CompanyTel = dr.IsDBNull(dr.GetOrdinal("CompanyTel")) ? "" : dr.GetString(dr.GetOrdinal("CompanyTel"));
//model.CompanyAddress = dr.IsDBNull(dr.GetOrdinal("CompanyAddress")) ? "" : dr.GetString(dr.GetOrdinal("CompanyAddress"));
list.Add(model);
model = null;
}
}
return(list);
}
