/// <summary> /// 修改[人员]数据到本地 /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <param name="person"></param> /// <returns></returns> internal int Update_PersonCore(IDbConnection connection, IDbTransaction transaction, PersonCore person) { var update = connection.Update("PersonCore") .Set("PK_User", DbType.AnsiString, person.PK_User) .Set("Code", DbType.AnsiString, person.Code) .Set("Name", DbType.AnsiString, person.Name) .Set("ShortName", DbType.AnsiString, person.ShortName) .Set("IDCardNumber", DbType.AnsiString, person.IDCardNumber) .Set("Sex", DbType.Int32, person.Sex) .Set("Age", DbType.Int32, person.Age) .Set("Email", DbType.AnsiString, person.Email) .Set("Mobile", DbType.AnsiString, person.Mobile) .Set("Birthdate", DbType.AnsiString, person.Birthdate) .Set("JoinWorkDate", DbType.AnsiString, person.JoinWorkDate) .Set("Censusaddr", DbType.AnsiString, person.Censusaddr) .Set("T_Updater", DbType.AnsiString, person.T_Updater) .Set("T_UpdaterName", DbType.AnsiString, person.T_UpdaterName) .Set("T_UpdateTime", DbType.DateTime, person.T_UpdateTime) .Set("NC_Modifiedtime", DbType.AnsiString, person.NC_Modifiedtime) .Where(WhereMySQL.Equal("NC_PK_User", DbType.AnsiString, person.NC_PK_User)) .Execute(); return update; }
internal PersonCoreInsert(IDbConnection _conn, PersonCore _entity) { this.Connection = _conn; this.IsBeginTransaction = false; this.entity = _entity; }
/// <summary> /// 新增[人员]数据到本地 /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <param name="person"></param> /// <returns></returns> internal int Insert_PersonCore(IDbConnection connection, IDbTransaction transaction, PersonCore person) { var insert = connection.Insert("PersonCore") .Field("PK_User", DbType.AnsiString, person.PK_User) .Field("Code", DbType.AnsiString, person.Code) .Field("Name", DbType.AnsiString, person.Name) .Field("ShortName", DbType.AnsiString, person.ShortName) .Field("IDCardNumber", DbType.AnsiString, person.IDCardNumber) .Field("Sex", DbType.Int32, person.Sex) .Field("Age", DbType.Int32, person.Age) .Field("Email", DbType.AnsiString, person.Email) .Field("Mobile", DbType.AnsiString, person.Mobile) .Field("Birthdate", DbType.AnsiString, person.Birthdate) .Field("JoinWorkDate", DbType.AnsiString, person.JoinWorkDate) .Field("Censusaddr", DbType.AnsiString, person.Censusaddr) .Field("T_Creater", DbType.AnsiString, person.T_Creater) .Field("T_CreaterName", DbType.AnsiString, person.T_CreaterName) .Field("T_CreateTime", DbType.DateTime, person.T_CreateTime) .Field("T_Updater", DbType.AnsiString, person.T_Updater) .Field("T_UpdaterName", DbType.AnsiString, person.T_UpdaterName) .Field("T_UpdateTime", DbType.DateTime, person.T_UpdateTime) .Field("NC_PK_User", DbType.AnsiString, person.NC_PK_User) .Field("NC_Modifiedtime", DbType.AnsiString, person.NC_Modifiedtime) .Execute(); return insert; }