/// <summary>
/// 修改[人员工作关系]数据到本地
/// </summary>
/// <param name="personJob"></param>
/// <returns></returns>
internal int Update_PersonJob(IDbConnection connection, IDbTransaction transaction, PersonJob personJob)
{
var update = connection.Update("PersonJob")
.Set("PK_Job", DbType.AnsiString, personJob.PK_Job)
.Set("PK_User", DbType.AnsiString, personJob.PK_User)
.Set("PK_Dept", DbType.AnsiString, personJob.PK_Dept)
.Set("PK_Org", DbType.AnsiString, personJob.PK_Org)
.Set("PK_Group", DbType.AnsiString, personJob.PK_Group)
.Where(WhereMySQL.Equal("NC_PK_Job", DbType.AnsiString, personJob.NC_PK_Job))
.Execute();
return update;
}
internal PersonJobInsert(IDbConnection _conn, PersonJob _entity)
{
this.Connection = _conn;
this.IsBeginTransaction = false;
this.entity = _entity;
}
/// <summary>
/// 新增[人员工作关系]数据到本地
/// </summary>
/// <param name="personJob"></param>
/// <returns></returns>
internal int Insert_PersonJob(IDbConnection connection, IDbTransaction transaction, PersonJob personJob)
{
var insert = connection.Insert("PersonJob")
.Field("PK_Job", DbType.AnsiString, personJob.PK_Job)
.Field("PK_User", DbType.AnsiString, personJob.PK_User)
.Field("PK_Dept", DbType.AnsiString, personJob.PK_Dept)
.Field("PK_Org", DbType.AnsiString, personJob.PK_Org)
.Field("PK_Group", DbType.AnsiString, personJob.PK_Group)
.Field("NC_PK_Job", DbType.AnsiString, personJob.NC_PK_Job)
.Execute();
return insert;
}