/// <summary>
/// 获取用户下拉列表
/// </summary>
/// <param name="companyId">当前机构ID</param>
/// <param name="userNames">用多个数组</param>
/// <param name="keyWord">查询关键字</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">每页条数</param>
/// <param name="username">当前调用api的username</param>
/// <param name="signname">当前调用api的signname</param>
/// <returns></returns>
public static List <UserInfo> GetUserListByCompanyId(int companyId, string[] userNames, string keyWord, int?valid, int pageIndex, int pageSize, out int count, string loginusername, string loginsignname, List <Apps> appList)
{
count = 0;
StringBuilder sb = new StringBuilder("");
if (userNames != null)
{
foreach (string str in userNames)
{
sb.Append("").Append(str).Append(",");
}
}
keyWord = keyWord.TrimBlank();
var para = new { username = sb.ToString().Trim(','), keyword = keyWord, valid = Convert.ToString(valid), companyid = companyId, companycode = "", search = new { Page = "true", PageIndex = pageIndex, PageRecords = pageSize }.ToJSONjss() };
DataCenterResult result = Common.PostUserCenter(loginusername, loginsignname, Common.userseven, para, appList);
List <UserInfo> list = new List <UserInfo>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <UserInfo>();
}
if (list != null && list.Count > 0)
{
count = list[0].RecordCount;
}
return(list);
}
public static UserCenter_LoginUserInfo UserLogin(string userName, string password, out List <UserCenter_Apps> appList, out string message)
{
appList = new List <UserCenter_Apps>();
message = "";
DataCenterResult result = Common.PostUserCenter_Login(userName, password);
if (result == null || string.IsNullOrEmpty(result.data) || result.returntype != 1)
{
message = "用户名或密码错误";
return(null);
}
UserCenter_LoginUserInfo userObj = new UserCenter_LoginUserInfo();
JObject jobj = JObject.Parse(result.data);
string uinfoJson = Convert.ToString(jobj.Value <object>("uinfo"));
string sinfoJson = Convert.ToString(jobj.Value <object>("sinfo"));
if (string.IsNullOrEmpty(uinfoJson) || string.IsNullOrEmpty(sinfoJson))
{
message = "用户名或密码错误";
return(null);
}
userObj = uinfoJson.ParseJSONjss <UserCenter_LoginUserInfo>();
if (userObj == null)
{
message = "用户名或密码错误";
return(null);
}
string appsJson = Convert.ToString(jobj["sinfo"].Value <object>("apps"));
appList = appsJson.ParseJSONList <UserCenter_Apps>();
userObj.SignName = jobj["sinfo"].Value <string>("signname");
userObj.UserName = userName;
userObj.Password = password;
return(userObj);
}
/// <summary>
/// 获取行政区列表
/// </summary>
/// <param name="cityId"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static List <FxtApi_SYSArea> GetAreaByCityId(int cityId, string username, string signname, List <Apps> appList)
{
List <FxtApi_SYSArea> areaList = CacheHelper.GetCache("areaList") as List <FxtApi_SYSArea>;
if (areaList == null)
{
CAS.Common.MVC4.LogHelper.Info("写入行政区缓存");
//var para = new { cityid = cityId };
var para = new { };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.garealist, para, appList);
List <FxtApi_SYSArea> list = new List <FxtApi_SYSArea>();
if (!string.IsNullOrEmpty(result.data))
{
areaList = result.data.ParseJSONList <FxtApi_SYSArea>();
}
HttpHelper.CurrentCache.Insert("areaList", areaList, null, Cache.NoAbsoluteExpiration, DateTime.Now.AddDays(1) - DateTime.Now);
areaList = areaList.Where(m => m.CityId == cityId).ToList();
}
else
{
CAS.Common.MVC4.LogHelper.Info("读取行政区缓存");
areaList = areaList.Where(m => m.CityId == cityId).ToList();
}
return(areaList);
}
/// <summary>
/// 转换数据中心结果对象
/// </summary>
/// <param name="jsonStr"></param>
/// <returns></returns>
public static DataCenterResult GetDataCenterResult(string jsonStr)
{
if (string.IsNullOrEmpty(jsonStr))
{
return(new DataCenterResult());
}
DataCenterResult obj = jsonStr.ParseJSONjss <DataCenterResult>();
return(obj);
}
/// <summary>
/// 调用数据中心接口(用于上传文件)
/// </summary>
/// <param name="userName"></param>
/// <param name="signName"></param>
/// <param name="functionName"></param>
/// <param name="parasObj"></param>
/// <param name="data"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static DataCenterResult PostDataCenter(string userName, string signName, string functionName, object parasObj, byte[] data, List <Apps> appList)
{
string appPwd = "";
string appKey = "";
string apiUrl = "";
FxtApiCommon.GetNowApiInfo(Common.appId, appList, out apiUrl, out appPwd, out appKey);
//apiUrl = "http://192.168.1.104:8100/dc/active";
string nowTime = DateTime.Now.ToString("yyyyMMddHHmmss");
string sinfo = JsonHelp.ToJSONjss(new
{
functionname = functionName,
appid = Common.appId,
apppwd = appPwd,
signname = signName,
time = nowTime,
code = Common.GetCode(signName, nowTime, functionName, appList)
});
string info = JsonHelp.ToJSONjss(new
{
uinfo = new { username = userName, token = "" },
appinfo = new
{
splatype = "win",
platVer = "2007",
stype = "",//验证
version = "4.26",
vcode = "1",
systypecode = Common.systypeCode.ToString(), //验证
channel = "360"
},
funinfo = parasObj
});
string url = apiUrl + "/upload";
url = url + "?sinfo=" + sinfo.EncodeField() + "&info=" + info.EncodeField();
HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(url);
webrequest.ContentType = "application/octet-stream";
webrequest.Method = "POST";
Stream requestStream = webrequest.GetRequestStream();
byte[] boundaryBytes = Encoding.ASCII.GetBytes("\r\n–—————————7d930d1a850658–\r\n");
requestStream.Write(data, 0, data.Length);
// 输入尾部数据
requestStream.Write(boundaryBytes, 0, boundaryBytes.Length);
WebResponse responce = webrequest.GetResponse();
Stream s = responce.GetResponseStream();
StreamReader sr = new StreamReader(s);
// 返回数据流(源码)
string str = sr.ReadToEnd();
DataCenterResult result = Common.GetDataCenterResult(str);
return(result);
}
public static List <CAS.Entity.DBEntity.DATProject> GetProjectInfo(int cityId, int projectid, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, projectid = projectid };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.gpdinfo, para, appList);
List <CAS.Entity.DBEntity.DATProject> entity = new List <CAS.Entity.DBEntity.DATProject>();
if (!string.IsNullOrEmpty(result.data))
{
entity = JsonHelp.ParseJSONList <CAS.Entity.DBEntity.DATProject>(result.data);
}
return(entity);
}
/// <summary>
/// 获取行政区列表
/// </summary>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static List <FxtApi_SYSCity> GetCityAll(string username, string signname, List <UserCenter_Apps> appList)
{
var para = new {};
DataCenterResult result = Common.PostDataCenter(username, signname, Common.citylist, para, appList);
List <FxtApi_SYSCity> list = new List <FxtApi_SYSCity>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <FxtApi_SYSCity>();
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static List <SYSCode> GetCodeById(int id, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { id = id };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.gscodelist, para, appList);
List <SYSCode> list = new List <SYSCode>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <SYSCode>();
}
return(list);
}
/// <summary>
/// 根据楼盘ID获取楼栋、房号数量
/// </summary>
/// <param name="cityId"></param>
/// <param name="projectid"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static DatProjectTotal GetProjectBuildingHouseTotal(int cityId, int projectid, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, projectid = projectid };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.buildinghousetotal, para, appList);
DatProjectTotal entity = null;
if (!string.IsNullOrEmpty(result.data))
{
entity = JsonHelp.ParseJSONjss <DatProjectTotal>(result.data);
}
return(entity);
}
public static List <int> GetSysRoleUserIds(string userName, string signName, List <Apps> appList)
{
var para = new { username = userName };
DataCenterResult result = Common.PostDataCenter(userName, signName, Common.getsysroleuserids, para, appList);
List <int> list = new List <int>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <int>();
}
return(list);
}
/// <summary>
/// 获取楼盘下拉列表
/// </summary>
/// <param name="key">搜索关键字</param>
/// <param name="cityId">当前城市</param>
/// <param name="username">当前调用api的username</param>
/// <param name="signname">当前调用api的signname</param>
/// <param name="appList">当前当前用户拥有的api信息集合</param>
/// <returns></returns>
public static IList <DATHouse> GetHouseByBuildingIdAndFloorNo(int buildingId, int floorNo, int cityId, string username, string signname, List <Apps> appList)
{
var para = new { buildingid = buildingId, floorno = floorNo, cityid = cityId, pageindex = 1, pagerecords = 300, };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.queryhousedropdownlist, para, appList);
IList <DATHouse> list = new List <DATHouse>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <DATHouse>();
}
return(list);
}
/// <summary>
/// 获取省份列表
/// </summary>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static List <FxtApi_SYSProvince> GetProvinceAll(string username, string signname, List <Apps> appList)
{
var para = new { };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.provincelist, para, appList);
List <FxtApi_SYSProvince> list = new List <FxtApi_SYSProvince>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <FxtApi_SYSProvince>();
}
return(list);
}
/// <summary>
/// 获取楼栋下拉列表
/// </summary>
/// <param name="key">搜索关键字</param>
/// <param name="cityId">当前城市</param>
/// <param name="projectId">楼盘</param>
/// <param name="username">当前调用api的username</param>
/// <param name="signname">当前调用api的signname</param>
/// <param name="appList">当前用户拥有的api集合</param>
/// <returns></returns>
public static IList <CAS.Entity.DBEntity.DATBuilding> GetBuilding(string key, int cityId, int projectId, int pageindex, int pagerecords, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, key = key, projectid = projectId, pageindex = pageindex, pagerecords = pagerecords };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.queryautobuildinginfolist, para, appList);
IList <CAS.Entity.DBEntity.DATBuilding> list = new List <CAS.Entity.DBEntity.DATBuilding>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <CAS.Entity.DBEntity.DATBuilding>();
}
return(list);
}
public static List <CAS.Entity.DBEntity.DATProject> GetProjectBuildingHouse(int cityId, string proujectIds, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, projectids = proujectIds };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.getprojectbuildinghouselist, para, appList);
List <CAS.Entity.DBEntity.DATProject> list = new List <CAS.Entity.DBEntity.DATProject>();
if (!string.IsNullOrEmpty(result.data))
{
list = JsonHelp.ParseJSONList <CAS.Entity.DBEntity.DATProject>(result.data);
}
return(list);
}
/// <summary>
/// 获取片区列表
/// </summary>
/// <param name="cityId"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static List <FxtApi_SYSSubArea> GetSubAreaByAreaId(int areaId, string username, string signname, List <Apps> appList)
{
var para = new { areaid = areaId };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.gsubarealist, para, appList);
List <FxtApi_SYSSubArea> list = new List <FxtApi_SYSSubArea>();
if (!string.IsNullOrEmpty(result.data))
{
list = result.data.ParseJSONList <FxtApi_SYSSubArea>();
}
return(list);
}
/// <summary>
/// 调用数据中心接口
/// </summary>
/// <param name="userName"></param>
/// <param name="signName"></param>
/// <param name="functionName"></param>
/// <param name="parasObj"></param>
/// <returns></returns>
public static DataCenterResult PostDataCenter(string userName, string signName, string functionName, object parasObj, List <Apps> appList)
{
try
{
string appPwd = "";
string appKey = "";
string apiUrl = "";
FxtApiCommon.GetNowApiInfo(Common.appId, appList, out apiUrl, out appPwd, out appKey);
apiUrl = "http://localhost:40455/dc/active";
string nowTime = DateTime.Now.ToString("yyyyMMddHHmmss");
var para = new
{
sinfo = JsonHelp.ToJSONjss(new
{
functionname = functionName,
appid = Common.appId,
apppwd = appPwd,
signname = signName,
time = nowTime,
code = Common.GetCode(signName, nowTime, functionName, appList)
}),
info = JsonHelp.ToJSONjss(new
{
uinfo = new { username = userName, token = "" },
appinfo = new
{
splatype = "win",
platVer = "2007",
stype = "",//验证
version = "4.26",
vcode = "1",
systypecode = Common.systypeCode.ToString(),//验证
channel = "360"
},
funinfo = parasObj
})
};
HttpClient client = new HttpClient();
//client.BaseAddress = new Uri(apiUrl);
client.Timeout = new TimeSpan(0, 10, 0);
HttpResponseMessage hrm = client.PostAsJsonAsync(new Uri(apiUrl), para).Result;
string str = hrm.Content.ReadAsStringAsync().Result;
DataCenterResult result = Common.GetDataCenterResult(str);
return(result);
}
catch (AggregateException ex)
{
throw ex;
}
}
/// <summary>
/// 获取公司开通产品模块的城市ID
/// </summary>
/// <param name="signname"></param>
/// <param name="productcode"></param>
/// <param name="loginusername"></param>
/// <param name="loginsignname"></param>
/// <param name="appList"></param>
/// <returns></returns>
public static int[] GetCompanyProductMuduleCityIds(string signname, int productcode, string loginusername, string loginsignname, List <Apps> appList)
{
int[] cityIds = null;
var para = new { signname = signname, productcode = productcode };
DataCenterResult result = Common.PostUserCenter(loginusername, loginsignname, Common.cptmcityids, para, appList);
List <UserInfo> list = new List <UserInfo>();
if (!string.IsNullOrEmpty(result.data))
{
List <int> intList = result.data.ParseJSONList <int>();
if (intList != null && intList.Count > 0)
{
cityIds = intList.ToArray();
}
}
return(cityIds);
}
/// <summary>
/// 调用用户中心接口
/// </summary>
/// <param name="userName"></param>
/// <param name="signName"></param>
/// <param name="functionName"></param>
/// <param name="parasObj"></param>
/// <param name="appList">当前用户所拥有的api信息集合</param>
/// <returns></returns>
public static DataCenterResult PostUserCenter(string userName, string signName, string functionName, object parasObj, List <UserCenter_Apps> appList)
{
string appPwd = "";
string appKey = "";
string apiUrl = "";
FxtApiCommon.GetNowApiInfo(Common.appId, appList, out apiUrl, out appPwd, out appKey);
string nowTime = DateTime.Now.ToString("yyyyMMddHHmmss");
var para = new
{
sinfo = JsonHelp.ToJSONjss(new
{
functionname = functionName,
appid = Common.appId,
apppwd = appPwd,
signname = signName,
time = nowTime,
code = Common.GetCode(signName, nowTime, functionName, appList)
}),
info = JsonHelp.ToJSONjss(new
{
uinfo = new { username = userName, token = "" },
appinfo = new
{
splatype = "win",
platVer = "2007",
stype = "",//验证
version = "4.26",
vcode = "1",
systypecode = Common.systypeCode.ToString(),//验证
channel = "360"
},
funinfo = parasObj
})
};
HttpClient client = new HttpClient();
//apiUrl = "http://192.168.1.104:8200/uc/active";
HttpResponseMessage hrm = client.PostAsJsonAsync(apiUrl, para).Result;
string str = hrm.Content.ReadAsStringAsync().Result;
DataCenterResult result = Common.GetDataCenterResult(str);
return(result);
}
/// <summary>
/// 给楼盘上传照片
/// </summary>
/// <param name="projectId"></param>
/// <param name="cityId"></param>
/// <param name="photoTypeCode"></param>
/// <param name="fileName"></param>
/// <param name="photoName"></param>
/// <param name="data"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <param name="message"></param>
/// <returns></returns>
public static int AddProjectPhoto(int projectId, long buildingId, int cityId, int photoTypeCode, string fileName, string photoName, byte[] data, string username, string signname, List <UserCenter_Apps> appList, out string message)
{
var para = new { projectid = projectId, buildingid = buildingId, cityid = cityId, phototypecode = photoTypeCode, filename = fileName, photoname = photoName };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.addprojectphoto, para, data, appList);
string path = "";
message = "";
if (!string.IsNullOrEmpty(result.data))
{
JObject _jobj = JObject.Parse(result.data);
path = _jobj.Value <string>("path").DecodeField();
message = _jobj.Value <string>("message");
}
if (string.IsNullOrEmpty(path))
{
return(0);
}
return(1);
}
/// <summary>
/// 获取楼盘下拉列表
/// </summary>
/// <param name="key">搜索关键字</param>
/// <param name="cityId">当前城市</param>
/// <param name="areaId">行政区</param>
/// <param name="subAreaId">片区</param>
/// <param name="username">当前调用api的username</param>
/// <param name="signname">当前调用api的signname</param>
/// <param name="appList">当前用户拥有的api集合</param>
/// <returns></returns>
public static IList <CAS.Entity.DBEntity.DATProject> GetProject(string key, int cityId, int areaId, int subAreaId, int pageindex, int pagerecords, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, key = key, areaid = areaId, subareaid = subAreaId, pageindex = pageindex, pagerecords = pagerecords };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.plist, para, appList);
IList <CAS.Entity.DBEntity.DATProject> list = new List <CAS.Entity.DBEntity.DATProject>();
if (!string.IsNullOrEmpty(result.data))
{
JArray _jarray = JArray.Parse(result.data);
foreach (JToken jt in _jarray)
{
JObject _jobject = (JObject)jt;
CAS.Entity.DBEntity.DATProject proj = new CAS.Entity.DBEntity.DATProject();
proj = _jobject.ToJSONjss().ParseJSONjss <CAS.Entity.DBEntity.DATProject>();
list.Add(proj);
}
}
return(list);
}
/// <summary>
/// 获取楼盘下拉列表
/// </summary>
/// <param name="key">搜索关键字</param>
/// <param name="cityId">当前城市</param>
/// <param name="username">当前调用api的username</param>
/// <param name="signname">当前调用api的signname</param>
/// <param name="appList">当前用户拥有的api集合</param>
/// <returns></returns>
public static IList <DATProject> GetProjectByLikeName(string key, int cityId, string username, string signname, List <UserCenter_Apps> appList)
{
var para = new { cityid = cityId, key = key };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.projectdropdownlist, para, appList);
IList <DATProject> list = new List <DATProject>();
if (!string.IsNullOrEmpty(result.data))
{
JArray _jarray = JArray.Parse(result.data);
foreach (JToken jt in _jarray)
{
JObject _jobject = (JObject)jt;
DATProject proj = new DATProject();
proj = _jobject.ToJSONjss().ParseJSONjss <DATProject>();
proj.BuildingNum = Convert.ToInt32(_jobject.Value <JValue>("buildingtotal").Value);
proj.TotalNum = Convert.ToInt32(_jobject.Value <JValue>("housetotal").Value);
list.Add(proj);
}
}
return(list);
}
public static DataCenterResult PostUserCenter_Login(string userName, string password)
{
//LogHelper.Info("Common.apiUrl_Login="******"yyyyMMddHHmmss");
string _password = GetCode(password, appKey_LoginPwd);
//string _password = EncryptHelper.GetMd5("Cmbfxtproduct*&2014");// GetCode(password, appKey_LoginPwd);
var para = new
{
sinfo = JsonHelp.ToJSONjss(new
{
time = nowTime,
code = Common.GetCode(nowTime, appKey_Login)
}),
info = JsonHelp.ToJSONjss(new
{
uinfo = new { username = userName, token = "", password = _password },
appinfo = new
{
splatype = "win",
platVer = "2007",
stype = "",//验证
version = "4.26",
vcode = "1",
systypecode = Common.systypeCode.ToString(),//验证
channel = "360"
},
funinfo = new { }
})
};
string test = para.ToJSONjss();
//LogHelper.Info("test=" + test);
HttpClient client = new HttpClient();
HttpResponseMessage hrm = client.PostAsJsonAsync(new Uri(Common.apiUrl_Login), para).Result;
//HttpResponseMessage hrm = client.PostAsJsonAsync(new Uri("http://192.168.0.7:9994/uc/active"), para).Result;
string str = hrm.Content.ReadAsStringAsync().Result;
//LogHelper.Info("str=" + str);
DataCenterResult result = Common.GetDataCenterResult(str);
return(result);
}
/// <summary>
/// 导入楼盘+楼栋+房号数据到运维中心
/// </summary>
/// <param name="project"></param>
/// <param name="lnkComList"></param>
/// <param name="lnkpaList"></param>
/// <param name="buildingList"></param>
/// <param name="houseList"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <param name="message"></param>
/// <returns></returns>
public static int ImportProjectData(Project project, ref List <Building> resultBuilding, string username, string signname, List <Apps> appList, out string message)
{
//string dataJson = project.ToJSONjss();
message = "";
int projectId = 0;
JObject jobj = new JObject();
PropertyInfo[] buildingPropertys = typeof(Building).GetProperties();
PropertyInfo[] housePropertys = typeof(HouseDetails).GetProperties();
//所有字段
var fields = project.Templet.FieldGroups.SelectMany(m => m.Fields).ToList();
if (fields != null && fields.Count > 0)
{
//获取实体属性
var propertys = project.GetType().GetProperties();
foreach (var field in fields)
{
var property = propertys.Where(pInfo => pInfo.Name == field.FieldName).FirstOrDefault();
if (property != null)
{
jobj.Add(new JProperty(field.FieldName.ToLower(), property.GetValue(project)));
}
}
//楼栋
JArray buildingArry = new JArray();
if (project.Buildings != null && project.Buildings.Count > 0)
{
foreach (Building building in project.Buildings)
{
//楼栋字段
var buildingFields = building.Templet.FieldGroups.SelectMany(m => m.Fields);
if (buildingFields != null && buildingFields.Count() > 0)
{
//楼栋字段取值
JObject buildingObj = new JObject();
foreach (var buildingField in buildingFields)
{
var property = buildingPropertys.Where(pInfo => pInfo.Name == buildingField.FieldName).FirstOrDefault();
if (property != null)
{
buildingObj.Add(new JProperty(buildingField.FieldName.ToLower(), property.GetValue(building)));
}
}
//房号
JArray houseArry = new JArray();
if (building.HouseDetails != null && building.HouseDetails.Count > 0)
{
foreach (var house in building.HouseDetails)
{
//房号字段
//var houseFields = house.Templet.FieldGroups.SelectMany(m => m.Fields);
//if (houseFields != null && houseFields.Count() > 0)
//{
//房号字段取值
JObject houseObj = new JObject();
//foreach (var houseField in houseFields)
//{
//var property = housePropertys.Where(pInfo => pInfo.Name == houseField.FieldName).FirstOrDefault();
//houseObj.Add(new JProperty(houseField.FieldName, property.GetValue(house)));
//}
foreach (var houseProperty in housePropertys)
{
if (houseProperty.Name == "Building" || houseProperty.Name == "House" || houseProperty.Name == "Id" || houseProperty.Name == "HouseId"
|| houseProperty.Name == "BuildingId" || houseProperty.Name == "CreateTime" || houseProperty.Name == "SaveDateTime")
{
continue;
}
houseObj.Add(new JProperty(houseProperty.Name.ToLower(), houseProperty.GetValue(house)));
}
houseArry.Add(houseObj);
//}
}
}
buildingObj.Add(new JProperty("houselist", houseArry));
buildingObj.Add(new JProperty("cityid", building.CityID));
buildingObj.Add(new JProperty("buildingid", building.BuildingId));
buildingObj.Add(new JProperty("fxtbuildingid", building.FxtBuildingId));
buildingObj.Add(new JProperty("fxtcompanyid", building.FxtCompanyId));
buildingObj.Add(new JProperty("saveuser", building.SaveUser));
//buildingObj.Add(new JProperty("savedatetime", building.SaveDateTime));
buildingObj.Add(new JProperty("creator", building.Creator));
//buildingObj.Add(new JProperty("createtime", building.CreateTime));
buildingArry.Add(buildingObj);
}
}
}
jobj.Add(new JProperty("buildinglist", buildingArry));
jobj.Add(new JProperty("cityid", project.CityID));
jobj.Add(new JProperty("fxtprojectid", project.FxtProjectId));
jobj.Add(new JProperty("fxtcompanyid", project.FxtCompanyId));
jobj.Add(new JProperty("saveuser", project.SaveUser));
//jobj.Add(new JProperty("savedatetime", project.SaveDateTime));
//jobj.Add(new JProperty("updatedatetime", project.UpdateDateTime));
jobj.Add(new JProperty("creator", project.Creator));
//jobj.Add(new JProperty("createtime", project.CreateTime));
}
#region (楼盘信息)
//jobj.Add(new JProperty("x", project.X));
//jobj.Add(new JProperty("y", project.Y));
//jobj.Add(new JProperty("projectname", project.ProjectName.TrimBlank().EncodeField()));
//jobj.Add(new JProperty("cityid", project.CityID));
//jobj.Add(new JProperty("areaid", project.AreaID));
//jobj.Add(new JProperty("address", project.Address.EncodeField()));
//jobj.Add(new JProperty("enddate", project.EndDate));
//jobj.Add(new JProperty("east", project.East.EncodeField()));
//jobj.Add(new JProperty("west", project.West.EncodeField()));
//jobj.Add(new JProperty("south", project.South.EncodeField()));
//jobj.Add(new JProperty("north", project.North.EncodeField()));
////jobj.Add(new JProperty("buildingarea", project.BuildingArea));
////jobj.Add(new JProperty("landarea", project.LandArea));
////jobj.Add(new JProperty("cubagerate", project.CubageRate));
////jobj.Add(new JProperty("greenrate", project.GreenRate));
////jobj.Add(new JProperty("managerprice", project.ManagerPrice.EncodeField()));
//jobj.Add(new JProperty("parkingnumber", project.ParkingNumber));
////jobj.Add(new JProperty("saledate", project.SaleDate));
////jobj.Add(new JProperty("buildingdate", project.BuildingDate));
//jobj.Add(new JProperty("detail", project.Detail.EncodeField()));
//jobj.Add(new JProperty("fxtprojectid", project.FxtProjectId));
//jobj.Add(new JProperty("fxtcompanyid", project.FxtCompanyId));
//jobj.Add(new JProperty("valid", 1));
//jobj.Add(new JProperty("othername", project.OtherName));
//jobj.Add(new JProperty("subareaid", project.SubAreaId));
//jobj.Add(new JProperty("purposecode", project.PurposeCode));
//jobj.Add(new JProperty("rightcode", project.RightCode));
//jobj.Add(new JProperty("buildingnum", project.BuildingNum));
//jobj.Add(new JProperty("totalnum", project.TotalNum));
//jobj.Add(new JProperty("managerquality", project.ManagerQuality));
////jobj.Add(new JProperty("parkingstatus", project.ParkingStatus));
//jobj.Add(new JProperty("creator", project.Creator));
//jobj.Add(new JProperty("updatedatetime", project.UpdateDateTime));
//jobj.Add(new JProperty("saveuser", project.SaveUser));
//jobj.Add(new JProperty("savedatetime", project.SaveDateTime));
#endregion
#region 楼盘关联公司
JArray companyArray = new JArray();
if (project.Companys != null)
{
var companys = project.Companys.Select(m => new
{
projectid = m.ProjectId,
companyname = m.CompanyName,
companytype = m.CompanyType,
cityid = m.CityId
});
companyArray = JArray.Parse(companys.ToJSONjss());
}
jobj.Add(new JProperty("companylist", companyArray));
//jobj.Add(new JProperty("companylist", JArray.Parse(Common.ConvertToJson(lnkComList))));
#endregion
#region 楼盘配套
JArray appendageArray = new JArray();
if (project.Appendages != null)
{
var appendages = project.Appendages.Select(m => new
{
address = m.Address,
appendagecode = m.AppendageCode,
area = m.Area,
cityid = m.CityId,
classcode = m.ClassCode,
distance = m.Distance,
id = m.Id,
isinner = m.IsInner,
p_aname = m.P_AName,
projectid = m.ProjectId,
uid = m.Uid,
x = m.X,
y = m.Y
});
appendageArray = JArray.Parse(appendages.ToJSONjss());
}
jobj.Add(new JProperty("appendage", appendageArray));
//jobj.Add(new JProperty("appendage", JArray.Parse(lnkpaList.ToJSONjss(false))));
#endregion
//楼栋+房号信息
//JArray buildingArry = new JArray();
//foreach (Building building in buildingList)
//{
// JObject buildingObj = new JObject();
// #region(楼栋信息)
// buildingObj.Add(new JProperty("buildingid", building.BuildingId));
// buildingObj.Add(new JProperty("buildingname", building.BuildingName.EncodeField()));
// //buildingObj.Add(new JProperty("doorplate", building.Doorplate.EncodeField()));
// buildingObj.Add(new JProperty("othername", building.OtherName.EncodeField()));
// buildingObj.Add(new JProperty("structurecode", building.StructureCode));
// buildingObj.Add(new JProperty("locationcode", building.LocationCode));
// //buildingObj.Add(new JProperty("averageprice", building.AveragePrice));
// buildingObj.Add(new JProperty("builddate", building.BuildDate));
// buildingObj.Add(new JProperty("iselevator", building.IsElevator));
// buildingObj.Add(new JProperty("elevatorrate", building.ElevatorRate.EncodeField()));
// //buildingObj.Add(new JProperty("pricedetail", building.PriceDetail.EncodeField()));
// buildingObj.Add(new JProperty("remark", building.Remark.EncodeField()));
// buildingObj.Add(new JProperty("fxtbuildingid", building.FxtBuildingId));
// //buildingObj.Add(new JProperty("sightcode", building.SightCode));
// buildingObj.Add(new JProperty("totalfloor", building.TotalFloor));
// buildingObj.Add(new JProperty("fxtcompanyid", building.FxtCompanyId));
// buildingObj.Add(new JProperty("cityid", building.CityID));
// buildingObj.Add(new JProperty("purposecode", building.PurposeCode));
// buildingObj.Add(new JProperty("maintenancecode", building.MaintenanceCode));
// buildingObj.Add(new JProperty("creator", building.Creator));
// buildingObj.Add(new JProperty("saveuser", building.SaveUser));
// buildingObj.Add(new JProperty("x", building.X));
// buildingObj.Add(new JProperty("y", building.Y));
// #endregion
// JArray houseArry = new JArray();
// #region (房号信息)
// List<HouseDetails> _houseList = houseList.Where(obj => obj.BuildingId == building.BuildingId).ToList();
// foreach (HouseDetails house in _houseList)
// {
// JObject houseObj = new JObject();
// houseObj.Add(new JProperty("fxtcompanyid", house.FxtCompanyId));
// houseObj.Add(new JProperty("cityid", house.CityID));
// houseObj.Add(new JProperty("unitno", (house.UnitNo + house.RoomNo).EncodeField()));
// houseObj.Add(new JProperty("floorno", house.FloorNo));
// //houseObj.Add(new JProperty("endfloorno", house.EndFloorNo));
// houseObj.Add(new JProperty("housename", house.HouseName.EncodeField()));
// houseObj.Add(new JProperty("frontcode", house.FrontCode));
// houseObj.Add(new JProperty("buildarea", house.BuildArea));
// houseObj.Add(new JProperty("housetypecode", house.HouseTypeCode));
// houseObj.Add(new JProperty("remark", house.Remark.EncodeField()));
// houseObj.Add(new JProperty("fxthouseid", house.FxtHouseId));
// houseObj.Add(new JProperty("sightcode", house.SightCode));
// houseObj.Add(new JProperty("purposecode", house.PurposeCode));
// houseObj.Add(new JProperty("vdcode", house.VDCode));
// houseObj.Add(new JProperty("structurecode", house.StructureCode));
// houseObj.Add(new JProperty("noisecode", house.NoiseCode));
// houseObj.Add(new JProperty("creator", house.Creator));
// houseObj.Add(new JProperty("saveuser", house.SaveUser));
// houseArry.Add(houseObj);
// }
// buildingObj.Add(new JProperty("houselist", houseArry));
// #endregion
// buildingArry.Add(buildingObj);
//}
//jobj.Add(new JProperty("buildinglist", buildingArry));
string dataJson = jobj.ToJSONjss();
var para = new { data = dataJson };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.importprojectdata, para, appList);
if (!string.IsNullOrEmpty(result.data))
{
JObject _jobj = JObject.Parse(result.data);
projectId = _jobj.Value <int>("projectid");
message = _jobj.Value <string>("message");
var buildingids = _jobj["buildingids"].ToString();
if (!buildingids.IsNullOrEmpty())
{
var buildingidList = JsonHelp.ParseJSONList <Building>(buildingids);
resultBuilding = buildingidList;
}
}
//projectId = project.ProjectId;
return(projectId);
}
/// <summary>
/// 导入楼盘+楼栋+房号数据到运维中心
/// </summary>
/// <param name="project"></param>
/// <param name="lnkComList"></param>
/// <param name="lnkpaList"></param>
/// <param name="buildingList"></param>
/// <param name="houseList"></param>
/// <param name="username"></param>
/// <param name="signname"></param>
/// <param name="appList"></param>
/// <param name="message"></param>
/// <returns></returns>
public static int ImportProjectData(Project project, List <PCompany> lnkComList, List <PAppendage> lnkpaList, List <Building> buildingList, ref List <Building> resultBuilding, List <HouseDetails> houseList, string username, string signname, List <UserCenter_Apps> appList, out string message)
{
message = "";
int projectId = 0;
JObject jobj = new JObject();
#region (楼盘信息)
jobj.Add(new JProperty("x", project.X));
jobj.Add(new JProperty("y", project.Y));
jobj.Add(new JProperty("projectname", project.ProjectName.TrimBlank().EncodeField()));
jobj.Add(new JProperty("cityid", project.CityID));
jobj.Add(new JProperty("areaid", project.AreaID));
jobj.Add(new JProperty("address", project.Address.EncodeField()));
jobj.Add(new JProperty("enddate", project.EndDate));
jobj.Add(new JProperty("east", project.East.EncodeField()));
jobj.Add(new JProperty("west", project.West.EncodeField()));
jobj.Add(new JProperty("south", project.South.EncodeField()));
jobj.Add(new JProperty("north", project.North.EncodeField()));
//jobj.Add(new JProperty("buildingarea", project.BuildingArea));
//jobj.Add(new JProperty("landarea", project.LandArea));
//jobj.Add(new JProperty("cubagerate", project.CubageRate));
//jobj.Add(new JProperty("greenrate", project.GreenRate));
//jobj.Add(new JProperty("managerprice", project.ManagerPrice.EncodeField()));
jobj.Add(new JProperty("parkingnumber", project.ParkingNumber));
//jobj.Add(new JProperty("saledate", project.SaleDate));
//jobj.Add(new JProperty("buildingdate", project.BuildingDate));
jobj.Add(new JProperty("detail", project.Detail.EncodeField()));
jobj.Add(new JProperty("fxtprojectid", project.FxtProjectId));
jobj.Add(new JProperty("fxtcompanyid", project.FxtCompanyId));
jobj.Add(new JProperty("valid", 1));
jobj.Add(new JProperty("othername", project.OtherName));
jobj.Add(new JProperty("subareaid", project.SubAreaId));
jobj.Add(new JProperty("purposecode", project.PurposeCode));
jobj.Add(new JProperty("rightcode", project.RightCode));
jobj.Add(new JProperty("buildingnum", project.BuildingNum));
jobj.Add(new JProperty("totalnum", project.TotalNum));
jobj.Add(new JProperty("managerquality", project.ManagerQuality));
//jobj.Add(new JProperty("parkingstatus", project.ParkingStatus));
jobj.Add(new JProperty("creator", project.Creator));
jobj.Add(new JProperty("updatedatetime", project.UpdateDateTime));
jobj.Add(new JProperty("saveuser", project.SaveUser));
jobj.Add(new JProperty("savedatetime", project.SaveDateTime));
#endregion
//楼盘关联公司
jobj.Add(new JProperty("companylist", JArray.Parse(Common.ConvertToJson(lnkComList))));
//楼盘配套
jobj.Add(new JProperty("appendage", JArray.Parse(lnkpaList.ToJSONjss())));
//楼栋+房号信息
JArray buildingArry = new JArray();
foreach (Building building in buildingList)
{
JObject buildingObj = new JObject();
#region (楼栋信息)
buildingObj.Add(new JProperty("buildingid", building.BuildingId));
buildingObj.Add(new JProperty("buildingname", building.BuildingName.EncodeField()));
//buildingObj.Add(new JProperty("doorplate", building.Doorplate.EncodeField()));
buildingObj.Add(new JProperty("othername", building.OtherName.EncodeField()));
buildingObj.Add(new JProperty("structurecode", building.StructureCode));
buildingObj.Add(new JProperty("locationcode", building.LocationCode));
//buildingObj.Add(new JProperty("averageprice", building.AveragePrice));
buildingObj.Add(new JProperty("builddate", building.BuildDate));
buildingObj.Add(new JProperty("iselevator", building.IsElevator));
buildingObj.Add(new JProperty("elevatorrate", building.ElevatorRate.EncodeField()));
//buildingObj.Add(new JProperty("pricedetail", building.PriceDetail.EncodeField()));
buildingObj.Add(new JProperty("remark", building.Remark.EncodeField()));
buildingObj.Add(new JProperty("fxtbuildingid", building.FxtBuildingId));
//buildingObj.Add(new JProperty("sightcode", building.SightCode));
buildingObj.Add(new JProperty("totalfloor", building.TotalFloor));
buildingObj.Add(new JProperty("fxtcompanyid", building.FxtCompanyId));
buildingObj.Add(new JProperty("cityid", building.CityID));
buildingObj.Add(new JProperty("purposecode", building.PurposeCode));
buildingObj.Add(new JProperty("maintenancecode", building.MaintenanceCode));
buildingObj.Add(new JProperty("creator", building.Creator));
buildingObj.Add(new JProperty("saveuser", building.SaveUser));
buildingObj.Add(new JProperty("x", building.X));
buildingObj.Add(new JProperty("y", building.Y));
#endregion
JArray houseArry = new JArray();
#region (房号信息)
List <HouseDetails> _houseList = houseList.Where(obj => obj.BuildingId == building.BuildingId).ToList();
foreach (HouseDetails house in _houseList)
{
JObject houseObj = new JObject();
houseObj.Add(new JProperty("fxtcompanyid", house.FxtCompanyId));
houseObj.Add(new JProperty("cityid", house.CityID));
houseObj.Add(new JProperty("unitno", (house.UnitNo + house.RoomNo).EncodeField()));
houseObj.Add(new JProperty("floorno", house.FloorNo));
//houseObj.Add(new JProperty("endfloorno", house.EndFloorNo));
houseObj.Add(new JProperty("housename", house.HouseName.EncodeField()));
houseObj.Add(new JProperty("frontcode", house.FrontCode));
houseObj.Add(new JProperty("buildarea", house.BuildArea));
houseObj.Add(new JProperty("housetypecode", house.HouseTypeCode));
houseObj.Add(new JProperty("remark", house.Remark.EncodeField()));
houseObj.Add(new JProperty("fxthouseid", house.FxtHouseId));
houseObj.Add(new JProperty("sightcode", house.SightCode));
houseObj.Add(new JProperty("purposecode", house.PurposeCode));
houseObj.Add(new JProperty("vdcode", house.VDCode));
houseObj.Add(new JProperty("structurecode", house.StructureCode));
houseObj.Add(new JProperty("noisecode", house.NoiseCode));
houseObj.Add(new JProperty("creator", house.Creator));
houseObj.Add(new JProperty("saveuser", house.SaveUser));
houseArry.Add(houseObj);
}
buildingObj.Add(new JProperty("houselist", houseArry));
#endregion
buildingArry.Add(buildingObj);
}
jobj.Add(new JProperty("buildinglist", buildingArry));
string dataJson = jobj.ToJSONjss();
var para = new { data = dataJson };
DataCenterResult result = Common.PostDataCenter(username, signname, Common.importprojectdata, para, appList);
if (!string.IsNullOrEmpty(result.data))
{
JObject _jobj = JObject.Parse(result.data);
projectId = _jobj.Value <int>("projectid");
message = _jobj.Value <string>("message");
var buildingids = _jobj["buildingids"].ToString();
if (!buildingids.IsNullOrEmpty())
{
var buildingidList = JsonHelp.ParseJSONList <Building>(buildingids);
resultBuilding = buildingidList;
}
}
return(projectId);
}
