/// <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); }