/// <summary>
/// 新增人员
/// </summary>
//[AbpAuthorize(PermissionNames.InfEmployer_CreateInfEmployer)]
public async Task <int> CreateInfEmployer(InfEmployerEditDto input)
{
try {
//TODO:新增前的逻辑判断，是否允许新增
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into inf_employer(");
strSql.Append("Id,Name,BirthDate,Duty,Education,Contact,StationId,IsDeleted,CreationTime,CreatorUserId)");
strSql.Append(" values (");
strSql.Append("@Id,@Name,@BirthDate,@Duty,@Education,@Contact,@StationId,@IsDeleted,@CreationTime,@CreatorUserId)");
using (var conn = DBUtility.GetMySqlConnection())
{
input.Id = Guid.NewGuid();
input.CreatorUserId = AbpSession.UserId;
return(await conn.ExecuteAsync(strSql.ToString(), input));
}
}
catch (Exception ex) {
throw ex;
}
}
/// <summary>
/// 更新人员
/// </summary>
//[AbpAuthorize(PermissionNames.InfEmployer_UpdateInfEmployer)]
public async Task <int> UpdateInfEmployer(InfEmployerEditDto input)
{
//TODO:更新前的逻辑判断，是否允许更新
StringBuilder strSql = new StringBuilder();
strSql.Append("update inf_employer set ");
strSql.Append("Name=@Name,");
strSql.Append("BirthDate=@BirthDate,");
strSql.Append("Duty=@Duty,");
strSql.Append("Education=@Education,");
strSql.Append("Contact=@Contact,");
strSql.Append("StationId=@StationId,");
strSql.Append("LastModificationTime=@LastModificationTime,");
strSql.Append("LastModifierUserId=@LastModifierUserId");
strSql.Append(" where Id=@Id ");
using (var conn = DBUtility.GetMySqlConnection())
{
input.LastModifierUserId = AbpSession.UserId;
return(await conn.ExecuteAsync(strSql.ToString(), input));
}
}
