Пример #1
0
 void Start()
 {
     techCanvas.gameObject.SetActive(false);
     toggle = GetComponent <Toggle> ();
     city   = GameObject.FindGameObjectWithTag("City").GetComponent <CityManagement> ();
     #region Shuting down toggles
     #region Tier 0
     AlarianEcology.enabled  = false;
     Habitation.enabled      = false;
     PlanetarySurvey.enabled = false;
     #endregion
     #region Tier 1
     #region Tier 1 Biology
     AlienBiology.enabled = false;
     Biogenetics.enabled  = false;
     Prosthetics.enabled  = false;
     SocialPhych.enabled  = false;
     #endregion
     #region Tier 1 Engineering
     MineralProcessing.enabled    = false;
     CommunicationNetwork.enabled = false;
     ConstructorCrews.enabled     = false;
     PoweredExoskeletons.enabled  = false;
     #endregion
     #region Tier 1 Physics
     CleanEnergy.enabled    = false;
     Computers.enabled      = false;
     AppliedPhysics.enabled = false;
     Geophysics.enabled     = false;
     #endregion
     #endregion
     #region Tier 2
     #region Tier 2 Biology
     AlienDomestication.enabled = false;
     Bioengineering.enabled     = false;
     Augmentation.enabled       = false;
     Technocracy.enabled        = false;
     #endregion
     #region Tier 2 Engineering
     IndustrialBase.enabled = false;
     Pioneering.enabled     = false;
     Robotics.enabled       = false;
     Vehicles.enabled       = false;
     #endregion
     #region Tier 2 Physics
     DatabankUplinks.enabled = false;
     PowerGrids.enabled      = false;
     IonThrusters.enabled    = false;
     Nanotechnology.enabled  = false;
     #endregion
     #endregion
     #endregion
 }
Пример #2
0
        private List <SelectListItem> getCityDropDownData()
        {
            CityManagement cityManagement = new CityManagement();

            var query = from city in cityManagement.GetAllCity()
                        select new SelectListItem
            {
                Value = city.City_ID.ToString(),
                Text  = city.City_Name
            };

            return(query.ToList());
        }
        public IActionResult CityManagementImport(IFormFile excelfile)
        {
            var response = ResponseModelFactory.CreateInstance;

            using (_dbContext)
            {
                DateTime beginTime = DateTime.Now;

                string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportSocialGovernExcel";


                //var schoolinfo = _dbContext.SchoolInforManagement.AsQueryable();
                string   uploadtitle = "城管执法信息导入" + DateTime.Now.ToString("yyyyMMddHHmmss");
                string   sFileName   = $"{uploadtitle}.xlsx";
                FileInfo file        = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
                //string conStr = ConnectionStrings.DefaultConnection;
                string responsemsgsuccess = "";
                string responsemsgrepeat  = "";
                string responsemsgdefault = "";
                int    successcount       = 0;
                int    repeatcount        = 0;
                int    defaultcount       = 0;
                //string today = DateTime.Now.ToString("yyyy-MM-dd");
                try
                {
                    //把excelfile中的数据复制到file中
                    using (FileStream fs = new FileStream(file.ToString(), FileMode.Create)) //初始化一个指定路径和创建模式的FileStream
                    {
                        excelfile.CopyTo(fs);
                        fs.Flush();  //清空stream的缓存,并且把缓存中的数据输出到file
                    }
                    DataTable dt = Haikan3.Utils.ExcelTools.ExcelToDataTable(file.ToString(), "Sheet1", true);

                    if (dt == null || dt.Rows.Count == 0)
                    {
                        response.SetFailed("表格无数据");
                        return(Ok(response));
                    }
                    else
                    {
                        if (!dt.Columns.Contains("事件"))
                        {
                            response.SetFailed("无‘事件’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("时间"))
                        {
                            response.SetFailed("无‘时间’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("地址"))
                        {
                            response.SetFailed("无‘地址’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("处理人"))
                        {
                            response.SetFailed("无‘处理人’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("被处理人"))
                        {
                            response.SetFailed("无‘被处理人’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("执法人"))
                        {
                            response.SetFailed("无‘执法人’列");
                            return(Ok(response));
                        }
                        if (!dt.Columns.Contains("处理情况"))
                        {
                            response.SetFailed("无‘处理情况’列");
                            return(Ok(response));
                        }


                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            var entity = new CityManagement();
                            entity.CityManagementUuid = Guid.NewGuid();
                            if (!string.IsNullOrEmpty(dt.Rows[i]["事件"].ToString()))
                            {
                                entity.Incident = dt.Rows[i]["事件"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行事件为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }
                            if (!string.IsNullOrEmpty(dt.Rows[i]["时间"].ToString()))
                            {
                                entity.ZhifaTime = dt.Rows[i]["时间"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行时间为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }
                            if (!string.IsNullOrEmpty(dt.Rows[i]["地址"].ToString()))
                            {
                                entity.ZhifaAddress = dt.Rows[i]["地址"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行地址为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }
                            if (!string.IsNullOrEmpty(dt.Rows[i]["处理人"].ToString()))
                            {
                                entity.Chuliren = dt.Rows[i]["处理人"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行处理人为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }
                            if (!string.IsNullOrEmpty(dt.Rows[i]["被处理人"].ToString()))
                            {
                                entity.BeiChulirren = dt.Rows[i]["被处理人"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行被处理人为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }
                            if (!string.IsNullOrEmpty(dt.Rows[i]["执法人"].ToString()))
                            {
                                entity.ZhifaRen = dt.Rows[i]["执法人"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行执法人为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }

                            if (!string.IsNullOrEmpty(dt.Rows[i]["处理情况"].ToString()))
                            {
                                entity.ChuliQingk = dt.Rows[i]["处理情况"].ToString();
                            }
                            else
                            {
                                responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行处理情况为空" + "</p></br>";
                                defaultcount++;
                                continue;
                            }

                            entity.IsDeleted = 0;
                            entity.AddTime   = DateTime.Now.ToString("yyyy-MM-dd");
                            entity.AddPeople = AuthContextService.CurrentUser.DisplayName;

                            _dbContext.CityManagement.Add(entity);
                            _dbContext.SaveChanges();
                            successcount++;
                        }
                    }
                    responsemsgsuccess = "<p style='color:green'>导入成功:" + successcount + "条</p></br>" + responsemsgsuccess;
                    responsemsgrepeat  = "<p style='color:orange'>重复需手动修改数据:" + repeatcount + "条</p></br>" + responsemsgrepeat;
                    responsemsgdefault = "<p style='color:red'>导入失败:" + defaultcount + "条</p></br>" + responsemsgdefault;

                    ToLog.AddLog("导入", "成功:导入:城管执法记录信息数据", _dbContext);
                    //DateTime endTime = DateTime.Now;
                    //TimeSpan useTime = endTime - beginTime;
                    //string taketime = "导入时间" + useTime.TotalSeconds.ToString() + "秒  ";
                    response.SetData(JsonConvert.DeserializeObject(JsonConvert.SerializeObject(new
                    {
                        //time = taketime,
                        successmsg = responsemsgsuccess
                        ,
                        repeatmsg  = responsemsgrepeat,
                        defaultmsg = responsemsgdefault
                    })));
                    return(Ok(response));
                }
                catch (Exception ex)
                {
                    response.SetFailed(ex.Message);
                    return(Ok(response));
                }
            }
        }
Пример #4
0
 void Start()
 {
     map      = GameObject.Find("Generated_map").GetComponent <Map> ();
     canBuild = true;
     city     = GameObject.FindGameObjectWithTag("City").GetComponent <CityManagement> ();
 }