/// <summary>
/// 导入数据
/// </summary>
/// <returns></returns>
public ActionResult ExcelImport()
{
JsonObject json = new JsonObject();
HttpPostedFileBase file = Request.Files["fileImport"];
if (file == null || file.ContentLength <= 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "文件不能为空";
return(Json(json));
}
string[] FileType = new string[] { ".xls", ".xlsx" }; //定义上传文件的类型
string filename = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名
string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename); //获取无扩展名的文件名
if (!fileEx.Contains(fileEx.ToLower()))
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "文件类型不对，只能导入xls和xlsx格式的文件";
return(Json(json));
}
DataTable dt = ExcelHelper.ReadExcelToDataTable(Server.MapPath("~/"), file, fileEx.ToLower());
//查询和模板页列是否相同
DataTable dtTemplate = NOPI_ExcelHelp.ImportDataTableFromExcel2007(Server.MapPath("~/") + @"\Excel\Template\销售健康度模板.xlsx");
json = new Excel.HealthXsExcel().Import(dt, dtTemplate);
return(Json(json));
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
public ActionResult Save(Model.Health_Xs model)
{
JsonObject json = new JsonObject();
StringBuilder sbErro = new StringBuilder();
if (string.IsNullOrEmpty(model.区域))
{
sbErro.Append(",区域不能为空");
}
else
{
Model.Area modelParmExist = new BLL.Area().GetModel(model.区域);
if (modelParmExist == null)
{
sbErro.Append(",区域不存在");
}
}
if (string.IsNullOrEmpty(model.客户名称))
{
sbErro.Append(",客户名称不能为空");
}
else
{
Model.Customer modelParmExist = new BLL.Customer().GetModel(model.客户名称);
if (modelParmExist == null)
{
sbErro.Append(",客户名称不存在");
}
}
if (string.IsNullOrEmpty(model.站点编码))
{
sbErro.Append(",站点编码不能为空");
}
if (string.IsNullOrEmpty(model.站点名称))
{
sbErro.Append(",站点名称不能为空");
}
if (sbErro.Length > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = sbErro.ToString().Substring(1);
return(Json(json));
}
//初始化自动生成值
Excel.HealthXsExcel healthXsExcel = new Excel.HealthXsExcel();
model.伟通收入不含税 = 0;
model.累计应收金额 = 0;
healthXsExcel.Get伟通收入不含税(model);
healthXsExcel.Get累计应收金额(model);
//如果ID为空，则是添加
if (string.IsNullOrEmpty(model.id))
{
List <Model.Health_Xs> modelExistsList = BLL.GetModelList("站点编码='" + model.站点编码 + "' and IsDeleted!=1");
if (modelExistsList != null && modelExistsList.Count > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败,此数据已存在";
return(Json(json));
}
model.IsDeleted = 0;
model.CreateTime = DateTime.Now;
model.CreateBy = CurrentUser.User.Userinfo.UserID;
model.id = Guid.NewGuid().ToString();
bool res = BLL.Add(model);
if (res)
{
json.Status = JsonObject.STATUS_SUCCESS;
json.Message = "添加成功";
return(Json(json));
}
else
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败";
return(Json(json));
}
}
else
{
List <Model.Health_Xs> modelExistsList = BLL.GetModelList("站点编码='" + model.站点编码 + "' and id!='" + model.id + "' and IsDeleted!=1");
if (modelExistsList != null && modelExistsList.Count > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败,此数据已存在";
return(Json(json));
}
Model.Health_Xs modelOld = BLL.GetModel(model.id);
if (modelOld == null)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据不存在";
return(Json(json));
}
if (modelOld.IsDeleted == 1)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "修改失败，数据已删除";
return(Json(json));
}
model.IsDeleted = modelOld.IsDeleted;
model.CreateBy = modelOld.CreateBy;
model.CreateTime = modelOld.CreateTime;
model.UpdateTime = DateTime.Now;
model.UpdateBy = CurrentUser.User.Userinfo.UserID;
bool res = BLL.Update(model);
if (res)
{
json.Status = JsonObject.STATUS_SUCCESS;
json.Message = "修改成功";
return(Json(json));
}
else
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "修改失败";
return(Json(json));
}
}
}