public ActionResult SummitCarWorkItemImport(string CityId, string CountyId, string projectId, int isRename = 1)
{
projectId = "dd1bbf6b-bcea-4cad-851b-1be4adf71860";
string path = @"C:\Users\zps\Desktop\聚力环境测评系统样版\聚力环境测评系统样版\";
string fileName = "1班次作业明细.xls";
#region 导出
if (FileHelper.IsExistFile(Path.Combine(path, fileName)))
{
using (ExcelHelper exHelp = new ExcelHelper(Path.Combine(path, fileName)))
{
var datatable = exHelp.ExcelToDataTable(fileName, true);
ProfileSanitationCarWorkItemEntity[] models = new ProfileSanitationCarWorkItemEntity[datatable.Rows.Count];
ProfileSanitationCarWorkItemEntity model;
for (int i = 0; i < datatable.Rows.Count; i++)
{
try
{
var workShift = datatable.Rows[i]["作业班次"].ToString();
var xh = datatable.Rows[i]["序号"].ToString();
var workTime = datatable.Rows[i]["作业时间"].ToString();
var workName = datatable.Rows[i]["作业点名称"].ToString();
var workAddress = datatable.Rows[i]["作业点地址"].ToString();
var workNode = datatable.Rows[i]["备注"].ToString();
model = new ProfileSanitationCarWorkItemEntity()
{
Note = workNode,
WorkName = workName,
WorkAddress = workAddress,
WorkTime = workTime,
WorkShift = workShift,
Subscript = int.Parse(xh)
};
models[i] = model;
}
catch
{
}
}
var thapp = new ProfileAmenitiesConstructionSiteApp();
foreach (var item in models)
{
try
{
if (item == null)
{
continue;
}
App.SubmitWorkItemForm(item, string.Empty);
}
catch
{
}
}
}
}
#endregion
return(Success("ss"));
}
public ActionResult SummitImport(string CityId, string CountyId, string projectId, int isRename = 1)
{
projectId = "dd1bbf6b-bcea-4cad-851b-1be4adf71860";
string path = @"C:\Users\zps\Desktop\聚力环境测评系统样版\聚力环境测评系统样版\附件6、虹口市容点位\";
string fileName = "Book1.xlsx";
#region 导出
if (FileHelper.IsExistFile(Path.Combine(path, fileName)))
{
using (ExcelHelper exHelp = new ExcelHelper(Path.Combine(path, fileName)))
{
var datatable = exHelp.ExcelToDataTable(fileName, true);
//ProfileAmenitiesConstructionSiteEntiy
ProfileAmenitiesConstructionSiteEntity[] models = new ProfileAmenitiesConstructionSiteEntity[datatable.Rows.Count];
ProfileAmenitiesConstructionSiteEntity model;
for (int i = 0; i < datatable.Rows.Count; i++)
{
try
{
var jdName = datatable.Rows[i]["街道"].ToString();
var fCode = datatable.Rows[i]["序号"].ToString();
var address = datatable.Rows[i]["地址"].ToString();
var name = datatable.Rows[i]["工地名称"].ToString();
var StreetNamekey = StreetApp.GetDictionary(d => d.StreetName == jdName)[0].Key;
var streetModel = StreetApp.GetForm(StreetNamekey);
model = new ProfileAmenitiesConstructionSiteEntity()
{
CityId = streetModel.CityId,
CountyId = streetModel.CountyId,
StreetId = streetModel.F_Id,
Address = address,
F_EnCode = fCode,
SiteName = name,
ProjectId = projectId
};
models[i] = model;
}
catch
{
}
}
var thapp = new ProfileAmenitiesConstructionSiteApp();
foreach (var item in models)
{
try
{
if (item == null)
{
continue;
}
thapp.SubmitForm(item, string.Empty);
}
catch
{
}
}
}
}
#endregion
return(Success("ss"));
}
public ActionResult SummitCarImport(string CityId, string CountyId, string projectId, int isRename = 1)
{
projectId = "dd1bbf6b-bcea-4cad-851b-1be4adf71860";
string path = @"C:\Users\zps\Desktop\聚力环境测评系统样版\聚力环境测评系统样版\";
string fileName = "1车辆信息(1).xlsx";
ProfileOperationsCompanyApp companyApp = new ProfileOperationsCompanyApp();
#region 导出
if (FileHelper.IsExistFile(Path.Combine(path, fileName)))
{
using (ExcelHelper exHelp = new ExcelHelper(Path.Combine(path, fileName)))
{
var datatable = exHelp.ExcelToDataTable(fileName, true);
ProfileSanitationCarEntity[] models = new ProfileSanitationCarEntity[datatable.Rows.Count];
ProfileSanitationCarEntity model;
for (int i = 0; i < datatable.Rows.Count; i++)
{
try
{
var carTypeStr = datatable.Rows[i]["车辆类型"].ToString();
var carId = datatable.Rows[i]["车牌号"].ToString();
var f_EnCode = datatable.Rows[i]["自编号"].ToString();
var companyName = datatable.Rows[i]["作业公司"].ToString();
var workShift = datatable.Rows[i]["作业班次"].ToString();
int carTypeInt = 0;
string companyId = "";
if (carTypeStr == "机扫车")
{
carTypeInt = ProfileCarTypeEnum.MachineCleanCar.GetIntValue();
}
else if (carTypeStr == "冲洗车")
{
carTypeInt = ProfileCarTypeEnum.WashTheCar.GetIntValue();
}
companyId = companyApp.GetDictionary(d => d.CompanyName == companyName).FirstOrDefault().Key;
model = new ProfileSanitationCarEntity()
{
CarId = carId,
CarType = carTypeInt,
WorkShift = workShift,
CompanyId = companyId,
F_EnCode = f_EnCode
};
models[i] = model;
}
catch
{
}
}
var thapp = new ProfileAmenitiesConstructionSiteApp();
foreach (var item in models)
{
try
{
if (item == null)
{
continue;
}
App.SubmitForm(item, string.Empty);
}
catch
{
}
}
}
}
#endregion
return(Success("ss"));
}
