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