/// <summary> /// 更新入库失败案例的楼盘名称 /// </summary> /// <param name="projectName"></param> /// <param name="cityId"></param> /// <param name="projectId"></param> /// <param name="areaId">无行政区时则传0</param> /// <param name="_dc"></param> /// <returns></returns> public static bool UpdateImportFailCaseProjectBy(string projectName, int cityId, long projectId, long areaId, out string message, DataClass _dc = null) { message = ""; if (string.IsNullOrEmpty(projectName)) { return(true); } DataClass dc = new DataClass(_dc); try { string sql = " update 案例信息 set ProjectId={0} , 楼盘名=null where 城市ID={1} and ProjectId={2} and {3} and 是否已进行入库整理=1 and fxtId is null "; SysData_Project project = ProjectManager.GetProjectByProjectNameAndCityId(projectName, cityId, _db: dc); if (project == null) { project = ProjectManager.InsertProject(projectName, cityId, 0, _db: dc); } if (areaId > 0) { sql = string.Format(sql, project.ID, cityId, projectId, "AreaId=" + areaId); } else { sql = string.Format(sql, project.ID, cityId, projectId, "(AreaId is null or AreaId=0)"); } int count = dc.DB.ExecuteCommand(sql); ProjectCaseCountManager.UpdateNotImportCaseCount(projectId, areaId, -count, _db: dc); ProjectCaseCountManager.UpdateNotImportCaseCount(project.ID, areaId, count, _db: dc); } catch (Exception ex) { message = "更新入库失败案例楼盘名称_系统异常"; log.Error("UpdateImportFailCaseProjectBy异常", ex); dc.Connection_Close(); dc.Dispose(); return(false); } dc.Connection_Close(); dc.Dispose(); return(true); }
/// <summary> /// 设置案例楼盘ID,行政区ID,片区ID /// </summary> /// <param name="_list"></param> /// <param name="_dc"></param> /// <returns></returns> public static List <VIEW_案例信息_城市表_网站表> SetProjectId(List <VIEW_案例信息_城市表_网站表> _list, DataClass _dc = null) { if (_list != null && _list.Count > 0) { List <long> longs = new List <long>(); _list.ForEach(delegate(VIEW_案例信息_城市表_网站表 obj) { if ((!string.IsNullOrEmpty(obj.楼盘名.TrimBlank()) && obj.ProjectId == null) || (!string.IsNullOrEmpty(obj.行政区.TrimBlank()) && obj.AreaId == null) || !string.IsNullOrEmpty(obj.片区.TrimBlank()) && obj.SubAreaId == null) { longs.Add(obj.ID); } }); if (longs != null && longs.Count > 0) { DataClass dc = new DataClass(_dc); List <案例信息> list = dc.DB.案例信息.Where(p => longs.Contains(p.ID)).ToList(); list.ForEach(delegate(案例信息 obj) { if (!string.IsNullOrEmpty(obj.楼盘名.TrimBlank()) && obj.ProjectId == null) { SysData_Project project = ProjectManager.GetProjectByProjectNameAndCityId(obj.楼盘名.TrimBlank(), obj.城市ID, _db: dc); if (project == null) { project = ProjectManager.InsertProject(obj.楼盘名, obj.城市ID, Convert.ToInt32(obj.网站ID), _db: dc); } obj.ProjectId = project.ID; obj.楼盘名 = null; } if (!string.IsNullOrEmpty(obj.行政区.TrimBlank()) && obj.AreaId == null) { SysData_Area areaObj = AreaManager.GetAreaByAreaNameLikeByCityId(obj.行政区, obj.城市ID, _db: dc); if (areaObj == null) { areaObj = AreaManager.InsertArea(obj.行政区, obj.城市ID, Convert.ToInt32(obj.网站ID), _db: dc); } obj.AreaId = areaObj.ID; obj.行政区 = null; } else if (string.IsNullOrEmpty(obj.行政区.TrimBlank()) && obj.AreaId == null) { obj.AreaId = 0; obj.行政区 = null; } if (!string.IsNullOrEmpty(obj.片区.TrimBlank()) && obj.SubAreaId == null) { SysData_SubArea subAreaObj = SubAreaManager.GetAreaByAreaNameByCityId(obj.片区, obj.城市ID, _db: dc); if (subAreaObj == null) { subAreaObj = SubAreaManager.InsertArea(obj.片区, obj.城市ID, Convert.ToInt32(obj.网站ID), _db: dc); } obj.SubAreaId = subAreaObj.ID; obj.片区 = null; } VIEW_案例信息_城市表_网站表 vObj = _list.Where(p => p.ID == obj.ID).FirstOrDefault(); if (vObj != null) { vObj.ProjectId = obj.ProjectId; vObj.楼盘名 = obj.楼盘名; vObj.AreaId = obj.AreaId; vObj.行政区 = obj.行政区; vObj.SubAreaId = obj.SubAreaId; vObj.片区 = obj.片区; } }); dc.DB.SubmitChanges(); dc.Connection_Close(); dc.Dispose(); } } return(_list); }