/// <summary>
/// 获取城市数据
/// </summary>
/// <returns></returns>
public string GetCityData()
{
StringBuilder sbScript = new StringBuilder();
try
{
BaseDataManage Manage = new BaseDataManage();
List <Bd_Air_AirPort> CityList = null;
string cacheUrl = System.Configuration.ConfigurationManager.AppSettings["CacheUrl"];
//是否为国际城市 1是 0否
string IsGJ = Request["IsGJ"] != null ? Request["IsGJ"].ToString() : "0";
if (!string.IsNullOrEmpty(cacheUrl))
{
try
{
//去缓存数据
IRemoteMethod remoteobj = (IRemoteMethod)Activator.GetObject(typeof(IRemoteMethod), cacheUrl);
DataSet ds = remoteobj.GetBd_Air_Airport("");
if (ds != null && ds.Tables.Count > 0)
{
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = " CityQuanPin ";//拼音全称排序
DataTable Bd_Air_AirPort = dv.ToTable();
CityList = PbProject.Dal.Mapping.MappingHelper <Bd_Air_AirPort> .FillModelList(Bd_Air_AirPort);
}
}
catch (Exception)
{
//取数据库数据
CityList = Manage.CallMethod("Bd_Air_AirPort", "GetList", null, new object[] { " 1=1 order by CityQuanPin " }) as List <Bd_Air_AirPort>;
}
}
else
{
//取数据库数据
CityList = Manage.CallMethod("Bd_Air_AirPort", "GetList", null, new object[] { " 1=1 order by CityQuanPin " }) as List <Bd_Air_AirPort>;
}
List <string> AllData = new List <string>();
if (CityList != null && CityList.Count > 0)
{
List <string> A_C_List = new List <string>();
List <string> D_G_List = new List <string>();
List <string> H_I_List = new List <string>();
List <string> J_K_List = new List <string>();
List <string> L_M_List = new List <string>();
List <string> N_R_List = new List <string>();
List <string> S_T_List = new List <string>();
List <string> U_X_List = new List <string>();
List <string> Y_Z_List = new List <string>();
List <string> A_List = new List <string>();
List <string> B_List = new List <string>();
List <string> C_List = new List <string>();
List <string> D_List = new List <string>();
List <string> E_List = new List <string>();
List <string> F_List = new List <string>();
List <string> G_List = new List <string>();
List <string> H_List = new List <string>();
List <string> I_List = new List <string>();
List <string> J_List = new List <string>();
List <string> K_List = new List <string>();
List <string> L_List = new List <string>();
List <string> M_List = new List <string>();
List <string> N_List = new List <string>();
List <string> O_List = new List <string>();
List <string> P_List = new List <string>();
List <string> Q_List = new List <string>();
List <string> R_List = new List <string>();
List <string> S_List = new List <string>();
List <string> T_List = new List <string>();
List <string> U_List = new List <string>();
List <string> V_List = new List <string>();
List <string> W_List = new List <string>();
//List<string> X_List = new List<string>();
List <string> Y_List = new List <string>();
List <string> Z_List = new List <string>();
string FirstChar = "";
foreach (var item in CityList)
{
if (item.CityQuanPin.Length == 0 || item.CityCodeWord.Length == 0)
{
continue;
}
AllData.Add(item.CityQuanPin + "|" + item.CityName + "|" + item.CityCodeWord + "|" + item.CityJianPin + "|");
FirstChar = item.CityQuanPin[0].ToString().ToUpper();
if (IsGJ == "0" && item.IsDomestic == 1)//国内
{
if ("ABC".Contains(FirstChar))
{
A_C_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("DEFG".Contains(FirstChar))
{
D_G_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("HI".Contains(FirstChar))
{
H_I_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("JK".Contains(FirstChar))
{
J_K_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("LM".Contains(FirstChar))
{
L_M_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("NOPQR".Contains(FirstChar))
{
N_R_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("ST".Contains(FirstChar))
{
S_T_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("UVWX".Contains(FirstChar))
{
U_X_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("YZ".Contains(FirstChar))
{
Y_Z_List.Add(item.CityCodeWord + "|" + item.CityName);
}
}
else if (IsGJ == "1" && item.IsDomestic == 2)//国际
{
if ("A".Contains(FirstChar))
{
A_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("B".Contains(FirstChar))
{
B_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("C".Contains(FirstChar))
{
C_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("D".Contains(FirstChar))
{
D_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("E".Contains(FirstChar))
{
E_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("F".Contains(FirstChar))
{
F_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("G".Contains(FirstChar))
{
G_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("H".Contains(FirstChar))
{
H_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("I".Contains(FirstChar))
{
I_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("J".Contains(FirstChar))
{
J_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("K".Contains(FirstChar))
{
K_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("L".Contains(FirstChar))
{
L_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("M".Contains(FirstChar))
{
M_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("N".Contains(FirstChar))
{
N_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("O".Contains(FirstChar))
{
O_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("P".Contains(FirstChar))
{
P_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("Q".Contains(FirstChar))
{
Q_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("R".Contains(FirstChar))
{
R_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("S".Contains(FirstChar))
{
S_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("T".Contains(FirstChar))
{
T_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("U".Contains(FirstChar))
{
U_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("V".Contains(FirstChar))
{
V_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("W".Contains(FirstChar))
{
W_List.Add(item.CityCodeWord + "|" + item.CityName);
}
//else if ("X".Contains(FirstChar))
//{
// X_List.Add(item.CityCodeWord + "|" + item.CityName);
//}
else if ("Y".Contains(FirstChar))
{
Y_List.Add(item.CityCodeWord + "|" + item.CityName);
}
else if ("Z".Contains(FirstChar))
{
Z_List.Add(item.CityCodeWord + "|" + item.CityName);
}
}
}
//所有数据
sbScript.AppendFormat("$$.module.address.source.fltdomestic =\"@{0}@\";\r\n", string.Join("@", AllData.ToArray()));
sbScript.Append(" $$.module.address.source.fltdomestic_hotData = {\r\n");
if (IsGJ == "0")
{
//国内热门
sbScript.Append("\"热门\": \"@PEK|北京(首都)@NAY|北京(南苑)@SHA|上海(虹桥)@PVG|上海(浦东)@CAN|广州@SZX|深圳@CTU|成都@HGH|杭州@WUH|武汉@XIY|西安@CKG|重庆@TAO|青岛@CSX|长沙@NKG|南京@XMN|厦门@KMG|昆明@DLC|大连@TSN|天津@CGO|郑州@SYX|三亚@TNA|济南@FOC|福州\",\r\n");
sbScript.AppendFormat(" 'ABC': \"@{0}\",\r\n", string.Join("@", A_C_List.ToArray()));
sbScript.AppendFormat(" 'DEFG': \"@{0}\",\r\n", string.Join("@", D_G_List.ToArray()));
sbScript.AppendFormat(" 'HI': \"@{0}\",\r\n", string.Join("@", H_I_List.ToArray()));
sbScript.AppendFormat(" 'JK': \"@{0}\",\r\n", string.Join("@", J_K_List.ToArray()));
sbScript.AppendFormat(" 'LM': \"@{0}\",\r\n", string.Join("@", L_M_List.ToArray()));
sbScript.AppendFormat(" 'NOPQR': \"@{0}\",\r\n", string.Join("@", N_R_List.ToArray()));
sbScript.AppendFormat(" 'ST': \"@{0}\",\r\n", string.Join("@", S_T_List.ToArray()));
sbScript.AppendFormat(" 'UVWX': \"@{0}\",\r\n", string.Join("@", U_X_List.ToArray()));
sbScript.AppendFormat(" 'YZ': \"@{0}\"\r\n", string.Join("@", Y_Z_List.ToArray()));
}
else//国际热门
{
sbScript.Append("\"热门\": \"@HKG|香港@TPE|台北@MFM|澳门@KHH|高雄@TYO|东京@SEL|首尔@SIN|新加坡@BKK|曼谷@NYC|纽约@KUL|吉隆坡@OSA|大阪@LAX|洛杉矶@SYD|悉尼@SFO|旧金山@YVR|温哥华@MEL|墨尔本@JKT|雅加达@CHI|芝加哥@YTO|多伦多@SGN|胡志明市@MNL|马尼拉@DPS|巴厘岛@NGO|名古屋@HKT|普吉岛@HAN|河内@MLE|马累@DXB|迪拜@PUS|釜山@KTM|加德满都\",\r\n");
sbScript.AppendFormat(" 'A': \"@{0}\",\r\n", string.Join("@", A_List.ToArray()));
sbScript.AppendFormat(" 'B': \"@{0}\",\r\n", string.Join("@", B_List.ToArray()));
sbScript.AppendFormat(" 'C': \"@{0}\",\r\n", string.Join("@", C_List.ToArray()));
sbScript.AppendFormat(" 'D': \"@{0}\",\r\n", string.Join("@", D_List.ToArray()));
sbScript.AppendFormat(" 'E': \"@{0}\",\r\n", string.Join("@", E_List.ToArray()));
sbScript.AppendFormat(" 'F': \"@{0}\",\r\n", string.Join("@", F_List.ToArray()));
sbScript.AppendFormat(" 'G': \"@{0}\",\r\n", string.Join("@", G_List.ToArray()));
sbScript.AppendFormat(" 'H': \"@{0}\",\r\n", string.Join("@", H_List.ToArray()));
sbScript.AppendFormat(" 'I': \"@{0}\",\r\n", string.Join("@", I_List.ToArray()));
sbScript.AppendFormat(" 'J': \"@{0}\",\r\n", string.Join("@", J_List.ToArray()));
sbScript.AppendFormat(" 'K': \"@{0}\",\r\n", string.Join("@", K_List.ToArray()));
sbScript.AppendFormat(" 'L': \"@{0}\",\r\n", string.Join("@", L_List.ToArray()));
sbScript.AppendFormat(" 'M': \"@{0}\",\r\n", string.Join("@", M_List.ToArray()));
sbScript.AppendFormat(" 'N': \"@{0}\",\r\n", string.Join("@", N_List.ToArray()));
sbScript.AppendFormat(" 'O': \"@{0}\",\r\n", string.Join("@", O_List.ToArray()));
sbScript.AppendFormat(" 'P': \"@{0}\",\r\n", string.Join("@", P_List.ToArray()));
sbScript.AppendFormat(" 'Q': \"@{0}\",\r\n", string.Join("@", Q_List.ToArray()));
sbScript.AppendFormat(" 'R': \"@{0}\",\r\n", string.Join("@", R_List.ToArray()));
sbScript.AppendFormat(" 'S': \"@{0}\",\r\n", string.Join("@", S_List.ToArray()));
sbScript.AppendFormat(" 'T': \"@{0}\",\r\n", string.Join("@", T_List.ToArray()));
sbScript.AppendFormat(" 'U': \"@{0}\",\r\n", string.Join("@", U_List.ToArray()));
sbScript.AppendFormat(" 'V': \"@{0}\",\r\n", string.Join("@", V_List.ToArray()));
sbScript.AppendFormat(" 'W': \"@{0}\",\r\n", string.Join("@", W_List.ToArray()));
// sbScript.AppendFormat(" 'X': \"@{0}\",\r\n", string.Join("@", X_List.ToArray()));
sbScript.AppendFormat(" 'Y': \"@{0}\",\r\n", string.Join("@", Y_List.ToArray()));
sbScript.AppendFormat(" 'Z': \"@{0}\"\r\n", string.Join("@", Z_List.ToArray()));
}
sbScript.Append(" };\r\n");
sbScript.Append(" $$.module.address.source.fltdomestic_keyWord = $s2t(\"(可直接输入城市名称查找)\");\r\n");
}
}
catch (Exception ex)
{
PnrAnalysis.LogText.LogWrite("获取城市数据：" + ex.Message, "GetCity");
}
return(sbScript.ToString());
}
//更新缓存
public void UpdateCache()
{
if (Request["ctype"] != null && Request["ctype"].ToString() != "")
{
bool IsRefresh = false;
string msg = "";
try
{
string cacheUrl = System.Configuration.ConfigurationManager.AppSettings["CacheUrl"];
if (!string.IsNullOrEmpty(cacheUrl))
{
IRemoteMethod remoteobj = (IRemoteMethod)Activator.GetObject(typeof(IRemoteMethod), cacheUrl);
string ctype = Request["ctype"].ToString();
//基建
if (ctype == "0")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_Aircraft);
}
//仓位
else if (ctype == "1")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_CabinDiscount);
}
//承运人
else if (ctype == "2")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_Carrier);
}
//票价
else if (ctype == "3")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_Fares);
}
//燃油
else if (ctype == "4")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_Fuel);
}
//机场
else if (ctype == "5")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_Airport);
}
//退改签
else if (ctype == "6")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Bd_Air_TGQProvision);
}
//政策
else if (ctype == "7")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.Tb_Ticket_Policy);
}
//所有
else if (ctype == "8")
{
IsRefresh = remoteobj.RefreshCache(cacheTableName.All_Table);
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
try
{
Response.Clear();
int suc = 0;
if (IsRefresh)
{
suc = 1;
}
Response.Write(suc + "@@" + msg);
Response.Flush();
Response.End();
}
catch (Exception)
{
}
}
}
