/// <summary> /// 手动执行同步运安数据库数据的操作 /// </summary> private void btnMigration_Click(object sender, EventArgs e) { var bll = new PersonInfoBll(); if (bll.Exists()) { MessageBox.Show(@"人员信息已存在(:="); } else { OracleMigrationTask.ExecuteDataSynchronization(); } }
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)); }