/// <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; }