/// <summary>
/// 修改[系统账号]数据
/// </summary>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <param name="sysAccount"></param>
/// <returns></returns>
internal int Update_SysAccount(IDbConnection connection, IDbTransaction transaction, SysAccount sysAccount)
{
var update = connection.Update("SysAccount")
.Set("PK_Account", DbType.AnsiString, sysAccount.PK_Account)
.Set("UserName", DbType.AnsiString, sysAccount.UserName)
.Set("Password", DbType.AnsiString, sysAccount.Password)
.Set("WeChatNumber", DbType.AnsiString, sysAccount.WeChatNumber)
.Set("NCIdCard", DbType.AnsiString, sysAccount.NCIdCard)
.Set("T_Updater", DbType.AnsiString, sysAccount.T_Updater)
.Set("T_UpdaterName", DbType.AnsiString, sysAccount.T_UpdaterName)
.Set("T_UpdateTime", DbType.DateTime, sysAccount.T_UpdateTime)
.Where(WhereMySQL.Equal("NCIdCard", DbType.AnsiString, sysAccount.NCIdCard))
.Execute();
return update;
}
/// <summary>
/// 新增[系统账号]数据
/// </summary>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <param name="sysAccount"></param>
/// <returns></returns>
internal int Insert_SysAccount(IDbConnection connection, IDbTransaction transaction, SysAccount sysAccount)
{
var insert = connection.Insert("SysAccount")
.Field("PK_Account", DbType.AnsiString, sysAccount.PK_Account)
.Field("UserName", DbType.AnsiString, sysAccount.UserName)
.Field("Password", DbType.AnsiString, sysAccount.Password)
.Field("WeChatNumber", DbType.AnsiString, sysAccount.WeChatNumber)
.Field("NCIdCard", DbType.AnsiString, sysAccount.NCIdCard)
.Field("T_Creater", DbType.AnsiString, sysAccount.T_Creater)
.Field("T_CreaterName", DbType.AnsiString, sysAccount.T_CreaterName)
.Field("T_CreateTime", DbType.DateTime, sysAccount.T_CreateTime)
.Field("T_Updater", DbType.AnsiString, sysAccount.T_Updater)
.Field("T_UpdaterName", DbType.AnsiString, sysAccount.T_UpdaterName)
.Field("T_UpdateTime", DbType.DateTime, sysAccount.T_UpdateTime)
.Execute();
return insert;
}
