public ActionResult SubmitForm(ProfileSanitationCarEntity entity, int carType, string keyValue, string workItem)
{
entity.CarType = carType;
ProfileCarWorkItemContracts[] works = workItem.ToObject <ProfileCarWorkItemContracts[]>();
App.SubmitForm(entity, keyValue, works);
return(Success("操作成功!"));
}
public void SubmitForm(ProfileSanitationCarEntity entity, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
service.Update(entity);
}
else
{
entity.Create();
service.Insert(entity);
}
}
/// <summary>
/// 提交，修改
/// </summary>
/// <param name="tandasEntity"></param>
/// <param name="keyValue"></param>
public void SubmitForm(ProfileSanitationCarEntity entity, string keyValue, ProfileCarWorkItemContracts[] works)
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
}
else
{
entity.Create();
}
service.SubmitForm(entity, keyValue, works);
try
{
LogMess.addLog(DbLogType.Update.ToString(), "修改成功", "新建环卫车辆信息【" + entity.CarId + "】成功！");
}
catch
{
}
}
/// <summary>
/// 单条
/// 批量导入车辆信息
/// </summary>
/// <param name="entity"></param>
/// <param name="skipWhere"></param>
/// <param name="coverWhere"></param>
public void BatchCarSubmitFrom(ProfileSanitationCarEntity entity, Func <ProfileSanitationCarEntity, ProfileSanitationCarEntity, bool> skipWhere, Func <ProfileSanitationCarEntity, ProfileSanitationCarEntity, bool> coverWhere)
{
if (skipWhere != null)
{
Func <ProfileSanitationCarEntity, bool> dbSkipWhere = db => skipWhere(db, entity);
var dbSkipQuery = this.service.dbcontext.Set <ProfileSanitationCarEntity>().Where(dbSkipWhere);
if (dbSkipQuery.Count() > 0)
{
return;
}
}
if (coverWhere != null)
{
Func <ProfileSanitationCarEntity, bool> dbCoverWhere = db => coverWhere(db, entity);
var dbCoverQuery = this.service.dbcontext.Set <ProfileSanitationCarEntity>().Where(dbCoverWhere);
if (dbCoverQuery.Count() > 0)
{
var dbEntity = dbCoverQuery.FirstOrDefault();
dbEntity.CarId = entity.CarId;
dbEntity.CarType = entity.CarType;
dbEntity.CompanyId = entity.CompanyId;
dbEntity.F_EnCode = entity.F_EnCode;
dbEntity.WorkShift = entity.WorkShift;
dbEntity.Modify(dbEntity.F_Id);
this.service.Update(dbEntity);
return;
}
}
entity.Create();
this.service.Insert(entity);
}
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"));
}