/// <summary>
/// 取得更新数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateUpdateCommand(Entity.UserDepartment item)
{
string sql = $"UPDATE {TableName} SET MerchantId=@MerchantId WHERE UserId=@UserId And DepartmentId=@DepartmentId";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得插入数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateInsertCommand(Entity.UserDepartment item)
{
string sql = $"INSERT INTO {TableName} (UserId,DepartmentId,MerchantId) VALUES (@UserId,@DepartmentId,@MerchantId)";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得删除数据的数据库命令
/// </summary>
/// <param name="item">实体实例</param>
/// <returns></returns>
protected override DapperCommand CreateDeleteCommand(Entity.UserDepartment item)
{
string sql = $"DELETE FROM {TableName} WHERE UserId=@UserId And DepartmentId=@DepartmentId";
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("UserId", item.UserId);
dynamicParameters.Add("DepartmentId", item.DepartmentId);
return(new DapperCommand()
{
CommandText = sql,
Parameters = dynamicParameters
});
}
