public IActionResult AddOrganInfo(OrgPersonDto model)
{
var resModel = new ResponseModel(ResponseCode.Error, "操作失败");
try
{
var verifmsg = "";
if (!CheckAccountNum(model.账户, model.账户id))
{
verifmsg = "登录帐号重复";
}
if (!model.身份证号.IsNullOrEmpty())
{
//查询身份证在该机构是否存在
//判断新增，修改
var exist = false;
if (model.id == 0)
{
exist = this.Query <OrgPerson>().Where("身份证号", model.身份证号).Where("机构id", model.机构id).Exists();
}
else
{
//查询该机构下不包含修改id的身份证出现过几次
var personlist = this.Query <OrgPerson>().Where("身份证号", model.身份证号).Where("机构id", model.机构id).GetModelList();
exist = personlist == null ? false : personlist.Where(d => d.id != model.id).Any();
}
if (exist)
{
verifmsg = verifmsg.IsNullOrEmpty() ? "身份证号已存在" : verifmsg += ",身份证号已存在";
}
}
if (!verifmsg.IsNullOrEmpty())
{
resModel.code = (int)ResponseCode.Error;
resModel.msg = verifmsg;
return(Json(resModel));
}
//实例化机构接口
var org = this.GetInstance <IOrgPerson>();
var data = org.EditPerson(model);
if (data.Result.code == ResponseCode.Success.ToInt32())
{
resModel.code = (int)ResponseCode.Success;
resModel.msg = "操作成功";
}
}
catch (Exception ex)
{
LogError("新增或修改机构", ex);
resModel.msg = "操作异常";
}
return(Json(resModel));
}
/// <summary>
/// 根据id获取机构人员信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public OrgPersonDto GetOrgPersonDtoInfo(int id)
{
OrgPersonDto item = null;
try
{
var param = new List <string>();
using (var db = new DbContext())
{
//根据编码查询行政区划
var sqlStr = db.GetSql("CA00005-查询机构人员账户信息", null, null);
ISqlBuilder sqlBuilder = db.Sql(sqlStr).Parameters("id", id);
//执行SQL脚本
item = sqlBuilder.GetModel <OrgPersonDto>();
}
}
catch (Exception ex)
{
Logger.Instance.Error("获取机构人员信息异常!", ex);
}
return(item);
}
/// <summary>
/// 新增或修改机构人员信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <ResponseModel> EditPerson(OrgPersonDto model)
{
return(Task.FromResult(this.Logic.EditPerson(model)));
}
/// <summary>
/// 新增或修改机构人员信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ResponseModel EditPerson(OrgPersonDto model)
{
//提示信息
var result = new ResponseModel(ResponseCode.Success, "保存机构人员信息成功!");
try
{
using (var db = new DbContext())
{
//查询机构人员下一个序列
var sqlStr = db.GetSql("CA00006-查询机构人员下一个序列", null, null);
ISqlBuilder sqlBuilder = db.Sql(sqlStr);
int item = 0;
//执行SQL脚本
if (sqlBuilder.Select().Rows[0][0] != null)
{
item = Convert.ToInt32((sqlBuilder.Select().Rows[0][0]));
}
//重置简码
model.简码 = Basics.Utils.Strings.GetFirstPY(model.姓名.Trim());
//机构人员
OrgPerson person = new OrgPerson();
person.出生日期 = model.出生日期;
person.姓名 = model.姓名;
person.学历 = model.学历;
person.性别 = model.性别;
person.手机 = model.手机;
person.擅长 = model.擅长;
person.机构id = model.机构id;
person.民族 = model.民族;
person.状态 = model.状态;
person.电话 = model.电话;
person.简介 = model.简介;
person.简码 = model.简码;
person.职务 = model.职务;
person.身份证号 = model.身份证号;
person.邮箱 = model.邮箱;
//账户
Account account = new Account();
account.姓名 = model.姓名;
account.账户 = model.账户;
account.状态 = model.状态;
if (!model.密码.IsNullOrEmpty())
{
account.密码 = Strings.StrToMD5(model.密码);
}
var value = db.DelegateTrans <bool>(() =>
{
var count = 0;
if (model.id == 0)
{
//将下一个序列赋值给机构人员id
person.id = item;
//新增默认给状态赋值为启用
person.状态 = 1;
account.状态 = 1;
//新增机构人员
count = db.Insert <OrgPerson>(person).Execute();
if (count <= 0)
{
db.Rollback();
return(false);
}
////新增账户
account.人员id = item;
//保存账户
count = db.Insert <Account>(account).Execute();
if (count <= 0)
{
db.Rollback();
return(false);
}
}
else
{
person.id = model.id;
//修改机构人员
count = db.Update <OrgPerson>(person).Where("id", person.id).Execute();
if (count <= 0)
{
db.Rollback();
return(false);
}
//修改账户
account.人员id = model.id;
account.id = model.账户id;
count = db.Update <Account>(account).Execute();
if (count <= 0)
{
db.Rollback();
return(false);
}
}
return(true);
});
if (!value)
{
result.code = ResponseCode.Error.ToInt32();
result.msg = "保存机构人员信息失败!";
}
}
}
catch (Exception ex)
{
result.code = ResponseCode.Error.ToInt32();
result.msg = "保存机构人员信息失败!";
}
return(result);
}
