Пример #1
0
        /// <summary>
        /// 根据ID获得一个实体
        /// </summary>
        /// <param name="id">id</param>
        /// <returns>实体</returns>
        public virtual MIS_PersonModel GetById(string id)
        {
            if (IsExist(id))
            {
                MIS_Person      entity = m_Rep.GetById(id);
                MIS_PersonModel model  = new MIS_PersonModel();
                model.Id         = entity.Id;
                model.Name       = entity.Name;
                model.Sex        = entity.Sex;
                model.Age        = entity.Age;
                model.IDCard     = entity.IDCard;
                model.Phone      = entity.Phone;
                model.Email      = entity.Email;
                model.Address    = entity.Address;
                model.CreateTime = entity.CreateTime;
                model.Region     = entity.Region;
                model.Category   = entity.Category;

                return(model);
            }
            else
            {
                return(null);
            }
        }
Пример #2
0
        public ActionResult Edit(string id)
        {
            ViewBag.perm = GetPermission();
            MIS_PersonModel entity = m_BLL.GetById(id);

            return(View(entity));
        }
Пример #3
0
        public ActionResult Details(string id)
        {
            ViewBag.perm = GetPermission();
            MIS_PersonModel model = m_BLL.GetById(id);

            return(View(model));
        }
Пример #4
0
        /// <summary>
        /// 修改一个实体
        /// </summary>
        /// <param name="errors">持久的错误信息</param>
        /// <param name="model">模型</param>
        /// <returns>是否成功</returns>
        public virtual bool Edit(ref ValidationErrors errors, MIS_PersonModel model)
        {
            try
            {
                MIS_Person entity = m_Rep.GetById(model.Id);
                if (entity == null)
                {
                    errors.add(Suggestion.Disable);
                    return(false);
                }
                entity.Id         = model.Id;
                entity.Name       = model.Name;
                entity.Sex        = model.Sex;
                entity.Age        = model.Age;
                entity.IDCard     = model.IDCard;
                entity.Phone      = model.Phone;
                entity.Email      = model.Email;
                entity.Address    = model.Address;
                entity.CreateTime = model.CreateTime;
                entity.Region     = model.Region;
                entity.Category   = model.Category;



                if (m_Rep.Edit(entity))
                {
                    return(true);
                }
                else
                {
                    errors.add(Suggestion.EditFail);
                    return(false);
                }
            }
            catch (Exception ex)
            {
                errors.add(ex.Message);
                ExceptionHandler.WriteException(ex);
                //ExceptionHander.WriteException(ex);
                return(false);
            }
        }
Пример #5
0
 public JsonResult Edit(MIS_PersonModel model)
 {
     if (model != null && ModelState.IsValid)
     {
         if (m_BLL.Edit(ref errors, model))
         {
             LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id, "成功", "修改", "MIS_Person");
             return(Json(JsonHandler.CreateMessage(1, Suggestion.EditSucceed)));
         }
         else
         {
             string ErrorCol = errors.Error;
             LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + "," + ErrorCol, "失败", "修改", "MIS_Person");
             return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail + ErrorCol)));
         }
     }
     else
     {
         return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail)));
     }
 }
Пример #6
0
 public bool CheckImportData(string fileName, List <MIS_PersonModel> personList, ref ValidationErrors errors)
 {
     try
     {
         var targetFile = new FileInfo(fileName);
         if (!targetFile.Exists)
         {
             errors.add("文件不存在");
             return(false);
         }
         var excelFile = new ExcelQueryFactory(fileName);
         //对应表头
         excelFile.AddMapping <MIS_PersonModel>(x => x.Name, "Name");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Sex, "Sex");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Age, "Age");
         excelFile.AddMapping <MIS_PersonModel>(x => x.IDCard, "IDCard");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Phone, "Phone");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Email, "Email");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Address, "Address");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Region, "Region");
         excelFile.AddMapping <MIS_PersonModel>(x => x.Category, "Category");
         //sheetName
         var excelContent = excelFile.Worksheet <MIS_PersonModel>(0);
         int rowIndex     = 1;
         //检查数据正确性
         foreach (var row in excelContent)
         {
             var errorMessage = new StringBuilder();
             var person       = new MIS_PersonModel();
             person.Id       = row.Id;
             person.Name     = row.Name;
             person.Sex      = row.Sex;
             person.Age      = row.Age;
             person.IDCard   = row.IDCard;
             person.Phone    = row.Phone;
             person.Email    = row.Email;
             person.Address  = row.Address;
             person.Region   = row.Region;
             person.Category = row.Category;
             if (string.IsNullOrEmpty(person.Name))
             {
                 errorMessage.Append("Name - 不能为空. ");
             }
             if (string.IsNullOrWhiteSpace(row.IDCard))
             {
                 errorMessage.Append("IDCard - 不能为空. ");
             }
             if (errorMessage.Length > 0)
             {
                 errors.add(string.Format("第{0}行发现错误:{1}{2}", rowIndex, errorMessage, "<br />"));
             }
             else
             {
                 personList.Add(person);
             }
             rowIndex++;
         }
         if (errors.Count() > 0)
         {
             return(false);
         }
         else
         {
             return(true);
         }
     }
     catch (Exception ex)
     {
         errors.add("数据表列名不合法");
         ExceptionHandler.WriteException(ex);
         return(false);
     }
 }