/// <summary>
/// 根据城市名称查询楼盘信息
/// </summary>
/// <param name="cityName"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <param name="isGetCount">是否获取总数</param>
/// <returns></returns>
public static List <FxtApi_DATProject> GetProjectByCityName(string cityName, int pageIndex, int pageSize, out int count, bool isGetCount = true, FxtAPIClientExtend _fxtApi = null)
{
count = 0;
int isgetcount = 1;
if (!isGetCount)
{
isgetcount = 0;
}
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
string name = "GetProjectByCityNameAndPage";
var para = new { cityName = cityName, pageIndex = pageIndex, pageSize = pageSize, isGetCount = isgetcount };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_DATProject>());
}
FxtApi_ResultPageList listObj = FxtApi_ResultPageList.ConvertToObj(jsonStr);
count = listObj.Count;
List <FxtApi_DATProject> list = FxtApi_DATProject.ConvertToObjList(listObj.ObjJson);
list = list.DecodeField();
fxtApi.Abort();
return(list);
}
public static bool InsertProjectApi(string projectName, int cityId, int areaId, int purposeCode, string address, out string message, FxtAPIClientExtend _fxtApi = null)
{
bool r = true;
message = "";
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "InsertProject";
var para = new { projectName = projectName, cityId = cityId, areaId = areaId, purposeCode = purposeCode, address = address };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
FxtApi_Result result = FxtApi_Result.ConvertToObj(jsonStr);
if (result == null)
{
fxtApi.Abort();
return(false);
}
r = result.Result == 0 ? false : true;
message = JsonHelp.DecodeField(result.Message);
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error("InsertProjectApi(string projectName,int cityId,int areaId,int purposeCode,string address,out string message)", ex);
return(false);
}
return(r);
}
public static List <FxtApi_DATProject> GetProjectByCityIdAndProjectIds(int fxtCityId, int[] projectIds, FxtAPIClientExtend _fxtApi = null)
{
string projectIdsStr = projectIds.ConvertToString();
List <FxtApi_DATProject> list = new List <FxtApi_DATProject>();
if (string.IsNullOrEmpty(projectIdsStr))
{
return(list);
}
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
JObject jObjPara = new JObject();
jObjPara.Add(new JProperty("cityId", fxtCityId));
jObjPara.Add(new JProperty("projectIds", projectIdsStr));
string methodName = "GetProjectByCityIdAndProjectIds";
string jsonStr = Convert.ToString(EntranceApi.Entrance(methodName, jObjPara.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_DATProject>());
}
list = FxtApi_DATProject.ConvertToObjList(jsonStr);
list = list.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetProjectByCityIdAndProjectIds(int fxtCityId, int[] projectIds, FxtAPIClientExtend _fxtApi = null),fxtCity={0}",
fxtCityId), ex);
}
return(list);
}
/// <summary>
/// 根据楼盘名+城市名获取楼盘信息
/// </summary>
/// <param name="projectName"></param>
/// <param name="cityName"></param>
/// <returns></returns>
public static FxtApi_DATProject GetProjectByProjectNameAndCityName(string projectName, string cityName, FxtAPIClientExtend _fxtApi = null)
{
if (string.IsNullOrEmpty(projectName) || string.IsNullOrEmpty(cityName))
{
return(null);
}
FxtApi_DATProject project = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProjectByProjectNameAndCityName";
var para = new { projectName = projectName, cityName = cityName };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(null);
}
project = FxtApi_DATProject.ConvertToObj(jsonStr);
project = project.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetProjectByProjectNameAndCityName(string projectName:{0}, string cityName:{1})",
projectName == null ? "null" : "", cityName == null ? "null" : ""), ex);
}
return(project);
}
public static List <FxtApi_SYSProvince> GetAllProvince(FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_SYSProvince> list = new List <FxtApi_SYSProvince>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProvince";
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, "", _fxtApi: fxtApi));
FxtApi_PublicResult result = FxtApi_PublicResult.ConvertToObj(jsonStr);
if (result == null || string.IsNullOrEmpty(Convert.ToString(result.data)))
{
fxtApi.Abort();
return(new List <FxtApi_SYSProvince>());
}
list = FxtApi_SYSProvince.ConvertToObjList(Convert.ToString(result.data));
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error("GetAllProvince()", ex);
}
return(list);
}
public static List <FxtApi_SYSArea> GetAreaByAreaIds(int[] areaIds, FxtAPIClientExtend _fxtApi = null)
{
string areaIdsStr = areaIds.ConvertToString();
List <FxtApi_SYSArea> list = new List <FxtApi_SYSArea>();
if (string.IsNullOrEmpty(areaIdsStr))
{
return(list);
}
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
JObject jObjPara = new JObject();
jObjPara.Add(new JProperty("areaIds", areaIdsStr));
string methodName = "GetSYSAreaByAreaIds";
string jsonStr = Convert.ToString(EntranceApi.Entrance(methodName, jObjPara.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_SYSArea>());
}
list = FxtApi_SYSArea.ConvertToObjList(jsonStr);
list = list.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetAreaByAreaIds(int[] areaIds, FxtAPIClientExtend _fxtApi = null),areaIds={0}",
areaIdsStr == null?"null":areaIdsStr), ex);
}
return(list);
}
/// <summary>
/// 根据城市名称 and 多个楼盘Ids获取案例Id+楼盘名
/// </summary>
/// <param name="cityId"></param>
/// <param name="fxtCaseIds"></param>
/// <returns></returns>
public static Dictionary <int, string> GetCaseIdJoinProjectNameByCityNameAndCaseIds(string cityName, int[] fxtCaseIds, FxtAPIClientExtend _fxtApi = null)
{
Dictionary <int, string> dic = new Dictionary <int, string>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetCityByCityName";
var para = new { cityName = cityName };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(dic);
}
FxtApi_SYSCity city = FxtApi_SYSCity.ConvertToObj(jsonStr);
if (city == null)
{
fxtApi.Abort();
return(dic);
}
int cityId = city.CityId;
dic = GetCaseIdJoinProjectNameByFxtCityIdAndCaseIds(cityId, fxtCaseIds, _fxtApi: fxtApi);
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetCaseIdJoinProjectNameByCityNameAndCaseIds(string cityName:{0}, int[] fxtCaseIds)", cityName == null ? "null" : ""), ex);
}
return(dic);
}
public static FxtApi_DATProjectAvgPrice ResetCross(int projectId, int fxtCityId, int purposeTypeCode, int buildingTypeCode, int buildingAreaType, string date, out string message, FxtAPIClientExtend _fxtApi = null)
{
message = "";
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
FxtApi_DATProjectAvgPrice avgPrice = null;
try
{
string name = "ResetCrossBy";
var para = new { projectId = projectId, cityId = fxtCityId, purposeTypeCode = purposeTypeCode, buildingTypeCode = buildingTypeCode, buildingAreaType = buildingAreaType, date = date };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (!string.IsNullOrEmpty(jsonStr))
{
avgPrice = FxtApi_DATProjectAvgPrice.ConvertToObj(jsonStr);
}
}
catch (Exception ex)
{
fxtApi.Abort();
message = "系统异常";
log.Error("ResetCross(int projectId, int fxtCityId, int purposeTypeCode, int buildingTypeCode, int buildingAreaType, string date, FxtAPIClientExtend _fxtApi = null)", ex);
return(null);
}
fxtApi.Abort();
return(avgPrice);
}
public static List <FxtApi_SYSCode> GetSYSCodeById(int id, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_SYSCode> list = new List <FxtApi_SYSCode>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetSYSCodeByID";
var para = new { id = id };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_SYSCode>());
}
list = FxtApi_SYSCode.ConvertToObjList(jsonStr);
list.DecodeField <FxtApi_SYSCode>();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error("GetSYSCodeById(int id,FxtAPIClientExtend _fxtApi = null)", ex);
}
return(list);
}
public static List <FxtApi_DATProjectAvgPrice> GetCross(int projectId, int fxtCityId, int[] codeTypes, string[] dates, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
if (codeTypes == null || codeTypes.Length < 1)
{
codeTypes = new int[] { 1002001, 1002027 };
}
try
{
foreach (int code in codeTypes)
{
foreach (string date in dates)
{
List <FxtApi_DATProjectAvgPrice> _list = GetCross(projectId, fxtCityId, code, date, _fxtApi: fxtApi);
if (_list != null && _list.Count > 0)
{
list.AddRange(_list);
}
}
}
}
catch (Exception ex)
{
log.Error("GetCross(int projectId, int fxtCityId, int[] codeTypes, string[] dates, FxtAPIClientExtend _fxtApi = null)", ex);
fxtApi.Abort();
return(list);
}
fxtApi.Abort();
return(list);
}
/// <summary>
/// 根据条件获取DATProjectAvgPrice
/// </summary>
/// <param name="projectId"></param>
/// <param name="fxtCityId"></param>
/// <param name="purposeCode"></param>
/// <param name="buildingTypeCode"></param>
/// <param name="buildingAreaCode"></param>
/// <param name="date"></param>
/// <param name="dateRange"></param>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static List <FxtApi_DATProjectAvgPrice> GetProjectAvgPriceByProjectIdAndCityIdAndBy(int projectId, int fxtCityId, int purposeCode, int?buildingTypeCode, int?buildingAreaCode, string date, int dateRange, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProjectAvgPriceByProjectIdAndCityIdAndBy";
var para = new { projectId = projectId, cityId = fxtCityId, purposeCode = purposeCode, buildingTypeCode = buildingTypeCode, buildingAreaCode = buildingAreaCode, date = date, dateRange = dateRange };
string json = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
FxtApi_PublicResult result = FxtApi_PublicResult.ConvertToObj(json);
if (result == null || string.IsNullOrEmpty(Convert.ToString(result.data)))
{
fxtApi.Abort();
return(list);
}
list = FxtApi_DATProjectAvgPrice.ConvertToObjList(Convert.ToString(result.data));
fxtApi.Abort();
}
catch (Exception ex)
{
log.Error("GetProjectAvgPriceByProjectIdAndCityIdAndBy", ex);
fxtApi.Abort();
}
return(list);
}
public static List <FxtApi_DATProjectView> GetProjectViewByCityNameAndLikeProjectName(string projectNameLike, string cityName, int count, FxtAPIClientExtend _fxtApi = null)
{
if (string.IsNullOrEmpty(projectNameLike) || string.IsNullOrEmpty(cityName))
{
return(new List <FxtApi_DATProjectView>());
}
List <FxtApi_DATProjectView> list = new List <FxtApi_DATProjectView>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProjectViewByCityNameAndLikePrjName";
var para = new { cityName = cityName, projectName = projectNameLike, length = count };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_DATProjectView>());
}
list = FxtApi_DATProjectView.ConvertToObjList(jsonStr);
list = list.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetProjectViewByCityNameAndLikeProjectName(string projectNameLike:{0}, string cityName:{1}, int count:{2})",
projectNameLike == null ? "null" : "", cityName == null ? "null" : "", count), ex);
}
return(list);
}
/// <summary>
/// 根据名称成城市ID,获取楼盘信息(关联网络名查询)
/// </summary>
/// <param name="projectName">名字</param>
/// <param name="fxtCityId">服务端的城市ID</param>
/// <returns></returns>
public static List <FxtApi_DATProject> GetProjectJoinProjectMatchByProjectNameCityId(string projectName, int fxtCityId, FxtAPIClientExtend _fxtApi = null)
{
if (string.IsNullOrEmpty(projectName))
{
return(new List <FxtApi_DATProject>());
}
List <FxtApi_DATProject> list = new List <FxtApi_DATProject>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProjectJoinProjectMatchByProjectNameCityId";
var para = new { projectName = projectName, cityId = fxtCityId };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_DATProject>());
}
list = FxtApi_DATProject.ConvertToObjList(jsonStr);
list = list.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetProjectJoinProjectMatchByProjectNameCityId(string projectName:{0}, int fxtCityId:{1})",
projectName == null ? "null" : "", fxtCityId), ex);
}
return(list);
}
/// <summary>
/// 根据字段code获取code信息
/// </summary>
/// <param name="code"></param>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static FxtApi_SYSCode GetSYSCodeByCode(int code, FxtAPIClientExtend _fxtApi = null)
{
FxtApi_SYSCode codeObj = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
JObject jObjPara = new JObject();
jObjPara.Add(new JProperty("code", code));
string methodName = "GetSYSCodeByCode";
string jsonStr = Convert.ToString(EntranceApi.Entrance(methodName, jObjPara.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(codeObj);
}
codeObj = FxtApi_SYSCode.ConvertToObj(jsonStr);
codeObj = codeObj.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetSYSCodeByCode(int code, FxtAPIClientExtend _fxtApi = null)),code={0}",
code), ex);
}
return(codeObj);
}
/// <summary>
/// 获取别墅相关的住宅用途
/// </summary>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static List <FxtApi_SYSCode> GetPurposeTypeCodeVillaType(FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_SYSCode> list = new List <FxtApi_SYSCode>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetPurposeTypeCodeVillaType";
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, "", _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_SYSCode>());
}
list = FxtApi_SYSCode.ConvertToObjList(jsonStr);
list.DecodeField <FxtApi_SYSCode>();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error("GetPurposeTypeCodeVillaType()", ex);
}
return(list);
}
/// <summary>
/// 根据房讯通城市ID and 案例ID获取案例信息
/// </summary>
/// <param name="fxtCityId"></param>
/// <param name="fxtCaseId"></param>
/// <returns></returns>
public static FxtApi_DATCase GetCaseByFxtCityIdAndCaseId(int fxtCityId, int fxtCaseId, FxtAPIClientExtend _fxtApi = null)
{
FxtApi_DATCase _case = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
JObject jObjPara = new JObject();
jObjPara.Add(new JProperty("cityId", fxtCityId));
jObjPara.Add(new JProperty("caseId", fxtCaseId));
string methodName = "GetCaseByCityIdAndCaseId";
string jsonStr = Convert.ToString(EntranceApi.Entrance(methodName, jObjPara.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(_case);
}
_case = FxtApi_DATCase.ConvertToObj(jsonStr);
_case = _case.DecodeField();
fxtApi.Abort();
}
catch (Exception ex)
{
log.Error(string.Format("GetCaseByFxtCityIdAndCaseId(int fxtCityId:{0}, int fxtCaseId:{1}, FxtAPIClientExtend _fxtApi = null)", fxtCityId, fxtCaseId), ex);
fxtApi.Abort();
}
return(_case);
}
/// <summary>
/// 根据城市ID和多个caseId删除案例
/// </summary>
/// <param name="fxtCityId"></param>
/// <param name="caseIds"></param>
/// <param name="message"></param>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static bool DeleteCaseByFxtCityIdAndCaseIds(int fxtCityId, int[] caseIds, out string message, FxtAPIClientExtend _fxtApi = null)
{
message = "";
if (caseIds == null || caseIds.Length < 1)
{
return(true);
}
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "DeleteCaseByCityIdAndCaseIds";
var para = new { cityId = fxtCityId, caseIds = caseIds.ConvertToString() };
string json = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
FxtApi_PublicResult result = FxtApi_PublicResult.ConvertToObj(json);
bool _re = true;
if (result.type == 0)
{
message = result.message.DecodeField();
_re = false;
}
fxtApi.Abort();
return(_re);
}
catch (Exception ex)
{
message = "系统异常";
log.Error("DeleteCaseByCityIdAndCaseIds(int cityId, int[] caseIds,out string message)", ex);
fxtApi.Abort();
return(false);
}
return(true);
}
/// <summary>
/// 根据城市名称获取城市信息
/// </summary>
/// <param name="cityName"></param>
/// <returns></returns>
public static FxtApi_SYSCity GetCityByCityName(string cityName, FxtAPIClientExtend _fxtApi = null)
{
FxtApi_SYSCity city = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetCityByCityName";
var para = new { cityName = cityName };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(null);
}
city = FxtApi_SYSCity.ConvertToObj(jsonStr);
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetCityByCityName(string cityName:{0})", cityName == null ? "null" : ""), ex);
}
return(city);
}
/// <summary>
/// 根据fxt省份ID获取城市信息
/// </summary>
/// <param name="fxtProvinceId"></param>
/// <returns></returns>
public static List <FxtApi_SYSCity> GetCityByProvinceId(int fxtProvinceId, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_SYSCity> list = new List <FxtApi_SYSCity>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetCity";
var para = new { provinceId = fxtProvinceId };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
FxtApi_PublicResult result = FxtApi_PublicResult.ConvertToObj(jsonStr);
if (result == null || string.IsNullOrEmpty(Convert.ToString(result.data)))
{
fxtApi.Abort();
return(new List <FxtApi_SYSCity>());
}
list = FxtApi_SYSCity.ConvertToObjList(Convert.ToString(result.data));
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format(" GetCityByProvinceId(int provinceId:{0})", fxtProvinceId), ex);
}
return(list);
}
public static object Entrance_FxtSpider(string methodName, string methodValue, FxtAPIClientExtend _fxtApi = null)
{
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
object obj = fxtApi.FxtApi.Entrance(WcfCheck.GetWcfCheckValidDate(), WcfCheck.GetWcfCheckValidCode(), "B", methodName, methodValue);
fxtApi.Abort();
return(obj);
}
public static List <FxtApi_DATProjectAvgPrice> GetCross(int[] projectIds, int fxtCityId, int[] codeTypes, string[] dates, FxtAPIClientExtend _fxtApi = null)
{
int[] villaTypeCode = SysCodeApi.PurposeTypeCodeVillaType.ToArray();
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
if (codeTypes == null || codeTypes.Length < 1)
{
codeTypes = new int[] { SysCodeApi.Code1, SysCodeApi.Code2 };
}
List <string> stringList = new List <string>();
foreach (string str in dates)
{
stringList.Add(str.Replace("-", ""));
}
list = GetProjectAvgPriceByProjectIdsAndCityIdAndDateRangeAndAvgPriceDates(projectIds, fxtCityId, 3, stringList.ToArray(), _fxtApi: fxtApi);
try
{
foreach (int projectId in projectIds)
{
foreach (int code in codeTypes)
{
foreach (string date in dates)
{
Func <FxtApi_DATProjectAvgPrice, bool> where = p => p.ProjectId == projectId && p.PurposeType == code && p.AvgPriceDate == date.Replace("-", "");
if (code == 1002027)//如果为别墅
{
where = p => p.ProjectId == projectId && villaTypeCode.Contains(Convert.ToInt32(p.PurposeType)) && p.AvgPriceDate == date.Replace("-", "");
}
List <FxtApi_DATProjectAvgPrice> _list = list.Where(where).ToList();
if (_list == null || _list.Count < 1)
{
_list = GetCross(projectId, fxtCityId, code, date, _fxtApi: fxtApi);
if (_list != null && _list.Count > 0)
{
list.AddRange(_list);
}
}
}
}
}
}
catch (Exception ex)
{
log.Error("GetCross(int[] projectIds, int fxtCityId, int[] codeTypes, string[] dates, FxtAPIClientExtend _fxtApi = null)", ex);
fxtApi.Abort();
return(list);
}
fxtApi.Abort();
return(list);
}
/// <summary>
/// 获取房讯通companyId=25的可查询企业范围
/// </summary>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static string GetFxtPriviCompanyShowDataCaseCompanyIds(int fxtCityId, FxtAPIClientExtend _fxtApi = null)
{
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
FxtApi_PriviCompanyShowData obj = GetPriviCompanyShowDataByCompanyIdAndCityId(25, fxtCityId, _fxtApi: fxtApi);
fxtApi.Abort();
if (obj == null || string.IsNullOrEmpty(obj.CaseCompanyId))
{
return("25");
}
return(obj.CaseCompanyId);
}
public static List <FxtApi_DATProjectAvgPrice> GetProjectAvgPriceByProjectIdsAndCityIdAndDateRangeAndAvgPriceDates(int[] projectIds, int fxtCityId, int dateRange, string[] avgPriceDates, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
string name = "GetProjectAvgPriceByProjectIdsAndCityIdAndDateRangeAndAvgPriceDates";
var para = new { projectIds = projectIds.ConvertToString(), cityId = fxtCityId, dateRange = dateRange, avgPriceDates = avgPriceDates.ConvertToString() };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
return(list);
}
list = FxtApi_DATProjectAvgPrice.ConvertToObjList(jsonStr);
fxtApi.Abort();
return(list);
}
public static void testcross()
{
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend();
try
{
JObject jObjPara = new JObject();
jObjPara.Add(new JProperty("cityId", 1));
string methodName = "testcross";
string jsonStr = Convert.ToString(EntranceApi.Entrance(methodName, jObjPara.ToJSONjss(), _fxtApi: fxtApi));
fxtApi.Abort();
}
catch (Exception ex)
{
}
}
public static int GetCrossProjectByCodeType(int projectId, int fxtCityId, int codeType, string date, FxtAPIClientExtend _fxtApi = null)
{
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
string name = "CrossProjectByCodeType";
var para = new { projectId = projectId, cityId = fxtCityId, codeType = codeType, date = date };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
fxtApi.Abort();
FxtApi_PublicResult result = FxtApi_PublicResult.ConvertToObj(jsonStr);
if (result == null || string.IsNullOrEmpty(Convert.ToString(result.data)))
{
return(0);
}
return(Convert.ToInt32(result.data));
}
public static List <FxtApi_DATProjectAvgPrice> GetCrossByCompanyId(int projectId, int fxtCityId, int codeType, string date, int fxtCompanyId, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
string name = "CrossByFxtCompanyId";
var para = new { projectId = projectId, cityId = fxtCityId, codeType = codeType, date = date, fxtCompanyId = fxtCompanyId };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
return(list);
}
list = FxtApi_DATProjectAvgPrice.ConvertToObjList(jsonStr);
fxtApi.Abort();
return(list);
}
/// <summary>
/// 查询案例
/// </summary>
/// <param name="fxtCityId"></param>
/// <param name="projectId"></param>
/// <param name="buildingTypeCode"></param>
/// <param name="purposeCode">用途</param>
/// <param name="buildingAreaCode">面积段code</param>
/// <param name="startDate">案例时间</param>
/// <param name="endDate"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <param name="isGetCount">是否获取总个数</param>
/// <returns></returns>
public static List <FxtApi_DATCase> GetCaseByFxtCityIdAndFxtProjectIdAndBuildingTypeCodeAndPurposeCodeAndAreaTypeAndDate(int fxtCityId, int projectId, string fxtCompanyIds, int?buildingTypeCode, int purposeCode, int?buildingAreaCode, DateTime?startDate, DateTime?endDate, int pageIndex, int pageSize, out int count, bool isGetCount = true, FxtAPIClientExtend _fxtApi = null)
{
count = 0;
int isgetcount = 1;
if (!isGetCount)
{
isgetcount = 0;
}
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
string name = "GetCaseByCityIdAndProjectIdAndPurposeCodeAndBuildingTypeCodeAndAreaTypeAndDateAndPage";
var para = new
{
cityId = fxtCityId,
projectId = projectId,
fxtCompanyIds = fxtCompanyIds,
buildingTypeCode = buildingTypeCode,
purposeCode = purposeCode,
buildingAreaCode = buildingAreaCode,
startDate = Convert.ToString(startDate),
endDate = Convert.ToString(endDate),
pageIndex = pageIndex,
pageSize = pageSize,
isGetCount = isgetcount
};
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
if (string.IsNullOrEmpty(jsonStr))
{
fxtApi.Abort();
return(new List <FxtApi_DATCase>());
}
FxtApi_ResultPageList listObj = FxtApi_ResultPageList.ConvertToObj(jsonStr);
count = listObj.Count;
List <FxtApi_DATCase> list = FxtApi_DATCase.ConvertToObjList(listObj.ObjJson);
list = list.DecodeField();
fxtApi.Abort();
return(list);
}
public static FxtApi_SYSProvince GetProvinceById(int fxtId, FxtAPIClientExtend _fxtApi = null)
{
FxtApi_SYSProvince obj = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetProvinceById";
var para = new { provinceId = fxtId };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
obj = FxtApi_SYSProvince.ConvertToObj(jsonStr);
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetProvinceById(int Id:{0})", fxtId), ex);
}
return(obj);
}
/// <summary>
/// 根据房讯通城市ID and 多个楼盘Ids获取案例Id+楼盘名
/// </summary>
/// <param name="cityId"></param>
/// <param name="fxtCaseIds"></param>
/// <returns></returns>
public static Dictionary <int, string> GetCaseIdJoinProjectNameByFxtCityIdAndCaseIds(int fxtCityId, int[] fxtCaseIds, FxtAPIClientExtend _fxtApi = null)
{
Dictionary <int, string> dic = new Dictionary <int, string>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
if (fxtCaseIds == null || fxtCaseIds.Length < 1)
{
return(dic);
}
string fxtCaseIdsStr = fxtCaseIds.ConvertToString();
string name = "GetCaseIdJoinProjectNameByCityIdAndCaseIds";
var para = new { cityId = fxtCityId, caseIds = fxtCaseIdsStr };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
fxtApi.Abort();
if (string.IsNullOrEmpty(jsonStr))
{
return(dic);
}
JArray jarray = JArray.Parse(jsonStr);
foreach (JObject jobject in jarray)
{
int fxtCaseId = jobject["CaseId"].Value <int>();
string projectName = jobject["ProjectName"].Value <string>();
projectName = projectName.DecodeField();
if (!dic.ContainsKey(fxtCaseId))
{
dic.Add(fxtCaseId, projectName);
}
}
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error(string.Format("GetCaseIdJoinProjectNameByFxtCityIdAndCaseIds(int fxtCityId:{0}, int[] fxtCaseIds)", fxtCityId), ex);
}
return(dic);
}
public static FxtApi_DATProjectAvgPrice GetProjectAvgNowMonths(int projectId, int fxtCityId, int purposeCode, string date, FxtAPIClientExtend _fxtApi = null)
{
List <FxtApi_DATProjectAvgPrice> list = new List <FxtApi_DATProjectAvgPrice>();
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
list = GetProjectAvgPriceByProjectIdAndCityIdAndBy(projectId, fxtCityId, purposeCode, null, null, date, 1, _fxtApi: fxtApi);
fxtApi.Abort();
}
catch (Exception ex)
{
log.Error("GetProjectAvgNowMoths", ex);
fxtApi.Abort();
}
if (list == null || list.Count < 1)
{
return(null);
}
return(list[0]);
}
