/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, EvaluateDetailsEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception ex)
{
throw;
}
}
public string ImportEvaluateDetails(string keyValue, string EvaluatePlanId)
{
string orgId = OperatorProvider.Provider.Current().OrganizeId;//所属公司
int error = 0;
string message = "请选择格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
string orgid = OperatorProvider.Provider.Current().OrganizeId;
if (count > 0)
{
HttpPostedFileBase file = HttpContext.Request.Files[0];
if (string.IsNullOrEmpty(file.FileName))
{
return(message);
}
if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx")))
{
return(message);
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName));
DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName));
int order = 1;
if (dt.Rows.Count < 1)
{
falseMessage += string.Format(@"导入失败,请填写数据！</br>", order);
}
else
{
for (int i = 2; i < dt.Rows.Count; i++)
{
EvaluateDetailsEntity item = new EvaluateDetailsEntity();
order = i + 1;
item.MainId = keyValue;
item.EvaluatePlanId = EvaluatePlanId;
#region 大类
string categoryname = dt.Rows[i][1].ToString();
if (!string.IsNullOrEmpty(categoryname))
{
item.CategoryName = categoryname;
JObject queryJson = new JObject();
queryJson.Add(new JProperty("name", categoryname));
var data = StcategoryBLL.GetQueryEntity(queryJson.ToString());
if (data != null)
{
item.Category = data.ID;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,大类在系统中不存在！</br>", order);
error++;
continue;
}
}
//else
//{
// falseMessage += string.Format(@"第{0}行导入失败,类别不能为空！</br>", order);
// error++;
// continue;
//}
#endregion
#region 小类
string rankname = dt.Rows[i][2].ToString();
if (!string.IsNullOrEmpty(rankname))
{
item.RankName = rankname;
JObject queryJson = new JObject();
queryJson.Add(new JProperty("name", rankname));
queryJson.Add(new JProperty("parentid", item.Category));
var data = StcategoryBLL.GetQueryEntity(queryJson.ToString());
if (data != null)
{
item.Rank = data.ID;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,小类在系统中不存在或者不属于大类！</br>", order);
error++;
continue;
}
}
//else
//{
// falseMessage += string.Format(@"第{0}行导入失败,类别不能为空！</br>", order);
// error++;
// continue;
//}
#endregion
#region 文件名称
string filename = dt.Rows[i][3].ToString();
if (!string.IsNullOrEmpty(filename))
{
item.FileName = filename;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,文件编号及名称不能为空！</br>", order);
error++;
continue;
}
#endregion
#region 颁布部门
string dutydept = dt.Rows[i][4].ToString();
if (!string.IsNullOrEmpty(dutydept))
{
item.DutyDept = dutydept;
}
#endregion
#region 实施日期
string putdate = dt.Rows[i][5].ToString();
if (!string.IsNullOrEmpty(putdate))
{
try
{
item.PutDate = DateTime.Parse(DateTime.Parse(putdate).ToString("yyyy-MM-dd"));
}
catch
{
falseMessage += string.Format(@"第{0}行导入失败,实施日期不对！(正确示例：2019-01-01)</br>", order);
error++;
continue;
}
}
#endregion
#region 纳入企业标准的名称
string normname = dt.Rows[i][6].ToString();
if (!string.IsNullOrEmpty(normname))
{
item.NormName = normname;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,纳入企业标准的名称不能为空！</br>", order);
error++;
continue;
}
#endregion
#region 适用条款
string clause = dt.Rows[i][7].ToString();
if (!string.IsNullOrEmpty(clause))
{
item.Clause = clause;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,适用条款不能为空！</br>", order);
error++;
continue;
}
#endregion
#region 适用范围
string applyscope = dt.Rows[i][8].ToString();
if (!string.IsNullOrEmpty(applyscope))
{
item.ApplyScope = applyscope;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,适用范围不能为空！</br>", order);
error++;
continue;
}
#endregion
#region 符合性
string isconform = dt.Rows[i][9].ToString();
if (!string.IsNullOrEmpty(isconform))
{
if (isconform == "符合")
{
item.IsConform = 0;
}
else if (isconform == "不符合")
{
item.IsConform = 1;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,符合性不存在！</br>", order);
error++;
continue;
}
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,符合性不能为空！</br>", order);
error++;
continue;
}
#endregion
#region 现状符合性
string describe = dt.Rows[i][10].ToString();
if (!string.IsNullOrEmpty(describe))
{
item.Describe = describe;
}
#endregion
#region 整改意见
string opinion = dt.Rows[i][11].ToString();
if (!string.IsNullOrEmpty(opinion))
{
if (item.IsConform == 1)
{
item.Opinion = opinion;
}
else
{
item.Opinion = null;
}
}
else
{
if (item.IsConform == 1)
{
falseMessage += string.Format(@"第{0}行导入失败,整改意见不能为空！</br>", order);
error++;
continue;
}
}
#endregion
#region 整改计划完成时间
string FinishTime = dt.Rows[i][12].ToString();
DateTime tempFinishTime;
if (!string.IsNullOrEmpty(FinishTime))
{
if (item.IsConform == 1)
{
try
{
item.FinishTime = DateTime.Parse(DateTime.Parse(FinishTime).ToString("yyyy-MM-dd"));
}
catch
{
falseMessage += string.Format(@"第{0}行导入失败,整改截止时间不对！(正确示例：2019-01-01)</br>", order);
error++;
continue;
}
//if (DateTime.TryParse(FinishTime, out tempFinishTime))
// item.FinishTime = tempFinishTime;
//else
//{
// falseMessage += string.Format(@"第{0}行导入失败,整改计划完成时间不对！</br>", order);
// error++;
// continue;
//}
}
else
{
item.FinishTime = null;
}
}
else
{
if (item.IsConform == 1)
{
falseMessage += string.Format(@"第{0}行导入失败,整改计划完成时间不能为空！</br>", order);
error++;
continue;
}
}
#endregion
//评价人
//string evaluateperson = dt.Rows[i][13].ToString();
//if (!string.IsNullOrEmpty(evaluateperson))
//{
// item.EvaluatePerson = evaluateperson;
//}
#region 评价人
string evaluateperson = dt.Rows[i][13].ToString();
if (!string.IsNullOrEmpty(evaluateperson))
{
var userEntity = userBLL.GetListForCon(x => x.RealName == evaluateperson && x.OrganizeId == orgid).FirstOrDefault();
if (userEntity != null)
{
item.EvaluatePersonId = userEntity.UserId;
item.EvaluatePerson = evaluateperson;
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,评价人不存在！</br>", order);
error++;
continue;
}
}
else
{
falseMessage += string.Format(@"第{0}行导入失败,评价人不能为空！</br>", order);
error++;
continue;
}
#endregion
try
{
evaluatedetailsbll.SaveForm("", item);
}
catch
{
error++;
}
}
}
count = dt.Rows.Count;
message = "共有" + (count - 2) + "条记录,成功导入" + ((count - 2) - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
public ActionResult SaveForm(string keyValue, EvaluateDetailsEntity entity)
{
evaluatedetailsbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
