public void GetDefaultPolicy()
{
string cpyNo = GetVal("cpyNo", "");
string aircode = GetVal("aircode", "ALL");
if (!string.IsNullOrEmpty(cpyNo))
{
string sqlWhere = string.Format(" CpyNo='{0}' and CarryCode like '%{1}%' and A1 in(1,2) ", cpyNo, aircode.Trim(new char[] { '/' }));
List <Tb_Ticket_Policy> defaultList = this.baseDataManage.CallMethod("Tb_Ticket_Policy", "GetList", null, new object[] { sqlWhere }) as List <Tb_Ticket_Policy>;
if (defaultList != null && defaultList.Count > 0)
{
Tb_Ticket_Policy adult = defaultList.Find(delegate(Tb_Ticket_Policy tb_ticket_policy)
{
return(tb_ticket_policy.A1 == 1 ? true : false);
});
Tb_Ticket_Policy child = defaultList.Find(delegate(Tb_Ticket_Policy tb_ticket_policy)
{
return(tb_ticket_policy.A1 == 2 ? true : false);
});
if (adult != null)
{
string cityData = JsonHelper.ObjToJson <Tb_Ticket_Policy>(adult);
Hid_AdultPolicy.Value = escape(cityData);
SelectAirCode1.Value = adult.CarryCode.Trim(new char[] { '/' });
Hid_AirCode.Value = adult.CarryCode.Trim(new char[] { '/' });
}
if (child != null)
{
string cityData = JsonHelper.ObjToJson <Tb_Ticket_Policy>(child);
Hid_ChildPolicy.Value = escape(cityData);
SelectAirCode1.Value = child.CarryCode.Trim(new char[] { '/' });
Hid_AirCode.Value = child.CarryCode.Trim(new char[] { '/' });
}
string id = GetVal("id", "");
Hid_IsEdit.Value = "1";
Hid_id.Value = id; //列表中的数据id
string currPage = GetVal("currPage", "1");
Hid_currPage.Value = currPage; //来自列表第几页
Hid_where.Value = Request["where"] != null && Request["where"].ToString() != "" ? Request["where"].ToString() : "";
addAndNext.Value = "保存";
}
else
{
addAndNext.Value = "保存";
Hid_IsEdit.Value = "0";
SetDefaultDate();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "showdialog('页面初始化异常!');", true);
}
}
/// <summary>
/// 加载页面类型
/// </summary>
public void LoadSetParam()
{
//政策种类 1普通政策 2特价政策 3默认政策 4散冲团政策 5团政策 6特殊仓位政策
if (Request["PageType"] != null && Request["PageType"].ToString() != "")
{
//政策种类 1.普通，2.特价
string strPolicyKind = Request["PageType"].ToString();
if (strPolicyKind == "1" || strPolicyKind == "2")
{
if (GetVal("id", "") != "")
{
//按钮
addAndNext.Value = "保存";
//来源---------------
string id = GetVal("id", "");
Hid_id.Value = id; //列表中的数据id
string currPage = GetVal("currPage", "1");
Hid_currPage.Value = currPage; //来自列表第几页
Hid_where.Value = Request["where"].ToString();
//来源---------------
Tb_Ticket_Policy PTPolicy = this.baseDataManage.CallMethod("Tb_Ticket_Policy", "GetById", null, new object[] { id }) as Tb_Ticket_Policy;
if (PTPolicy != null)
{
Hid_IsEdit.Value = "1";//编辑
string formatData = JsonHelper.ObjToJson <Tb_Ticket_Policy>(PTPolicy);
Hid_EditData.Value = escape(formatData);
}
}
else
{
//日期
SetDefaultDate();
}
}
Hid_PolicyKind.Value = Request["PageType"].ToString();
Hid_PageType.Value = Request["PageType"].ToString();
}
else
{
//日期
SetDefaultDate();
}
//页面类型
PageType = Hid_PageType.Value;
showText(PageType, Hid_IsEdit.Value);
}
/// <summary>
/// 将517政策合并到原始政策dt中去
/// </summary>
/// <param name="LocalDt">原始dt</param>
/// <param name="Dt517">517dt</param>
private List <PbProject.Model.Tb_Ticket_Policy> Merger517DT(DataRow[] Dr517, User_Company GYCompany, bool ChangePnr)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < Dr517.Length; i++)
{
//如果不允许换编码并且政策是必须换编码出票的,则过滤掉,yyy 2013-6-7update
if (!ChangePnr && bool.Parse(Dr517[i]["IsChangePNRCP"].ToString()))
{
continue;
}
//DataRow dr = LocalDt.NewRow();
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = "0" + PbProject.Model.definitionParam.PolicySourceParam.b517na.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
if (Dr517[i]["IsSp"].ToString() == "0") //是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = Dr517[i]["CarryCode"].ToString();
if (Dr517[i]["TravelType"].ToString() == "单程")
{
mPolicy.TravelType = 1;
}
else if (Dr517[i]["TravelType"].ToString() == "单程/往返")
{
mPolicy.TravelType = 2;
}
else if (Dr517[i]["TravelType"].ToString() == "往返")
{
mPolicy.TravelType = 3;
}
else
{
mPolicy.TravelType = 4;
}
if (Dr517[i]["PolicyType"].ToString() == "1")
{
mPolicy.PolicyType = 2;
}
else
{
mPolicy.PolicyType = 1;
}
mPolicy.TeamFlag = 0;
if (Dr517[i]["FromCity"].ToString() == "")
{
mPolicy.StartCityNameCode = "ALL";
}
else
{
mPolicy.StartCityNameCode = Dr517[i]["FromCity"].ToString();
}
mPolicy.StartCityNameSame = 2;
if (Dr517[i]["ToCity"].ToString() == "")
{
mPolicy.TargetCityNameCode = "ALL";
}
else
{
mPolicy.TargetCityNameCode = Dr517[i]["FromCity"].ToString();
}
mPolicy.TargetCityNameSame = 2;
if (Dr517[i]["FlightType"].ToString() == "1")
{
mPolicy.ApplianceFlight = Dr517[i]["Flight"].ToString();
}
if (Dr517[i]["FlightType"].ToString() == "2")
{
mPolicy.UnApplianceFlight = Dr517[i]["Flight"].ToString();
}
if (Dr517[i]["FlightType"].ToString() == "0")
{
mPolicy.ApplianceFlightType = 1;
}
else if (Dr517[i]["FlightType"].ToString() == "1")
{
mPolicy.ApplianceFlightType = 2;
}
else
{
mPolicy.ApplianceFlightType = 3;
}
mPolicy.ScheduleConstraints = Dr517[i]["ScheduleConstraints"].ToString();
mPolicy.ShippingSpace = Dr517[i]["Space"].ToString();
mPolicy.SpacePrice = Convert.ToDecimal(Dr517[i]["PMFee"]);
mPolicy.FlightStartDate = Convert.ToDateTime(Dr517[i]["EffectDate"]);
mPolicy.FlightEndDate = Convert.ToDateTime(Dr517[i]["ExpirationDate"]);
mPolicy.PrintStartDate = Convert.ToDateTime(Dr517[i]["EffectDate"]);
mPolicy.PrintEndDate = Convert.ToDateTime(Dr517[i]["ExpirationDate"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
string isChangePnr = "";
if (bool.Parse(Dr517[i]["IsChangePNRCP"].ToString()))
{
isChangePnr = "须换编码出票.";
}
mPolicy.Remark = isChangePnr + " " + Dr517[i]["Remark"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(Dr517[i]["Policy"].ToString());
mPolicy.InterPolicyId = Dr517[i]["PolicyID"].ToString() + "~" + Dr517[i]["PolicyChildID"].ToString();
mPolicy._WorkTime = WorkTimeConvert(Dr517[i]["GYOnlineTime"].ToString(), GYCompany.WorkTime);
mPolicy._FPGQTime = Dr517[i]["GYFPTime"].ToString();
mPolicy.Office = Dr517[i]["Office"] == DBNull.Value?"":Dr517[i]["Office"].ToString();
mPolicyList.Add(mPolicy);
//dr["CarryCode"] = Dr517[i]["CarryCode"];
//if (Dr517[i]["FlightType"].ToString() == "1")
//{
// dr["ApplianceFlight"] = Dr517[i]["Flight"];
//}
//if (Dr517[i]["FlightType"].ToString() == "2")
//{
// dr["UnApplianceFlight"] = Dr517[i]["Flight"];
//}
//dr["ScheduleConstraints"] = Dr517[i]["ScheduleConstraints"];
//dr["Space"] = "/" + Dr517[i]["Space"] + "/";
//dr["OldPolicy"] = decimal.Parse(Dr517[i]["Policy"].ToString()) / 100;
//dr["GYPolicy"] = decimal.Parse(Dr517[i]["Policy"].ToString()) / 100;
//dr["FXPolicy"] = decimal.Parse(Dr517[i]["Policy"].ToString()) / 100;
//dr["PolicySource"] = "3";
//dr["PolicyId"] = Dr517[i]["PolicyID"] + "~" + Dr517[i]["PolicyChildID"];
//dr["PolicyType"] = Dr517[i]["PolicyType"];
//if (DateTime.Now.DayOfWeek != DayOfWeek.Saturday && DateTime.Now.DayOfWeek != DayOfWeek.Sunday)
//{
// dr["WorkTime"] = WorkTimeConvert(Dr517[i]["GYOnlineTime"].ToString(), GYCompany.WorkTime);
// dr["BusinessTime"] = Dr517[i]["GYFPTime"];
//}
//else
//{
// dr["WorkTime"] = Dr517[i]["GYOutlineTime"];
// dr["BusinessTime"] = Dr517[i]["GYFPTimeNew"];
//}
//dr["SpecialType"] = "0";
//dr["IsPause"] = "0";
//dr["IsLowerOpen"] = "0";
//dr["Remark"] = Dr517[i]["Remark"];
//dr["PolOffice"] = Dr517[i]["Office"];
//LocalDt.Rows.Add(dr);
}
return(mPolicyList);
}
finally
{ }
}
private List <PbProject.Model.Tb_Ticket_Policy> MergerTodayDT(DataRow[] DrToday, User_Company GYCompany, string CarryCode, string FromCityCode, string ToCityCode)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < DrToday.Length; i++)
{
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = "0" + PbProject.Model.definitionParam.PolicySourceParam.bToday.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
if (DrToday[i]["RateType"].ToString() == "0")//是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = CarryCode;
if (DrToday[i]["VoyageType"].ToString() == "0")
{
mPolicy.TravelType = 1;
}
else if (DrToday[i]["VoyageType"].ToString() == "2")
{
mPolicy.TravelType = 2;
}
else if (DrToday[i]["VoyageType"].ToString() == "1")
{
mPolicy.TravelType = 3;
}
else
{
mPolicy.TravelType = 4;
}
if (DrToday[i]["RateType"].ToString().ToUpper().Contains("B2P"))
{
mPolicy.PolicyType = 2;
}
else
{
mPolicy.PolicyType = 1;
}
if (DrToday[i]["UserType"].ToString() == "0")
{
mPolicy.TeamFlag = 0;
}
else
{
mPolicy.TeamFlag = 1;
}
mPolicy.StartCityNameCode = FromCityCode;
mPolicy.StartCityNameSame = 2;
mPolicy.TargetCityNameCode = ToCityCode;
mPolicy.TargetCityNameSame = 2;
//适用的航空公司
mPolicy.ApplianceFlight = DrToday[i]["AirComE"].ToString();
//不适用的航空公司
mPolicy.UnApplianceFlight = DrToday[i]["NoAirComE"].ToString();
mPolicy.ApplianceFlightType = 1;
mPolicy.ScheduleConstraints = "";
mPolicy.ShippingSpace = DrToday[i]["Cabin"].ToString();
mPolicy.FlightStartDate = Convert.ToDateTime(DrToday[i]["Sdate"]);
mPolicy.FlightEndDate = Convert.ToDateTime(DrToday[i]["Edate"]);
mPolicy.PrintStartDate = Convert.ToDateTime(DrToday[i]["Sdate"]);
mPolicy.PrintEndDate = Convert.ToDateTime(DrToday[i]["Edate"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
mPolicy.Remark = DrToday[i]["Remark"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(DrToday[i]["Discounts"].ToString());
mPolicy.InterPolicyId = DrToday[i]["PolicyId"].ToString();
string workTime = "{0}-{1}";
workTime = string.Format(workTime, DrToday[i]["WorkTimeBegin"].ToString(), DrToday[i]["WorkTimeEnd"].ToString());
mPolicy._WorkTime = WorkTimeConvert(workTime, GYCompany.WorkTime);
mPolicy._FPGQTime = DrToday[i]["RefundTimeBegin"].ToString() + "-" + DrToday[i]["RefundTimeEnd"].ToString();
//Office
mPolicy.Office = (DrToday[i]["OfficeNum"] == DBNull.Value ? "" : DrToday[i]["OfficeNum"].ToString());// +"^" + (DrToday[i]["RateId"] == DBNull.Value ? "" : DrToday[i]["RateId"].ToString());
//供应商ID
mPolicy.A16 = DrToday[i]["RateId"].ToString();
mPolicyList.Add(mPolicy);
//DataRow dr = LocalDt.NewRow();
//dr["CarryCode"] = CarryCode;
//dr["ApplianceFlight"] = DrToday[i]["AirComE"].ToString().Replace(CarryCode, "");
//dr["UnApplianceFlight"] = DrToday[i]["NoAirComE"].ToString().Replace(CarryCode, "");
//dr["ScheduleConstraints"] = "1/2/3/4/5/6/7";
//dr["Space"] = "/" + DrToday[i]["Cabin"].ToString() + "/";
//dr["OldPolicy"] = decimal.Parse(DrToday[i]["Discounts"].ToString()) / 100;
//dr["GYPolicy"] = decimal.Parse(DrToday[i]["Discounts"].ToString()) / 100;
//dr["FXPolicy"] = decimal.Parse(DrToday[i]["Discounts"].ToString()) / 100;
//dr["PolicySource"] = "4";
//dr["PolicyId"] = DrToday[i]["PolicyId"];
//dr["PolicyType"] = DrToday[i]["RateType"].ToString().ToUpper().Contains("B2B") ? "1" : "2";
//workTime = string.Format(workTime, DrToday[i]["WorkTimeBegin"].ToString(), DrToday[i]["WorkTimeEnd"].ToString());
//dr["WorkTime"] = WorkTimeConvert(workTime, GYCompany.WorkTime);
//dr["BusinessTime"] = DrToday[i]["RefundTimeBegin"].ToString() + "-" + DrToday[i]["RefundTimeEnd"].ToString();
//dr["SpecialType"] = "0";
//dr["IsPause"] = "0";
//dr["IsLowerOpen"] = "0";
//dr["Remark"] = DrToday[i]["Remark"].ToString();
//dr["PolOffice"] = DrToday[i]["OfficeNum"] + "^" + DrToday[i]["RateId"];
//LocalDt.Rows.Add(dr);
}
return(mPolicyList);
}
finally
{ }
}
private List <PbProject.Model.Tb_Ticket_Policy> Merger8000YDT(DataRow[] Dr8000Y, User_Company GYCompany, bool ChangePnr)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < Dr8000Y.Length; i++)
{
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = "0" + PbProject.Model.definitionParam.PolicySourceParam.b8000yi.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
//yyy 2013年6月7日
//过滤掉换编码出票的政策
if (!ChangePnr)
{
if (Dr8000Y[i]["A17"].ToString().Contains("换编码出票"))
{
continue;
}
}
if (Dr8000Y[i]["A22"].ToString() == "0")//是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = Dr8000Y[i]["A4"].ToString();
if (Dr8000Y[i]["A7"].ToString() == "1")
{
mPolicy.TravelType = 1;
}
else if (Dr8000Y[i]["A7"].ToString() == "3")
{
mPolicy.TravelType = 2;
}
else if (Dr8000Y[i]["A7"].ToString() == "2")
{
mPolicy.TravelType = 3;
}
else
{
mPolicy.TravelType = 4;
}
if (Dr8000Y[i]["A16"].ToString() == "BSP")
{
mPolicy.PolicyType = 2;
}
else
{
mPolicy.PolicyType = 1;
}
mPolicy.TeamFlag = 0;
if (Dr8000Y[i]["A2"].ToString() == "All")
{
mPolicy.StartCityNameCode = "ALL";
}
else
{
mPolicy.StartCityNameCode = Dr8000Y[i]["A2"].ToString();
}
mPolicy.StartCityNameSame = 2;
if (Dr8000Y[i]["A3"].ToString() == "All")
{
mPolicy.TargetCityNameCode = "ALL";
}
else
{
mPolicy.TargetCityNameCode = Dr8000Y[i]["A3"].ToString();
}
mPolicy.TargetCityNameSame = 2;
mPolicy.ApplianceFlight = Dr8000Y[i]["A5"].ToString();
mPolicy.UnApplianceFlight = Dr8000Y[i]["A6"].ToString();
mPolicy.ApplianceFlightType = 2;
mPolicy.ScheduleConstraints = Dr8000Y[i]["A21"].ToString();
Regex reg = new Regex(@"/^\d+$/");
if (!reg.IsMatch(Dr8000Y[i]["A9"].ToString()))
{
mPolicy.ShippingSpace = Dr8000Y[i]["A9"].ToString().Replace("#", "");
}
mPolicy.SpacePrice = Convert.ToDecimal(Dr8000Y[i]["A24"]);
mPolicy.FlightStartDate = Convert.ToDateTime(Dr8000Y[i]["A10"]);
mPolicy.FlightEndDate = Convert.ToDateTime(Dr8000Y[i]["A11"]);
mPolicy.PrintStartDate = Convert.ToDateTime(Dr8000Y[i]["A10"]);
mPolicy.PrintEndDate = Convert.ToDateTime(Dr8000Y[i]["A11"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
mPolicy.Remark = Dr8000Y[i]["A17"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(Dr8000Y[i]["A8"].ToString());
mPolicy.InterPolicyId = Dr8000Y[i]["A1"].ToString();
mPolicy._WorkTime = WorkTimeConvert(Dr8000Y[i]["A12"].ToString(), GYCompany.WorkTime);
if (DateTime.Now.DayOfWeek != DayOfWeek.Saturday && DateTime.Now.DayOfWeek != DayOfWeek.Sunday)
{
mPolicy._FPGQTime = Dr8000Y[i]["A19"].ToString().Replace("|", "-");
}
else
{
mPolicy._FPGQTime = Dr8000Y[i]["A20"].ToString().Replace("|", "-");
}
mPolicy.Office = Dr8000Y[i]["A26"] == DBNull.Value ? "" : Dr8000Y[i]["A26"].ToString();
mPolicyList.Add(mPolicy);
//DataRow dr = LocalDt.NewRow();
//dr["CarryCode"] = Dr8000Y[i]["A4"];
//dr["ApplianceFlight"] = Dr8000Y[i]["A5"];
//dr["UnApplianceFlight"] = Dr8000Y[i]["A6"];
//dr["ScheduleConstraints"] = Dr8000Y[i]["A21"];
//Regex reg = new Regex(@"/^\d+$/");
//if (!reg.IsMatch(Dr8000Y[i]["A9"].ToString()))
//{
// dr["Space"] = "/" + Dr8000Y[i]["A9"].ToString().Replace("#", "") + "/";
//}
//dr["OldPolicy"] = decimal.Parse(Dr8000Y[i]["A8"].ToString()) / 100;
//dr["GYPolicy"] = decimal.Parse(Dr8000Y[i]["A8"].ToString()) / 100;
//dr["FXPolicy"] = decimal.Parse(Dr8000Y[i]["A8"].ToString()) / 100;
//dr["PolicySource"] = "8";
//dr["PolicyId"] = Dr8000Y[i]["A1"];
//dr["PolicyType"] = Dr8000Y[i]["A16"].ToString().ToUpper().Contains("B2B") ? "1" : "2";
//dr["WorkTime"] = WorkTimeConvert(Dr8000Y[i]["A12"].ToString(), GYCompany.WorkTime);
//if (DateTime.Now.DayOfWeek != DayOfWeek.Saturday && DateTime.Now.DayOfWeek != DayOfWeek.Sunday)
//{
// dr["BusinessTime"] = Dr8000Y[i]["A19"].ToString().Replace("|", "-");
//}
//else
//{
// dr["BusinessTime"] = Dr8000Y[i]["A20"].ToString().Replace("|", "-");
//}
//dr["SpecialType"] = "0";
//dr["IsPause"] = "0";
//dr["IsLowerOpen"] = "0";
//dr["Remark"] = Dr8000Y[i]["A17"].ToString();
//dr["PolOffice"] = Dr8000Y[i]["A26"];
//LocalDt.Rows.Add(dr);
}
return(mPolicyList);
}
finally
{ }
}
/// <summary>
/// 将517政策合并到原始政策dt中去
/// </summary>
/// <param name="LocalDt">原始dt</param>
/// <param name="Dt517">517dt</param>
private List <PbProject.Model.Tb_Ticket_Policy> MergerYeeXingDT(DataRow[] DrYeeXing, User_Company GYCompany, bool ChangePnr)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < DrYeeXing.Length; i++)
{
//如果不允许换编码并且政策是必须换编码出票的,则过滤掉,yyy 2013-6-7update
if (!ChangePnr && DrYeeXing[i]["changePnr"].ToString() == "1")
{
continue;
}
//DataRow dr = LocalDt.NewRow();
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = PbProject.Model.definitionParam.PolicySourceParam.bYeeXing.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
//屏蔽易行特殊政策性额
if (DrYeeXing[i]["isSphigh"].ToString() == "1")//是否是特殊政策
{
continue;
}
if (!DrYeeXing[i]["payType"].ToString().Contains("1"))//屏蔽不支持支付宝支付的政策
{
continue;
}
if (DrYeeXing[i]["isSphigh"].ToString() == "0")//是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = DrYeeXing[i]["airComp"].ToString();
if (DrYeeXing[i]["airSeg"].ToString() == "1")
{
mPolicy.TravelType = 1;
}
else if (DrYeeXing[i]["airSeg"].ToString() == "2")
{
mPolicy.TravelType = 3;
}
else
{
mPolicy.TravelType = 4;
}
if (DrYeeXing[i]["tickType"].ToString() == "1")
{
mPolicy.PolicyType = 1;
}
else
{
mPolicy.PolicyType = 1;
}
mPolicy.TeamFlag = 0;
mPolicy.StartCityNameCode = DrYeeXing[i]["orgCity"].ToString();
mPolicy.StartCityNameSame = 2;
mPolicy.TargetCityNameCode = DrYeeXing[i]["dstCity"].ToString();
mPolicy.TargetCityNameSame = 2;
mPolicy.ApplianceFlight = DrYeeXing[i]["flight"].ToString();
mPolicy.UnApplianceFlight = "";
mPolicy.ApplianceFlightType = 1;
mPolicy.ShippingSpace = DrYeeXing[i]["cabin"].ToString();
mPolicy.SpacePrice = Convert.ToDecimal(DrYeeXing[i]["ibePrice"]);
mPolicy.FlightStartDate = Convert.ToDateTime(DrYeeXing[i]["startTime"]);
mPolicy.FlightEndDate = Convert.ToDateTime(DrYeeXing[i]["endTime"]);
mPolicy.PrintStartDate = Convert.ToDateTime(DrYeeXing[i]["startTime"]);
mPolicy.PrintEndDate = Convert.ToDateTime(DrYeeXing[i]["endTime"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
string isChangePnr = "";
if (DrYeeXing[i]["changePnr"].ToString() == "1")
{
isChangePnr = "须换编码出票.";
}
mPolicy.Remark = isChangePnr + " " + DrYeeXing[i]["memo"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(DrYeeXing[i]["disc"].ToString());
mPolicy.InterPolicyId = DrYeeXing[i]["plcid"].ToString();
mPolicy._WorkTime = WorkTimeConvert(DrYeeXing[i]["workTime"].ToString(), GYCompany.WorkTime);
mPolicy._FPGQTime = WorkTimeConvert(DrYeeXing[i]["workReturnTime"].ToString(), GYCompany.BusinessTime);
mPolicy._returnMoney = DrYeeXing[i]["extReward"].ToString();;
mPolicyList.Add(mPolicy);
}
return(mPolicyList);
}
finally
{ }
}
/// <summary>
/// 获取航空公司B2B政策
/// </summary>
/// <param name="CpCpyNo">出票公司编号</param>
/// <param name="Pnr">编码</param>
/// <param name="BigPnr">大编码</param>
/// <param name="CarryCode">航空公司二字码</param>
/// <returns></returns>
public List <Tb_Ticket_Policy> getAirB2BPolicy(PolicyParamEx Param, out string ErrMsg)
{
ErrMsg = "";
List <Tb_Ticket_Policy> airPolicyList = new List <Tb_Ticket_Policy>();
Param.CpCpyNo = Param.CpCpyNo.Length >= 12 ? Param.CpCpyNo.Substring(0, 12) : Param.CpCpyNo;
PbProject.Model.definitionParam.BaseSwitch BS = new Model.definitionParam.BaseSwitch();
PbProject.Logic.ControlBase.Bd_Base_ParametersBLL Bp = new ControlBase.Bd_Base_ParametersBLL();
List <PbProject.Model.Bd_Base_Parameters> ParList = Bp.GetParametersListByCpyNo(Param.CpCpyNo.ToString());
if (ParList == null)
{
return(airPolicyList);
}
BS = WebCommon.Utility.BaseParams.getParams(ParList);
//权限
if (BS.KongZhiXiTong.Contains("|105|") && BS.yunYingQuanXian.Contains("|105|"))
{
w_Airb2bPolicy.B2BPolicyWebService B2BWebService = new w_Airb2bPolicy.B2BPolicyWebService();
DataSet dsPolicy = B2BWebService.GetAirB2BPolicy(Param.CpCpyNo, Param.Pnr, Param.BigPnr, Param.CarryCode);
if (dsPolicy != null && dsPolicy.Tables.Count > 0 && Param != null)
{
DataTable ErrTable = dsPolicy.Tables["ErrMsg"];
if (ErrTable != null && ErrTable.Rows.Count > 0 && ErrTable.Rows[0][0] != DBNull.Value && ErrTable.Rows[0][0].ToString() == "OK")
{
foreach (DataTable item in dsPolicy.Tables)
{
if (item.TableName == "policy" && item.Rows.Count > 0)
{
Tb_Ticket_Policy tb_ticket_policy = new Tb_Ticket_Policy();
#region 为Tb_Ticket_Policy实体赋值
DataRow dr = item.Rows[0];
string strpgid = dr["pgid"] != DBNull.Value ? dr["pgid"].ToString() : "";
string strpgcode = dr["pgcode"] != DBNull.Value ? dr["pgcode"].ToString() : "";
//为票面价
string strticketprice = dr["ticketprice"] != DBNull.Value ? dr["ticketprice"].ToString() : "";
//政策返点
string strpolicynum = dr["policynum"] != DBNull.Value ? dr["policynum"].ToString() : "";
decimal AirReBate = 0m;
if (!decimal.TryParse(strpolicynum, out AirReBate))
{
continue;
}
//税费
string strtotaltax = dr["totaltax"] != DBNull.Value ? dr["totaltax"].ToString() : "";
//实付金额
string strpayprice = dr["payprice"] != DBNull.Value ? dr["payprice"].ToString() : "";
decimal payprice = 0m;
decimal.TryParse(strpayprice, out payprice);
string strfc = dr["fc"] != DBNull.Value ? dr["fc"].ToString() : "";
tb_ticket_policy.id = Guid.NewGuid();
tb_ticket_policy.CpyNo = Param.CpCpyNo;
tb_ticket_policy.CpyName = "";
tb_ticket_policy.PolicyKind = 0; //-未确认--
tb_ticket_policy.GenerationType = 1; //-未确认--
tb_ticket_policy.ReleaseType = 1; //-未确认--
tb_ticket_policy.CarryCode = Param.CarryCode;
//行程类型
int TravelType = 1;
int.TryParse(Param.TravelType, out TravelType);
tb_ticket_policy.TravelType = TravelType;
tb_ticket_policy.PolicyType = 1;
tb_ticket_policy.TeamFlag = 0;
tb_ticket_policy.Office = Param.Office;
tb_ticket_policy.StartCityNameCode = Param.StartCityNameCode; //-未确认--
tb_ticket_policy.StartCityNameSame = 2;
tb_ticket_policy.MiddleCityNameCode = Param.MiddleCityNameCode; //-未确认--
tb_ticket_policy.MiddleCityNameSame = 2;
tb_ticket_policy.TargetCityNameCode = Param.TargetCityNameCode; //-未确认--
tb_ticket_policy.TargetCityNameSame = 2;
tb_ticket_policy.ApplianceFlightType = 1;
tb_ticket_policy.ApplianceFlight = "";
tb_ticket_policy.UnApplianceFlight = "";
tb_ticket_policy.ScheduleConstraints = "";
tb_ticket_policy.ShippingSpace = Param.Space;
tb_ticket_policy.InterPolicyId = ""; //-未确认--
tb_ticket_policy.SpacePrice = 0m; //-未确认--
tb_ticket_policy.ReferencePrice = 0m;
tb_ticket_policy.AdvanceDay = 0;
tb_ticket_policy.AirReBate = 0; //-未确认--
tb_ticket_policy.AirReBateReturnMoney = 0;
tb_ticket_policy.DownPoint = AirReBate; //-未确认--
tb_ticket_policy.DownReturnMoney = 0;
tb_ticket_policy.LaterPoint = 0;
tb_ticket_policy.LaterReturnMoney = 0;
tb_ticket_policy.SharePoint = 0;
tb_ticket_policy.SharePointReturnMoney = 0;
tb_ticket_policy.FlightStartDate = System.DateTime.Now;
tb_ticket_policy.FlightEndDate = System.DateTime.Now;
tb_ticket_policy.PrintStartDate = System.DateTime.Now;
tb_ticket_policy.PrintEndDate = System.DateTime.Now;
tb_ticket_policy.AuditDate = System.DateTime.Now;
tb_ticket_policy.AuditType = 1;
tb_ticket_policy.AuditLoginName = ""; //-未确认--
tb_ticket_policy.AuditName = ""; //-未确认--
tb_ticket_policy.CreateDate = System.DateTime.Now;
tb_ticket_policy.CreateLoginName = ""; //-未确认--
tb_ticket_policy.CreateName = ""; //-未确认--
tb_ticket_policy.UpdateDate = System.DateTime.Now; //-未确认--
tb_ticket_policy.UpdateLoginName = ""; //-未确认--
tb_ticket_policy.UpdateName = ""; //-未确认--
tb_ticket_policy.Remark = ""; //-未确认--
tb_ticket_policy.IsApplyToShareFlight = 0;
tb_ticket_policy.ShareAirCode = "";
tb_ticket_policy.IsLowerOpen = 0;
tb_ticket_policy.HighPolicyFlag = 0;
tb_ticket_policy.AutoPrintFlag = 2; //默认自动出票
tb_ticket_policy.GroupId = ""; //-未确认--
tb_ticket_policy.IsPause = 0;
tb_ticket_policy.A13 = "1"; //航空公司政策
tb_ticket_policy._AirPayMoney = payprice; //支付金额
#endregion
//添加到集合
airPolicyList.Add(tb_ticket_policy);
}
}
}
else
{
if (ErrTable != null && ErrTable.Rows.Count > 0 && ErrTable.Rows[0][0] != DBNull.Value && ErrTable.Rows[0][0].ToString() != "")
{
ErrMsg = ErrTable.Rows[0][0].ToString();
}
else
{
DataTable pnrinfo = dsPolicy.Tables["pnrinfo"];
if (pnrinfo != null && pnrinfo.Rows.Count > 0)
{
//<pnr>MFC9B3|JMKDVD</pnr><air>SC</air>
ErrMsg = "航空公司:" + pnrinfo.Rows[0]["air"].ToString() + "编码：" + pnrinfo.Rows[0]["pnr"].ToString() + " 信息：" + pnrinfo.Rows[0]["message"].ToString();
}
}
}
}
}
return(airPolicyList);
}
/// <summary>
/// 将51政策合并到原始政策dt中去
/// </summary>
/// <param name="LocalDt">原始dt</param>
/// <param name="Dt517">51dt</param>
private List <PbProject.Model.Tb_Ticket_Policy> Merger51DT(DataRow[] Dr51, string travel, string FromDate, string time, User_Company GYCompany, bool ChangePnr)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < Dr51.Length; i++)
{
Dr51[i]["startDate"] = Dr51[i]["startDate"].ToString().Trim() == "" ? FromDate : Dr51[i]["startDate"].ToString();
Dr51[i]["expiredDate"] = Dr51[i]["expiredDate"].ToString().Trim() == "" ? time : Dr51[i]["expiredDate"].ToString();
Dr51[i]["printTicketStartDate"] = Dr51[i]["printTicketStartDate"].ToString().Trim() == "" ? DateTime.Now.ToShortDateString() : Dr51[i]["printTicketStartDate"].ToString();
Dr51[i]["printTicketExpiredDate"] = Dr51[i]["printTicketExpiredDate"].ToString().Trim() == "" ? DateTime.Now.ToShortDateString() : Dr51[i]["printTicketExpiredDate"].ToString();
if (DateTime.Parse(Dr51[i]["startDate"].ToString().Split(' ')[0]) <= DateTime.Parse(FromDate) && DateTime.Parse(Dr51[i]["expiredDate"].ToString().Split(' ')[0]) >= DateTime.Parse(time) && DateTime.Parse(Dr51[i]["printTicketStartDate"].ToString().Split(' ')[0]) <= DateTime.Parse(DateTime.Now.ToShortDateString()) && DateTime.Parse(Dr51[i]["printTicketExpiredDate"].ToString().Split(' ')[0]) >= DateTime.Parse(DateTime.Now.ToShortDateString()))
{
//如果不允许换编码并且政策是必须换编码出票的,则过滤掉,yyy 2013-6-7update
if (!ChangePnr && bool.Parse(Dr51[i]["needSwitchPNR"].ToString()))
{
continue;
}
if (travel == Dr51[i]["routeType"].ToString())
{
if (Dr51[i]["onWorking"].ToString().ToLower() == "true")
{
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = "0" + PbProject.Model.definitionParam.PolicySourceParam.b51book.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
if (Dr51[i]["businessUnitType"].ToString() == "0")//是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = Dr51[i]["airlineCode"].ToString();
if (Dr51[i]["routeType"].ToString() == "OW")
{
mPolicy.TravelType = 1;
}
else if (Dr51[i]["routeType"].ToString() == "RT")
{
mPolicy.TravelType = 3;
}
else
{
mPolicy.TravelType = 4;
}
if (Dr51[i]["policyType"].ToString() == "B2P")
{
mPolicy.PolicyType = 2;
}
else
{
mPolicy.PolicyType = 1;
}
mPolicy.TeamFlag = 0;
if (Dr51[i]["flightCourse"].ToString() == "999-999")
{
mPolicy.StartCityNameCode = "ALL";
}
else
{
mPolicy.StartCityNameCode = Dr51[i]["flightCourse"].ToString().Split('-')[0];
}
mPolicy.StartCityNameSame = 2;
if (Dr51[i]["flightCourse"].ToString() == "999-999")
{
mPolicy.TargetCityNameCode = "ALL";
}
else
{
mPolicy.TargetCityNameCode = Dr51[i]["flightCourse"].ToString().Split('-')[1];
}
mPolicy.TargetCityNameSame = 2;
mPolicy.ApplianceFlight = Dr51[i]["flightNoIncluding"].ToString();
mPolicy.UnApplianceFlight = Dr51[i]["flightNoExclude"].ToString();
mPolicy.ApplianceFlightType = 2;
mPolicy.ScheduleConstraints = Dr51[i]["flightCycle"].ToString();
mPolicy.ShippingSpace = Dr51[i]["seatClass"].ToString();
mPolicy.FlightStartDate = Convert.ToDateTime(Dr51[i]["startDate"]);
mPolicy.FlightEndDate = Convert.ToDateTime(Dr51[i]["expiredDate"]);
mPolicy.PrintStartDate = Convert.ToDateTime(Dr51[i]["printTicketStartDate"]);
mPolicy.PrintEndDate = Convert.ToDateTime(Dr51[i]["printTicketExpiredDate"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
string isChangePnr = "";
if (bool.Parse(Dr51[i]["needSwitchPNR"].ToString()))
{
isChangePnr = "须换编码出票.";
}
mPolicy.Remark = isChangePnr + " " + Dr51[i]["comment"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(Dr51[i]["Commission"].ToString());
mPolicy.InterPolicyId = Dr51[i]["Id"].ToString();
mPolicy._WorkTime = WorkTimeConvert(Dr51[i]["workTime"].ToString(), GYCompany.WorkTime);
mPolicy._FPGQTime = Dr51[i]["chooseOutWorkTime"].ToString();
mPolicy.Office = Dr51[i]["param2"] == DBNull.Value ? "" : Dr51[i]["param2"].ToString();
mPolicyList.Add(mPolicy);
//DataRow dr = LocalDt.NewRow();
//dr["CarryCode"] = Dr51[i]["airlineCode"];
//dr["ApplianceFlight"] = Dr51[i]["flightNoIncluding"];
//dr["UnApplianceFlight"] = Dr51[i]["flightNoExclude"];
//dr["ScheduleConstraints"] = Dr51[i]["flightCycle"];
//dr["Space"] = "/" + Dr51[i]["seatClass"] + "/";
//dr["OldPolicy"] = decimal.Parse(Dr51[i]["Commission"].ToString()) / 100;
//dr["GYPolicy"] = decimal.Parse(Dr51[i]["Commission"].ToString()) / 100;
//dr["FXPolicy"] = decimal.Parse(Dr51[i]["Commission"].ToString()) / 100;
//dr["PolicySource"] = "6";
//dr["PolicyId"] = Dr51[i]["Id"];
//dr["PolicyType"] = Dr51[i]["policyType"].ToString().ToUpper().Contains("B2B") ? "1" : "2";
//dr["WorkTime"] = WorkTimeConvert(Dr51[i]["workTime"].ToString(), GYCompany.WorkTime);
//dr["BusinessTime"] = Dr51[i]["chooseOutWorkTime"];
//dr["SpecialType"] = "0";
//dr["IsPause"] = "0";
//dr["IsLowerOpen"] = "0";
//dr["Remark"] = Dr51[i]["Comment"].ToString();
//dr["PolOffice"] = Dr51[i]["param2"];
//LocalDt.Rows.Add(dr);
}
}
}
}
return(mPolicyList);
}
finally
{ }
}
/// <summary>
/// 将票盟政策合并到原始政策dt中去
/// </summary>
/// <param name="LocalDt">原始dt</param>
/// <param name="DrPM">票盟dt</param>
private List <PbProject.Model.Tb_Ticket_Policy> MergerPMDT(DataRow[] DrPM, string FromCityCode, string ToCityCode, string CarrCode, string FlyNo, PbProject.Model.User_Company GYCompany, string
StartDate, string SecondDate, bool ChangePnr)
{
try
{
List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>();
for (int i = 0; i < DrPM.Length; i++)
{
if (SecondDate == "")
{
if (DateTime.Parse(DrPM[i]["fromtime"].ToString()) > DateTime.Parse(StartDate))
{
continue;
}
}
else
{
if (DateTime.Parse(DrPM[i]["fromtime"].ToString()) > DateTime.Parse(StartDate) || DateTime.Parse(DrPM[i]["totime"].ToString()) < DateTime.Parse(SecondDate))
{
continue;
}
}
//如果不允许换编码并且政策是必须换编码出票的,则过滤掉,yyy 2013-6-7update
if (!ChangePnr && DrPM[i]["changerecord"].ToString() == "1")
{
continue;
}
PbProject.Model.Tb_Ticket_Policy mPolicy = new Tb_Ticket_Policy();
mPolicy.CpyNo = "0" + PbProject.Model.definitionParam.PolicySourceParam.bPiaoMeng.ToString() + _mTopcom.UninCode;
mPolicy.CpyName = _mTopcom.UninName;
if (DrPM[i]["isspecmark"].ToString() == "0")//是否是特殊政策
{
mPolicy.PolicyKind = 0;
mPolicy.GenerationType = 1;
}
else
{
mPolicy.PolicyKind = 2;
mPolicy.GenerationType = 2;
}
mPolicy.CarryCode = CarrCode;
mPolicy.TravelType = 1;
if (DrPM[i]["policytype"].ToString().ToUpper().Contains("B2P"))
{
mPolicy.PolicyType = 2;
}
else
{
mPolicy.PolicyType = 1;
}
mPolicy.TeamFlag = 0;
mPolicy.StartCityNameCode = FromCityCode;
mPolicy.StartCityNameSame = 2;
mPolicy.TargetCityNameCode = ToCityCode;
mPolicy.TargetCityNameSame = 2;
mPolicy.ApplianceFlight = FlyNo;
mPolicy.UnApplianceFlight = "";
mPolicy.ApplianceFlightType = 2;
mPolicy.ScheduleConstraints = "";
mPolicy.ShippingSpace = DrPM[i]["applyclass"].ToString().Replace(",", "/");
mPolicy.FlightStartDate = Convert.ToDateTime(DrPM[i]["fromtime"]);
mPolicy.FlightEndDate = Convert.ToDateTime(DrPM[i]["totime"]);
mPolicy.PrintStartDate = Convert.ToDateTime(DrPM[i]["fromtime"]);
mPolicy.PrintEndDate = Convert.ToDateTime(DrPM[i]["totime"]);
mPolicy.AuditDate = DateTime.Now;
mPolicy.AuditType = 1;
string isChangePnr = "";
if (DrPM[i]["changerecord"].ToString() == "1")
{
isChangePnr = "须换编码出票.";
}
mPolicy.Remark = isChangePnr + " " + DrPM[i]["note"].ToString();
mPolicy.IsApplyToShareFlight = 0;
mPolicy.ShareAirCode = "";
mPolicy.IsLowerOpen = 0;
mPolicy.DownPoint = decimal.Parse(DrPM[i]["rate"].ToString());
mPolicy.InterPolicyId = DrPM[i]["id"].ToString();
mPolicy._WorkTime = WorkTimeConvert(TimeTemp(DrPM[i]["worktime"].ToString(), 0), GYCompany.WorkTime);
mPolicy._FPGQTime = TimeTemp(DrPM[i]["worktime"].ToString().Substring(0, 4) + "-" + DrPM[i]["RefundWorkTimeTo"].ToString(), 0);
mPolicy.Office = DrPM[i]["officeid"] == DBNull.Value ? "" : DrPM[i]["officeid"].ToString();
mPolicyList.Add(mPolicy);
//DataRow dr = LocalDt.NewRow();
//dr["CarryCode"] = CarrCode;
//dr["ApplianceFlight"] = FlyNo;
//dr["ScheduleConstraints"] = "1/2/3/4/5/6/7";
//dr["Space"] = "/" + DrPM[i]["applyclass"].ToString().Replace(",", "/") + "/";
//dr["OldPolicy"] = decimal.Parse(DrPM[i]["rate"].ToString()) / 100;
//dr["GYPolicy"] = decimal.Parse(DrPM[i]["rate"].ToString()) / 100;
//dr["FXPolicy"] = decimal.Parse(DrPM[i]["rate"].ToString()) / 100;
//dr["PolicySource"] = "5";
//dr["PolicyId"] = DrPM[i]["id"];
//dr["PolicyType"] = DrPM[i]["policytype"].ToString().ToUpper().Contains("B2B") ? "1" : "2";
//dr["WorkTime"] = WorkTimeConvert(TimeTemp(DrPM[i]["worktime"].ToString(), 0), GYCompany.WorkTime);
////dr["BusinessTime"] = TimeTemp(DrPM[i]["worktime"].ToString(), -1);
//dr["BusinessTime"] = TimeTemp(DrPM[i]["worktime"].ToString().Substring(0, 4) + "-" + DrPM[i]["RefundWorkTimeTo"].ToString(), 0);
//dr["SpecialType"] = "0";
//dr["IsPause"] = "0";
//dr["IsLowerOpen"] = "0";
//dr["Remark"] = DrPM[i]["note"].ToString();
//dr["PolOffice"] = DrPM[i]["officeid"];
//LocalDt.Rows.Add(dr);
}
return(mPolicyList);
}
finally
{ }
}
