/// <summary>
/// 获取城市信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public Bd_Air_AirPort GetCityInfo(string data)
{
if (list == null)
{
list = GetCity("1");
}
Bd_Air_AirPort cityinfo = list.Find(delegate(Bd_Air_AirPort item)
{
return(!string.IsNullOrEmpty(data) && (item.CityCodeWord.ToUpper() == data.ToUpper() || item.CityName.ToUpper() == data.ToUpper()));
});
return(cityinfo);
}
/// <summary>
/// 获取城市信息
/// </summary>
/// <param name="city"></param>
/// <returns></returns>
public Bd_Air_AirPort GetCity(string city)
{
if (list == null)
{
list = GetCityList("1");
}
Bd_Air_AirPort reModel = list.Find(delegate(Bd_Air_AirPort bd_air_airport)
{
if (bd_air_airport.CityName.ToUpper() == city.Trim().ToUpper() || bd_air_airport.CityCodeWord == city.Trim().ToUpper())
{
return(true);
}
else
{
return(false);
}
});
return(reModel);
}
private void CityInfoBind()
{
Bd_Air_AirPort city = baseDataManage.CallMethod("Bd_Air_AirPort", "GetById", null, new object[] { ViewState["Id"].ToString() }) as Bd_Air_AirPort;
txtCity.Text = city.CityName;
txtQuanPing.Text = city.CityQuanPin;
txtJianPin.Text = city.CityJianPin;
txtCityCode.Text = city.CityCodeWord;
txtCountry.Text = city.Country;
txtContinents.Text = city.Continents;
txtAirPortName.Text = city.AirPortName;
if (city.IsDomestic == 1)
{
ddlType.SelectedIndex = 0;
}
else
{
ddlType.SelectedIndex = 1;
}
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
public string Query(string IsExpires)
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(string.Format(" CpyNo='{0}' ", mCompany.UninCode));
if (PageType == "1")
{
//普通政策
sbWhere.Append(" and PolicyKind=1 ");
if (!rdAuditState.SelectedValue.Equals("0"))
{
sbWhere.AppendFormat(" and AuditType={0} ", rdAuditState.SelectedValue);
}
}
else if (PageType == "2")
{
//特价政策
sbWhere.Append(" and PolicyKind=2 ");
if (!rdAuditState.SelectedValue.Equals("0"))
{
sbWhere.AppendFormat(" and AuditType={0} ", rdAuditState.SelectedValue);
}
}
if (PageType == "3")
{
//默认政策
if (ddlPasType.SelectedValue != "" && ddlPasType.SelectedValue != "0")
{
sbWhere.AppendFormat(" and A1 ={0} ", ddlPasType.SelectedValue);
}
else
{
sbWhere.Append(" and A1 in(1,2) ");
}
}
else
{
//不是默认政策
sbWhere.Append(" and A1 =0 ");
}
//发布者
if (SelPublic.Value != "0" && SelPublic.Value != "")
{
sbWhere.Append(string.Format(" and CreateLoginName='{0}' ", SelPublic.Text.Trim()));
}
//行程类型
if (rblTravelType.SelectedValue.Trim() != "0")
{
sbWhere.Append(string.Format(" and TravelType={0} ", rblTravelType.SelectedValue.Trim()));
}
//出票方式
if (ddlETDZType.SelectedValue != "")
{
sbWhere.Append(string.Format(" and AutoPrintFlag={0} ", ddlETDZType.SelectedValue.Trim()));
}
if (PageType != "3")//不是默认政策
{
//出发城市
if (txtFromCityName.Value.Trim() != "" && txtFromCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtFromCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and StartCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (FromCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and StartCityNameCode like '%{0}%'", FromCityCode.Value.Trim()));
}
}
}
if (rblTravelType.SelectedValue.Trim() == "4")
{
//中转城市
if (txtMiddleCityName.Value.Trim() != "" && txtMiddleCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtMiddleCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and MiddleCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (MiddleCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and MiddleCityNameCode like '%{0}%'", MiddleCityCode.Value.Trim()));
}
}
}
}
//到达城市
if (txtToCityName.Value.Trim() != "" && txtToCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtToCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and TargetCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (ToCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and TargetCityNameCode like '%{0}%'", ToCityCode.Value.Trim()));
}
}
}
}
//航空公司
if (ddlCarry.Value != "" && ddlCarry.Value != "0")
{
sbWhere.Append(string.Format(" and CarryCode like '%{0}%'", ddlCarry.Value));
}
if (string.IsNullOrEmpty(IsExpires))
{
//乘机日期
if (!string.IsNullOrEmpty(txtFlightStartDate.Value.Trim()) && !string.IsNullOrEmpty(txtFlightEndDate.Value.Trim()))
{
sbWhere.Append(" and FlightStartDate >='" + txtFlightStartDate.Value.Trim() + " 00:00:00' and FlightEndDate <= '" + txtFlightEndDate.Value.Trim() + " 23:59:59' ");
}
//出票日期
if (!string.IsNullOrEmpty(txtTicketStartDate.Value.Trim()) && !string.IsNullOrEmpty(txtTicketEndDate.Value.Trim()))
{
sbWhere.Append(" and PrintStartDate >='" + txtTicketStartDate.Value.Trim() + " 00:00:00' and PrintEndDate <= '" + txtTicketEndDate.Value.Trim() + " 23:59:59' ");
}
}
else
{
//过期政策查看
sbWhere.Append(" and (FlightEndDate <= '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and PrintEndDate <= '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "') ");
}
//审核
return(sbWhere.ToString());
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
try
{
Bd_Air_AirPort city = null;
if (Request.QueryString["Id"] != null && Request.QueryString["Id"].ToString() != "")
{
//获取实体
city = baseDataManage.CallMethod("Bd_Air_AirPort", "GetById", null, new object[] { ViewState["Id"].ToString() }) as Bd_Air_AirPort;
}
else
{
city = new Bd_Air_AirPort();
}
Regex regex = new Regex("^[a-zA-Z]+$");
Regex regex1 = new Regex("^[\u4E00-\u9FA5]+$");
bool IsOk = true;
bool IsOk1 = true;
if (!regex.IsMatch(txtQuanPing.Text))
{
IsOk = false;
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('城市全拼必须为字母！');", true);
}
if (!regex1.IsMatch(txtCity.Text))
{
IsOk1 = false;
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('城市中文必须为汉字！');", true);
}
if (IsOk && IsOk1)
{
city.CityName = txtCity.Text.Trim().Replace("'", "");
city.CityQuanPin = txtQuanPing.Text.Trim().Replace("'", "").ToUpper();
city.CityJianPin = txtJianPin.Text.Trim().Replace("'", "").ToUpper();
city.CityCodeWord = txtCityCode.Text.Trim().Replace("'", "").ToUpper();
city.Continents = txtContinents.Text.Trim().Replace("'", "");
city.Country = txtCountry.Text.Trim().Replace("'", "");
city.IsDomestic = int.Parse(ddlType.SelectedValue);
if (Request.QueryString["Id"] != null)
{
//修改
bool UpdateSuc = (bool)baseDataManage.CallMethod("Bd_Air_AirPort", "Update", null, new object[] { city });
if (UpdateSuc)
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog3('保存成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('保存失败,此三字码已存在！');", true);
}
}
else
{
string SqlWhere = string.Format(" CityName='{0}' and CityCodeWord='{1}' ", city.CityName, city.CityCodeWord);
bool IsExist = (bool)baseDataManage.CallMethod("Bd_Air_AirPort", "IsExist", null, new object[] { SqlWhere });
if (!IsExist)
{
//添加
bool InsertSuc = (bool)baseDataManage.CallMethod("Bd_Air_AirPort", "Insert", null, new object[] { city });
if (InsertSuc)
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog3('添加成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('添加失败,此三字码已存在！');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('添加失败,此三字码已存在！');", true);
}
}
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "showdialog('三字码已存在！');", true);
}
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
public string Query(string IsExpires)
{
StringBuilder sbWhere = new StringBuilder(" AuditType=1 and isPause<>1 ");//
if (PageType == "1")
{
//普通政策
sbWhere.Append(" and PolicyKind=1 ");
}
else if (PageType == "2")
{
//特价政策
sbWhere.Append(" and PolicyKind=2 ");
}
if (PageType == "3")
{
//默认政策
if (ddlPasType.SelectedValue != "" && ddlPasType.SelectedValue != "0")
{
sbWhere.AppendFormat(" and A1 ={0} ", ddlPasType.SelectedValue);
}
else
{
sbWhere.Append(" and A1 in(1,2) ");
}
}
else
{
//不是默认政策
sbWhere.Append(" and A1 =0 ");
}
//航空公司
if (ddlCarry.Value != "" && ddlCarry.Value != "0")
{
sbWhere.Append(string.Format(" and CarryCode like '%{0}%'", ddlCarry.Value));
}
//政策类型
if (ddlPolicyType.SelectedValue != "" && ddlPolicyType.SelectedValue != "-1")
{
sbWhere.AppendFormat(" and PolicyType ={0} ", ddlPolicyType.SelectedValue);
}
if (string.IsNullOrEmpty(IsExpires))
{
//乘机日期
if (!string.IsNullOrEmpty(txtFlightStartDate.Value.Trim()) && !string.IsNullOrEmpty(txtFlightEndDate.Value.Trim()))
{
sbWhere.Append(" and FlightStartDate >='" + txtFlightStartDate.Value.Trim() + " 00:00:00' and FlightEndDate <= '" + txtFlightEndDate.Value.Trim() + " 23:59:59' ");
}
//出票日期
if (!string.IsNullOrEmpty(txtTicketStartDate.Value.Trim()) && !string.IsNullOrEmpty(txtTicketEndDate.Value.Trim()))
{
sbWhere.Append(" and PrintStartDate >='" + txtTicketStartDate.Value.Trim() + " 00:00:00' and PrintEndDate <= '" + txtTicketEndDate.Value.Trim() + " 23:59:59' ");
}
}
else
{
//过期政策查看
sbWhere.Append(" and (FlightEndDate <= '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and PrintEndDate <= '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "') ");
}
if (PageType != "3")//不是默认政策
{
//出发城市
if (txtFromCityName.Value.Trim() != "" && txtFromCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtFromCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and StartCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (FromCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and StartCityNameCode like '%{0}%'", FromCityCode.Value.Trim()));
}
}
}
if (rblTravelType.SelectedValue.Trim() == "4")
{
//中转城市
if (txtMiddleCityName.Value.Trim() != "" && txtMiddleCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtMiddleCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and MiddleCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (MiddleCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and MiddleCityNameCode like '%{0}%'", MiddleCityCode.Value.Trim()));
}
}
}
}
//到达城市
if (txtToCityName.Value.Trim() != "" && txtToCityName.Value.Trim() != "中文/英文")
{
Bd_Air_AirPort airinfo = GetCityInfo(txtToCityName.Value.Trim());
if (airinfo != null)
{
sbWhere.Append(string.Format(" and TargetCityNameCode like '%{0}%'", airinfo.CityCodeWord));
}
else
{
if (ToCityCode.Value.Trim() != "")
{
sbWhere.Append(string.Format(" and TargetCityNameCode like '%{0}%'", ToCityCode.Value.Trim()));
}
}
}
}
//行程类型
if (rblTravelType.SelectedValue.Trim() != "0")
{
sbWhere.Append(string.Format(" and TravelType={0} ", rblTravelType.SelectedValue.Trim()));
}
//适用航班号
if (txtFlightNo.Text.Trim() != "" && txtFlightNo.Text.Trim().Split(new string[] { "/" }, StringSplitOptions.RemoveEmptyEntries).Length > 0)
{
sbWhere.AppendFormat(" and (ApplianceFlightType=1 or (ApplianceFlightType=2 and ApplianceFlight like '%{0}%')) ", txtFlightNo.Text.Trim().Replace("'", ""));
}
//舱位
if (txtSpace.Text.Trim() != "")
{
sbWhere.AppendFormat(" and ShippingSpace like '%{0}%' ", txtSpace.Text.Trim().Replace("'", ""));
}
return(sbWhere.ToString());
}
