Пример #1
0
        /// <summary>
        /// 手动执行同步运安数据库数据的操作
        /// </summary>
        private void btnMigration_Click(object sender, EventArgs e)
        {
            var bll = new PersonInfoBll();

            if (bll.Exists())
            {
                MessageBox.Show(@"人员信息已存在(:=");
            }
            else
            {
                OracleMigrationTask.ExecuteDataSynchronization();
            }
        }
Пример #2
0
        public JsonResult PersonEdit(PersonInfo person)
        {
            if (person == null)
            {
                return(Json(ErrorModel.InputError));
            }

            var personBll = new PersonInfoBll();
            // 验证工号重复性
            var condition = person.Id > 0
                ? $"WorkNo='{person.WorkNo}' AND Id<>{person.Id} AND IsDelete=0"
                : $"WorkNo='{person.WorkNo}' AND IsDelete=0";

            if (personBll.Exists(condition))
            {
                return(Json(ErrorModel.ExistSameItem));
            }

            // 获取姓名的简拼
            person.Spell      = PinyinHelper.GetInitials(person.Name).ToLower();
            person.UpdateTime = DateTime.Now;

            var dbUpdateType = person.Id > 0 ? DataUpdateType.Update : DataUpdateType.Insert;

            var success = false;

            if (person.Id > 0)
            {
                success = personBll.Update(person);
            }
            else
            {
                // 第一次录入时将密码设置为工号后四位
                var password = person.WorkNo.Substring(person.WorkNo.Length - 5);
                // person.Password = password.GetMd5();
                // @FrancisTan 修改于 2017-02-17
                // 目的是为了统一密码的生成,保证一致性
                person.Password = EncryptHelper.EncryptPassword(password);

                success = personBll.Insert(person).Id > 0;
            }

            if (success)
            {
                DataUpdateLog.SingleUpdate(typeof(PersonInfo).Name, (int)person.Id, dbUpdateType);

                return(Json(ErrorModel.OperateSuccess));
            }

            return(Json(ErrorModel.OperateFailed));
        }