/// <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;
 }
Exemplo n.º 2
0
 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;
 }