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
}
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));
}
}
}
void Start()
{
map = GameObject.Find("Generated_map").GetComponent <Map> ();
canBuild = true;
city = GameObject.FindGameObjectWithTag("City").GetComponent <CityManagement> ();
}
