/// <summary>
/// 获取价格实体
/// </summary>
/// <param name="pricesId">价格编号</param>
/// <param name="trafficId">交通编号</param>
/// <returns>价格实体</returns>
public EyouSoft.Model.PlanStructure.TrafficPricesInfo GetTrafficPrices(string pricesId, int trafficId)
{
EyouSoft.Model.PlanStructure.TrafficPricesInfo model = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_TRAFFIC_GETPRICESINFO);
this._db.AddInParameter(cmd, "PricesID", DbType.String, pricesId);
this._db.AddInParameter(cmd, "TrafficId", DbType.Int32, trafficId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo()
{
TrafficId = dr.IsDBNull(dr.GetOrdinal("TrafficId")) ? 0 : dr.GetInt32(dr.GetOrdinal("TrafficId")),
TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0,
TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0,
InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")),
PricesID = dr["PricesID"].ToString(),
Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()),
SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime"))
};
}
}
return(model);
}
/// <summary>
/// 修改价格
/// </summary>
/// <param name="pricemodel">价格实体</param>
/// <returns>true 成功 false 失败</returns>
public bool UpdateTrafficPrice(EyouSoft.Model.PlanStructure.TrafficPricesInfo pricemodel)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_TRAFFIC_UPDATEPRICES);
this._db.AddInParameter(cmd, "TrafficId", DbType.Int32, pricemodel.TrafficId);
this._db.AddInParameter(cmd, "SDateTime", DbType.DateTime, pricemodel.SDateTime);
this._db.AddInParameter(cmd, "TicketPrices", DbType.Decimal, pricemodel.TicketPrices);
this._db.AddInParameter(cmd, "TicketNums", DbType.Int32, pricemodel.TicketNums);
this._db.AddInParameter(cmd, "Status", DbType.Byte, Convert.ToInt32(pricemodel.Status));
this._db.AddInParameter(cmd, "InsueTime", DbType.DateTime, pricemodel.InsueTime);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 获取成本价
/// </summary>
protected void GetPrice()
{
DateTime dt = Utils.GetDateTime(Utils.GetQueryStringValue("startDate"));
int trafficId = Utils.GetInt(Utils.GetQueryStringValue("trafficId"));
EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic();
EyouSoft.Model.PlanStructure.TrafficPricesInfo model = BLL.GetTrafficPriceModel(trafficId, dt);
if (model != null)
{
Response.Clear();
Response.Write(string.Format("{{\"result\":\"{0}\",\"shengyu\":\"{1}\"}}", Utils.FilterEndOfTheZeroDecimal(model.TicketPrices), model.ShengYu.ToString()));
Response.End();
}
else
{
Response.Clear();
Response.Write(string.Format("{{\"result\":\"{0}\",\"shengyu\":\"{1}\"}}", 0, 0));
Response.End();
}
}
/// <summary>
/// 根据交通编号出团时间获取价格集合
/// </summary>
/// <param name="trafficId">交通编号集合</param>
/// <param name="LTourDate">出团时间</param>
/// <returns>返回价格集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> GetTrafficPriceList(DateTime LTourDate, params int[] trafficId)
{
IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> list = null;
EyouSoft.Model.PlanStructure.TrafficPricesInfo model = null;
var strSql = new StringBuilder();
strSql.Append(" SELECT PricesID,InsueTime,SDateTime, TrafficId,TicketPrices,TicketNums,[Status] ");
strSql.AppendFormat(
",(SELECT SUM(to1.PeopleNumber - to1.LeaguePepoleNum) FROM tbl_TourOrder to1 WHERE to1.IsDelete = '0' AND EXISTS(SELECT 1 FROM tbl_TourOrderTraffic tot WHERE tot.OrderId = to1.ID AND tot.TrafficId = tbl_TrafficPrices.TrafficId) AND DATEDIFF(dd,to1.LeaveDate,tbl_TrafficPrices.SDateTime) = 0 and to1.OrderState IN({0},{1},{2})) as YiShiYong ",
(int)Model.EnumType.TourStructure.OrderState.未处理,
(int)Model.EnumType.TourStructure.OrderState.已成交,
(int)Model.EnumType.TourStructure.OrderState.已留位);
strSql.Append(" FROM tbl_TrafficPrices ");
strSql.AppendFormat(" WHERE TrafficId in ({0}) AND DateDiff(dd,SDateTime,@LeaveDate)=0 ", trafficId);
strSql.AppendFormat(" and [Status] = {0} ", (int)Model.EnumType.PlanStructure.TicketStatus.正常);
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "LeaveDate", DbType.DateTime, LTourDate);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
list = new List <EyouSoft.Model.PlanStructure.TrafficPricesInfo>();
while (dr.Read())
{
model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo()
{
PricesID = dr["PricesID"].ToString(),
Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()),
InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")),
SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime")),
TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0,
TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0,
TrafficId = dr.GetInt32(dr.GetOrdinal("TrafficId")),
YiShiYong = dr.IsDBNull(dr.GetOrdinal("YiShiYong")) ? 0 : dr.GetInt32(dr.GetOrdinal("YiShiYong"))
};
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 保存价格
/// </summary>
protected string PageSave()
{
string ret = string.Empty;
//开始时间
DateTime sDate = Utils.GetDateTime(Utils.GetFormValue("txtSDate"));
//结束时间
DateTime eDate = Utils.GetDateTime(Utils.GetFormValue("txtEDate"));
//价格
string[] PricesArr = Utils.GetFormValues("txtprice");
//数量
string[] NumArr = Utils.GetFormValues("txtnum");
if (PricesArr.Length > 0)
{
string tfID = Utils.GetQueryStringValue("tfId");
for (int i = 0; i < PricesArr.Length; i++)
{
EyouSoft.Model.PlanStructure.TrafficPricesInfo model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo();
model.TrafficId = Utils.GetInt(tfID);
model.InsueTime = DateTime.Now;
model.SDateTime = sDate.AddDays(i);
model.Status = EyouSoft.Model.EnumType.PlanStructure.TicketStatus.正常;
model.TicketNums = Utils.GetInt(NumArr[i]);
model.TicketPrices = Utils.GetDecimal(PricesArr[i]);
bool result = new EyouSoft.BLL.PlanStruture.PlanTrffic().AddTrafficPrice(model);
if (result)
{
ret = "{\"ret\":\"1\",\"msg\":\"添加成功!\"}";
}
else
{
ret = "{\"ret\":\"0\",\"msg\":\"添加失败!\"}";
}
}
}
return(ret);
}
/// <summary>
/// 修改价格
/// </summary>
/// <param name="pricemodel">价格实体</param>
/// <returns>true 成功 false 失败</returns>
public bool UpdatetrafficPrice(EyouSoft.Model.PlanStructure.TrafficPricesInfo pricemodel)
{
if (pricemodel == null)
{
return(false);
}
bool result = Idal.UpdateTrafficPrice(pricemodel);
if (result)
{
this.TongBuGengXinTuanDui(pricemodel.TrafficId);
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() + "更新交通价格！编号为：" + pricemodel.PricesID,
EventTitle = "修改" + Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理.ToString() + "数据"
});
}
return(result);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="pricesId">价格编号</param>
/// <returns></returns>
protected string PageSave()
{
string msg = string.Empty;
EyouSoft.Model.PlanStructure.TrafficPricesInfo priceInfo = new EyouSoft.Model.PlanStructure.TrafficPricesInfo();
priceInfo.InsueTime = DateTime.Now;
priceInfo.SDateTime = Utils.GetDateTime(Utils.GetQueryStringValue("date"));
priceInfo.Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus)Utils.GetInt(Utils.GetFormValue("radStatus"));
priceInfo.TicketNums = Utils.GetInt(Utils.GetFormValue(this.txtTicketNums.UniqueID));
priceInfo.TicketPrices = Utils.GetDecimal(Utils.GetFormValue(this.txtTicketPrices.UniqueID));
priceInfo.TrafficId = Utils.GetInt(Utils.GetQueryStringValue("tfId"));
if (Utils.GetQueryStringValue("type") == "update")
{
priceInfo.PricesID = Utils.GetQueryStringValue("pricesId");
bool ret = new EyouSoft.BLL.PlanStruture.PlanTrffic().UpdatetrafficPrice(priceInfo);
if (ret)
{
msg = "{\"msg\":\"修改成功!\"}";
}
else
{
msg = "{\"msg\":\"修改失败!\"}";
}
}
else
{
bool ret = new EyouSoft.BLL.PlanStruture.PlanTrffic().AddTrafficPrice(priceInfo);
if (ret)
{
msg = "{\"msg\":\"添加成功!\"}";
}
else
{
msg = "{\"msg\":\"添加失败!\"}";
}
}
return(msg);
}
/// <summary>
/// 获取价格列表
/// </summary>
/// <param name="TrafficId">交通编号</param>
/// <returns>价格集合</returns>
public IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> GetPricesList(int trafficID)
{
IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> priceslist = null;
EyouSoft.Model.PlanStructure.TrafficPricesInfo pricesmodel = null;
StringBuilder sqlWhere = new StringBuilder();
sqlWhere.AppendFormat(" SELECT * ");
sqlWhere.AppendFormat(" ,(SELECT SUM(to1.PeopleNumber - to1.LeaguePepoleNum) FROM tbl_TourOrder to1 WHERE to1.IsDelete = '0' AND EXISTS(SELECT 1 FROM tbl_TourOrderTraffic tot WHERE tot.OrderId = to1.ID AND tot.TrafficId = tbl_TrafficPrices.TrafficId) AND DATEDIFF(dd,to1.LeaveDate,tbl_TrafficPrices.SDateTime) = 0 and to1.OrderState IN({0},{1},{2})) as YiShiYong ",
(int)Model.EnumType.TourStructure.OrderState.未处理,
(int)Model.EnumType.TourStructure.OrderState.已成交,
(int)Model.EnumType.TourStructure.OrderState.已留位);
sqlWhere.AppendFormat(" FROM tbl_TrafficPrices WHERE TrafficId = {0} ORDER BY InsueTime DESC ", trafficID);
DbCommand cmd = this._db.GetSqlStringCommand(sqlWhere.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
priceslist = new List <EyouSoft.Model.PlanStructure.TrafficPricesInfo>();
while (dr.Read())
{
pricesmodel = new EyouSoft.Model.PlanStructure.TrafficPricesInfo()
{
InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")),
PricesID = !dr.IsDBNull(dr.GetOrdinal("PricesID")) ? dr.GetString(dr.GetOrdinal("PricesID")) : string.Empty,
SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime")),
Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()),
TrafficId = Convert.ToInt32(dr["TrafficId"].ToString()),
TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0,
TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0,
YiShiYong = dr.IsDBNull(dr.GetOrdinal("YiShiYong")) ? 0 : dr.GetInt32(dr.GetOrdinal("YiShiYong"))
};
priceslist.Add(pricesmodel);
}
}
return(priceslist);
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
NumConfig = (int)(new EyouSoft.BLL.CompanyStructure.CompanySetting().GetTeamNumberOfPeople(CurrentUserCompanyID));
#region 将表单值 赋值给变量
//团号
string teamNum = Utils.InputText(this.txtTeamNum.Text);
//线路区域名
string lineArea = Utils.GetFormValue(this.ddlLineArea.UniqueID);
//计调员
string coordinatorId = Utils.GetFormValue(this.ddlSeller.UniqueID);
//组团社ID
int buyerCId = Utils.GetInt(this.hideGroupsId.Value);
//组团社名称
string buyerCName = Utils.GetFormValue(this.txtGroupsName.UniqueID);
//线路名称
string xianLuName = this.xianluWindow1.Name;
//线路ID
string routeId = this.xianluWindow1.Id;
//天数
int dayCount = Utils.GetInt(this.txtDayCount.Text);
//人数
int peopleCount = Utils.GetInt(this.txtPeopelCount.Text);
//出发交通
string startTraffic = Utils.InputText(this.txtStartTraffic.Text);
//返程交通
string endTraffic = Utils.InputText(this.txtEndTraffic.Text.Trim());
//出团日期
DateTime lDate = Convert.ToDateTime(this.txtLDate.Text);
//回团日期
// DateTime rDate = Convert.ToDateTime(this.txtRDate.Text);
//添加地接社信息
IList <EyouSoft.Model.TourStructure.TourLocalAgencyInfo> list = this.DiJieControl1.GetList;
//添加价格组成
IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> listPrice = this.PriceControl1.GetList;
//行程安排
string travel = Utils.EditInputText(this.txtTravel.Text);
//服务标准
string services = Utils.EditInputText(this.txtServices.Text);
//备注
string remarks = this.txtRemarks.Text;
//常用城市
int tourCity = Utils.GetInt(Utils.GetFormValue(this.ddlCityList.UniqueID));
#endregion
#region 验证
//判断线路区域不能为空
if (lineArea == "")
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择线路区域"));
return;
}
//判断是否选择组团社
if (buyerCId <= 0)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择组团社!"));
return;
}
if (coordinatorId == "-1")
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择计调员!"));
return;
}
//判断线路名称不能为空
if (xianLuName == "")
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入线路名称!"));
return;
}
//判断天数不能为空
if (dayCount == 0)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入天数!"));
return;
}
//判断人数不能为空
if ((peopleCount == null || peopleCount == 0) && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.OnlyTotalNumber)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!"));
return;
}
int crNum = Utils.GetInt(txt_crNum.Text);
if (crNum == 0 && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.PartNumber)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!"));
return;
}
#endregion
#region 验证上传文件的格式是否正确
string msg = "";
if (!EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "fileField", new[] { ".gif", ".jpeg", ".jpg", ".png", ".xls", ".doc", ".docx", ".rar", ".txt" }, null, out msg))
{
this.litMsg.Text = Utils.ShowMsg(msg);
return;
}
#endregion
//声明bll对象
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour();
//声明团队计划对象
EyouSoft.Model.TourStructure.TourTeamInfo model = new EyouSoft.Model.TourStructure.TourTeamInfo();
if (this.hideType.Value == "Update")
{
//如果是修改操作，那么先获的这个对象
model = (EyouSoft.Model.TourStructure.TourTeamInfo)bll.GetTourInfo(this.hideID.Value);
}
#region 对象属性赋值
//判断对象时候存在
if (model != null)
{
//对象属性赋值
model.TourCode = teamNum;
model.AreaId = Convert.ToInt32(lineArea);
model.Coordinator = new EyouSoft.Model.TourStructure.TourCoordinatorInfo();
model.Coordinator.CoordinatorId = Utils.GetInt(coordinatorId);
//修改时原购买单位
if (model.BuyerCId > 0)
{
model.OBuyerCId = model.BuyerCId;
}
model.BuyerCId = buyerCId;
model.BuyerCName = buyerCName;
model.RouteName = xianLuName;
if (model.RouteId > 0)
{
model.ORouteId = model.RouteId;
}
model.RouteId = Utils.GetInt(routeId);
model.TourDays = dayCount;
model.PlanPeopleNumber = peopleCount;
model.LTraffic = startTraffic;
model.RTraffic = endTraffic;
model.LDate = lDate;
model.LocalAgencys = list;
model.Services = listPrice;
model.CompanyId = SiteUserInfo.CompanyID;
EyouSoft.Model.TourStructure.TourQuickPrivateInfo quickInfo = new EyouSoft.Model.TourStructure.TourQuickPrivateInfo();
quickInfo.QuickPlan = travel;
quickInfo.Service = services;
quickInfo.Remark = remarks;
model.TourQuickInfo = quickInfo;
model.OperatorId = SiteUserInfo.ID;
model.TourType = EyouSoft.Model.EnumType.TourStructure.TourType.团队计划;
model.ReleaseType = EyouSoft.Model.EnumType.TourStructure.ReleaseType.Quick;
model.TicketStatus = EyouSoft.Model.EnumType.PlanStructure.TicketState.None;
model.TotalAmount = PriceControl1.TotalAmount;
model.TourCityId = tourCity;
model.TourTraffic = new List <int>()
{
Utils.GetInt(Utils.GetFormValue("selectTraffic"), -1)
};
///人数、单价 by txb
model.TourTeamUnit = new EyouSoft.Model.TourStructure.MTourTeamUnitInfo();
model.TourTeamUnit.NumberCr = Utils.GetInt(txt_crNum.Text);
model.TourTeamUnit.NumberEt = Utils.GetInt(txt_rtNum.Text);
model.TourTeamUnit.NumberQp = Utils.GetInt(txt_allNum.Text);
model.TourTeamUnit.UnitAmountCr = PriceControl1.cr_price;
model.TourTeamUnit.UnitAmountEt = PriceControl1.rt_price;
model.TourTeamUnit.UnitAmountQp = PriceControl1.all_price;
#endregion
#region 单文件
//团队附件实体
EyouSoft.Model.TourStructure.TourAttachInfo attachModel = new EyouSoft.Model.TourStructure.TourAttachInfo();
//文件路径
string filePath = "";
//文件名
string fileName = "";
//文件上传
if (EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["fileField"], "TeamPlanFile", out filePath, out fileName))
{
if (filePath.Trim() != "" && fileName.Trim() != "")
{
//设置文件上传后的虚拟路劲
attachModel.FilePath = filePath;
//保存原文件名
attachModel.Name = fileName;
IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>();
attachList.Add(attachModel);
model.Attachs = attachList;
}
else if (Utils.GetFormValue(this.hideData.UniqueID).Trim() != "")
{
attachModel.FilePath = this.hideData.Value;
IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>();
attachList.Add(attachModel);
model.Attachs = attachList;
}
else
{
model.Attachs = null;
}
}
else
{
//上传失败提示
this.litMsg.Text = Utils.ShowMsg("文件上传失败!");
return;
}
#endregion
int count = 0;
if (model.TourTraffic != null && model.TourTraffic.Count > 0)
{
EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic();
EyouSoft.Model.PlanStructure.TrafficPricesInfo TrafficPricesInfoModel = BLL.GetTrafficPriceModel(model.TourTraffic.First(), model.LDate);
if (TrafficPricesInfoModel != null && TrafficPricesInfoModel.TicketNums > 0)
{
//如果是新增和复制 时 都做新增操作
if (this.hideType.Value == "Add" || this.hideType.Value == "Copy")
{
//数据库添加操作
count = bll.InsertTeamTourInfo(model);
//新增成功
if (count > 0)
{
Utils.ShowAndRedirect("添加成功!", "/TeamPlan/TeamPlanList.aspx");
}
else
//失败时提示
if (count == -1)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("团号重复!"));
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("添加失败!"));
}
}
else
{
//数据库修改操作
count = bll.UpdateTeamTourInfo(model);
//成功提示
if (count > 0)
{
Utils.ShowAndRedirect("修改成功!", "/TeamPlan/TeamPlanList.aspx");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("修改失败!"));
}
}
}
else
{
Response.Write("<script type='text/javascript'>alert('提交失败,关联交通票数为零！');location.href=location.href;</script>");
}
}
else
{
Response.Write("<script type='text/javascript'>alert('提交失败,关联交通为空！');location.href=location.href;</script>");
}
}
else
{
Utils.ShowAndRedirect("该计划不存在!", "/TeamPlan/TeamPlanList.aspx");
}
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
NumConfig = (int)(new EyouSoft.BLL.CompanyStructure.CompanySetting().GetTeamNumberOfPeople(CurrentUserCompanyID));
#region 将表单值赋值于变量
//团号
string teamNum = this.txtTeamNum.Text.Trim();
//线路区域名
string lineArea = Utils.GetFormValue(this.ddlLineArea.UniqueID);
//计调员
string coordinatorId = Utils.GetFormValue(this.ddlSeller.UniqueID);
//线路名称
string xianLuName = this.xianluWindow1.Name;
//线路ID
string routeId = this.xianluWindow1.Id;
//组团社ID
int buyerCId = Utils.GetInt(this.hideGroupsId.Value);
//组团社名称
string buyerCName = Utils.GetFormValue(this.txtGroupsName.UniqueID);
//天数
int?dayCount = Utils.GetIntNull(this.txtDayCount.Text);
//人数
int?peopleCount = Utils.GetIntNull(this.txtPeopelCount.Text);
//出发交通
string startTraffic = this.txtStartTraffic.Text.Trim();
//返程交通
string endTraffic = this.txtEndTraffic.Text.Trim();
//出团日期
DateTime lDate = Utils.GetDateTime(this.txtLDate.Text);
//不含项目
string noProject = this.txtNoProject.Text.Trim();
//购物安排
string buyPlan = this.txtBuyPlan.Text;
//儿童安排
string childPlan = this.txtChildPlan.Text;
//自费项目
string selfProject = this.txtSelfProject.Text;
//注意事项
string note = this.txtNote.Text;
//温馨提示
string tips = this.txtTips.Text;
//内部信息
string internalMsg = this.txtNeiBu.Text;
//集合时间
//string gatheredTime = (Utils.GetFormValue(this.txtGathered.UniqueID)) + " " + ddl_jh_date.SelectedValue + ":00:00";
string gatheredTime = Utils.GetFormValue(this.txtGathered.UniqueID);
//集合地点
string place = Utils.GetFormValue(this.txtPlace.UniqueID);
//集合标志
string logo = Utils.GetFormValue(this.txtLogo.UniqueID);
//送团人
string operatorId = this.selectOperator1.OperId;
//常用城市
int tourCity = Utils.GetInt(Utils.GetFormValue(this.ddlCityList.UniqueID));
#endregion
#region 验证上传文件的格式是否正确
string msg = "";
if (!EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "fileField", new[] { ".gif", ".jpeg", ".jpg", ".png", ".xls", ".doc", ".docx", ".rar", ".txt" }, null, out msg))
{
this.litMsg.Text = Utils.ShowMsg(msg);
return;
}
#endregion
#region 地接信息
IList <EyouSoft.Model.TourStructure.TourLocalAgencyInfo> djList = this.DiJieControl1.GetList;
#endregion
#region 行程安排
IList <EyouSoft.Model.TourStructure.TourPlanInfo> planList = this.xingcheng1.GetValues();
#endregion
#region 包含项目
IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> standList = this.PriceControl1.GetList;
#endregion
#region 验证
if (lineArea == "")
{
this.litMsg.Text = Utils.ShowMsg("请选择线路区域!");
return;
}
//判断是否选择组团社
if (buyerCId <= 0)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择组团社!"));
return;
}
if (xianLuName == "")
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入线路名称!"));
return;
}
if (coordinatorId == "-1")
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择计调员!"));
return;
}
if (dayCount == null || dayCount == 0)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入天数!"));
return;
}
if ((peopleCount == null || peopleCount == 0) && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.OnlyTotalNumber)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!"));
return;
}
int crNum = Utils.GetInt(txt_crNum.Text);
if (crNum == 0 && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.PartNumber)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!"));
return;
}
#endregion
//声明bll对象
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo);
//声明model对象
EyouSoft.Model.TourStructure.TourTeamInfo model = new EyouSoft.Model.TourStructure.TourTeamInfo();
//如果是修改那么先获得该对象model
if (this.hideType.Value == "Update")
{
//如果是修改操作，那么先获的这个对象
model = (EyouSoft.Model.TourStructure.TourTeamInfo)bll.GetTourInfo(this.hideID.Value);
}
//判断对象是否存在
if (model != null)
{
#region 对象属性赋值
model.TourCode = teamNum;
model.AreaId = Convert.ToInt32(lineArea);
//修改时原购买单位
if (model.BuyerCId > 0)
{
model.OBuyerCId = model.BuyerCId;
}
model.Coordinator = new EyouSoft.Model.TourStructure.TourCoordinatorInfo();
model.Coordinator.CoordinatorId = Utils.GetInt(coordinatorId);
model.BuyerCId = buyerCId;
model.BuyerCName = buyerCName;
model.RouteName = xianLuName;
if (model.RouteId != 0)
{
model.ORouteId = model.RouteId;
}
model.RouteId = Utils.GetInt(routeId);
model.TourDays = Convert.ToInt32(dayCount);
#region 添加送团人
if (this.selectOperator1.OperId.Trim() != "")
{
string[] operIdList = this.selectOperator1.OperId.Split(',');
if (operIdList.Count() > 0)
{
model.SentPeoples = new List <EyouSoft.Model.TourStructure.TourSentPeopleInfo>();
for (int i = 0; i < operIdList.Count(); i++)
{
if (operIdList[i].Trim() != "")
{
EyouSoft.Model.TourStructure.TourSentPeopleInfo sentPeopleModel = new EyouSoft.Model.TourStructure.TourSentPeopleInfo();
sentPeopleModel.OperatorId = Utils.GetInt(operIdList[i]);
model.SentPeoples.Add(sentPeopleModel);
}
}
}
}
#endregion
model.GatheringPlace = place;
model.GatheringSign = logo;
model.GatheringTime = gatheredTime;
model.PlanPeopleNumber = Convert.ToInt32(peopleCount);
model.LTraffic = startTraffic;
model.RTraffic = endTraffic;
model.LDate = lDate;
model.LocalAgencys = djList;
EyouSoft.Model.TourStructure.TourTeamNormalPrivateInfo tourTeamModel = new EyouSoft.Model.TourStructure.TourTeamNormalPrivateInfo();
tourTeamModel.Plans = planList;
tourTeamModel.BuHanXiangMu = noProject;
tourTeamModel.GouWuAnPai = buyPlan;
tourTeamModel.ErTongAnPai = childPlan;
tourTeamModel.ZiFeiXIangMu = selfProject;
tourTeamModel.ZhuYiShiXiang = note;
tourTeamModel.WenXinTiXing = tips;
tourTeamModel.NeiBuXingXi = internalMsg;
model.TourNormalInfo = tourTeamModel;
model.Services = standList;
model.CompanyId = SiteUserInfo.CompanyID;
model.OperatorId = SiteUserInfo.ID;
model.TourType = EyouSoft.Model.EnumType.TourStructure.TourType.团队计划;
model.ReleaseType = EyouSoft.Model.EnumType.TourStructure.ReleaseType.Normal;
model.TicketStatus = EyouSoft.Model.EnumType.PlanStructure.TicketState.None;
model.TotalAmount = PriceControl1.TotalAmount;
//model.SelfUnitPriceAmount = PriceControl1.OnePriceAll;
model.TourCityId = tourCity;
model.TourTraffic = new List <int>()
{
Utils.GetInt(Utils.GetFormValue("selectTraffic"), -1)
};
///人数、单价 by txb
model.TourTeamUnit = new EyouSoft.Model.TourStructure.MTourTeamUnitInfo();
model.TourTeamUnit.NumberCr = Utils.GetInt(txt_crNum.Text);
model.TourTeamUnit.NumberEt = Utils.GetInt(txt_rtNum.Text);
model.TourTeamUnit.NumberQp = Utils.GetInt(txt_allNum.Text);
model.TourTeamUnit.UnitAmountCr = PriceControl1.cr_price;
model.TourTeamUnit.UnitAmountEt = PriceControl1.rt_price;
model.TourTeamUnit.UnitAmountQp = PriceControl1.all_price;
#endregion
#region 单文件
//团队附件实体
EyouSoft.Model.TourStructure.TourAttachInfo attachModel = new EyouSoft.Model.TourStructure.TourAttachInfo();
//文件路径
string filePath = "";
//文件名
string fileName = "";
//文件上传
if (EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["fileField"], "TeamPlanFile", out filePath, out fileName))
{
if (filePath.Trim() != "" && fileName.Trim() != "")
{
//设置文件上传后的虚拟路劲
attachModel.FilePath = filePath;
//保存原文件名
attachModel.Name = fileName;
IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>();
attachList.Add(attachModel);
model.Attachs = attachList;
}
else if (this.hideData.Value.Trim() != "")
{
//设置文件上传后的虚拟路劲
attachModel.FilePath = this.hideData.Value;
IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>();
attachList.Add(attachModel);
model.Attachs = attachList;
}
else
{
model.Attachs = null;
}
}
else
{
//上传失败提示
this.litMsg.Text = Utils.ShowMsg("文件上传失败!");
return;
}
#endregion
#region 数据操作
int count = 0;
if (model.TourTraffic != null && model.TourTraffic.Count > 0)
{
EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic();
EyouSoft.Model.PlanStructure.TrafficPricesInfo TrafficPricesInfoModel = BLL.GetTrafficPriceModel(model.TourTraffic.First(), model.LDate);
if (TrafficPricesInfoModel != null && TrafficPricesInfoModel.TicketNums > 0)
{
//新增和复制操作时 进行数据添加操作
if (this.hideType.Value == "Add" || this.hideType.Value == "Copy")
{
//数据库添加操作
count = bll.InsertTeamTourInfo(model);
//新增成功
if (count > 0)
{
Utils.ShowAndRedirect("添加成功!", "/TeamPlan/TeamPlanList.aspx");
}
else
//失败时提示
if (count == -1)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('团号重复!');");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('添加失败!');");
}
}
else
{
//数据库修改操作
count = bll.UpdateTeamTourInfo(model);
//成功提示
if (count > 0)
{
Utils.ShowAndRedirect("修改成功!", "/TeamPlan/TeamPlanList.aspx");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('修改失败!');");
}
}
}
else
{
Response.Write("<script type='text/javascript'>alert('提交失败,关联交通票数为零！');location.href=location.href;</script>");
}
}
else
{
Response.Write("<script type='text/javascript'>alert('提交失败,关联交通为空！');location.href=location.href;</script>");
}
#endregion
}
else
{
Utils.ShowAndRedirect("该计划不存在!", "/TeamPlan/TeamPlanList.aspx");
}
}